Please retry your test without using keywords like "inner" as an alias for something.
regards, Adam On Wed, Aug 24, 2016 at 11:26 PM, Richard Newman <rnew...@mozilla.com> wrote: > Hi folks, > > According to my reading of < > https://www.sqlite.org/syntax/table-or-subquery.html>, a table alias for a > subquery does not require an AS; that is, > > SELECT noo.foo FROM ( SELECT … FROM bar ) AS noo > > > is equivalent to > > SELECT noo.foo FROM ( SELECT … FROM bar ) noo > > > This does not seem to be the case with 3.14.1: > > SQLite version 3.14.1 2016-08-11 18:53:32 > Enter ".help" for usage hints. > sqlite> CREATE TABLE bar (e BLOB, a BLOB, v BLOB); > sqlite> SELECT DISTINCT inner.uri AS uri FROM > ...> (SELECT DISTINCT v AS uri FROM bar) > ...> AS inner; > sqlite> SELECT DISTINCT inner.uri AS uri FROM > ...> (SELECT DISTINCT v AS uri FROM bar) > ...> inner; > Error: near ";": syntax error > > > Am I misreading the docs, or is this a bug? > > Thanks, > > -Richard > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- -------------- VerifEye Technologies Inc. 151 Whitehall Dr. Unit 2 Markham, ON L3R 9T1 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
