-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 19/12/13 15:36, RSmith wrote: > With this query you essentially ask the RDBMS to evaluate and supply > you with the result of (X and 0) - my guess is the optimiser pounces > directly on the fact that (X and 0) will always be 0 no matter what X > is so that it does not bother trying to evaluate X which means it never > has the need to resolve the name and so never needs to raise the > error.
Confirmed: sqlite> select nonsense or 0; SQLError: no such column: nonsense sqlite> select 1 or nonsense; SQLError: no such column: nonsense sqlite> select nonsense and 0; 0 Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) iEYEARECAAYFAlKzo/8ACgkQmOOfHg372QTyVACfbNlMOQR5nxfzgUg7tY5pF8il d0sAnjIp9K/aAIFXZcbc+pZvDdK6tN0x =Siia -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
