[
https://issues.apache.org/jira/browse/DERBY-3061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525970
]
Bryan Pendleton commented on DERBY-3061:
----------------------------------------
Hi Army, the patch looks good to me. Your explanation makes sense, and is
persuasive. The code change seems fine to me. Thanks for adding the comment to
the code, as this is a tricky subject, and the comment helps considerably here.
I applied the patch and tested, and the new test fails as expected without your
code change, and passes as expected with your code change. Thanks for picking
up this issue! +1 to commit.
> Wrong results from query with two conjuncts
> -------------------------------------------
>
> Key: DERBY-3061
> URL: https://issues.apache.org/jira/browse/DERBY-3061
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.1.4
> Reporter: Rick Hillegas
> Assignee: A B
> Priority: Critical
> Attachments: d3061_v1.patch, d3061_v1.stat
>
>
> Tim Dudgeon, on the user list, reports that the following query returns no
> results in 10.3.1.4 but works correctly in 10.2. I have verified that the
> query returns no results in the mainline as well. If you eliminate either of
> the the conjuncts, then the query returns the correct results:
> SELECT MYTABLE.MY_ID
> FROM MYTABLE
> WHERE MYTABLE.MY_ID < 100 AND MYTABLE.MY_ID IN (
> 2,15,19,20,21,48,49
> )
> Here is a more complete script which demonstrates the problem:
> drop table mytable;
> create table mytable ( id int primary key );
> insert into mytable ( id )
> values
> ( 0 ), ( 1 ), ( 2 ), ( 3 ), ( 4 ), ( 5 ), ( 6 ), ( 7 ), ( 8 ), ( 9 );
> insert into mytable select id + 10 from mytable;
> insert into mytable select id + 20 from mytable;
> insert into mytable select id + 40 from mytable;
> insert into mytable select id + 100 from mytable;
> select mytable.id
> from mytable
> where mytable.id < 100;
> select mytable.id
> from mytable
> where mytable.id in ( 2, 15, 19, 20, 21, 48, 49 );
> select mytable.id
> from mytable
> where mytable.id < 100
> and mytable.id in ( 2, 15, 19, 20, 21, 48, 49 );
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
