Comparisons between 'INTEGER' and 'CHAR' are not supported. - Derby

• Key: JDO-102
• 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.models.fieldtypes.TestHashMapStringKeyCollections
org.apache.jdo.tck.models.fieldtypes.TestHashtableStringKeyCollections
org.apache.jdo.tck.models.fieldtypes.TestMapStringKeyCollections

test(org.apache.jdo.tck.models.fieldtypes.TestHashMapStringKeyCollections)javax.jdo.JDODataStoreException: Get request failed : SELECT THIS.BIG_DECIMALVAL FROM applicationidentity0.HASHMAP_STR_BIG_DECIMAL104 THIS WHERE 1 = THIS.IDENTIFIER AND THIS.KEYVAL = 'World'
at org.jpox.store.rdbms.scostore.AbstractMapStore.getValue(AbstractMapStore.java:617)
at org.jpox.store.rdbms.scostore.NormalMapStore.put(NormalMapStore.java:582)
at org.jpox.store.rdbms.scostore.AbstractMapStore.putAll(AbstractMapStore.java:284)
at org.jpox.store.mapping.MapMapping.postUpdate(MapMapping.java:289)
at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1810)
at org.jpox.store.StoreManager.update(StoreManager.java:710)
at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4069)
at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2917)
at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:431)
at org.apache.jdo.tck.models.fieldtypes.TestHashMapStringKeyCollections.runTest(TestHashMapStringKeyCollections.java:116)
at org.apache.jdo.tck.models.fieldtypes.TestHashMapStringKeyCollections.test(TestHashMapStringKeyCollections.java:70)
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)
NestedThrowablesStackTrace:
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(BinaryComparisonOperatorNode.java)
at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(BinaryComparisonOperatorNode.java)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java)
at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(BinaryLogicalOperatorNode.java)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(AndNode.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.rdbms.scostore.AbstractMapStore.getValue(AbstractMapStore.java:562)
at org.jpox.store.rdbms.scostore.NormalMapStore.put(NormalMapStore.java:582)
at org.jpox.store.rdbms.scostore.AbstractMapStore.putAll(AbstractMapStore.java:284)
at org.jpox.store.mapping.MapMapping.postUpdate(MapMapping.java:289)
at org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266)
at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1810)
at org.jpox.store.StoreManager.update(StoreManager.java:710)
at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4069)
at org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2917)
at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:431)
at org.apache.jdo.tck.models.fieldtypes.TestHashMapStringKeyCollections.runTest(TestHashMapStringKeyCollections.java:116)
at org.apache.jdo.tck.models.fieldtypes.TestHashMapStringKeyCollections.test(TestHashMapStringKeyCollections.java:70)
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)