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 --disable_warnings
17 select * from performance_schema.global_variables where variable_name='lc_messages';
18 select * from performance_schema.session_variables where variable_name='lc_messages';
19 --enable_warnings
20
21 #
22 # show that it's writable
23 #
24 set global lc_messages=1;
25 select @@global.lc_messages;
26 set session lc_messages=2;
27 select @@session.lc_messages;
28 set global lc_messages="en_US";
29 set session lc_messages="en_GB";
30 select @@global.lc_messages;
31 select @@session.lc_messages;
32 --disable_warnings
33 select * from performance_schema.global_variables where variable_name='lc_messages';
34 select * from performance_schema.session_variables where variable_name='lc_messages';
35 --enable_warnings
36
37 #
38 # incorrect types
39 #
40 --error ER_WRONG_TYPE_FOR_VAR
41 set global lc_messages=1.1;
42 --error ER_WRONG_TYPE_FOR_VAR
43 set global lc_messages=1e1;
44
45 SET @@global.lc_messages = @start_global_value;
46 SELECT @@global.lc_messages;