Debian Codegraph @

mysql-test/suite/sys_vars/r/optimizer_trace_limit_basic.result

raw
1 SELECT @@global.optimizer_trace_limit;
2 @@global.optimizer_trace_limit
3 1
4 SET @@global.optimizer_trace_limit=5;
5 show global variables like 'optimizer_trace_limit';
6 Variable_name Value
7 optimizer_trace_limit 5
8 select * from performance_schema.global_variables where variable_name='optimizer_trace_limit';
9 VARIABLE_NAME VARIABLE_VALUE
10 optimizer_trace_limit 5
11 select @@session.optimizer_trace_limit;
12 @@session.optimizer_trace_limit
13 1
14 show session variables like 'optimizer_trace_limit';
15 Variable_name Value
16 optimizer_trace_limit 1
17 select * from performance_schema.session_variables where variable_name='optimizer_trace_limit';
18 VARIABLE_NAME VARIABLE_VALUE
19 optimizer_trace_limit 1
20 set session optimizer_trace_limit=10;
21 select @@session.optimizer_trace_limit;
22 @@session.optimizer_trace_limit
23 10
24 show session variables like 'optimizer_trace_limit';
25 Variable_name Value
26 optimizer_trace_limit 10
27 set session optimizer_trace_limit=0;
28 select @@session.optimizer_trace_limit;
29 @@session.optimizer_trace_limit
30 0
31 show session variables like 'optimizer_trace_limit';
32 Variable_name Value
33 optimizer_trace_limit 0
34 set session optimizer_trace_limit=-100;
35 Warnings:
36 Warning 1292 Truncated incorrect optimizer_trace_limit value: '-100'
37 select @@session.optimizer_trace_limit;
38 @@session.optimizer_trace_limit
39 0
40 show session variables like 'optimizer_trace_limit';
41 Variable_name Value
42 optimizer_trace_limit 0
43 set session optimizer_trace_limit=default;
44 select @@session.optimizer_trace_limit;
45 @@session.optimizer_trace_limit
46 5
47 show session variables like 'optimizer_trace_limit';
48 Variable_name Value
49 optimizer_trace_limit 5
50 set global optimizer_trace_limit=default;
51 select @@global.optimizer_trace_limit;
52 @@global.optimizer_trace_limit
53 1
54 show global variables like 'optimizer_trace_limit';
55 Variable_name Value
56 optimizer_trace_limit 1
57 set optimizer_trace_limit=1.1;
58 ERROR 42000: Incorrect argument type to variable 'optimizer_trace_limit'
59 set optimizer_trace_limit="foobar";
60 ERROR 42000: Incorrect argument type to variable 'optimizer_trace_limit'