diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-05-24 18:05:38 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2016-05-24 18:05:38 +0400 |
| commit | c80c3f6759e456b88211f8e207648ee5d3964dac (patch) | |
| tree | 371a553ff4b77722df92536ea6da4a6f71d09f28 /mysql-test/t/parser.test | |
| parent | ea9a393a868dda808bd0c7a3f03b28208eb6570f (diff) | |
| download | mariadb-git-c80c3f6759e456b88211f8e207648ee5d3964dac.tar.gz | |
MDEV-10109 Disallow syntactically INSERT .. SELECT .. {ORDER BY ..| LIMIT ..} .. UNION ..
Diffstat (limited to 'mysql-test/t/parser.test')
| -rw-r--r-- | mysql-test/t/parser.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/parser.test b/mysql-test/t/parser.test index aae6b2c34be..0450e3c6fb0 100644 --- a/mysql-test/t/parser.test +++ b/mysql-test/t/parser.test @@ -1030,3 +1030,16 @@ INSERT INTO t1 VALUES (1),(2),(3); --error ER_PARSE_ERROR SELECT * FROM (SELECT * FROM t1 LIMIT 1 LIMIT 2) t1; DROP TABLE t1; + +--echo # +--echo # MDEV-10109 Disallow syntactically INSERT .. SELECT .. {ORDER BY ..| LIMIT ..} .. UNION .. +--echo # + +--error ER_PARSE_ERROR +INSERT INTO t1 SELECT 1 ORDER BY 1 UNION SELECT 2; +--error ER_PARSE_ERROR +INSERT INTO t1 SELECT 1 LIMIT 1 UNION SELECT 2; +--error ER_PARSE_ERROR +CREATE TABLE t1 AS SELECT 1 ORDER BY 1 UNION SELECT 2; +--error ER_PARSE_ERROR +CREATE TABLE t1 AS SELECT 1 LIMIT 1 UNION SELECT 2; |