db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: query failing on 10.3.1.4
Date Fri, 07 Sep 2007 13:31:25 GMT
Thanks for finding this bug, Tim. I have verified that this occurs in 
the development mainline as well. I have created DERBY-3061 to track 
this issue.

Regards,
-Rick

Tim Dudgeon wrote:
> 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