Re: [sqlite] SQL join with "or" condition gives unexpected results

On Thu, May 9, 2013 at 10:22 AM, Simon Slavin wrote: > > Just checking ... you do know that SQLite has both > > INSERT OR ABORT ... > INSERT OR FAIL ... > > statements ? I do. But my application is (so far) database agnostic, and SQLite's behaviour is not being consistent

[sqlite] SQL join with "or" condition gives unexpected results

* reproduce that with sqlite3 3.7.9 2011-11-01 00:52:41 c7c6050e... I *cannot* reproduce that with sqlite3 3.7.8 2011-09-19 14:49:19 3e0da808... Tests were done on Ubuntu 13.04 3.8.0-19-generic x86_64. It looks like 3.7.9 introduced a bug? Regards, Romulo Ceccon __