diff options
-rw-r--r-- | mysql-test/r/cte_recursive.result | 6 | ||||
-rw-r--r-- | mysql-test/t/cte_recursive.test | 8 |
2 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/cte_recursive.result b/mysql-test/r/cte_recursive.result index 856f00abe59..d715fa20a6f 100644 --- a/mysql-test/r/cte_recursive.result +++ b/mysql-test/r/cte_recursive.result @@ -3314,10 +3314,10 @@ WITH recursive cte AS (SELECT 1 a UNION SELECT cte.* FROM cte natural join t1) SELECT * FROM cte limit 1 ); -SELECT func();; connect con1,localhost,root,,; -KILL QUERY 4; +SELECT func(); +connection default; +KILL QUERY 5; DROP FUNCTION func; DROP TABLE t1; disconnect con1; -connection default; diff --git a/mysql-test/t/cte_recursive.test b/mysql-test/t/cte_recursive.test index 504b2c64442..227ccd0cdb3 100644 --- a/mysql-test/t/cte_recursive.test +++ b/mysql-test/t/cte_recursive.test @@ -1,3 +1,4 @@ +--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'); @@ -2342,15 +2343,14 @@ RETURN SELECT * FROM cte limit 1 ); +--connect (con1,localhost,root,,) --let $conid= `SELECT CONNECTION_ID()` ---send SELECT func(); +--send SELECT func() ---connect (con1,localhost,root,,) +--connection default --eval KILL QUERY $conid --source include/restart_mysqld.inc DROP FUNCTION func; DROP TABLE t1; --disconnect con1 - ---connection default |