From 5b6b16636d48345475bfae7bae4eb7f0b2f0fb4e Mon Sep 17 00:00:00 2001 From: Oleksandr Byelkin Date: Thu, 17 Oct 2019 23:20:34 +0200 Subject: MDEV-20730: Syntax error on SELECT INTO @variable with CTE added forgotem WITH option to spacial case with INTO --- mysql-test/main/cte_nonrecursive.result | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mysql-test/main/cte_nonrecursive.result') 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 -- cgit v1.2.1