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 firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users