Debian Codegraph @

mysql-test/suite/opt_trace/r/debug.result

raw
1 # We want to make sure that the common case of
2 # a connection which has not enabled tracing,
3 # is optimized, i.e. neither Opt_trace_context_impl nor
4 # Opt_trace_context_stmt is created.
5 set debug="d,no_new_opt_trace_stmt";
6 select 1;
7 1
8 1
9 select * from information_schema.OPTIMIZER_TRACE;
10 QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
11 set @a=25;
12 set debug="default";
13 set optimizer_trace="enabled=on";
14 select 2;
15 2
16 2
17 select * from information_schema.OPTIMIZER_TRACE;
18 QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
19 select 2 {
20 "steps": [
21 {
22 "join_preparation": {
23 "select#": 1,
24 "steps": [
25 {
26 "expanded_query": "/* select#1 */ select 2 AS `2`"
27 }
28 ]
29 }
30 },
31 {
32 "join_optimization": {
33 "select#": 1,
34 "steps": [
35 ]
36 }
37 },
38 {
39 "join_execution": {
40 "select#": 1,
41 "steps": [
42 ]
43 }
44 }
45 ]
46 } 0 0
47 set optimizer_trace="enabled=off";
48 set debug="d,no_new_opt_trace_stmt";
49 select 3;
50 3
51 3
52 select * from information_schema.OPTIMIZER_TRACE;
53 QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
54 select 2 {
55 "steps": [
56 {
57 "join_preparation": {
58 "select#": 1,
59 "steps": [
60 {
61 "expanded_query": "/* select#1 */ select 2 AS `2`"
62 }
63 ]
64 }
65 },
66 {
67 "join_optimization": {
68 "select#": 1,
69 "steps": [
70 ]
71 }
72 },
73 {
74 "join_execution": {
75 "select#": 1,
76 "steps": [
77 ]
78 }
79 }
80 ]
81 } 0 0