Klaas Van B. wrote:
> Since 3.23 the words FALSE and TRUE should be added to SQLite Query Language:
> SQLite Keywords.
But FALSE and TRUE are not keywords.
<http://www.sqlite.org/lang_keywords.html> says that
| keywords ... may not be used as the names of tables, indices, columns,
| ... or any other named object.
While <http://www.sqlite.org/lang_expr.html#booleanexpr> says that
| SQLite recognizes the *identifiers* "TRUE" and "FALSE" as boolean
| literals, if and only if those identifiers are not already used for
| some other meaning. If there already exists columns or tables or other
| objects named TRUE or FALSE, then for the sake of backwards
| compatibility, the TRUE and FALSE identifiers refer to those other
| objects, not to the boolean values.
In other words, TRUE and FALSE behave like predefined global variables.
sqlite-users mailing list