Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # Variable Name: original_commit_timestamp #
4 # Scope: session #
5 # Data Type: integer #
6 # #
7 # #
8 # Creation Date: 2014-10-29 #
9 # Author : Shivji Kumar Jha #
10 # #
11 # #
12 # Description: Test Cases of variable original_commit_timestamp that checks #
13 # the scope of this variable. #
14 ###############################################################################
15
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 SELECT @@GLOBAL.original_commit_timestamp;
18
19 SELECT @@SESSION.original_commit_timestamp;
20
21 ####################################################################
22 # Verify that SHOW VARIABLES works #
23 ####################################################################
24 SHOW VARIABLES LIKE 'original_commit_timestamp';
25
26 ####################################################################
27 # Check if Value can set #
28 ####################################################################
29 --error ER_LOCAL_VARIABLE
30 SET @@GLOBAL.original_commit_timestamp=123456;
31
32 SET @@SESSION.original_commit_timestamp=123456;
33 SELECT @@SESSION.original_commit_timestamp;
34
35 ##########################################################################################
36 # Check errors for wrong values (different type or not in the range of allowed values) #
37 ##########################################################################################
38
39 # This will generate a warning
40 SET @@SESSION.original_commit_timestamp= -123456;
41 SELECT @@SESSION.original_commit_timestamp;
42
43 # Should be accepted.
44 SET @@SESSION.original_commit_timestamp= 0;
45 SELECT @@SESSION.original_commit_timestamp;
46
47 --error ER_WRONG_TYPE_FOR_VAR
48 SET @@SESSION.original_commit_timestamp= 123456789012345678901;
49 SELECT @@SESSION.original_commit_timestamp;
50
51 --error ER_WRONG_TYPE_FOR_VAR
52 SET @@SESSION.original_commit_timestamp= 'xyz';
53 SELECT @@SESSION.original_commit_timestamp;
54
55 --error ER_WRONG_TYPE_FOR_VAR
56 SET @@SESSION.original_commit_timestamp= xyz;
57 SELECT @@SESSION.original_commit_timestamp;
58
59 # Should give a warning and truncate the value and set it to the maximum value.
60 SET @@SESSION.original_commit_timestamp= 36028797018963969;
61 SELECT @@SESSION.original_commit_timestamp;
62
63 # Should give a warning and truncate the value and set it to the maximum value.
64 SET @@SESSION.original_commit_timestamp= 18446744073709551615;
65 SELECT @@SESSION.original_commit_timestamp;
66
67 # Should give a error
68 --error ER_WRONG_TYPE_FOR_VAR
69 SET @@SESSION.original_commit_timestamp= 18446744073709551616;
70 SELECT @@SESSION.original_commit_timestamp;
71
72
73 #################################################################
74 # Check if the value in SESSION Table matches value in variable #
75 #################################################################
76
77 SELECT @@SESSION.original_commit_timestamp = VARIABLE_VALUE
78 FROM performance_schema.session_variables
79 WHERE VARIABLE_NAME='original_commit_timestamp';
80
81 SELECT COUNT(@@SESSION.original_commit_timestamp);
82
83 SELECT COUNT(VARIABLE_VALUE)
84 FROM performance_schema.session_variables
85 WHERE VARIABLE_NAME='original_commit_timestamp';
86
87 ################################################################################
88 # Check if original_commit_timestamp can be accessed with @@ sign #
89 ################################################################################
90
91 SELECT COUNT(@@original_commit_timestamp);
92
93 SELECT COUNT(@@SESSION.original_commit_timestamp);
94
95 ################################################################################
96 # Check that it's read-only to a NON super privileged #
97 ################################################################################
98
99 # Create new user without super privilege
100 CREATE USER nosuper;
101 connect (conn_nosuper,localhost,nosuper,,);
102 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
103 SET SESSION original_commit_timestamp= 0;
104 --disconnect conn_nosuper
105 --connection default
106 DROP USER nosuper;