Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.immediate_server_version;
2 ERROR HY000: Variable 'immediate_server_version' is a SESSION variable
3 include/assert.inc [immediate_server_version must be accessible and have the default value]
4 SHOW VARIABLES LIKE 'immediate_server_version';
5 Variable_name Value
6 immediate_server_version 999999
7 SET @@GLOBAL.immediate_server_version = 123456;
8 ERROR HY000: Variable 'immediate_server_version' is a SESSION variable and can't be used with SET GLOBAL
9 SET @@SESSION.immediate_server_version = 123456;
10 include/assert.inc [immediate_server_version must be equal to the set value]
11 SET @@SESSION.immediate_server_version = -123456;
12 Warnings:
13 Warning 1292 Truncated incorrect immediate_server_version value: '-123456'
14 include/assert.inc [immediate_server_version must be 0]
15 SET @@SESSION.immediate_server_version = 0;
16 include/assert.inc [immediate_server_version must be 0]
17 SET @@SESSION.immediate_server_version = 123456789012345678901;
18 ERROR 42000: Incorrect argument type to variable 'immediate_server_version'
19 include/assert.inc [immediate_server_version must be 0]
20 SET @@SESSION.immediate_server_version = 'xyz';
21 ERROR 42000: Incorrect argument type to variable 'immediate_server_version'
22 include/assert.inc [immediate_server_version must be 0]
23 SET @@SESSION.immediate_server_version = xyz;
24 ERROR 42000: Incorrect argument type to variable 'immediate_server_version'
25 include/assert.inc [immediate_server_version must be 0]
26 SET @@SESSION.immediate_server_version = 36028797018963969;
27 Warnings:
28 Warning 1292 Truncated incorrect immediate_server_version value: '36028797018963969'
29 include/assert.inc [immediate_server_version must be equal to the maximum value]
30 SET @@SESSION.immediate_server_version = 18446744073709551615;
31 Warnings:
32 Warning 1292 Truncated incorrect immediate_server_version value: '18446744073709551615'
33 include/assert.inc [immediate_server_version must be equal to the maximum value]
34 SET @@SESSION.immediate_server_version = 18446744073709551616;
35 ERROR 42000: Incorrect argument type to variable 'immediate_server_version'
36 include/assert.inc [immediate_server_version must be equal to the maximum value]
37 include/assert.inc [The value in session table matches the one in the variable]
38 include/assert.inc [There is only one variable with this name]
39 include/assert.inc [There is only one variable with this name in the performance schema table]
40 include/assert.inc [The variable can be accessed with @@ sign]
41 CREATE USER nosuper;
42 SET SESSION immediate_server_version = 0;
43 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
44 DROP USER nosuper;