SQLite Forum

"SQL Features That SQLite Does Not Implement" needs updating
Login

"SQL Features That SQLite Does Not Implement" needs updating

(1) By Simon Willison (simonw) on 2021-03-12 23:26:01 updated by 1.1 [source]

https://www.sqlite.org/omitted.html still says "Other kinds of ALTER TABLE operations such as DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT, and so forth are omitted." - that's no longer accurate as-of SQLite 3.35.

"SQL Features That SQLite Does Not Implement" needs updating

(1.1) By Simon Willison (simonw) on 2021-03-12 23:26:22 edited from 1.0 [link] [source]

www.sqlite.org/omitted.html still says "Other kinds of ALTER TABLE operations such as DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT, and so forth are omitted." - that's no longer accurate as-of SQLite 3.35.

(2) By Larry Brasfield (larrybr) on 2021-03-14 20:13:10 in reply to 1.1 updated by 2.1 [link] [source]

FYI and FWIW, Your correct observation is not being ignored.

(2.1) By Larry Brasfield (larrybr) on 2021-03-14 20:16:39 edited from 2.0 in reply to 1.1 [link] [source]

FYI, Your correct observation has not been ignored. Thanks for the report.

(3) By Decker (d3x0r) on 2021-03-14 23:58:48 in reply to 1.1 [link] [source]

Getting the alias specified for a table in a query from the result set should be added.

(4) By Larry Brasfield (larrybr) on 2021-03-15 00:05:22 in reply to 3 [link] [source]

Getting the alias specified for a table in a query from the result set should be added.

Could you please clarify? I do not understand either "getting the alias specified for a table in a query from the result set" or where you believe that should be added.