# Continuation of tests for optimizer trace. # Those need DBUG_EXECUTE_IF. --source include/have_optimizer_trace.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;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
bugs_no_prot_all.test | File | 541 B | 0644 |
|
bugs_no_prot_none.test | File | 652 B | 0644 |
|
bugs_ps_prot_all.test | File | 538 B | 0644 |
|
bugs_ps_prot_none.test | File | 649 B | 0644 |
|
charset.test | File | 2.16 KB | 0644 |
|
debug.test | File | 1010 B | 0644 |
|
eq_range_statistics.test | File | 3.21 KB | 0644 |
|
filesort_pq.test | File | 174 B | 0644 |
|
general2_no_prot.test | File | 202 B | 0644 |
|
general2_ps_prot.test | File | 199 B | 0644 |
|
general_no_prot_all.test | File | 570 B | 0644 |
|
general_no_prot_none.test | File | 681 B | 0644 |
|
general_ps_prot_all.test | File | 567 B | 0644 |
|
general_ps_prot_none.test | File | 678 B | 0644 |
|
range_no_prot.test | File | 199 B | 0644 |
|
range_ps_prot.test | File | 196 B | 0644 |
|
security_no_prot.test | File | 202 B | 0644 |
|
security_ps_prot.test | File | 199 B | 0644 |
|
subquery_no_prot.test | File | 202 B | 0644 |
|
subquery_ps_prot.test | File | 199 B | 0644 |
|
temp_table.test | File | 2.45 KB | 0644 |
|