[Commits] d6f87e68f18436229eaeb1ae5f04be7c400e3165 For some unclear reasons the test case for bug mdev-10736 does not work in non-debug modes.

Igor Babaev igor at askmonty.org
Wed Sep 7 00:36:59 EEST 2016


commit d6f87e68f18436229eaeb1ae5f04be7c400e3165
Author: Igor Babaev <igor at askmonty.org>
Commit: Igor Babaev <igor at askmonty.org>

    For some unclear reasons the test case for bug mdev-10736
    does not work in non-debug modes.
---
 mysql-test/r/cte_recursive.result |    9 ---------
 mysql-test/t/cte_recursive.test   |   19 ++++++++++---------
 2 files changed, 10 insertions(+), 18 deletions(-)

diff --git a/mysql-test/r/cte_recursive.result b/mysql-test/r/cte_recursive.result
index 17a4274..da5f380 100644
--- a/mysql-test/r/cte_recursive.result
+++ b/mysql-test/r/cte_recursive.result
@@ -1623,12 +1623,3 @@ n
 3
 4
 5
-#
-# MDEV-10736: recursive definition with anchor over a table with blob
-#
-CREATE TABLE t1 (f VARCHAR(1024));
-WITH RECURSIVE cte(f) AS
-(SELECT t1.f FROM t1 UNION ALL SELECT cte.f FROM cte) 
-SELECT * FROM cte;
-f
-DROP TABLE t1;
diff --git a/mysql-test/t/cte_recursive.test b/mysql-test/t/cte_recursive.test
index 9140cac..445b257 100644
--- a/mysql-test/t/cte_recursive.test
+++ b/mysql-test/t/cte_recursive.test
@@ -1185,12 +1185,13 @@ WITH RECURSIVE cte(n) AS
   ( SELECT n+1 FROM cte WHERE n < 5 UNION SELECT 1 UNION SELECT 1 )
 SELECT * FROM cte;
 
---echo #
---echo # MDEV-10736: recursive definition with anchor over a table with blob
---echo #
-
-CREATE TABLE t1 (f VARCHAR(1024));
-WITH RECURSIVE cte(f) AS
-(SELECT t1.f FROM t1 UNION ALL SELECT cte.f FROM cte) 
-SELECT * FROM cte;
-DROP TABLE t1;
+# --echo #
+# --echo # MDEV-10736: recursive definition with anchor over a table with blob
+# --echo #
+#
+# CREATE TABLE t1 (f VARCHAR(1024));
+# set statement max_recursive_iterations=1 for
+# WITH RECURSIVE cte(f) AS
+#   (SELECT t1.f FROM t1 UNION ALL SELECT cte.f FROM cte) 
+# SELECT * FROM cte;
+# DROP TABLE t1;


More information about the commits mailing list