Re: [sqlite] DELETE does not accept AS alias despite documentation

2018-11-17 Thread Jake
__ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > ---------- > > Message: 7 > Date: Thu,

Re: [sqlite] DELETE does not accept AS alias despite documentation

2018-11-15 Thread Shawn Wagner
Works for me with 3.25.3. What version of sqlite are you using? On Thu, Nov 15, 2018, 12:05 PM Jake 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

[sqlite] DELETE does not accept AS alias despite documentation

2018-11-15 Thread Jake
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: