Hello,
We just updated System.Data.SQLite to ver 1.0.89 and we started to have
issues with some of our queries. We cannot locate the issue, so I'm attaching
the database and a query so it can be recreated.
In the Query:
1. we select Products from [Products] table, we join them with [ProductPreviews]
table.
2. we select from [Products_UserItems] table
3. we create UNION ALL between the two results
What happens is, that only the first record from [Products_UserItems] is read
from the database This happens only with some of the records in the tables,
not for all.
This query is working fine with ver 1.0.81.
Thanks,
Nikola
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
