http://www.sqlite.org/src/info/bc878246ea
On Wed, Aug 28, 2013 at 10:20 AM, E.Pasma <pasm...@concepts.nl> wrote: > An experimantal query, involving OUTER JOIN with BETWEEN and JOIN with a > combined OR and AND expression, does not return all expected rows. I tried > this just after SQLite 3.8.0. was released and found that the issue is > particular to this version. At least it is alright in version 3.7.17. > Below is a simplified case. This is still complex but if you leave out > anything further, the problem no longer occurs. Hope it is useful to report > this. > > .echo on > .version > SQLite 3.8.0 2013-08-26 04:50:08 f64cd21e2e23ed7cff48f7dafa5e76** > adde9321c2 > CREATE TABLE t (id INTEGER PRIMARY KEY NOT NULL) > ; > INSERT INTO t VALUES (1) > ; > SELECT * > FROM t t1 > LEFT OUTER JOIN t t2 ON t2.id BETWEEN 10 AND 20 > JOIN t t3 ON > ( > t3.id = t1.id > OR t2.id IS NOT NULL AND t3.id = t2.id > ) > ; > > -- E Pasma > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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
