db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject query failing on 10.3.1.4
Date Fri, 07 Sep 2007 09:50:53 GMT
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


Mime
View raw message