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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2009/12/01 10:13:20 UTC
[jira] Closed: (DERBY-4456) The result is empty when the query
contains in clause and other condition at the same time
[ https://issues.apache.org/jira/browse/DERBY-4456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen closed DERBY-4456.
-------------------------------------
Resolution: Duplicate
Closing as a duplicate of DERBY-3061, which was introduced in 10.3.1.4 and fixed in 10.3.2.1.
> The result is empty when the query contains in clause and other condition at the same time
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-4456
> URL: https://issues.apache.org/jira/browse/DERBY-4456
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.1.4
> Reporter: Mingxia Wu
>
> I have a Customers table which contains an0 Integer column named CustomerNumber,
> CustomerNumber
> 101 ...
> 102
> 103
> 104
> 105
> 106
> When I execute the following query in my client with jdbc:
> Select * from Customers where CustomerNumber <105 AND CustomerNumber IN (101,103,104)
> The result is empty.
> Expected behavior:
> The result return 3 records, 101, 103 and 104
> If I change the query like:
> Select * from Customers where CustomerNumber IN (101,103,104), it works.
> Select * from Customers where CustomerNumber <105, it also works.
> I also test it on another database,like sql server, it works ok.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.