diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2020-01-27 21:50:16 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2020-03-10 07:20:49 +0100 |
| commit | 50c0939166afa2042a92d59698911fb54529ab39 (patch) | |
| tree | d37862b225823136bb06c4e049e798b56994e378 /mysql-test/main/table_value_constr.result | |
| parent | a5584b13d1e04f38b843602413669591aa65c359 (diff) | |
| download | mariadb-git-50c0939166afa2042a92d59698911fb54529ab39.tar.gz | |
MDEV-20632: Recursive CTE cycle detection using CYCLE clause (nonstandard)
Added CYCLE ... RESTRICT (nonstandard) clause to recursive CTE.
Diffstat (limited to 'mysql-test/main/table_value_constr.result')
| -rw-r--r-- | mysql-test/main/table_value_constr.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/table_value_constr.result b/mysql-test/main/table_value_constr.result index 54bf9c36491..38e1a54082c 100644 --- a/mysql-test/main/table_value_constr.result +++ b/mysql-test/main/table_value_constr.result @@ -2593,7 +2593,7 @@ ERROR 42S22: Unknown column '2' in 'order clause' create view v1 as with t(a) as (values (2), (1)) select a from t; show create view v1; View Create View character_set_client collation_connection -v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS with t(a) as (values (2),(1))select `t`.`a` AS `a` from `t` latin1 latin1_swedish_ci +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS with t(`a`) as (values (2),(1))select `t`.`a` AS `a` from `t` latin1 latin1_swedish_ci select * from v1; a 2 |