This mailing list strips attachments. Please include the SQL text in-line.
On Tue, Feb 25, 2014 at 11:24 AM, Mark Lawrence <no...@null.net> wrote: > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
