-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/11/12 12:33, Mark Brand wrote: > The optionality of "AS" when aliasing column names is not strange.
You are missing the point :-) I am not arguing for syntax changes or anything else in the core of SQLite or SQL. Instead in an additional "lint" mode, it should point out when you neglected to use AS. The purpose of lint mode is to reduce the probability of bugs or unintended consequences in your code. Omitting AS is one way to increase bug probability as this thread shows. (Another example would be if query strings are generated and column names containing spaces are not quoted.) There are an ever expanding list of things a lint mode would help with as you gave. I'm just hoping the SQLite team can figure out a way of providing such a mode given constraints, while still keeping SQLite "lite". Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlCS2LoACgkQmOOfHg372QSOQgCfUaBHQrRpHpM6PF/BnCUrn5+G oeQAn1+bcF+A/D/hdKz7iLVsVVJca5MO =fP/G -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
