-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 [email protected] wrote: > The following comment has been added to this issue: > > Author: Erik Bengtson > Created: Mon, 11 Oct 2004 4:07 AM > Body: > > "SQL Exception: Comparisons between 'VARCHAR' and 'INTEGER' are not supported." > > The above text between quotes is the Derby exception. I suggest that you try this to reproduce: > > create table xxxx ( COLUMN_A INT, COLUMN_B INT ) > > conn.prepareStatement("SELECT * FROM xxxx where COLUMN_B >= ?");
I don't any error running this specific example. Does this simple example reproduce the problem for you, or just the join case in the bug description? Erik, if the simple case does reproduce the problem, can you provide some more information, such as which platform, which jvm, did you build Derby yourself (jikes or javac) or use the snapshot from the site. The output of this would be useful java org.apache.derby.tools.sysinfo Otherwise the original create table statements will be needed to resolve the join issue case, as well as the environment information. Dan. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFBaqXjIv0S4qsbfuQRAgiOAJ9axuxduTkd1TXUibRzO79Qg2CfYgCeLZS2 vSWODTZvCeR0Qr540R7r3To= =0eQI -----END PGP SIGNATURE-----
