summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/explain_innodb.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/explain_innodb.result')
-rw-r--r--mysql-test/main/explain_innodb.result23
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/main/explain_innodb.result b/mysql-test/main/explain_innodb.result
new file mode 100644
index 00000000..ffd62c66
--- /dev/null
+++ b/mysql-test/main/explain_innodb.result
@@ -0,0 +1,23 @@
+#
+# MDEV-26249: Crash in in Explain_node::print_explain_for_children while writing to the slow query log
+#
+set @sql_tmp=@@slow_query_log;
+SET GLOBAL slow_query_log = 1;
+SET long_query_time = 0.000000;
+SET log_slow_verbosity = 'explain';
+CREATE TABLE t1 ( id varchar(50), KEY (id)) engine=innodb;
+SELECT * FROM (SELECT id FROM t1 GROUP BY id) dt WHERE 1=0;
+id
+select 1;
+1
+1
+explain
+SELECT * FROM (SELECT id FROM t1 GROUP BY id) dt WHERE 1=0;
+id select_type table type possible_keys key key_len ref rows Extra
+1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE
+2 DERIVED t1 range NULL id 53 NULL 2 Using index for group-by
+SET GLOBAL slow_query_log = @sql_tmp;
+drop table t1;
+#
+# End of 10.4 tests
+#