main.show_explain 'innodb'               w3 [ fail ]

        Test ended at 2023-11-15 23:10:09

CURRENT_TEST: main.show_explain

mysqltest: At line 279: query 'reap' succeeded - should have failed with error ER_QUERY_INTERRUPTED (1317)...

The result from queries just before the failure was:

< snip >

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	PRIMARY	a	ALL	NULL	NULL	NULL	NULL	10	Using where

2	DEPENDENT SUBQUERY	b	ALL	NULL	NULL	NULL	NULL	10	Using where

Warnings:

Note	1003	select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<1

connection con1;

a	(select max(a) from t0 b where b.a+a.a<10)

0	9

SET debug_dbug=@old_debug;

# Try to do SHOW EXPLAIN for a query that runs a  SET command:

#   I've found experimentally that select_id==2 here...

# 

set @show_explain_probe_select_id=2;

SET debug_dbug='+d,show_explain_probe_join_exec_start';

set @foo= (select max(a) from t0 where sin(a) >0);

connection default;

show explain for $thr2;

ERROR HY000: Target is not executing an operation with a query plan

kill query $thr2;

connection con1;

[Revision hash: 855356ca6df6cf3c8c8d2feafb41c10824c33a6d]

main.show_explain 'innodb'               w3 [ fail ]

        Test ended at 2023-11-02 13:16:24

CURRENT_TEST: main.show_explain

mysqltest: At line 510: query 'reap' succeeded - should have failed with error ER_QUERY_INTERRUPTED (1317)...

The result from queries just before the failure was:

< snip >

# JOIN::print_explain on query with a JOIN, TEMPTABLE view,

#          

CREATE TABLE t3 (a INT);

CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t3;

INSERT INTO t3 VALUES (8);

CREATE TABLE t2 (b INT);

INSERT INTO t2 VALUES (4),(5),(6),(7),(8),(9);

explain SELECT * FROM v1, t2;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

1	PRIMARY	<derived2>	system	NULL	NULL	NULL	NULL	1	

1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	6	

2	DERIVED	t3	system	NULL	NULL	NULL	NULL	1	

set @show_explain_probe_select_id=2;

SET debug_dbug='+d,show_explain_probe_join_exec_end';

SELECT * FROM v1, t2;

connection default;

show explain for $thr2;

ERROR HY000: Target is not executing an operation with a query plan

kill query $thr2;

connection con1;