1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
# Continuation of tests for optimizer trace.
# Those need DBUG_EXECUTE_IF.
--source include/have_optimizer_trace.inc
--source include/no_ps_protocol.inc
--source include/have_debug.inc
--echo # We want to make sure that the common case of
--echo # a connection which has not enabled tracing,
--echo # is optimized, i.e. neither Opt_trace_context_impl nor
--echo # Opt_trace_context_stmt is created.
# make server crash if it creates Opt_trace_stmt
set debug="d,no_new_opt_trace_stmt";
# tracable but tracing is off
select 1;
# non-tracable
select * from information_schema.OPTIMIZER_TRACE;
# non-tracable
set @a=25;
# Force creation of Opt_trace_context_impl and Opt_trace_stmt
set debug="default";
set optimizer_trace="enabled=on";
select 2;
select * from information_schema.OPTIMIZER_TRACE;
set optimizer_trace="enabled=off";
set debug="d,no_new_opt_trace_stmt";
# tracable, but tracing is off again (thd->opt_trace->is_started() is false)
select 3;
# should see only trace of "select 2"
select * from information_schema.OPTIMIZER_TRACE;
|
