diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-07-06 18:17:24 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-07-06 22:18:35 +0300 |
commit | 934d5f95d33ee6980ede7e1990b519fd13bee327 (patch) | |
tree | 632336a7d0b3d58a91d00c611cb79fb020e5f092 /mysql-test/main/cte_recursive.test | |
parent | b4c377f21510849a67bcb0c72e8715903883ce4d (diff) | |
parent | 8b0d4cff0760b0a35285c315d82c49631c108baf (diff) | |
download | mariadb-git-934d5f95d33ee6980ede7e1990b519fd13bee327.tar.gz |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/cte_recursive.test')
-rw-r--r-- | mysql-test/main/cte_recursive.test | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/mysql-test/main/cte_recursive.test b/mysql-test/main/cte_recursive.test index 4b91c04cd49..109f7d73011 100644 --- a/mysql-test/main/cte_recursive.test +++ b/mysql-test/main/cte_recursive.test @@ -1,4 +1,3 @@ ---source include/not_embedded.inc create table t1 (a int, b varchar(32)); insert into t1 values (4,'aaaa' ), (7,'bb'), (1,'ccc'), (4,'dd'); @@ -2325,36 +2324,6 @@ SELECT func(); DROP FUNCTION func; ---echo # ---echo # MDEV-15151: function with recursive CTE using no base tables ---echo # (duplicate of MDEV-16661) ---echo # - ---connection default - -CREATE TABLE t1 (id int KEY); -INSERT INTO t1 VALUES (0), (1),(2); - -CREATE OR REPLACE FUNCTION func() RETURNS int -RETURN -( - WITH recursive cte AS - (SELECT 1 a UNION SELECT cte.* FROM cte natural join t1) - SELECT * FROM cte limit 1 -); - ---connect (con1,localhost,root,,) ---let $conid= `SELECT CONNECTION_ID()` ---send SELECT func() - ---connection default ---eval KILL QUERY $conid ---source include/restart_mysqld.inc - -DROP FUNCTION func; -DROP TABLE t1; ---disconnect con1 - --echo # Start of 10.3 tests --echo # |