This query that used to work on the 10.2 version now return no results on 10.3.1.4:

SELECT MYTABLE.MY_ID
 FROM MYTABLE
 WHERE MYTABLE.MY_ID < 100 AND MYTABLE.MY_ID IN (
2,15,19,20,21,48,49
)

Both parts of the AND expression work OK on their own, but when combined you get 0 rows

Thanks
Tim

Reply via email to