summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sql_sequence/temporary.result
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-04-05 15:16:20 +0300
committerMichael Widenius <monty@mariadb.org>2018-04-05 15:17:41 +0300
commitd8da97b09abec8fba2398f6ff6d84285b0752400 (patch)
tree0e06e5ca37561ebfcc74e0ede13d9378c643fbc0 /mysql-test/suite/sql_sequence/temporary.result
parent3dd01669b41bfad75f4a785d6263eb0f729b0213 (diff)
downloadmariadb-git-d8da97b09abec8fba2398f6ff6d84285b0752400.tar.gz
MDEV-14762 Server crashes in MDL_ticket::has_stronger_or_equal_type upon inserting into temporary sequence
Fix is to not upgrade MDL locks for temporary tables
Diffstat (limited to 'mysql-test/suite/sql_sequence/temporary.result')
-rw-r--r--mysql-test/suite/sql_sequence/temporary.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/suite/sql_sequence/temporary.result b/mysql-test/suite/sql_sequence/temporary.result
index 4885b5f8a26..69463667210 100644
--- a/mysql-test/suite/sql_sequence/temporary.result
+++ b/mysql-test/suite/sql_sequence/temporary.result
@@ -10,3 +10,10 @@ select * from s1;
next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
1001 1 9223372036854775806 1 1 1000 0 0
drop temporary sequence s1;
+#
+# MDEV-14762 Server crashes in MDL_ticket::has_stronger_or_equal_type
+# upon inserting into temporary sequence
+#
+CREATE TEMPORARY SEQUENCE s1 ENGINE=InnoDB;
+INSERT INTO s1 VALUES (1, 1, 1000, 1, 1, 1, 1, 0);
+DROP TEMPORARY SEQUENCE s1;