Debian Codegraph @

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

raw
1 #
2 # Show the global value;
3 #
4 SELECT @@global.avoid_temporal_upgrade;
5 SHOW GLOBAL VARIABLES LIKE 'avoid_temporal_upgrade';
6 --disable_warnings
7 SELECT * FROM performance_schema.global_variables WHERE variable_name='avoid_temporal_upgrade';
8 --enable_warnings
9
10 --echo #It is not a session variable.
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 SELECT @@session.avoid_temporal_upgrade;
13 SHOW SESSION VARIABLES LIKE 'avoid_temporal_upgrade';
14 --disable_warnings
15 SELECT * FROM performance_schema.session_variables WHERE variable_name='avoid_temporal_upgrade';
16 --enable_warnings
17 --error ER_GLOBAL_VARIABLE
18 SET SESSION avoid_temporal_upgrade= ON;
19
20 --echo #Test setting the variable to various values.
21
22 --echo #Boolean values.
23 SET GLOBAL avoid_temporal_upgrade= ON;
24 SELECT @@global.avoid_temporal_upgrade;
25
26 SET GLOBAL avoid_temporal_upgrade= OFF;
27 SELECT @@global.avoid_temporal_upgrade;
28
29 SET GLOBAL avoid_temporal_upgrade= 1;
30 SELECT @@global.avoid_temporal_upgrade;
31
32 SET GLOBAL avoid_temporal_upgrade= 0;
33 SELECT @@global.avoid_temporal_upgrade;
34
35 --echo #Test for DEFAULT value.
36 SET GLOBAL avoid_temporal_upgrade= DEFAULT;
37 SELECT @@global.avoid_temporal_upgrade;
38
39 --echo #Test for invalid value.
40 --error ER_WRONG_VALUE_FOR_VAR
41 SET GLOBAL avoid_temporal_upgrade= 2;
42
43 --echo #Test for invalid statement for setting the
44 --echo #global variable.
45 --error ER_GLOBAL_VARIABLE
46 SET avoid_temporal_upgrade= 1;
47
48 --echo #Fetches the current global value for the variable.
49 SELECT @@avoid_temporal_upgrade;