Unsupported `CREATE VIEW` syntax

dolthub / dolt

Dolt – Git for Data

Apache License 2.0

17.94k stars 510 forks source link

Unsupported `CREATE VIEW` syntax #3117

Closed VinaiRachakonda closed 2 years ago

VinaiRachakonda commented 2 years ago

We should support the full range of CREATE VIEW` with a query like this

CREATE ALGORITHM=UNDEFINED DEFINER=`vinairachakonda`@`localhost` SQL SECURITY DEFINER VIEW `myview` AS select `parent`.`pk` AS `pk`,`parent`.`v1` AS `v1` from `parent`;

Specifically we are missing the

ALGORITHM Parameter
SQL SECRUITY DEFINER parameter

jennifersp commented 2 years ago

Parsing the syntax is now supported, https://github.com/dolthub/go-mysql-server/pull/935