[
https://issues.apache.org/jira/browse/DERBY-3061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
A B resolved DERBY-3061.
------------------------
Resolution: Fixed
Fix Version/s: 10.4.0.0
10.3.1.5
Derby Info: [Regression] (was: [Regression, Patch Available])
The merge to 10.3 was clean and the regression tests ran without error
(derbyall and suites.All) on Red Hat Linux:
svn merge -r 574634:574635
https://svn.apache.org/repos/asf/db/derby/code/trunk
So I committed d3061_v2.patch to the 10.3 branch with svn # 574730:
URL: http://svn.apache.org/viewvc?rev=574730&view=rev
I'm marking the issue as RESOLVED but will leave it up to Tim Dudgeon and/or
Rick Hillegas to verify and either close or re-open as appropriate.
> 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
> Fix For: 10.3.1.5, 10.4.0.0
>
> Attachments: d3061_v1.patch, d3061_v1.stat, d3061_v2.patch
>
>
> 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.
