diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2019-10-17 23:20:34 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2019-10-17 23:20:34 +0200 |
| commit | 5b6b16636d48345475bfae7bae4eb7f0b2f0fb4e (patch) | |
| tree | 4e90eb0a26a3c14001254ae5f6febb882acb34bb /mysql-test/main/cte_nonrecursive.test | |
| parent | 421d52e89627d85794d7e8e4b70216b14f384178 (diff) | |
| download | mariadb-git-5b6b16636d48345475bfae7bae4eb7f0b2f0fb4e.tar.gz | |
MDEV-20730: Syntax error on SELECT INTO @variable with CTEbb-10.5-MDEV-20730
added forgotem WITH option to spacial case with INTO
Diffstat (limited to 'mysql-test/main/cte_nonrecursive.test')
| -rw-r--r-- | mysql-test/main/cte_nonrecursive.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/cte_nonrecursive.test b/mysql-test/main/cte_nonrecursive.test index bd8af55071a..5626f720adf 100644 --- a/mysql-test/main/cte_nonrecursive.test +++ b/mysql-test/main/cte_nonrecursive.test @@ -1182,3 +1182,18 @@ with t as (select 1 as t) select * from t; with columns as (select 1 as t) select * from columns; use test; + + +--echo # +--echo # MDEV-20730: Syntax error on SELECT INTO @variable with CTE +--echo # + +with data as (select 1 as id) +select id into @myid from data; +set @save_sql_mode = @@sql_mode; +set sql_mode="oracle"; +with data as (select 1 as id) +select id into @myid from data; +set sql_mode= @save_sql_mode; + +--echo # End of 10.4 tests |