Details
Description
CURRENT_TEST: main.show_analyze
|
mysqltest: At line 226: 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 r_rows filtered r_filtered Extra
|
1 PRIMARY a ALL NULL NULL NULL NULL 10 10.00 100.00 20.00 Using where
|
2 DEPENDENT SUBQUERY b ALL NULL NULL NULL NULL 10 10.00 100.00 95.00 Using where
|
Warnings:
|
Note 1003 analyze select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2
|
connection con1;
|
id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra
|
1 PRIMARY a ALL NULL NULL NULL NULL 10 10.00 100.00 20.00 Using where
|
2 DEPENDENT SUBQUERY b ALL NULL NULL NULL NULL 10 10.00 100.00 95.00 Using where
|
SET debug_dbug=@old_debug;
|
# Try to do SHOW ANALYZE for a query that runs a SET command:
|
#
|
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 analyze for $thr2;
|
ERROR HY000: Target is not executing an operation with a query plan
|
kill query $thr2;
|
connection con1;
|
The portion of the test that is failing:
--echo # Try to do SHOW ANALYZE for a query that runs a SET command:
|
--echo #
|
set @show_explain_probe_select_id=2; # <--- |
SET debug_dbug='+d,show_explain_probe_join_exec_start'; |
send set @foo= (select max(a) from t0 where sin(a) >0); |
connection default; |
--source include/wait_condition.inc
|
--error ER_TARGET_NOT_EXPLAINABLE
|
evalp show analyze for $thr2; |
evalp kill query $thr2;
|
connection con1; |
--error ER_QUERY_INTERRUPTED
|
reap;
|
SET debug_dbug=@old_debug; |
Attachments
Issue Links
- is duplicated by
-
MDEV-33293 Race condition in test main.show_analyze
- Closed