summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sql_sequence
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2018-05-08 13:29:29 +0300
committerMonty <monty@mariadb.org>2018-05-08 13:29:41 +0300
commita536664e80da75c0dc2ef82d5872d5d91d6578ef (patch)
tree7f114faa5d65d5782b0bf68b7975835492395e60 /mysql-test/suite/sql_sequence
parentbd09c5ca866e273b6cebbd9a15c51c82bfa3ac9b (diff)
downloadmariadb-git-a536664e80da75c0dc2ef82d5872d5d91d6578ef.tar.gz
Added test case for MDEV-13029
MDEV 13029 Assertion `ds_control' failed in debug_sync upon closing connection after creating temporary sequence This test doesn't fail anymore. Adding it to ensure that the bug doesn't appear again.
Diffstat (limited to 'mysql-test/suite/sql_sequence')
-rw-r--r--mysql-test/suite/sql_sequence/debug_sync.opt1
-rw-r--r--mysql-test/suite/sql_sequence/debug_sync.result7
-rw-r--r--mysql-test/suite/sql_sequence/debug_sync.test15
3 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/suite/sql_sequence/debug_sync.opt b/mysql-test/suite/sql_sequence/debug_sync.opt
new file mode 100644
index 00000000000..16132e454cc
--- /dev/null
+++ b/mysql-test/suite/sql_sequence/debug_sync.opt
@@ -0,0 +1 @@
+--debug-sync-timeout=2
diff --git a/mysql-test/suite/sql_sequence/debug_sync.result b/mysql-test/suite/sql_sequence/debug_sync.result
new file mode 100644
index 00000000000..516b2343a82
--- /dev/null
+++ b/mysql-test/suite/sql_sequence/debug_sync.result
@@ -0,0 +1,7 @@
+connect con1,localhost,root,,;
+CREATE TEMPORARY SEQUENCE f ENGINE=InnoDB;
+disconnect con1;
+connection default;
+SELECT 'Still alive' AS `Heartbeat`;
+Heartbeat
+Still alive
diff --git a/mysql-test/suite/sql_sequence/debug_sync.test b/mysql-test/suite/sql_sequence/debug_sync.test
new file mode 100644
index 00000000000..ecc75f790a3
--- /dev/null
+++ b/mysql-test/suite/sql_sequence/debug_sync.test
@@ -0,0 +1,15 @@
+--source include/have_innodb.inc
+--source include/have_debug_sync.inc
+
+#
+# MDEV-13029
+# Assertion `ds_control' failed in debug_sync upon closing connection after
+# creating temporary sequence
+
+--connect (con1,localhost,root,,)
+CREATE TEMPORARY SEQUENCE f ENGINE=InnoDB;
+--disconnect con1
+--connection default
+--sleep 3
+
+SELECT 'Still alive' AS `Heartbeat`;