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.result | |
| 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.result')
| -rw-r--r-- | mysql-test/main/cte_nonrecursive.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/cte_nonrecursive.result b/mysql-test/main/cte_nonrecursive.result index 8fba35d8ed4..91f67e34749 100644 --- a/mysql-test/main/cte_nonrecursive.result +++ b/mysql-test/main/cte_nonrecursive.result @@ -1673,3 +1673,14 @@ with columns as (select 1 as t) select * from columns; t 1 use test; +# +# MDEV-20730: Syntax error on SELECT INTO @variable with CTE +# +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; +# End of 10.4 tests |