Debian Codegraph @

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

raw
1
2 #
3 # 2010-01-10 OBN - Added check for I_S values after change of variable value
4 #
5
6 SET @start_global_value = @@global.sql_select_limit;
7 SELECT @start_global_value;
8
9 #
10 # exists as global and session
11 #
12 select @@global.sql_select_limit;
13 select @@session.sql_select_limit;
14 show global variables like 'sql_select_limit';
15 show session variables like 'sql_select_limit';
16 --disable_warnings
17 select * from performance_schema.global_variables where variable_name='sql_select_limit';
18 select * from performance_schema.session_variables where variable_name='sql_select_limit';
19 --enable_warnings
20
21 #
22 # show that it's writable
23 #
24 set global sql_select_limit=10;
25 set session sql_select_limit=20;
26 select @@global.sql_select_limit;
27 select @@session.sql_select_limit;
28 show global variables like 'sql_select_limit';
29 show session variables like 'sql_select_limit';
30 --disable_warnings
31 select * from performance_schema.global_variables where variable_name='sql_select_limit';
32 select * from performance_schema.session_variables where variable_name='sql_select_limit';
33 --enable_warnings
34
35 #
36 # incorrect types
37 #
38 --error ER_WRONG_TYPE_FOR_VAR
39 set global sql_select_limit=1.1;
40 --error ER_WRONG_TYPE_FOR_VAR
41 set global sql_select_limit=1e1;
42 --error ER_WRONG_TYPE_FOR_VAR
43 set global sql_select_limit="foo";
44
45 SET @@global.sql_select_limit = @start_global_value;
46 SELECT @@global.sql_select_limit;