select inf; should be true or false? :)
On Mon, May 5, 2014 at 8:18 AM, mm.w <0xcafef...@gmail.com> wrote: > Hello, > > "an empty string should be false" strongly disagree, a NULL string should > be solely false, now in this case, the question is: comparisons should be > handled as bin or by; 'literal' values? or equality/comparison must not be > eval'ed and strictly made on type? > > one other of the quirk would be to cast to a float, ugly I might admit. > > Best. > > > > On Sun, May 4, 2014 at 4:14 PM, James K. Lowden > <jklow...@schemamania.org>wrote: > >> On Fri, 2 May 2014 21:09:46 +0200 >> Petite Abeille <petite.abei...@gmail.com> wrote: >> >> > >> > On May 2, 2014, at 8:54 PM, Richard Hipp <d...@sqlite.org> wrote: >> > >> > > I'm guessing that Mr. Abeille is upset that SQLite ? >> > >> > ? doesn?t even bother with SQL syntax and will happily accept any old >> > junk as a sorry excuse for a query. >> > >> > select 1 where null; >> > select 1 where not null; >> > >> > When SQLite 4 sees the light of the day, I wish for a strict SQL >> > parser and proper error messages. >> >> To amplify the point, the issue isn't pure fussiness or obligation to >> adhere to standards. A permissive parser invites error. >> >> It's not hard to imagine >> >> select 1 where 1 - 1; >> >> was intended as >> >> select 1 where 1 = 1; >> >> which, in the midst of a large query producing expected results, might >> easily be overlooked. >> >> I doubt Petite is confused by boolean evaluation, but rather is >> dismayed by its appearance in this context. >> >> SQL is not C. To the extent the SQL supplied by SQLite is nonstandard, >> it might as well be another language entirely. The better one knows >> SQL, the harder a nonconformant implementation is to use. >> >> Not long ago I was helping someone with a query in MS Access. Easy, >> just use a correlated subquery in an update statement. Hard, if >> it chokes the parser. Perhaps you know the joke with the punchline, >> "Assume a can opener." >> >> --jkl >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
