Nico Williams wrote:
On Thu, Nov 1, 2012 at 5:18 PM, Mark Brand <mabr...@mabrand.nl> wrote:
Why should the "missing" AS even be a warning in lint mode? SQL-92 does not
mandate it. One of the most important implementations does not even accept
it. Do you know of any SQL implementation that requires an AS here?
To catch misspellings of NATURAL, as in this case, naturally (heh).
Lint programs typically have options for warnings to enable/disable,
so let this warning be a user choice, no?
A warning for "missing" AS would create noise and serve no purpose.
The misspelling of NATURAL would be caught by a warning for JOIN without
ON constraint. A warning for this makes sense because an (INNER) JOIN
without an ON clause is not allowed by by SQL-92 or any implementation
besides sqlite that I am aware of.
In my opinion, it's actually a good idea to leave out the AS in table
aliases since SQL-92 and many or most implementations do not require the
AS, and at least one prominent implementation does not allow it.
Mark
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
