On Sun, Jun 13, 2010 at 10:04:51PM +0200, Kees Nuyt scratched on the wall:

> There appears to be an error in the description of the
> SELECT statement on http://www.sqlite.org/lang_select.html .

  The syntax diagrams have several instances of things that the
  diagrams allow, but are not legal SQL statements.  I think this
  would be included in that category.  The diagrams are more of a
  guide than definitive documentation on the parse syntax or the
  allowed language (which is a bit different than what the parser
  allows).

  Consider that "SELECT * FROM t1 NATURAL CROSS JOIN t2 ON (ex)" is
  allowed by the diagrams, yet that makes no sense.  There are several
  other examples.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to