[DERBY-4464] "select * from table where intColumn < int3 and intColumn in (int1, int2)" always returns empty

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.2.1
• Component/s: SQL
• Environment: OS: windows; DB: 10.3.1.4 - (561794); JDBC Driver: Apache Derby Embedded JDBC Driver
• Urgency: Normal
• Bug behavior facts: Wrong query result
• Assignee: Unassigned
• Reporter: Wenjie Tu
• Created: 08/Dec/09 05:44
• Updated: 08/Dec/09 09:52
• Resolved: 08/Dec/09 09:52

Description

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

Issue Links

• duplicates: DERBY-3061 Wrong results from query with two conjuncts