On 27 Apr 2019, at 8:46pm, Manuel Rigger <rigger.man...@gmail.com> wrote:
> INSERT INTO test(c0, c1) VALUES ("c1", 0);
Technically, SQLite should return an error for that, since you supplied an
entity name "c1" where it wanted an expression. For historical compatibility
reasons, SQLite will accept the "c1" and interpret it as, if I recall
correctly, 'c1'.
Please don't rely on this since not only does it make your code difficult for
others to read, but there may, in some future version, be a 'strict' mode which
disables it.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
