[ http://issues.apache.org/jira/browse/DERBY-887?page=comments#action_12364280 ]
Rick Hillegas commented on DERBY-887: ------------------------------------- Hi Manjula, Could you attach a script (including the ddl and table population) which demonstrates this problem? The following simplified test seems to work correctly. Thanks. ij> connect 'jdbc:derby:testdb'; ij> --connect 'jdbc:derby:testdb;create=true'; --connect 'jdbc:derby://localhost:8246/testdb'; drop table t1; 0 rows inserted/updated/deleted ij> create table t1( id bigint ); 0 rows inserted/updated/deleted ij> insert into t1 ( id ) values ( 0 ), ( 1 ), ( 2 ), ( 4 ); 4 rows inserted/updated/deleted ij> select * from t1 where id = true; ID -------------------- 1 2 4 3 rows selected ij> select * from t1 where id = 0<3; ID -------------------- 1 2 4 3 rows selected > Select statement returns wrong number of rows if you compare an integer > column with a boolean expression in the where clause > ---------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-887 > URL: http://issues.apache.org/jira/browse/DERBY-887 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.2.0.0 > Environment: Java : java version "1.5.0_02" > Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_02-b09) > Java HotSpot(TM) Client VM (build 1.5.0_02-b09, mixed mode) > Classpath : c:/pantry/derby.jar;c:/pantry/derbytools.jar; > OS: Windows XP Professional > Reporter: Manjula Kutty > Fix For: 10.2.0.0 > > I have a table with 2 columns one is BIGINT which is Generated always > starting with 1 and increment by1 and the other one is timestamp > ij> select id,date from inbox where id = 0<3; > ID |DATE > ----------------------------------------------- > 25 |2006-01-26 14:35:46.584 > 34 |2006-01-26 14:36:16.588 > 21 |2006-01-26 14:34:46.455 > 22 |2006-01-26 14:34:47.176 > 27 |2006-01-26 14:35:47.054 > 24 |2006-01-26 14:35:16.58 > 28 |2006-01-26 14:35:47.305 > 35 |2006-01-26 14:36:18.771 > 31 |2006-01-26 14:35:48.496 > 32 |2006-01-26 14:35:48.887 > 33 |2006-01-26 14:35:49.308 > 11 rows selected > ij> select id,date from inbox where id = true; > ID |DATE > ----------------------------------------------- > 21 |2006-01-26 14:34:46.455 > 1 row selected > Both queries should return same number of rows > Also If I delete the first row from the table then select id,date from inbox > where id = true; returns the second row > ij> delete from inbox where id=21; > 1 row inserted/updated/deleted > Then again run > ij> select id ,date from inbox where id=true; > ID |DATE > ----------------------------------------------- > 22 |2006-01-26 14:35:16.58 > Which indicates that the select returns only the first row and then is > getting closed -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
