You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <de...@db.apache.org> on 2006/01/28 00:48:05 UTC
[jira] Commented: (DERBY-887) Select statement returns wrong number
of rows if you compare an integer column with a boolean expression in the
where clause
[ 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