db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: [jira] Commented: (DERBY-37) detection of incorrect types comparison is done at ? parameters
Date Mon, 11 Oct 2004 15:25:23 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

derby-dev@db.apache.org 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-----


Mime
View raw message