Works for me with 3.25.3. What version of sqlite are you using? On Thu, Nov 15, 2018, 12:05 PM Jake <jake.c...@gmail.com wrote:
> I know the fact that DELETE and UPDATE don't accept a table alias has come > up here a couple of years ago, but I think this should be filed as a bug > because the syntax documentation explicitly shows it being accepted. Both > statements are documented as taking a qualified-table-name: > > qualified-table-name: > https://www.sqlite.org/syntaxdiagrams.html#qualified-table-name > > Delete: https://www.sqlite.org/syntaxdiagrams.html#delete-stmt > Update: https://www.sqlite.org/syntaxdiagrams.html#update-stmt > > And qualified-table-name has the optional [AS <alias>] component. > > This page places extra restrictions only in the context of triggers: > https://www.sqlite.org/lang_delete.html > > Even the trigger restrictions do not mention the alias clause. > > -Jake Cobb > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users