tarantool / tarantool / 30464060637

88%

push

github

sql: support `INSERT DEFAULT VALUES` in trigger

This patch adds support for the `INSERT INTO table DEFAULT VALUES`
statement for SQL triggers.

Closes #12969

@TarantoolBot document
Title: Support `INSERT INTO table DEFAULT VALUES` in SQL triggers

SQL triggers now support the INSERT INTO table DEFAULT VALUES statement.
Note that this is primarily a parser change, as prior to this patch,
it was possible to insert default values into all but one column
by inserting into a single column, for example:
```SQL
CREATE TABLE t1(i INT PRIMARY KEY);
CREATE TABLE t2(i INT PRIMARY KEY AUTOINCREMENT, a INT DEFAULT 1,
                b INT DEFAULT 2, c INT DEFAULT 3);
CREATE TRIGGER t1t AFTER INSERT ON t1 FOR EACH ROW BEGIN
    INSERT INTO t2(i) VALUES (NULL); END;
```

72065 of 120917 branches covered (59.6%)

108014 of 122966 relevant lines covered (87.84%)

1388263.96 hits per line