"select * from table where intColumn < int3 and intColumn in (int1, int2)"
always returns empty
--------------------------------------------------------------------------------------------------
Key: DERBY-4464
URL: https://issues.apache.org/jira/browse/DERBY-4464
Project: Derby
Issue Type: Bug
Components: SQL
Environment: OS: windows
DB: 10.3.1.4 - (561794)
JDBC Driver: Apache Derby Embedded JDBC Driver
Reporter: Wenjie Tu
There is a "CUSTOMERS" table with an INTEGER type column "CUSTOMERNUMBER".
Access db through Apache Derby Embedded JDBC Driver,
"select CUSTOMERNUMBER from CUSTOMERS where CUSTOMERNUMBER in (103, 112)"
returns 103 and 112 two rows.
However "select CUSTOMERNUMBER from CUSTOMERS where CUSTOMERNUMBER < 121 and
CUSTOMERNUMBER in (103, 112)" returns empty
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
