summaryrefslogtreecommitdiff
path: root/mysql-test/main/cte_recursive.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2018-07-06 18:17:24 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2018-07-06 22:18:35 +0300
commit934d5f95d33ee6980ede7e1990b519fd13bee327 (patch)
tree632336a7d0b3d58a91d00c611cb79fb020e5f092 /mysql-test/main/cte_recursive.test
parentb4c377f21510849a67bcb0c72e8715903883ce4d (diff)
parent8b0d4cff0760b0a35285c315d82c49631c108baf (diff)
downloadmariadb-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.test31
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 #