2. Recognize TRUE and FALSE as constants. (For compatibility, if there exist columns named "true" or "false", then the identifiers refer to the columns rather than Boolean constants.) 3. Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE.
On the documentation side of things I think https://sqlite.org/draft/lang_expr.html is gonna need a number of updates or additions to go over those a bit more. Including a reminder that [is true] is a new operator of two words which is a unary postfix operator, and that it isn't [is](the existing operator) [true](the new alias for 1) sqlite> select 2 is true; 2 is true 1 sqlite> select 2 is 1; 2 is 1 0 sqlite> select true is 2; true is 2 0 Hmm, my brain is sort of working, but not completely. Since [is true] is a unary postfix operator but we're respecting existing column names, how does "something is true" get parsed? Let's check... Looks like it prefers x [is] [true](column) over x [is true](postfix) sqlite> create table foo (true boolean); sqlite> insert into foo (true) values (false); sqlite> select * from foo; true 0 sqlite> select 1 is true; 1 is true 1 sqlite> select 1 is true from foo; 1 is true 0 sqlite> select 1, true, 1 is true from foo; 1|true|1 is true 1|0|0 Too much thinking, brain hurts now. -----Original Message----- From: sqlite-users [mailto:[email protected]] On Behalf Of Richard Hipp Sent: Thursday, March 22, 2018 3:09 PM To: General Discussion of SQLite Database; sqlite-dev Subject: [sqlite] The upcoming 3.23.0 release SQLite version 3.23.0 will probably be released soon, in early April. For a summary of changes see https://sqlite.org/draft/releaselog/3_23_0.html Please download the latest Pre-release Snapshot (https://sqlite.org/download.html) and test out the latest SQLite in your applications. Report any issues, either to this mailing list, or directly to me at [email protected]. All of our regression tests are passing with 100% branch coverage. However, passing over 100 million test cases do not guarantee that all is well, since developers who use SQLite tend to be very creative and wind up using SQLite in ways that we never thought to test. Hence, your independent verification is helpful to us and much appreciated. The release checklist for 3.23.0 is found at https://www.sqlite.org/checklists/3230000/index We have not yet frozen the code nor started the release checklist. But we will do that soon. You can follow our progress on the checklist. The release will occur when the checklist goes all-green. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
