Return-Path: X-Original-To: apmail-db-derby-commits-archive@www.apache.org Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 20F1391A7 for ; Mon, 30 Jul 2012 16:28:03 +0000 (UTC) Received: (qmail 6929 invoked by uid 500); 30 Jul 2012 16:28:03 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 6908 invoked by uid 500); 30 Jul 2012 16:28:03 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 6901 invoked by uid 99); 30 Jul 2012 16:28:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jul 2012 16:28:03 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jul 2012 16:27:54 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id 83424238889B; Mon, 30 Jul 2012 16:27:08 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1367150 [1/2] - in /db/derby/code/trunk/java: build/org/apache/derbyBuild/ client/org/apache/derby/client/am/ engine/org/apache/derby/iapi/types/ engine/org/apache/derby/impl/services/reflect/ engine/org/apache/derby/impl/sql/compile/ engi... Date: Mon, 30 Jul 2012 16:27:07 -0000 To: derby-commits@db.apache.org From: rhillegas@apache.org X-Mailer: svnmailer-1.0.8-patched Message-Id: <20120730162708.83424238889B@eris.apache.org> Author: rhillegas Date: Mon Jul 30 16:27:06 2012 New Revision: 1367150 URL: http://svn.apache.org/viewvc?rev=1367150&view=rev Log: DERBY-5885: Re-order message args to correspond with argument numbers. Modified: db/derby/code/trunk/java/build/org/apache/derbyBuild/MessageBuilder.java db/derby/code/trunk/java/client/org/apache/derby/client/am/SectionManager.java db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SqlXmlUtil.java db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/XML.java db/derby/code/trunk/java/engine/org/apache/derby/impl/services/reflect/UpdateLoader.java db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/BinaryLogicalOperatorNode.java db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/SelectNode.java db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/InternalTriggerExecutionContext.java db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/paramij.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions2.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ErrorCodeTest.java db/derby/code/trunk/java/testing/org/apache/derbyTesting/junit/JDBC.java Modified: db/derby/code/trunk/java/build/org/apache/derbyBuild/MessageBuilder.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/build/org/apache/derbyBuild/MessageBuilder.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/build/org/apache/derbyBuild/MessageBuilder.java (original) +++ db/derby/code/trunk/java/build/org/apache/derbyBuild/MessageBuilder.java Mon Jul 30 16:27:06 2012 @@ -379,7 +379,7 @@ public class MessageBuilder extends Task } catch (Exception e) { - throw new BuildException( "Could not generate English properties from message descriptors.", e ); + throw new BuildException( "Could not generate English properties from message descriptors: " + e.getMessage(), e ); } finally { Modified: db/derby/code/trunk/java/client/org/apache/derby/client/am/SectionManager.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/client/org/apache/derby/client/am/SectionManager.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/client/org/apache/derby/client/am/SectionManager.java (original) +++ db/derby/code/trunk/java/client/org/apache/derby/client/am/SectionManager.java Mon Jul 30 16:27:06 2012 @@ -143,7 +143,7 @@ public class SectionManager { { throw new SqlException(agent_.logWriter_, new ClientMessageId(SQLState.EXCEEDED_MAX_SECTIONS), - "32k"); + "32000"); } } Modified: db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SqlXmlUtil.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SqlXmlUtil.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SqlXmlUtil.java (original) +++ db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SqlXmlUtil.java Mon Jul 30 16:27:06 2012 @@ -315,7 +315,7 @@ public class SqlXmlUtil * continue to run as normal. */ throw StandardException.newException( - SQLState.LANG_XML_QUERY_ERROR, te, opName, te.getMessage()); + SQLState.LANG_XML_QUERY_ERROR, opName, te.getMessage()); } } Modified: db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/XML.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/XML.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/XML.java (original) +++ db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/XML.java Mon Jul 30 16:27:06 2012 @@ -830,7 +830,7 @@ public class XML * fail but Derby will continue to run as normal. */ throw StandardException.newException( - SQLState.LANG_XML_QUERY_ERROR, xe, + SQLState.LANG_XML_QUERY_ERROR, "XMLEXISTS", xe.getMessage()); } } @@ -904,7 +904,7 @@ public class XML * fail but Derby will continue to run as normal. */ throw StandardException.newException( - SQLState.LANG_XML_QUERY_ERROR, xe, + SQLState.LANG_XML_QUERY_ERROR, "XMLQUERY", xe.getMessage()); } } Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/services/reflect/UpdateLoader.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/services/reflect/UpdateLoader.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/engine/org/apache/derby/impl/services/reflect/UpdateLoader.java (original) +++ db/derby/code/trunk/java/engine/org/apache/derby/impl/services/reflect/UpdateLoader.java Mon Jul 30 16:27:06 2012 @@ -136,7 +136,7 @@ final class UpdateLoader implements Lock }); } if (vs != null) { - vs.println(MessageService.getTextMessage(MessageId.CM_CLASS_LOADER_START, classpath)); + vs.println(MessageService.getTextMessage(MessageId.CM_CLASS_LOADER_START, classpath )); } thisClasspath = classpath; Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/BinaryLogicalOperatorNode.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/BinaryLogicalOperatorNode.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/BinaryLogicalOperatorNode.java (original) +++ db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/BinaryLogicalOperatorNode.java Mon Jul 30 16:27:06 2012 @@ -89,7 +89,7 @@ abstract class BinaryLogicalOperatorNode { //following is to check if we have something like "? AND 1=1" or "2>1 OR ?" if (leftOperand.isParameterNode() || rightOperand.isParameterNode()) - throw StandardException.newException(SQLState.LANG_NON_BOOLEAN_WHERE_CLAUSE, "PARAMETER" ); + throw StandardException.newException( SQLState.LANG_UNTYPED_PARAMETER_IN_WHERE_CLAUSE ); super.bindExpression(fromList, subqueryList, aggregateVector); Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/SelectNode.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/SelectNode.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/SelectNode.java (original) +++ db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/SelectNode.java Mon Jul 30 16:27:06 2012 @@ -602,7 +602,7 @@ public class SelectNode extends ResultSe /* If whereClause is a parameter, (where ?/where -?/where +?), then we should catch it and throw exception */ if (whereClause.isParameterNode()) - throw StandardException.newException(SQLState.LANG_NON_BOOLEAN_WHERE_CLAUSE, "PARAMETER" ); + throw StandardException.newException(SQLState.LANG_UNTYPED_PARAMETER_IN_WHERE_CLAUSE ); whereClause = whereClause.checkIsBoolean(); getCompilerContext().popCurrentPrivType(); Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/InternalTriggerExecutionContext.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/InternalTriggerExecutionContext.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/InternalTriggerExecutionContext.java (original) +++ db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/InternalTriggerExecutionContext.java Mon Jul 30 16:27:06 2012 @@ -333,7 +333,7 @@ public class InternalTriggerExecutionCon // parser. However, this runtime check is needed to prevent execution // of DDL statements by procedures within a trigger context. if (constantAction instanceof DDLConstantAction) { - throw StandardException.newException(SQLState.LANG_NO_DDL_IN_TRIGGER, triggerd.getName(), constantAction.toString()); + throw StandardException.newException(SQLState.LANG_NO_DDL_IN_TRIGGER, triggerd.getName()); } // No INSERT/UPDATE/DELETE for a before trigger. There is no need to Modified: db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml (original) +++ db/derby/code/trunk/java/engine/org/apache/derby/loc/messages.xml Mon Jul 30 16:27:06 2012 @@ -28,6 +28,16 @@ information: * Message text returned to the user * Human-readable names for message arguments +Message argument names should be listed in numeric order rather than +position order. So, for the following message... + + "Table {1} in schema {0} cannot be indexed." + +...the order of arguments should be + + schemaName + tableName + For further guidance on writing messages with human-readable argument names, please see the following page on the Derby website: @@ -140,7 +150,7 @@ Guide. 01505 The value {0} may be truncated. - valueName + dataValue @@ -319,7 +329,7 @@ Guide. 08001.C.6 Password length ({0}) is outside the range of 1 to {1}. - value + length number @@ -593,9 +603,9 @@ Guide. 22001 A truncation error was encountered trying to shrink {0} '{1}' to length {2}. - value - value - value + dataType + dataValue + length @@ -607,8 +617,8 @@ Guide. 22003.S.1 Year ({0}) exceeds the maximum '{1}'. - value - value + year + year @@ -651,8 +661,8 @@ Guide. 22005.S.4 Unrecognized JDBC type. Type: {0}, columnCount: {1}, columnIndex: {2}. typeName - value - value + number + number @@ -746,15 +756,15 @@ Guide. 22013 Attempt to take the square root of a negative number, '{0}'. - value + number 22014 The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '{2}'. The string to search for is '{0}'. The string to search from is '{1}'. - startIndex searchString fromString + startIndex @@ -836,24 +846,24 @@ Guide. 23503 {2} on table '{1}' caused a violation of foreign key constraint '{0}' for key {3}. The statement has been rolled back. - value - tableName constraintName + tableName + statementType keyName 23505 The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by '{0}' defined on '{1}'. - value - value + indexOrConstraintName + tableName 23513 The check constraint '{1}' was violated while performing an INSERT or UPDATE on table '{0}'. - constraintName tableName + constraintName @@ -1193,8 +1203,8 @@ Guide. 4250B Invalid database authorization property '{0}={1}'. - value - value + propertyName + propertyValue @@ -1206,8 +1216,8 @@ Guide. 4250D Repeated user(s) '{1}' in access list '{0}'; - authorizationID listName + authorizationID @@ -1219,7 +1229,7 @@ Guide. 4251A Statement {0} can only be issued by database owner. - value + sqlText @@ -1315,7 +1325,7 @@ Guide. 42611 The length, precision, or scale attribute for column, or type mapping '{0}' is not valid. - value + dataType @@ -1327,7 +1337,7 @@ Guide. 42621 A check constraint or generated column that is defined with '{0}' is invalid. - value + columnName @@ -1358,14 +1368,14 @@ Guide. 42815.S.713 The replacement value for '{0}' is invalid. - value + sqlText 42815.S.171 The data type, length or value of arguments '{0}' and '{1}' is incompatible. - value - value + dataType + dataType @@ -1457,8 +1467,8 @@ Guide. 42886 '{0}' parameter '{1}' requires a parameter marker '?'. - value - value + parameterMode + parameterName @@ -1494,9 +1504,9 @@ Guide. 42915 - Foreign Key '{0}' is invalid because '{1}'. + Foreign Key '{0}' is invalid for the reason which follows: '{1}'. key - value + detailedReason @@ -1538,7 +1548,7 @@ Guide. 42X02 {0}. - value + parserException @@ -1606,7 +1616,7 @@ Guide. 42X14 '{0}' is not a column in table or VTI '{1}'. columnName - value + tableOrVTIName @@ -1624,13 +1634,18 @@ Guide. 42X17 In the Properties list of a FROM clause, the value '{0}' is not valid as a joinOrder specification. Only the values FIXED and UNFIXED are valid. - value + joinOrder - 42X19 + 42X19.S.1 The WHERE or HAVING clause or CHECK CONSTRAINT definition is a '{0}' expression. It must be a BOOLEAN expression. - value + dataType + + + + 42X19.S.2 + The WHERE or HAVING clause or CHECK CONSTRAINT definition is an untyped parameter expression. It must be a BOOLEAN expression. @@ -1711,19 +1726,19 @@ Guide. 42X35 It is not allowed for both operands of '{0}' to be ? parameters. - value + operatorName 42X36 The '{0}' operator is not allowed to take a ? parameter as an operand. - operator + operatorName 42X37 The unary '{0}' operator is not allowed on the '{1}' type. - operator + operatorName type @@ -1746,7 +1761,7 @@ Guide. 42X41 In the Properties clause of a FROM list, the property '{0}' is not valid (the property was being set to '{1}'). propertyName - value + propertyValue @@ -1770,9 +1785,9 @@ Guide. 42X45 {0} is an invalid type for argument number {1} of {2}. - type - value - value + dataType + argumentNumber + operatorName @@ -1790,22 +1805,22 @@ Guide. 42X48 Value '{1}' is not a valid precision for {0}. - value - value + dataType + number 42X49 Value '{0}' is not a valid integer literal. - value + invalidNumber 42X50 No method was found that matched the method call {0}.{1}({2}), 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. + className methodName - value - value + parameterTypes @@ -1837,20 +1852,20 @@ Guide. 42X55 Table name '{1}' should be the same as '{0}'. tableName - value + tableName 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 '{0}'. - value + viewName 42X57 The getColumnCount() for external virtual table '{0}' returned an invalid value '{1}'. Valid values are greater than or equal to 1. tableName - value + number @@ -1867,23 +1882,23 @@ Guide. 42X60 Invalid value '{0}' for insertMode property specified for table '{1}'. - value + insertMode tableName 42X61 Types '{0}' and '{1}' are not {2} compatible. - type - type - value + dataType + dataType + sqlOperator 42X62 '{0}' is not allowed in the '{1}' schema. - value - schemaNamet + sqlText + schemaName @@ -1894,7 +1909,7 @@ Guide. 42X64 In the Properties list, the invalid value '{0}' was specified for the useStatistics property. The only valid values are TRUE or FALSE. - value + propertyValue @@ -1926,7 +1941,7 @@ Guide. 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 '{0}'. - value + tableName @@ -1946,9 +1961,9 @@ Guide. 42X73 Method resolution for signature {0}.{1}({2}) was ambiguous. (No single maximally specific method.) - value - value - value + className + methodName + parameterTypes @@ -1959,8 +1974,8 @@ Guide. 42X75 No constructor was found with the signature {0}({1}). It may be that the parameter types are not method invocation convertible. - value - value + className + parameterTypes @@ -2075,8 +2090,8 @@ Guide. 42X94 {0} '{1}' does not exist. - value - value + sqlObjectType + objectName @@ -2111,7 +2126,7 @@ Guide. 42XA2 '{0}' cannot appear in a GENERATION CLAUSE because it may return unreliable results. - value + sqlObjectName @@ -2383,7 +2398,7 @@ Guide. 42Y37 '{0}' is a Java primitive and cannot be used with this operator. - value + javaTypeName @@ -2395,27 +2410,27 @@ Guide. 42Y39 '{0}' may not appear in a CHECK CONSTRAINT definition because it may return non-deterministic results. - value + sqlObjectName 42Y40 '{0}' appears multiple times in the UPDATE OF column list for trigger '{1}'. - value + columnName triggerName 42Y41 '{0}' cannot be directly invoked via EXECUTE STATEMENT because it is part of a trigger. - value + storedPreparedStatementName 42Y42 Scale '{1}' is not a valid scale for a {0}. + dataType scaleValue - value @@ -2435,7 +2450,7 @@ Guide. 42Y45 VTI '{0}' cannot be bound because it is a special trigger VTI and this statement is not part of a trigger action or WHEN clause. - value + vtiName @@ -2467,8 +2482,8 @@ Guide. 42Y55 '{0}' cannot be performed on '{1}' because it does not exist. - value - value + sqlText + sqlObjectName @@ -2481,26 +2496,26 @@ Guide. 42Y58 NumberFormatException occurred when converting value '{0}' for optimizer override '{1}'. - value - value + invalidNumber + optimizerOverrideName 42Y59 Invalid value, '{0}', specified for hashInitialCapacity override. Value must be greater than 0. - value + invalidNumber 42Y60 Invalid value, '{0}', specified for hashLoadFactor override. Value must be greater than 0.0 and less than or equal to 1.0. - value + invalidNumber 42Y61 Invalid value, '{0}', specified for hashMaxCapacity override. Value must be greater than 0. - value + invalidNumber @@ -2520,7 +2535,7 @@ Guide. 42Y64 bulkFetch value of '{0}' is invalid. The minimum value for bulkFetch is 1. - value + invalidNumber @@ -2571,7 +2586,7 @@ Guide. 42Y84 '{0}' may not appear in a DEFAULT definition. - value + sqlText @@ -2592,8 +2607,8 @@ Guide. 42Y92 {0} triggers may only reference {1} transition variables/tables. - triggerName - value + sqlKeyword + sqlKeyword @@ -2634,8 +2649,8 @@ Guide. 42Z08 Bulk insert replace is not permitted on '{0}' because it has an enabled trigger ({1}). - value - value + tableName + triggerName @@ -2702,8 +2717,8 @@ Guide. 42Z24 Overflow occurred in identity value for column '{1}' in table '{0}'. - columnName tableName + columnName @@ -2726,21 +2741,21 @@ Guide. 42Z50 INTERNAL ERROR: Unable to generate code for {0}. - value + queryTreeNodeIdentifier 42Z53 INTERNAL ERROR: Type of activation to generate for node choice {0} is unknown. - value + number 42Z60 {0} not allowed unless database property {1} has value '{2}'. - value + sqlText propertyName - value + propertyValue @@ -2786,7 +2801,7 @@ Guide. 42Z77 Context item must have type 'XML'; '{0}' is not allowed. - value + dataType @@ -2835,13 +2850,6 @@ Guide. - 42Z9B - The external virtual table interface does not support BLOB or CLOB columns. '{0}' column '{1}'. - value - value - - - 42Z9D.S.1 Procedures that modify SQL data are not allowed in BEFORE triggers. @@ -2857,7 +2865,7 @@ Guide. 42Z9E Constraint '{0}' is not a {1} constraint. constraintName - value + constraintType @@ -2882,17 +2890,17 @@ Guide. 42ZA2 Operand of LIKE predicate with type {0} and collation {1} is not compatable with LIKE pattern operand with type {2} and collation {3}. - type - value - type - value + dataType + collationType + dataType + collationType 42ZA3 The table will have collation type {0} which is different than the collation of the schema {1} hence this operation is not supported . - type - type + collationType + schemaName @@ -2983,8 +2991,8 @@ Guide. 58009.C.12 Network protocol exception: actual code point, {0}, does not match expected code point, {1}. The connection has been terminated. - value - value + codePoint + codePoint @@ -3010,7 +3018,7 @@ Guide. 58009.C.17 Network protocol exception: end of stream prematurely reached while reading InputStream, parameter #{0}. The connection has been terminated. - value + number @@ -3049,37 +3057,37 @@ Guide. 58009.C.9 Network protocol exception: PKGNAMCSN length, {0}, is invalid at SQLAM {1}. The connection has been terminated. length - value + sqlApplicationManager 58010.C A network protocol error was encountered. A connection could not be established because the manager {0} at level {1} is not supported by the server. - value - value + managerCodePoint + level 58014.C The DDM command 0x{0} is not supported. The connection has been terminated. - value + distributedDataManagementCommand 58015.C The DDM object 0x{0} is not supported. The connection has been terminated. - value + distributedDataManagementObject 58016.C The DDM parameter 0x{0} is not supported. The connection has been terminated. - value + distributedDataManagementParameter 58017.C The DDM parameter value 0x{0} is not supported. An input host variable may not be within the range the server supports. The connection has been terminated. - value + distributedDataManagementParameterValue @@ -3171,13 +3179,13 @@ Guide. X0X61.S The values for column '{4}' in index '{0}' and table '{1}.{2}' do not match for row location {3}. The value in the index is '{5}', while the value in the base table is '{6}'. The full index key, including the row location, is '{7}'. The suggested corrective action is to recreate the index. - columnName indexName - schemaNamet + schemaName tableName - location - value - value + rowLocation + columnName + dataValue + dataValue indexKey @@ -3193,7 +3201,7 @@ Guide. X0X63.S Got IOException '{0}'. - value + exceptionText @@ -3205,8 +3213,8 @@ Guide. X0X81.S {0} '{1}' does not exist. - value - value + sqlObjectType + sqlObjectName @@ -3242,7 +3250,7 @@ Guide. X0Y16.S '{0}' is not a view. If it is a table, then use DROP TABLE instead. - value + sqlObjectName @@ -3265,9 +3273,9 @@ Guide. X0Y25.S Operation '{0}' cannot be performed on object '{1}' because {2} '{3}' is dependent on that object. operationName - objectName - value - value + sqlObjectName + sqlObjectType + sqlObjectName @@ -3303,10 +3311,10 @@ Guide. X0Y32.S {0} '{1}' already exists in {2} '{3}'. - value - value - value - value + sqlObjectType + sqlObjectName + sqlObjectType + sqlObjectName @@ -3332,11 +3340,10 @@ Guide. X0Y43.S - Constraint '{0}' is invalid: the number of columns in {0} ({1}) does not match the number of columns in the referenced key ({2}). + Constraint '{0}' is invalid: the number of columns ({1}) does not match the number of columns in the referenced key ({2}). constraintName - value - value - value + number + number @@ -3379,7 +3386,7 @@ Guide. X0Y56.S '{0}' is not allowed on the System table '{1}'. - value + sqlText tableName @@ -3398,9 +3405,9 @@ Guide. X0Y59.S Attempt to add or enable constraint(s) on table '{1}' failed because the table contains {2} row(s) that violate the following check constraint(s): {0}. - tableName - rowName constraintName + tableName + rowCount @@ -3428,22 +3435,21 @@ Guide. X0Y68.S {0} '{1}' already exists. - value - value + sqlObjectType + sqlObjectName X0Y69.S - {1} is not supported in trigger {0}. - value + DDL is not supported in trigger {0}. triggerName X0Y70.S INSERT, UPDATE and DELETE are not permitted on table {1} because trigger {0} is active. - tableName triggerName + tableName @@ -3455,8 +3461,8 @@ Guide. X0Y72.S Bulk insert replace is not permitted on '{0}' because it has an enabled trigger ({1}). - value - value + tableName + triggerName @@ -3472,15 +3478,15 @@ Guide. X0Y78.S.1 {0}.executeQuery() cannot be called because multiple result sets were returned. Use {1}.execute() to obtain multiple results. - value - value + javaInterfaceName + javaInterfaceName X0Y78.S.2 {0}.executeQuery() was called but no result set was returned. Use {1}.executeUpdate() for non-queries. - value - value + javaInterfaceName + javaInterfaceName @@ -3531,8 +3537,8 @@ Guide. XBCA0.S Cannot create new object with key {1} in {0} cache. The object already exists in the cache. - key - cache + cacheName + keyValue @@ -3556,15 +3562,15 @@ Guide. XBCM3.S Method {1}() does not exist in generated class {0}. - methodName className + methodName XBCM4.S Java class file format limit(s) exceeded: {1} in generated class {0}. - value className + limitDescriptor @@ -3622,7 +3628,7 @@ Guide. XBCXB.S Bad encryption padding '{0}' or padding not specified. 'NoPadding' must be used. - value + paddingDirective @@ -3753,13 +3759,13 @@ Guide. XBM02.D Startup failed due to missing functionality for {0}. Please ensure your classpath includes the correct Derby software. - value + moduleName XBM05.D Startup failed due to missing product version information for {0}. - value + productName @@ -3775,8 +3781,8 @@ Guide. XBM08.D Could not instantiate {0} StorageFactory class {1}. - value - value + subSubProtocol + className @@ -3887,34 +3893,34 @@ Guide. XBM0V.S An exception was thrown while loading class {1} registered for identifier {0}. - className identifierName + className XBM0W.S An exception was thrown while creating an instance of class {1} registered for identifier {0}. - className identifierName + className XBM0X.D Supplied territory description '{0}' is invalid, expecting ln[_CO[_variant]] ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale. - value + territoryID XBM03.D Supplied value '{0}' for collation attribute is invalid, expecting UCS_BASIC or TERRITORY_BASED. - value + collationName XBM04.D Collator support not available from the JVM for the database's locale '{0}'. - value + localeName @@ -4070,7 +4076,7 @@ ln=lower-case two-letter ISO-639 languag XCL30.S An IOException was thrown when reading a '{0}' from an InputStream. - value + dataType @@ -4099,13 +4105,13 @@ ln=lower-case two-letter ISO-639 languag XCL36.S The delete rule of foreign key must be {0}. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) - value + sqlText XCL37.S The delete rule of foreign key must be {0}. (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.) - value + sqlText @@ -4157,7 +4163,7 @@ ln=lower-case two-letter ISO-639 languag XCL47.S Use of '{0}' requires database to be upgraded from version {1} to version {2} or later. - value + sqlText versionNumber versionNumber @@ -4165,14 +4171,14 @@ ln=lower-case two-letter ISO-639 languag XCL48.S TRUNCATE TABLE is not permitted on '{0}' because unique/primary key constraints on this table are referenced by enabled foreign key constraints from other tables. - value + tableName XCL49.S TRUNCATE TABLE is not permitted on '{0}' because it has an enabled DELETE trigger ({1}). - value - value + tableName + triggerName @@ -4201,8 +4207,8 @@ ln=lower-case two-letter ISO-639 languag XCW00.D Unsupported upgrade from '{0}' to '{1}'. - value - value + versionID + versionID @@ -4241,15 +4247,15 @@ ln=lower-case two-letter ISO-639 languag XCY00.S Invalid value for property '{0}'='{1}'. - value - value + propertyName + propertyValue XCY02.S The requested property change is not supported '{0}'='{1}'. - value - value + propertyName + propertyValue @@ -4294,8 +4300,8 @@ ln=lower-case two-letter ISO-639 languag XCZ02.S Invalid parameter '{0}'='{1}'. - value - value + propertyName + propertyValue @@ -4305,13 +4311,6 @@ ln=lower-case two-letter ISO-639 languag Class XD00: Dependency Manager - XD003.S - Unable to restore dependency from disk. DependableFinder = '{0}'. Further information: '{1}'. - value - value - - - XD004.S Unable to store dependencies. @@ -4464,7 +4463,7 @@ ln=lower-case two-letter ISO-639 languag XJ009.S Use of CallableStatement required for stored procedure call or use of output parameters: {0} - value + sqlText @@ -4480,7 +4479,7 @@ ln=lower-case two-letter ISO-639 languag XJ012.S '{0}' already closed. - value + interfaceName @@ -4568,14 +4567,14 @@ ln=lower-case two-letter ISO-639 languag XJ042.S '{0}' is not a valid value for property '{1}'. - value + propertyValue propertyName XJ044.S '{0}' is an invalid scale. - value + number @@ -4629,8 +4628,8 @@ ln=lower-case two-letter ISO-639 languag XJ05B.C JDBC attribute '{0}' has an invalid value '{1}', valid values are '{2}'. attributeName - value - value + attributeValue + attributeValues @@ -4647,31 +4646,31 @@ ln=lower-case two-letter ISO-639 languag XJ062.S Invalid parameter value '{0}' for ResultSet.setFetchSize(int rows). - value + invalidNumber XJ063.S Invalid parameter value '{0}' for Statement.setMaxRows(int maxRows). Parameter value must be >= 0. - value + invalidNumber XJ064.S Invalid parameter value '{0}' for setFetchDirection(int direction). - value + invalidNumber XJ065.S Invalid parameter value '{0}' for Statement.setFetchSize(int rows). - value + invalidNumber XJ066.S Invalid parameter value '{0}' for Statement.setMaxFieldSize(int max). - value + invalidNumber @@ -4714,7 +4713,7 @@ ln=lower-case two-letter ISO-639 languag XJ074.S Invalid parameter value '{0}' for Statement.setQueryTimeout(int seconds). - value + invalidNumber @@ -4731,7 +4730,7 @@ ln=lower-case two-letter ISO-639 languag XJ078.S Offset '{0}' is either less than zero or is too large for the current BLOB/CLOB. - value + invalidNumber @@ -4755,7 +4754,7 @@ ln=lower-case two-letter ISO-639 languag XJ081.S Invalid value '{0}' passed as parameter '{1}' to method '{2}' - value + parameterValue parameterName methodName @@ -4806,13 +4805,6 @@ ln=lower-case two-letter ISO-639 languag - XJ096.S - A resource bundle could not be found in the {0} package for {1} - packageName - value - - - XJ097.S Cannot rollback or release a savepoint that was not created by this connection. @@ -4820,7 +4812,7 @@ ln=lower-case two-letter ISO-639 languag XJ098.S The auto-generated keys value {0} is invalid - value + keyValue @@ -4841,7 +4833,7 @@ ln=lower-case two-letter ISO-639 languag XJ104.S Shared key length is invalid: {0}. - value + invalidNumber @@ -4897,7 +4889,7 @@ ln=lower-case two-letter ISO-639 languag XJ115.S Unable to open resultSet with requested holdability {0}. - value + invalidNumber @@ -4949,13 +4941,13 @@ ln=lower-case two-letter ISO-639 languag XJ128.S Unable to unwrap for '{0}' - value + interfaceName XJ200.S Exceeded maximum number of sections {0} - value + number @@ -4979,7 +4971,7 @@ ln=lower-case two-letter ISO-639 languag XJ206.S SQL text '{0}' has no tokens. - value + sqlText @@ -5103,40 +5095,40 @@ ln=lower-case two-letter ISO-639 languag XN014.S Encountered an Exception while reading from the stream specified by parameter #{0}. The remaining data expected by the server has been filled with 0x0. The Exception had this message: {1}. - value + number messageText XN015.S Network protocol error: the specified size of the InputStream, parameter #{0}, is less than the actual InputStream length. - value + number XN016.S Encountered an Exception while trying to verify the length of the stream specified by parameter #{0}. The Exception had this message: {1}. - value + number messageText XN017.S End of stream prematurely reached while reading the stream specified by parameter #{0}. The remaining data expected by the server has been filled with 0x0. - value + number XN018.S Network protocol error: the specified size of the Reader, parameter #{0}, is less than the actual InputStream length. - value + number XN019.S Error executing a {0}, server returned {1}. - value - value + xaFunctionName + xaError @@ -5295,7 +5287,7 @@ ln=lower-case two-letter ISO-639 languag XSAI2.S The conglomerate ({0}) requested does not exist. - value + conglomerateNumber @@ -5312,7 +5304,7 @@ ln=lower-case two-letter ISO-639 languag XSAM0.S Exception encountered while trying to boot module for '{0}'. - value + interfaceName @@ -5340,10 +5332,10 @@ ln=lower-case two-letter ISO-639 languag XSAM6.S + containerName Record {2} on page {1} in container {0} not found. - recordNumber pageNumber - containerName + recordNumber @@ -5419,7 +5411,7 @@ ln=lower-case two-letter ISO-639 languag XSCB4.S A method on a btree open scan has been called prior to positioning the scan on the first row (i.e. no next() call has been made yet). The current state of the scan is ({0}). - value + number @@ -5435,14 +5427,14 @@ ln=lower-case two-letter ISO-639 languag XSCB7.S An internal error was encountered during a btree scan - current_rh is null = {0}, position key is null = {1}. - value - value + trueOrFalse + trueOrFalse XSCB8.S The btree conglomerate {0} is closed. - value + conglomerateNumber @@ -5564,7 +5556,7 @@ ln=lower-case two-letter ISO-639 languag XSDAA.S Illegal time stamp {0}, either time stamp is from a different page or of incompatible implementation - value + timestamp @@ -5611,13 +5603,13 @@ ln=lower-case two-letter ISO-639 languag XSDAK.S Wrong page is gotten for record handle {0}. - value + recordHandle XSDAL.S Record handle {0} unexpectedly points to overflow page. - value + recordHandle @@ -5659,14 +5651,14 @@ ln=lower-case two-letter ISO-639 languag XSDB2.D Unknown container format at container {0} : {1} containerName - value + number XSDB3.D Container information cannot change once written: was {0}, now {1} - value - value + number + number @@ -5692,17 +5684,17 @@ ln=lower-case two-letter ISO-639 languag XSDB7.D WARNING: Derby (instance {0}) is attempting to boot the database {1} even though Derby (instance {2}) may still be active. Only one instance of Derby should boot a database at a time. Severe and non-recoverable corruption can result and may have already occurred. - value + derbyInstanceID databaseName - value + derbyInstanceID XSDB8.D WARNING: Derby (instance {0}) is attempting to boot the database {1} even though Derby (instance {2}) may still be active. Only one instance of Derby should boot a database at a time. Severe and non-recoverable corruption can result if 2 instances of Derby boot on the same database at the same time. The derby.database.forceDatabaseLock=true property has been set, so the database will not boot until the db.lck is no longer present. Normally this file is removed when the first instance of Derby to boot on the database exits, but it may be left behind in some shutdowns. It will be necessary to remove the file by hand in that case. It is important to verify that no other VM is accessing the database before deleting the db.lck file by hand. - value + derbyInstanceID databaseName - value + derbyInstanceID @@ -5721,7 +5713,7 @@ ln=lower-case two-letter ISO-639 languag XSDBB.D Unknown page format at page {0}, page dump follows: {1} page - value + hexDump @@ -5752,7 +5744,7 @@ ln=lower-case two-letter ISO-639 languag XSDF2.S Exception during creation of file {0} for container, file could not be removed. The exception was: {1}. fileName - value + exceptionText @@ -5765,7 +5757,7 @@ ln=lower-case two-letter ISO-639 languag XSDF4.S Exception during remove of file {0} for dropped container, file could not be removed {1}. fileName - value + detailedException @@ -5777,7 +5769,7 @@ ln=lower-case two-letter ISO-639 languag XSDF7.S Newly created page failed to be latched {0} - value + pageKey @@ -5795,8 +5787,8 @@ ln=lower-case two-letter ISO-639 languag XSDFD.S Different page image read on 2 I/Os on Page {0}, first image has incorrect checksum, second image has correct checksum. Page images follows: {1} {2} page - value - value + hexDump + hexDump @@ -5838,9 +5830,9 @@ ln=lower-case two-letter ISO-639 languag XSDG2.D Invalid checksum on Page {0}, expected={1}, on-disk version={2}, page dump follows: {3} page - value - value - value + number + number + hexDump @@ -5859,7 +5851,7 @@ ln=lower-case two-letter ISO-639 languag XSDG6.D Data segment directory not found in {0} backup during restore. Please make sure that backup copy is the right one and it is not corrupted. - value + directoryPath @@ -5872,7 +5864,7 @@ ln=lower-case two-letter ISO-639 languag XSDG8.D Unable to copy directory '{0}' to '{1}' during restore. Please make sure that there is enough space and permissions are correct. directoryName - value + directoryName @@ -5889,7 +5881,7 @@ ln=lower-case two-letter ISO-639 languag XSLA0.D Cannot flush the log file to disk {0}. - value + filePath @@ -5933,9 +5925,9 @@ ln=lower-case two-letter ISO-639 languag XSLA8.D Cannot rollback transaction {0}, trying to compensate {1} operation with {2} - value - value - value + transactionID + undoableOperation + compensationOperation @@ -5951,23 +5943,23 @@ ln=lower-case two-letter ISO-639 languag XSLAC.D - Database at {0} have incompatible format with the current version of software, it may have been created by or upgraded by a later version. - value + Database at {0} has a format incompatible with the current version of software. It may have been created by or upgraded by a later version. + directoryPath XSLAD.D - log Record at instant {2} in log file {3} corrupted. Expected log record length {0}, real length {1}. - value + Log Record at instant {2} in log file {3} corrupted. Expected log record length {0}, real length {1}. + length + length + logInstant logfileName - value - value XSLAE.D Control file at {0} cannot be written or updated. - value + fileName @@ -5993,41 +5985,42 @@ ln=lower-case two-letter ISO-639 languag XSLAK.D Database has exceeded largest log file number {0}. - value + number XSLAL.D - log record size {2} exceeded the maximum allowable log file size {3}. Error encountered in log file {0}, position {1}. - value - number + Log record size {2} exceeded the maximum allowable log file size {3}. Error encountered in log file {0}, position {1}. logfileName - value + position + size + size XSLAM.D - Cannot verify database format at {1} due to IOException. - value + Cannot verify database format at {1} due to IOException: {0} + exceptionDetails + directoryPath XSLAN.D Database at {0} has an incompatible format with the current version of the software. The database was created by or upgraded by version {1}. - value + directoryPath versionNumber XSLAO.D Recovery failed unexpected problem: {0}. - value + detailedMessage XSLAP.D Database at {0} is at version {1}. Beta databases cannot be upgraded, - value + directoryPath versionNumber @@ -6041,7 +6034,7 @@ ln=lower-case two-letter ISO-639 languag XSLAR.D Unable to copy log file '{0}' to '{1}' during restore. Please make sure that there is enough space and permissions are correct. logfileName - value + logFileName @@ -6075,18 +6068,12 @@ ln=lower-case two-letter ISO-639 languag - XSLB4.S - Cannot find truncationLWM {0}. - value - - - XSLB5.S Illegal truncationLWM instant {1} for truncation point {0}. Legal range is from {2} to {3}. - value - value - value - value + logInstant + truncationPoint + logInstant + logInstant @@ -6097,8 +6084,8 @@ ln=lower-case two-letter ISO-639 languag XSLB8.S Trying to reset a scan to {0}, beyond its limit of {1}. - value - value + logInstant + logInstant @@ -6120,14 +6107,14 @@ ln=lower-case two-letter ISO-639 languag XSRS1.S Cannot backup the database to {0}, which is not a directory. - value + directoryPath XSRS4.S Error renaming file (during backup) from {0} to {1}. - value - value + fileName + fileName @@ -6257,7 +6244,7 @@ MessageId.java. 10000 Encountered error while evaluating XML query expression for {0} operator: {1} operatorName - value + detailedError @@ -6266,22 +6253,6 @@ MessageId.java. - 42Y98.U - Encountered "{0}" at line {1}, column {2} - value - lineNumber - columnNumber - - - - 42Y99.U - Lexical error at line {0}, column {1}. Encountered: {2} - lineNumber - columnNumber - value - - - 42Z00.U Java method call or field reference @@ -7374,8 +7345,8 @@ MessageId.java. XJ001.U Java exception: '{1}: {0}'. - exceptionClassName errorMessage + exceptionClassName @@ -7573,35 +7544,35 @@ MessageId.java. C003 Exception loading database jar {0} - {1} - value - value + jarName + errorMessage C004 Stale class loader for class {0} - value + className C005 Database Class Loader started - derby.database.classpath='{0}' - value + classpath C006 Loaded {0} from database jar {1} - value - value + className + jarName C007 Exception loading class {0} from jar {1} - {2} - value - value - value + className + jarName + detailedError Modified: db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java (original) +++ db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java Mon Jul 30 16:27:06 2012 @@ -390,7 +390,6 @@ public interface SQLState { */ String LOG_WRITE_LOG_RECORD = "XSLB1.S"; String LOG_BUFFER_FULL = "XSLB2.S"; - String LOG_TRUNC_LWM_NULL = "XSLB4.S"; String LOG_TRUNC_LWM_ILLEGAL = "XSLB5.S"; String LOG_ZERO_LENGTH_LOG_RECORD = "XSLB6.S"; String LOG_RESET_BEYOND_SCAN_LIMIT = "XSLB8.S"; @@ -838,7 +837,8 @@ public interface SQLState { String LANG_DUPLICATE_COLUMN_NAME_UPDATE = "42X16"; String LANG_INVALID_JOIN_ORDER_SPEC = "42X17"; String LANG_NOT_COMPARABLE = "42818"; - String LANG_NON_BOOLEAN_WHERE_CLAUSE = "42X19"; + String LANG_NON_BOOLEAN_WHERE_CLAUSE = "42X19.S.1"; + String LANG_UNTYPED_PARAMETER_IN_WHERE_CLAUSE = "42X19.S.2"; String LANG_INTEGER_LITERAL_EXPECTED = "42X20"; String LANG_CURSOR_NOT_UPDATABLE = "42X23"; String LANG_INVALID_COL_HAVING_CLAUSE = "42X24"; @@ -1018,8 +1018,6 @@ public interface SQLState { String LANG_BINARY_OPERATOR_NOT_SUPPORTED = "42Y95"; String LANG_UNKNOWN = "42Y96.U"; String LANG_INVALID_ESCAPE = "42Y97"; - String LANG_JAVACC_SYNTAX = "42Y98.U"; - String LANG_JAVACC_LEXICAL_ERROR = "42Y99.U"; String LANG_JAVA_METHOD_CALL_OR_FIELD_REF = "42Z00.U"; String LANG_UNTYPED = "42Z01.U"; // TEMPORARY COMPILATION RESTRICTIONS @@ -1109,7 +1107,6 @@ public interface SQLState { // beetle 2758. For now just raise an error for literals > 64K String LANG_INVALID_LITERAL_LENGTH = "42Z99"; String LANG_READ_UNCOMMITTED = "42Z9A"; - String LANG_VTI_BLOB_CLOB_UNSUPPORTED = "42Z9B"; String LANG_UNSUPPORTED_TRIGGER_STMT = "42Z9D"; String LANG_UNSUPPORTED_TRIGGER_PROC = "42Z9D.S.1"; String LANG_DROP_CONSTRAINT_TYPE = "42Z9E"; @@ -1491,7 +1488,6 @@ public interface SQLState { /* ** Dependency manager */ - String DEP_UNABLE_TO_RESTORE = "XD003.S"; String DEP_UNABLE_TO_STORE = "XD004.S"; /* @@ -1563,7 +1559,6 @@ public interface SQLState { String PARAM_NOT_OUT_OR_INOUT = "XJ091.S"; String BLOB_TOO_LARGE_FOR_CLIENT = "XJ093.S"; String ERROR_PRIVILEGED_ACTION = "XJ095.S"; - String MISSING_RESOURCE_BUNDLE = "XJ096.S"; String SAVEPOINT_NOT_CREATED_BY_CONNECTION = "XJ097.S"; String BAD_AUTO_GEN_KEY_VALUE = "XJ098.S"; String READER_UNDER_RUN = "XJ099.S"; Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/paramij.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/paramij.out?rev=1367150&r1=1367149&r2=1367150&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/paramij.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/paramij.out Mon Jul 30 16:27:06 2012 @@ -92,15 +92,15 @@ ERROR 42X19: The WHERE or HAVING clause ij> prepare p1 as 'select * from t1 where 1'; ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'INTEGER' expression. It must be a BOOLEAN expression. ij> prepare p1 as 'select * from t1 where ?'; -ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'PARAMETER' expression. It must be a BOOLEAN expression. +ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is an untyped parameter expression. It must be a BOOLEAN expression. ij> prepare p1 as 'select * from t1 where ? for update'; -ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'PARAMETER' expression. It must be a BOOLEAN expression. +ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is an untyped parameter expression. It must be a BOOLEAN expression. ij> prepare p1 as 'select * from t1 where (?)'; -ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'PARAMETER' expression. It must be a BOOLEAN expression. +ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is an untyped parameter expression. It must be a BOOLEAN expression. ij> prepare p1 as 'select * from t1 where ? and 1=1'; -ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'PARAMETER' expression. It must be a BOOLEAN expression. +ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is an untyped parameter expression. It must be a BOOLEAN expression. ij> prepare p1 as 'select * from t1 where ? and 1=? or 2=2'; -ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'PARAMETER' expression. It must be a BOOLEAN expression. +ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is an untyped parameter expression. It must be a BOOLEAN expression. ij> prepare p1 as 'select * from t1 where not ?'; ERROR 42X36: The 'not' operator is not allowed to take a ? parameter as an operand. ij> prepare p1 as 'select * from t1 where lower(?)';