Error Class 42: Syntax Error or Access Rule Violation

Error Class 42: Syntax Error or Access Rule Violation
SQLSTATE Message Text
42000 Syntax error or access rule violation; see additional errors for details.
42500 User '<authorizationID>' does not have <permissionType> permission on table '<schemaName>'.'<tableName>'.
42501 User '<authorizationID>' does not have <permissionType> permission on table '<schemaName>'.'<tableName>' for grant.
42502 User '<authorizationID>' does not have <permissionType> permission on column '<columnName>' of table '<schemaName>'.'<tableName>'.
42503 User '<authorizationID>' does not have <permissionType> permission on column '<columnName>' of table '<schemaName>'.'<tableName>' for grant.
42504 User '<authorizationID>' does not have <permissionType> permission on <objectName> '<schemaName>'.'<tableName>'.
42505 User '<authorizationID>' does not have <permissionType> permission on <objectName> '<schemaName>'.'<tableName>' for grant.
42506 User '<authorizationID>' is not the owner of <objectName> '<schemaName>'.'<tableName>'.
42507 User '<authorizationID>' can not perform the operation in schema '<schemaName>'.
42508 User '<authorizationID>' can not create schema '<schemaName>'. Only database owner could issue this statement.
42509 Specified grant or revoke operation is not allowed on object '<objectName>'.
4250A User '<authorizationID>' does not have <permissionName> permission on object '<schemaName>'.'<objectName>'.
4250B Invalid database authorization property '<value>=<value>'.
4250C User(s) '<authorizationID>' must not be in both read-only and full-access authorization lists.
4250D Repeated user(s) '<authorizationID>' in access list '<listName>';
4250E Internal Error: invalid <authorizationID> id in statement permission list.
4251A Statement <value> can only be issued by database owner.
4251B PUBLIC is reserved and cannot be used as a user identifier or role name.
4251C Role <authorizationID> cannot be granted to <authorizationID> because this would create a circularity.
4251D Only the database owner can perform this operation.
4251E No one can view the '<tableName>'.'<columnName>' column.
4251F You cannot drop the credentials of the database owner.
4251G Please set derby.authentication.builtin.algorithm to a valid message digest algorithm. The current authentication scheme is too weak to be used by NATIVE authentication.
4251H Invalid NATIVE authentication specification. Please set derby.authentication.provider to a value of the form NATIVE:$credentialsDB or NATIVE:$credentialsDB:LOCAL (at the system level).
4251I Authentication cannot be performed because the credentials database '<databaseName>' does not exist.
4251J The value for the property '<propertyName>' is formatted badly.
4251K The first credentials created must be those of the DBO.
4251L The derby.authentication.provider property specifies '<dbName>' as the name of the credentials database. This is not a valid name for a database.
4251M User '<authorizationID>' does not have <permissionType> permission to analyze table '<schemaName>'.<tableName>'.
42601 In an ALTER TABLE statement, the column '<columnName>' has been specified as NOT NULL and either the DEFAULT clause was not specified or was specified as DEFAULT NULL.
42601.S.372 ALTER TABLE statement cannot add an IDENTITY column to a table.
42605 The number of arguments for function '<functionName>' is incorrect.
42606 An invalid hexadecimal constant starting with '<number>' has been detected.
42610 All the arguments to the COALESCE/VALUE function cannot be parameters. The function needs at least one argument that is not a parameter.
42611 The length, precision, or scale attribute for column, or type mapping '<value>' is not valid.
42613 Multiple or conflicting keywords involving the '<clause>' clause are present.
42621 A check constraint or generated column that is defined with '<value>' is invalid.
42622 The name '<name>' is too long. The maximum length is '<number>'.
42734 Name '<name>' specified in context '<context>' is not unique.
42802 The number of values assigned is not the same as the number of specified or implied columns.
42803 An expression containing the column '<columnName>' appears in the SELECT list and is not part of a GROUP BY clause.
42815.S.713 The replacement value for '<value>' is invalid.
42815.S.171 The data type, length or value of arguments '<value>' and '<value>' is incompatible.
42818 Comparisons between '<type>' and '<type>' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
42820 The floating point literal '<string>' contains more than 30 characters.
42821 Columns of type '<type>' cannot hold values of type '<type>'.
42824 An operand of LIKE is not a string, or the first operand is not a column.
42831 '<columnName>' cannot be a column of a primary key or unique key because it can contain null values.
42831.S.1 '<columnName>' cannot be a column of a primary key because it can contain null values.
42834 SET NULL cannot be specified because FOREIGN KEY '<key>' cannot contain null values.
42837 ALTER TABLE '<tableName>' specified attributes for column '<columnName>' that are not compatible with the existing column.
42846 Cannot convert types '<type>' to '<type>'.
42877 A qualified column name '<columnName>' is not allowed in the ORDER BY clause.
42878 The ORDER BY clause of a SELECT UNION statement only supports unqualified column references and column position numbers. Other expressions are not currently supported.
42879 The ORDER BY clause may not contain column '<columnName>', since the query specifies DISTINCT and that column does not appear in the query result.
4287A The ORDER BY clause may not specify an expression, since the query specifies DISTINCT.
4287B In this context, the ORDER BY clause may only specify a column number.
42884 No authorized routine named '<routineName>' of type '<type>' having compatible arguments was found.
42886 '<value>' parameter '<value>' requires a parameter marker '?'.
42894 DEFAULT value or IDENTITY attribute value is not valid for column '<columnName>'.
428C1 Only one identity column is allowed in a table.
428EK The qualifier for a declared global temporary table name must be SESSION.
428C2 DELETE ROWS is not supported for ON '<txnMode>'.
428C3 Temporary table columns cannot be referenced by foreign keys.
428C4 Attempt to add temporary table, '<txnMode>', as a view dependency.
42903 Invalid use of an aggregate function.
42908 The CREATE VIEW statement does not include a column list.
42909 The CREATE TABLE statement does not include a column list.
42915 Foreign Key '<key>' is invalid because '<value>'.
42916 Synonym '<synonym2>' cannot be created for '<synonym1>' as it would result in a circular synonym chain.
42939 An object cannot be created with the schema name '<schemaName>'.
4293A A role cannot be created with the name '<authorizationID>', the SYS prefix is reserved.
42962 Long column type column or parameter '<columnName>' not permitted in declared global temporary tables or procedure definitions.
42995 The requested function does not apply to global temporary tables.
42X01 Syntax error: <error>.
42X02 <value>.
42X03 Column name '<columnName>' is in more than one table in the FROM list.
42X04 Column '<columnName>' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then '<columnName>' is not a column in the target table.
42X05 Table/View '<objectName>' does not exist.
42X06 Too many result columns specified for table '<tableName>'.
42X07 Null is only allowed in a VALUES clause within an INSERT statement.
42X08 The constructor for class '<className>' cannot be used as an external virtual table because the class does not implement '<constructorName>'.
42X09 The table or alias name '<tableName>' is used more than once in the FROM list.
42X10 '<tableName>' is not an exposed table name in the scope in which it appears.
42X12 Column name '<columnName>' appears more than once in the CREATE TABLE statement.
42X13 Column name '<columnName>' appears more than once times in the column list of an INSERT statement.
42X14 '<columnName>' is not a column in table or VTI '<value>'.
42X15 Column name '<columnName>' appears in a statement without a FROM list.
42X16 Column name '<columnName>' appears multiple times in the SET clause of an UPDATE statement.
42X17 In the Properties list of a FROM clause, the value '<value>' is not valid as a joinOrder specification. Only the values FIXED and UNFIXED are valid.
42X19 The WHERE or HAVING clause or CHECK CONSTRAINT definition is a '<value>' expression. It must be a BOOLEAN expression.
42X20 Syntax error; integer literal expected.
42X23 Cursor <cursorName> is not updatable.
42X24 Column <columnName> is referenced in the HAVING clause but is not in the GROUP BY list.
42X25 The '<functionName>' function is not allowed on the type.
42X26 The class '<className>' for column '<columnName>' does not exist or is inaccessible. This can happen if the class is not public.
42X28 Delete table '<tableName>' is not target of cursor '<cursorName>'.
42X29 Update table '<tableName>' is not the target of cursor '<cursorName>'.
42X30 Cursor '<cursorName>' not found. Verify that autocommit is OFF.
42X31 Column '<columnName>' is not in the FOR UPDATE list of cursor '<cursorName>'.
42X32 The number of columns in the derived column list must match the number of columns in table '<tableName>'.
42X33 The derived column list contains a duplicate column name '<columnName>'.
42X34 There is a ? parameter in the select list. This is not allowed.
42X35 It is not allowed for both operands of '<value>' to be ? parameters.
42X36 The '<operator>' operator is not allowed to take a ? parameter as an operand.
42X37 The unary '<operator>' operator is not allowed on the '<type>' type.
42X38 'SELECT *' only allowed in EXISTS and NOT EXISTS subqueries.
42X39 Subquery is only allowed to return a single column.
42X40 A NOT statement has an operand that is not boolean . The operand of NOT must evaluate to TRUE, FALSE, or UNKNOWN.
42X41 In the Properties clause of a FROM list, the property '<propertyName>' is not valid (the property was being set to '<value>').
42X42 Correlation name not allowed for column '<columnName>' because it is part of the FOR UPDATE list.
42X43 The ResultSetMetaData returned for the class/object '<className>' was null. In order to use this class as an external virtual table, the ResultSetMetaData cannot be null.
42X44 Invalid length '<number>' in column specification.
42X45 <type> is an invalid type for argument number <value> of <value>.
42X46 There are multiple functions named '<functionName>'. Use the full signature or the specific name.
42X47 There are multiple procedures named '<procedureName>'. Use the full signature or the specific name.
42X48 Value '<value>' is not a valid precision for <value>.
42X49 Value '<value>' is not a valid integer literal.
42X50 No method was found that matched the method call <methodName>.<value>(<value>), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
42X51 The class '<className>' does not exist or is inaccessible. This can happen if the class is not public.
42X52 Calling method ('<methodName>') using a receiver of the Java primitive type '<type>' is not allowed.
42X53 The LIKE predicate can only have 'CHAR' or 'VARCHAR' operands. Type '<type>' is not permitted.
42X54 The Java method '<methodName>' has a ? as a receiver. This is not allowed.
42X55 Table name '<tableName>' should be the same as '<value>'.
42X56 The number of columns in the view column list does not match the number of columns in the underlying query expression in the view definition for '<value>'.
42X57 The getColumnCount() for external virtual table '<tableName>' returned an invalid value '<value>'. Valid values are greater than or equal to 1.
42X58 The number of columns on the left and right sides of the <tableName> must be the same.
42X59 The number of columns in each VALUES constructor must be the same.
42X60 Invalid value '<value>' for insertMode property specified for table '<tableName>'.
42X61 Types '<type>' and '<type>' are not <value> compatible.
42X62 '<value>' is not allowed in the '<schemaName>' schema.
42X63 The USING clause did not return any results. No parameters can be set.
42X64 In the Properties list, the invalid value '<value>' was specified for the useStatistics property. The only valid values are TRUE or FALSE.
42X65 Index '<index>' does not exist.
42X66 Column name '<columnName>' appears more than once in the CREATE INDEX statement.
42X68 No field '<fieldName>' was found belonging to class '<className>'. It may be that the field exists, but it is not public, or that the class does not exist or is not public.
42X69 It is not allowed to reference a field ('<fieldName>') using a referencing expression of the Java primitive type '<type>'.
42X70 The number of columns in the table column list does not match the number of columns in the underlying query expression in the table definition for '<value>'.
42X71 Invalid data type '<datatypeName>' for column '<columnName>'.
42X72 No static field '<fieldName>' was found belonging to class '<className>'. The field might exist, but it is not public and/or static, or the class does not exist or the class is not public.
42X73 Method resolution for signature <value>.<value>(<value>) was ambiguous. (No single maximally specific method.)
42X74 Invalid CALL statement syntax.
42X75 No constructor was found with the signature <value>(<value>). It may be that the parameter types are not method invocation convertible.
42X76 At least one column, '<columnName>', in the primary key being added is nullable. All columns in a primary key must be non-nullable.
42X77 Column position '<columnPosition>' is out of range for the query expression.
42X78 Column '<columnName>' is not in the result of the query expression.
42X79 Column name '<columnName>' appears more than once in the result of the query expression.
42X80 VALUES clause must contain at least one element. Empty elements are not allowed.
42X81 A query expression must return at least one column.
42X82 The USING clause returned more than one row. Only single-row ResultSets are permissible.
42X83 The constraints on column '<columnName>' require that it be both nullable and not nullable.
42X84 Index '<index>' was created to enforce constraint '<constraintName>'. It can only be dropped by dropping the constraint.
42X85 Constraint '<constraintName>'is required to be in the same schema as table '<tableName>'.
42X86 ALTER TABLE failed. There is no constraint '<constraintName>' on table '<tableName>'.
42X87 At least one result expression (THEN or ELSE) of the '<expression>' expression must not be a '?'.
42X88 A conditional has a non-Boolean operand. The operand of a conditional must evaluate to TRUE, FALSE, or UNKNOWN.
42X89 Types '<type>' and '<type>' are not type compatible. Neither type is assignable to the other type.
42X90 More than one primary key constraint specified for table '<tableName>'.
42X91 Constraint name '<constraintName>' appears more than once in the CREATE TABLE statement.
42X92 Column name '<columnName>' appears more than once in a constraint's column list.
42X93 Table '<tableName>' contains a constraint definition with column '<columnName>' which is not in the table.
42X94 <value> '<value>' does not exist.
42X96 The database class path contains an unknown jar file '<fileName>'.
42X98 Parameters are not allowed in a VIEW definition.
42X99 Parameters are not allowed in a TABLE definition.
42XA0 The generation clause for column '<columnName>' has data type '<datatypeName>', which cannot be assigned to the column's declared data type.
42XA1 The generation clause for column '<columnName>' contains an aggregate. This is not allowed.
42XA2 '<value>' cannot appear in a GENERATION CLAUSE because it may return unreliable results.
42XA3 You may not override the value of generated column '<columnName>'.
42XA4 The generation clause for column '<columnName>' references other generated columns. This is not allowed.
42XA5 Routine '<routineName>' may issue SQL and therefore cannot appear in a GENERATION CLAUSE.
42XA6 '<columnName>' is a generated column. It cannot be part of a foreign key whose referential action for DELETE is SET NULL or SET DEFAULT, or whose referential action for UPDATE is CASCADE.
42XA7 '<columnName>' is a generated column. You cannot change its default value.
42XA8 You cannot rename '<columnName>' because it is referenced by the generation clause of column '<columnName>'.
42XA9 Column '<columnName>' needs an explicit datatype. The datatype can be omitted only for columns with generation clauses.
42XAA The NEW value of generated column '<columnName>' is mentioned in the BEFORE action of a trigger. This is not allowed.
42XAB NOT NULL is allowed only if you explicitly declare a datatype.
42XAC 'INCREMENT BY' value can not be zero.
42XAE '<argName>' value out of range of datatype '<datatypeName>'. Must be between '<minValue>' and '<maxValue>'.
42XAF Invalid 'MINVALUE' value '<minValue>'. Must be smaller than 'MAXVALUE: <maxValue>'.
42XAG Invalid 'START WITH' value '<startValue>'. Must be between '<minValue>' and '<maxValue>'.
42XAH A NEXT VALUE FOR expression may not appear in many contexts, including WHERE, ON, HAVING, ORDER BY, DISTINCT, CASE, GENERATION, and AGGREGATE clauses as well as WINDOW functions and CHECK constraints.
42XAI The statement references the following sequence more than once: '<sequenceName>'.
42XAJ The CREATE SEQUENCE statement has a redundant '<clauseName>' clause.
42Y00 Class '<className>' does not implement com.splicemachine.db.iapi.db.AggregateDefinition and thus cannot be used as an aggregate expression.
42Y01 Constraint '<constraintName>' is invalid.
42Y03.S.0 '<statement>' is not recognized as a function or procedure.
42Y03.S.1 '<statement>' is not recognized as a procedure.
42Y03.S.2 '<statement>' is not recognized as a function.
42Y04 Cannot create a procedure or function with EXTERNAL NAME '<name>' because it is not a list separated by periods. The expected format is <full java path>.<method name>.
42Y05 There is no Foreign Key named '<key>'.
42Y07 Schema '<schemaName>' does not exist
42Y08 Foreign key constraints are not allowed on system tables.
42Y09 Void methods are only allowed within a CALL statement.
42Y10 A table constructor that is not in an INSERT statement has all ? parameters in one of its columns. For each column, at least one of the rows must have a non-parameter.
42Y11 A join specification is required with the '<clauseName>' clause.
42Y12 The ON clause of a JOIN is a '<expressionType>' expression. It must be a BOOLEAN expression.
42Y13 Column name '<columnName>' appears more than once in the CREATE VIEW statement.
42Y16 No public static method '<methodName>' was found in class '<className>'. The method might exist, but it is not public, or it is not static.
42Y22 Aggregate <aggregateType> cannot operate on type <type>.
42Y23 Incorrect JDBC type info returned for column <colunmName>.
42Y24 View '<viewName>' is not updatable. (Views are currently not updatable.)
42Y25 '<tableName>' is a system table. Users are not allowed to modify the contents of this table.
42Y26 Aggregates are not allowed in the GROUP BY list.
42Y27 Parameters are not allowed in the trigger action.
42Y29 The SELECT list of a non-grouped query contains at least one invalid expression. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
42Y30 The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
42Y32 Aggregator class '<className>' for aggregate '<aggregateName>' on type <type> does not implement com.splicemachine.db.iapi.sql.execute.ExecAggregator.
42Y33 Aggregate <aggregateName> contains one or more aggregates.
42Y34 Column name '<columnName>' matches more than one result column in table '<tableName>'.
42Y35 Column reference '<reference>' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
42Y36 Column reference '<reference>' is invalid, or is part of an invalid expression. For a SELECT list with a GROUP BY, the columns and expressions being selected may only contain valid grouping expressions and valid aggregate expressions.
42Y37 '<value>' is a Java primitive and cannot be used with this operator.
42Y38 insertMode = replace is not permitted on an insert where the target table, '<tableName>', is referenced in the SELECT.
42Y39 '<value>' may not appear in a CHECK CONSTRAINT definition because it may return non-deterministic results.
42Y40 '<value>' appears multiple times in the UPDATE OF column list for trigger '<triggerName>'.
42Y41 '<value>' cannot be directly invoked via EXECUTE STATEMENT because it is part of a trigger.
42Y42 Scale '<scaleValue>' is not a valid scale for a <value>.
42Y43 Scale '<scaleValue>' is not a valid scale with precision of '<precision>'.
42Y44 Invalid key '<key>' specified in the Properties list of a FROM list. The case-sensitive keys that are currently supported are '<key>'.
42Y45 VTI '<value>' cannot be bound because it is a special trigger VTI and this statement is not part of a trigger action or WHEN clause.
42Y46 Invalid Properties list in FROM list. There is no index '<index>' on table '<tableName>'.
42Y47 Invalid Properties list in FROM list. The hint useSpark needs (true/false) and does not support '<value>'.
42Y48 Invalid Properties list in FROM list. Either there is no named constraint '<constraintName>' on table '<tableName>' or the constraint does not have a backing index.
42Y49 Multiple values specified for property key '<key>'.
42Y50 Properties list for table '<tableName>' may contain values for index or for constraint but not both.
42Y55 '<value>' cannot be performed on '<value>' because it does not exist.
42Y56 Invalid join strategy '<strategyValue>' specified in Properties list on table '<tableName>'. The currently supported values for a join strategy are: <supportedStrategyNames>.
42Y58 NumberFormatException occurred when converting value '<value>' for optimizer override '<value>'.
42Y59 Invalid value, '<value>', specified for hashInitialCapacity override. Value must be greater than 0.
42Y60 Invalid value, '<value>', specified for hashLoadFactor override. Value must be greater than 0.0 and less than or equal to 1.0.
42Y61 Invalid value, '<value>', specified for hashMaxCapacity override. Value must be greater than 0.
42Y62 '<statement>' is not allowed on '<viewName>' because it is a view.
42Y63 Hash join requires an optimizable equijoin predicate on a column in the selected index or heap. An optimizable equijoin predicate does not exist on any column in table or index '<index>'. Use the 'index' optimizer override to specify such an index or the heap on table '<tableName>'.
42Y64 bulkFetch value of '<value>' is invalid. The minimum value for bulkFetch is 1.
42Y65 bulkFetch is not permitted on '<joinType>' joins.
42Y66 bulkFetch is not permitted on updatable cursors.
42Y67 Schema '<schemaName>' cannot be dropped.
42Y69 No valid execution plan was found for this statement. This is usually because an infeasible join strategy was chosen, or because an index was chosen which prevents the chosen join strategy from being used.
42Y70 The user specified an illegal join order. This could be caused by a join column from an inner table being passed as a parameter to an external virtual table.
42Y71 System function or procedure '<procedureName>' cannot be dropped.
42Y82 System generated stored prepared statement '<statement>' that cannot be dropped using DROP STATEMENT. It is part of a trigger.
42Y83 An untyped null is not permitted as an argument to aggregate <aggregateName>. Please cast the null to a suitable type.
42Y84 '<value>' may not appear in a DEFAULT definition.
42Y85 The DEFAULT keyword is only allowed in a VALUES clause when the VALUES clause appears within an INSERT statement.
42Y90 FOR UPDATE is not permitted in this type of statement.
42Y91 The USING clause is not permitted in an EXECUTE STATEMENT for a trigger action.
42Y92 <triggerName> triggers may only reference <value> transition variables/tables.
42Y93 Illegal REFERENCING clause: only one name is permitted for each type of transition variable/table.
42Y94 An AND or OR has a non-boolean operand. The operands of AND and OR must evaluate to TRUE, FALSE, or UNKNOWN.
42Y95 The '<operatorName>' operator with a left operand type of '<operandType>' and a right operand type of '<operandType>' is not supported.
42Y96 Invalid Sort Strategy: '<sortStrategy>'.
42Y97 Invalid escape character at line '<lineNumber>', column '<columnName>'.
42Z02 Multiple DISTINCT aggregates are not supported at this time.
42Z07 Aggregates are not permitted in the ON clause.
42Z08 Bulk insert replace is not permitted on '<value>' because it has an enabled trigger (<value>).
42Z15 Invalid type specified for column '<columnName>'. The type of a column may not be changed.
42Z16 Only columns of type VARCHAR, CLOB, and BLOB may have their length altered.
42Z17 Invalid length specified for column '<columnName>'. Length must be greater than the current column length.
42Z18 Column '<columnName>' is part of a foreign key constraint '<constraintName>'. To alter the length of this column, you should drop the constraint first, perform the ALTER TABLE, and then recreate the constraint.
42Z19 Column '<columnName>' is being referenced by at least one foreign key constraint '<constraintName>'. To alter the length of this column, you should drop referencing constraints, perform the ALTER TABLE and then recreate the constraints.
42Z20 Column '<columnName>' cannot be made nullable. It is part of a primary key or unique constraint, which cannot have any nullable columns.
42Z20.S.1 Column '<columnName>' cannot be made nullable. It is part of a primary key, which cannot have any nullable columns.
42Z21 Invalid increment specified for identity focr column '<columnName>'. Increment cannot be zero.
42Z22 Invalid type specified for identity column '<columnName>'. The only valid types for identity columns are BIGINT, INT and SMALLINT.
42Z23 Attempt to modify an identity column '<columnName>'.
42Z24 Overflow occurred in identity value for column '<columnName>' in table '<tableName>'.
42Z25 INTERNAL ERROR identity counter. Update was called without arguments with current value \= NULL.
42Z26 A column, '<columnName>', with an identity default cannot be made nullable.
42Z27 A nullable column, '<columnName>', cannot be modified to have identity default.
42Z50 INTERNAL ERROR: Unable to generate code for <value>.
42Z53 INTERNAL ERROR: Type of activation to generate for node choice <value> is unknown.
42Z60 <value> not allowed unless database property <propertyName> has value '<value>'.
42Z70 Binding directly to an XML value is not allowed; try using XMLPARSE.
42Z71 XML values are not allowed in top-level result sets; try using XMLSERIALIZE.
42Z72 Missing SQL/XML keyword(s) '<keywords>' at line <lineNumber>, column <columnNumber>.
42Z73 Invalid target type for XMLSERIALIZE: '<typeName>'.
42Z74 XML feature not supported: '<featureName>'.
42Z75 XML query expression must be a string literal.
42Z76 Multiple XML context items are not allowed.
42Z77 Context item must have type 'XML'; '<value>' is not allowed.
42Z79 Unable to determine the parameter type for XMLPARSE; try using a CAST.
42Z90 Class '<className>' does not return an updatable ResultSet.
42Z91 subquery
42Z92 repeatable read
42Z93 Constraints '<constraintName>' and '<constraintName>' have the same set of columns, which is not allowed.
42Z97 Renaming column '<columnName>' will cause check constraint '<constraintName>' to break.
42Z99 String or Hex literal cannot exceed 64K.
42Z9A read uncommitted
42Z9B The external virtual table interface does not support BLOB or CLOB columns. '<value>' column '<value>'.
42Z9D.S.1 Procedures that modify SQL data are not allowed in BEFORE triggers.
42Z9D '<statement>' statements are not allowed in '<triggerName>' triggers.
42Z9E Constraint '<constraintName>' is not a <value> constraint.
42Z9F Too many indexes (<index>) on the table <tableName>. The limit is <number>.
42ZA0 Statement too complex. Try rewriting the query to remove complexity. Eliminating many duplicate expressions or breaking up the query and storing interim results in a temporary table can often help resolve this error.
42ZA1 Invalid SQL in Batch: '<batch>'.
42ZA2 Operand of LIKE predicate with type <type> and collation <value> is not compatable with LIKE pattern operand with type <type> and collation <value>.
42ZA3 The table will have collation type <type> which is different than the collation of the schema <type> hence this operation is not supported .
42ZB1 Parameter style DERBY_JDBC_RESULT_SET is only allowed for table functions.
42ZB2 Table functions can only have parameter style DERBY_JDBC_RESULT_SET.
42ZB3 XML is not allowed as the datatype of a user-defined aggregate or of a column returned by a table function.
42ZB4 '<schemaName>'.<functionName>' does not identify a table function.
42ZB5 Class '<className>' implements VTICosting but does not provide a public, no-arg constructor.
42ZB6 A scalar value is expected, not a row set returned by a table function.
42ZC0 Window '<windowName>' is not defined.
42ZC1 Only one window is supported.
42ZC2 Window function is illegal in this context: '<clauseName>' clause
42ZC3 A user defined aggregate may not have the name of an aggregate defined by the SQL Standard or the name of a builtin Derby function having one argument: '<aggregateName>'
42ZC4 User defined aggregate '<schemaName>'.'<aggregateName>' is bound to external class '<className>'. The parameter types of that class could not be resolved.
42ZC6 User defined aggregate '<schemaName>'.'<aggregateName>' was declared to have this input Java type: '<javaDataType>'. This does not extend the following actual bounding input Java type: '<javaDataType>'.
42ZC7 User defined aggregate '<schemaName>'.'<aggregateName>' was declared to have this return Java type: '<javaDataType>'. This does not extend the following actual bounding return Java type: '<javaDataType>'.
42ZC8 Implementing class '<className>' for user defined aggregate '<schemaName>'.'<aggregateName>' could not be instantiated or was malformed. Detailed message follows: <detailedMessage>
43001 The truncate function was provided a null operand.
43002 The truncate function was provided an operand which it does not know how to handle: '<operand>'. It requires a DATE, TIMESTAMP, INTEGER or DECIMAL type.
43003 The truncate function expects a right-side argument of type CHAR for an operand of type DATE or TIMESTAMP but got: '<truncValue>'.
43004 The truncate function expects a right-side argument of type INTEGER for an operand of type DECIMAL but got: '<truncValue>'.
43005 The truncate function got an invalid right-side trunc value for operand type DATE: '<truncValue>'.
43006 The truncate function got an unknown right-side trunc value for operand type '<operand>': '<truncValue>'. Acceptable values are: '<acceptableValues>'.
44001 <dateOrTimestamp>s cannot be multiplied or divided. The operation is undefined.
44002 <dateOrTimestamp>s cannot be added. The operation is undefined.
44003 Timestamp '<dateOrTimestamp>' is out of range (~ from 21 Sep 1677 00:12:44 GMT to 11 Apr 2262 23:47:16 GMT).