Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.expensive_subquery_limit;
2 SELECT @start_global_value;
3
4 #
5 # exists as global and session
6 #
7 select @@global.expensive_subquery_limit;
8 select @@session.expensive_subquery_limit;
9 show global variables like 'expensive_subquery_limit';
10 show session variables like 'expensive_subquery_limit';
11 select * from information_schema.global_variables where variable_name='expensive_subquery_limit';
12 select * from information_schema.session_variables where variable_name='expensive_subquery_limit';
13
14 #
15 # show that it's writable
16 #
17 set global expensive_subquery_limit=10;
18 set session expensive_subquery_limit=20;
19 select @@global.expensive_subquery_limit;
20 select @@session.expensive_subquery_limit;
21 show global variables like 'expensive_subquery_limit';
22 show session variables like 'expensive_subquery_limit';
23 select * from information_schema.global_variables where variable_name='expensive_subquery_limit';
24 select * from information_schema.session_variables where variable_name='expensive_subquery_limit';
25
26 #
27 # incorrect types
28 #
29 --error ER_WRONG_TYPE_FOR_VAR
30 set global expensive_subquery_limit=1.1;
31 --error ER_WRONG_TYPE_FOR_VAR
32 set global expensive_subquery_limit=1e1;
33 --error ER_WRONG_TYPE_FOR_VAR
34 set global expensive_subquery_limit="foo";
35
36 SET @@global.expensive_subquery_limit = @start_global_value;
37 SELECT @@global.expensive_subquery_limit;
38