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 select * from information_schema.global_variables where variable_name='sql_select_limit';
17 select * from information_schema.session_variables where variable_name='sql_select_limit';
18
19 #
20 # show that it's writable
21 #
22 set global sql_select_limit=10;
23 set session sql_select_limit=20;
24 select @@global.sql_select_limit;
25 select @@session.sql_select_limit;
26 show global variables like 'sql_select_limit';
27 show session variables like 'sql_select_limit';
28 select * from information_schema.global_variables where variable_name='sql_select_limit';
29 select * from information_schema.session_variables where variable_name='sql_select_limit';
30
31 #
32 # incorrect types
33 #
34 --error ER_WRONG_TYPE_FOR_VAR
35 set global sql_select_limit=1.1;
36 --error ER_WRONG_TYPE_FOR_VAR
37 set global sql_select_limit=1e1;
38 --error ER_WRONG_TYPE_FOR_VAR
39 set global sql_select_limit="foo";
40
41 SET @@global.sql_select_limit = @start_global_value;
42 SELECT @@global.sql_select_limit;