skeema / skeema / 10274552331

92%

push

github

SQL processor: parse and ignore OR REPLACE in CREATE statements

In MariaDB, all object types support CREATE OR REPLACE syntax. MySQL also
supports this for CREATE VIEW only. Although Skeema's dump-style commands
(init, pull, format) don't ever use this syntax, it could appear when hand-
writing a new CREATE statement.

Previously, Skeema would fail to process any hand-written statements that
use CREATE OR REPLACE syntax. This commit improves the situation by parsing
(but otherwise ignoring) the OR REPLACE clause, for all object types.

Use of this syntax otherwise has no practical effect on Skeema's behavior,
since `skeema diff` and `skeema push` will only emit a CREATE when the object
does not exist on the DB server anyway.

The server flavor must also support the OR REPLACE syntax for it to be usable
in .sql files. Otherwise, a workspace SQL error will result.

29 of 29 new or added lines in 1 file covered. (100.0%)

9938 of 10659 relevant lines covered (93.24%)

1.11 hits per line