Re: [jira] Created: (DERBY-2256) Wrong Results: Use of decimal values in an IN-list with INTEGER left operand can lead to extra rows.

[Bryan Pendleton]

-- But this one returns 1 row...
ij> select * from t1 where i in (2.8, 4.23);
I
-----------
4

Is the 2-element IN list being converted to a BETWEEN expression, perhaps?

bryan