On Tue Feb 25, 2014 at 09:37:41AM -0500, Richard Hipp wrote:
> Can you please send the database schema, and possibly some test data?
Attached is an SQL file containing enough to reproduce the issue on my
system:
* Schema for the tables
* Rows for the tables
* 4 queries demonstrating the issue:
1. Single SELECT query #1
2. Single SELECT query #2
3. UNION ALL query of #1 and #2
4. UNION ALL query of #1 and #2 plus ORDER BY
Note that there are of course a bunch of other tables and triggers not
included, but I think they are irrelevant given I can reproduce the
issue with what is in the file.
Mark.
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
