summaryrefslogtreecommitdiff
path: root/mysql-test/main/temp_table.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/temp_table.result')
-rw-r--r--mysql-test/main/temp_table.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/temp_table.result b/mysql-test/main/temp_table.result
index 7ecc3dec10d..7f005bde37c 100644
--- a/mysql-test/main/temp_table.result
+++ b/mysql-test/main/temp_table.result
@@ -619,3 +619,15 @@ ERROR 42S02: Unknown table 'test.t2'
#
# End of 10.5 tests
#
+#
+# Record that temporary table locks are always WRITE locks
+#
+CREATE TEMPORARY TABLE t1 (a INT);
+LOCK TABLE t1 READ;
+TRUNCATE TABLE t1;
+TRUNCATE TABLE t1;
+UNLOCK TABLES;
+DROP TABLE t1;
+#
+# End of 10.6 tests
+#