Debian Codegraph @

mysql-test/suite/sys_vars/t/optimizer_trace_limit_basic.test

raw
1 --source include/have_optimizer_trace.inc
2
3 # Basic read/write test.
4 # Functionality of this variable is covered in
5 # main.optimizer_trace*.test
6
7 SELECT @@global.optimizer_trace_limit;
8 SET @@global.optimizer_trace_limit=5;
9 show global variables like 'optimizer_trace_limit';
10 --disable_warnings
11 select * from performance_schema.global_variables where variable_name='optimizer_trace_limit';
12 --enable_warnings
13
14 select @@session.optimizer_trace_limit;
15 show session variables like 'optimizer_trace_limit';
16 --disable_warnings
17 select * from performance_schema.session_variables where variable_name='optimizer_trace_limit';
18 --enable_warnings
19
20 #
21 # show that it's writable
22 #
23 set session optimizer_trace_limit=10;
24 select @@session.optimizer_trace_limit;
25 show session variables like 'optimizer_trace_limit';
26
27 set session optimizer_trace_limit=0;
28 select @@session.optimizer_trace_limit;
29 show session variables like 'optimizer_trace_limit';
30
31 set session optimizer_trace_limit=-100;
32 select @@session.optimizer_trace_limit;
33 show session variables like 'optimizer_trace_limit';
34
35 set session optimizer_trace_limit=default;
36 select @@session.optimizer_trace_limit;
37 show session variables like 'optimizer_trace_limit';
38
39 set global optimizer_trace_limit=default;
40 select @@global.optimizer_trace_limit;
41 show global variables like 'optimizer_trace_limit';
42
43 #
44 # incorrect assignments
45 #
46 --error ER_WRONG_TYPE_FOR_VAR
47 set optimizer_trace_limit=1.1;
48 --error ER_WRONG_TYPE_FOR_VAR
49 set optimizer_trace_limit="foobar";