ERROR 42Y03: 'ASCII' is not recognized as a function or procedure.

• Key: JDO-108
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Major
• Assignee: Erik Bengtson
• Reporter: Michelle Caisse
• Component/s: tck2
• Fix Version/s: JDO 2 beta

Description

Three tests affected:
org.apache.jdo.tck.query.operators.BinaryAddition
org.apache.jdo.tck.query.operators.BinarySubtraction
org.apache.jdo.tck.query.operators.SignInversion

(org.apache.jdo.tck.query.operators.BinaryAddition)javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT 'org.apache.jdo.tck.pc.mylib.PrimitiveTypes' AS JPOXMETADATA,THIS.PRIMITIVETYPES,THIS.BIGDECIMAL,THIS.BIGINTEGER,THIS.BOOLEANNOTNULL,THIS.BOOLEANNULL,THIS.BYTENOTNULL,THIS.BYTENULL,THIS.CHARNOTNULL,THIS.CHARNULL,THIS.DATENULL,THIS.DOUBLENOTNULL,THIS.DOUBLENULL,THIS.FLOATNOTNULL,THIS.FLOATNULL,THIS.ID,THIS.INTNOTNULL,THIS.INTNULL,THIS.LONGNOTNULL,THIS.LONGNULL,THIS.SHORTNOTNULL,THIS.SHORTNULL,THIS.STRINGNULL FROM applicationidentity0.PRIMITIVETYPES THIS WHERE ASCII(THIS.CHARNULL) + 1 = ?" : 'ASCII' is not recognized as a function or procedure.

ERROR 42Y03: 'ASCII' is not recognized as a function or procedure.

at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)

at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(StaticMethodCallNode.java)

at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(JavaToSQLValueNode.java)

at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java)

at org.apache.derby.impl.sql.compile.BinaryArithmeticOperatorNode.bindExpression(BinaryArithmeticOperatorNode.java)

at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java)

at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(BinaryComparisonOperatorNode.java)

at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java)

at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java)

at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java)

at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(ReadCursorNode.java)

at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java)

at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java)

at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)

at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java)

at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java)

at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java)

at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java)

at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java)

at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)

at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)

at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:303)

at org.jpox.store.StatementText.prepareStatement(StatementText.java:194)

at org.jpox.store.query.JDOQLQuery.performExecute(JDOQLQuery.java:654)

at org.jpox.store.query.Query.executeWithMap(Query.java:891)

at org.jpox.store.query.Query.executeWithArray(Query.java:871)

at org.jpox.store.query.Query.execute(Query.java:803)

at org.apache.jdo.tck.query.QueryTest.runSimplePrimitiveTypesQuery(QueryTest.java:219)

at org.apache.jdo.tck.query.operators.BinaryAddition.runTest(BinaryAddition.java:117)

at org.apache.jdo.tck.query.operators.BinaryAddition.test(BinaryAddition.java:65)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197)

at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128)

at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106)

.

at org.jpox.store.query.JDOQLQuery.performExecute(JDOQLQuery.java:719)

at org.jpox.store.query.Query.executeWithMap(Query.java:891)

at org.jpox.store.query.Query.executeWithArray(Query.java:871)

at org.jpox.store.query.Query.execute(Query.java:803)

at org.apache.jdo.tck.query.QueryTest.runSimplePrimitiveTypesQuery(QueryTest.java:219)

at org.apache.jdo.tck.query.operators.BinaryAddition.runTest(BinaryAddition.java:117)

at org.apache.jdo.tck.query.operators.BinaryAddition.test(BinaryAddition.java:65)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197)

at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128)

at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106)