Maybe there could be a strict switch. It could also be useful for developing/testing stuff on SQLite that would later be sent to different a RDBMS or a custom SQL processor.
*Jonas Malaco Filho* 2012/10/31 Richard Hipp <d...@sqlite.org> > On Wed, Oct 31, 2012 at 10:13 AM, Ryan Johnson > <ryan.john...@cs.utoronto.ca>wrote: > > > On 31/10/2012 9:54 AM, Samuel Neff wrote: > > > >> We wrote a query and intended to use a "natural" join but had a typo and > >> wrote "natrual" join instead. We were surprised this query was > processed > >> without error and performed a cross join. > >> > > That must have been a delightful one to track down... > > > > It's due to the (non-standard?) support for specifing table aliases > > without the keyword AS. In other words, sqlite3 sees the following as > > identical: > > > > sqlite> select natral.* from a natral join b; > > sqlite> select natral.* from a as natral join b; > > > > ... and will reject this: > > sqlite> select a.* from a natral join b; > > > > Whether this is a bug or a feature, I'm not sure... but it clearly had an > > unintended consequence in your case. > > > > I copied this syntax from PostgreSQL > > > > > > Ryan > > > > > > ______________________________**_________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users< > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
