Sqlite 3.7.5. Possible NATURAL JOIN bug.
I have a ~100 MB database which gives me odd results when running two similar
queries. I'm currently trying to create a minimal test case, but the error
seems to go away when I try to narrow it down.
In short, the queries look like this (scrambled :P)...
SELECT N FROM (Y JOIN S USING (S_ID) JOIN B USING (A_ID)) NATURAL JOIN ((SELECT
A_ID, N FROM C NATURAL JOIN A) NATURAL JOIN A) GROUP BY N ORDER BY N;
3 rows returned
SELECT N FROM (Y JOIN S USING (S_ID) JOIN B USING (A_ID)) NATURAL JOIN ((SELECT
A_ID, N FROM C NATURAL JOIN A)) GROUP BY N ORDER BY N;
4 rows returned
Obviously, the extra "natural join" eliminates one row somehow. I'm quite
convinced I'm facing a rare bug here.
Where can I send my 100 MB database for assistance? (In case I don't manage to
narrow it down.)
Thanks!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users