Debian Codegraph @

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

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