Debian Codegraph @

mysql-test/suite/sys_vars/r/original_commit_timestamp_basic.result

raw
1 SELECT @@GLOBAL.original_commit_timestamp;
2 ERROR HY000: Variable 'original_commit_timestamp' is a SESSION variable
3 SELECT @@SESSION.original_commit_timestamp;
4 @@SESSION.original_commit_timestamp
5 36028797018963968
6 SHOW VARIABLES LIKE 'original_commit_timestamp';
7 Variable_name Value
8 original_commit_timestamp 36028797018963968
9 SET @@GLOBAL.original_commit_timestamp=123456;
10 ERROR HY000: Variable 'original_commit_timestamp' is a SESSION variable and can't be used with SET GLOBAL
11 SET @@SESSION.original_commit_timestamp=123456;
12 SELECT @@SESSION.original_commit_timestamp;
13 @@SESSION.original_commit_timestamp
14 123456
15 SET @@SESSION.original_commit_timestamp= -123456;
16 Warnings:
17 Warning 1292 Truncated incorrect original_commit_timestamp value: '-123456'
18 SELECT @@SESSION.original_commit_timestamp;
19 @@SESSION.original_commit_timestamp
20 0
21 SET @@SESSION.original_commit_timestamp= 0;
22 SELECT @@SESSION.original_commit_timestamp;
23 @@SESSION.original_commit_timestamp
24 0
25 SET @@SESSION.original_commit_timestamp= 123456789012345678901;
26 ERROR 42000: Incorrect argument type to variable 'original_commit_timestamp'
27 SELECT @@SESSION.original_commit_timestamp;
28 @@SESSION.original_commit_timestamp
29 0
30 SET @@SESSION.original_commit_timestamp= 'xyz';
31 ERROR 42000: Incorrect argument type to variable 'original_commit_timestamp'
32 SELECT @@SESSION.original_commit_timestamp;
33 @@SESSION.original_commit_timestamp
34 0
35 SET @@SESSION.original_commit_timestamp= xyz;
36 ERROR 42000: Incorrect argument type to variable 'original_commit_timestamp'
37 SELECT @@SESSION.original_commit_timestamp;
38 @@SESSION.original_commit_timestamp
39 0
40 SET @@SESSION.original_commit_timestamp= 36028797018963969;
41 Warnings:
42 Warning 1292 Truncated incorrect original_commit_timestamp value: '36028797018963969'
43 SELECT @@SESSION.original_commit_timestamp;
44 @@SESSION.original_commit_timestamp
45 36028797018963968
46 SET @@SESSION.original_commit_timestamp= 18446744073709551615;
47 Warnings:
48 Warning 1292 Truncated incorrect original_commit_timestamp value: '18446744073709551615'
49 SELECT @@SESSION.original_commit_timestamp;
50 @@SESSION.original_commit_timestamp
51 36028797018963968
52 SET @@SESSION.original_commit_timestamp= 18446744073709551616;
53 ERROR 42000: Incorrect argument type to variable 'original_commit_timestamp'
54 SELECT @@SESSION.original_commit_timestamp;
55 @@SESSION.original_commit_timestamp
56 36028797018963968
57 SELECT @@SESSION.original_commit_timestamp = VARIABLE_VALUE
58 FROM performance_schema.session_variables
59 WHERE VARIABLE_NAME='original_commit_timestamp';
60 @@SESSION.original_commit_timestamp = VARIABLE_VALUE
61 1
62 SELECT COUNT(@@SESSION.original_commit_timestamp);
63 COUNT(@@SESSION.original_commit_timestamp)
64 1
65 SELECT COUNT(VARIABLE_VALUE)
66 FROM performance_schema.session_variables
67 WHERE VARIABLE_NAME='original_commit_timestamp';
68 COUNT(VARIABLE_VALUE)
69 1
70 SELECT COUNT(@@original_commit_timestamp);
71 COUNT(@@original_commit_timestamp)
72 1
73 SELECT COUNT(@@SESSION.original_commit_timestamp);
74 COUNT(@@SESSION.original_commit_timestamp)
75 1
76 CREATE USER nosuper;
77 SET SESSION original_commit_timestamp= 0;
78 ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN, SESSION_VARIABLES_ADMIN or REPLICATION_APPLIER privilege(s) for this operation
79 DROP USER nosuper;