summaryrefslogtreecommitdiff
path: root/mysql-test/main/alter_table_lock.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/alter_table_lock.result')
-rw-r--r--mysql-test/main/alter_table_lock.result19
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/alter_table_lock.result b/mysql-test/main/alter_table_lock.result
new file mode 100644
index 00000000000..ce6097c9ada
--- /dev/null
+++ b/mysql-test/main/alter_table_lock.result
@@ -0,0 +1,19 @@
+#
+# MDEV-23836: Assertion `! is_set() || m_can_overwrite_status' in
+# Diagnostics_area::set_error_status (interrupted ALTER TABLE under LOCK)
+#
+SET @max_session_mem_used_save= @@max_session_mem_used;
+CREATE TABLE t1 (a INT);
+SELECT * FROM t1;
+a
+ALTER TABLE x MODIFY xx INT;
+ERROR 42S02: Table 'test.x' doesn't exist
+SET SESSION max_session_mem_used= 8192;
+LOCK TABLE t1 WRITE;
+ALTER TABLE t1 CHANGE COLUMN IF EXISTS b c INT;
+Warnings:
+Note 1054 Unknown column 'b' in 't1'
+SET SESSION max_session_mem_used = @max_session_mem_used_save;
+UNLOCK TABLES;
+DROP TABLE t1;
+# End of 10.5 tests