45 lines
2.6 KiB
Plaintext
45 lines
2.6 KiB
Plaintext
SELECT @@GLOBAL.immediate_server_version;
|
|
ERROR HY000: Variable 'immediate_server_version' is a SESSION variable
|
|
include/assert.inc [immediate_server_version must be accessible and have the default value]
|
|
SHOW VARIABLES LIKE 'immediate_server_version';
|
|
Variable_name Value
|
|
immediate_server_version 999999
|
|
SET @@GLOBAL.immediate_server_version = 123456;
|
|
ERROR HY000: Variable 'immediate_server_version' is a SESSION variable and can't be used with SET GLOBAL
|
|
SET @@SESSION.immediate_server_version = 123456;
|
|
include/assert.inc [immediate_server_version must be equal to the set value]
|
|
SET @@SESSION.immediate_server_version = -123456;
|
|
Warnings:
|
|
Warning 1292 Truncated incorrect immediate_server_version value: '-123456'
|
|
include/assert.inc [immediate_server_version must be 0]
|
|
SET @@SESSION.immediate_server_version = 0;
|
|
include/assert.inc [immediate_server_version must be 0]
|
|
SET @@SESSION.immediate_server_version = 123456789012345678901;
|
|
ERROR 42000: Incorrect argument type to variable 'immediate_server_version'
|
|
include/assert.inc [immediate_server_version must be 0]
|
|
SET @@SESSION.immediate_server_version = 'xyz';
|
|
ERROR 42000: Incorrect argument type to variable 'immediate_server_version'
|
|
include/assert.inc [immediate_server_version must be 0]
|
|
SET @@SESSION.immediate_server_version = xyz;
|
|
ERROR 42000: Incorrect argument type to variable 'immediate_server_version'
|
|
include/assert.inc [immediate_server_version must be 0]
|
|
SET @@SESSION.immediate_server_version = 36028797018963969;
|
|
Warnings:
|
|
Warning 1292 Truncated incorrect immediate_server_version value: '36028797018963969'
|
|
include/assert.inc [immediate_server_version must be equal to the maximum value]
|
|
SET @@SESSION.immediate_server_version = 18446744073709551615;
|
|
Warnings:
|
|
Warning 1292 Truncated incorrect immediate_server_version value: '18446744073709551615'
|
|
include/assert.inc [immediate_server_version must be equal to the maximum value]
|
|
SET @@SESSION.immediate_server_version = 18446744073709551616;
|
|
ERROR 42000: Incorrect argument type to variable 'immediate_server_version'
|
|
include/assert.inc [immediate_server_version must be equal to the maximum value]
|
|
include/assert.inc [The value in session table matches the one in the variable]
|
|
include/assert.inc [There is only one variable with this name]
|
|
include/assert.inc [There is only one variable with this name in the performance schema table]
|
|
include/assert.inc [The variable can be accessed with @@ sign]
|
|
CREATE USER nosuper;
|
|
SET SESSION immediate_server_version = 0;
|
|
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
|
|
DROP USER nosuper;
|