72 lines
2.5 KiB
Plaintext
72 lines
2.5 KiB
Plaintext
CREATE TABLE valid_values (value varchar(255));
|
|
INSERT INTO valid_values VALUES(0);
|
|
INSERT INTO valid_values VALUES(8<<32);
|
|
INSERT INTO valid_values VALUES(3);
|
|
CREATE TABLE invalid_values (value varchar(255));
|
|
INSERT INTO invalid_values VALUES('\'abc\'');
|
|
INSERT INTO invalid_values VALUES('\'cde\'');
|
|
INSERT INTO invalid_values VALUES('\'-1\'');
|
|
SET @start_global_value = @@global.XENGINE_COMPACT_CF;
|
|
SELECT @start_global_value;
|
|
@start_global_value
|
|
0
|
|
'# Setting to valid values in global scope#'
|
|
"Trying to set variable @@global.XENGINE_COMPACT_CF to 0"
|
|
SET @@global.XENGINE_COMPACT_CF = 0;
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
"Setting the global scope variable back to default"
|
|
SET @@global.XENGINE_COMPACT_CF = DEFAULT;
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
"Trying to set variable @@global.XENGINE_COMPACT_CF to 34359738368"
|
|
SET @@global.XENGINE_COMPACT_CF = 34359738368;
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
"Setting the global scope variable back to default"
|
|
SET @@global.XENGINE_COMPACT_CF = DEFAULT;
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
"Trying to set variable @@global.XENGINE_COMPACT_CF to 3"
|
|
SET @@global.XENGINE_COMPACT_CF = 3;
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
"Setting the global scope variable back to default"
|
|
SET @@global.XENGINE_COMPACT_CF = DEFAULT;
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
"Trying to set variable @@session.XENGINE_COMPACT_CF to 444. It should fail because it is not session."
|
|
SET @@session.XENGINE_COMPACT_CF = 444;
|
|
ERROR HY000: Variable 'xengine_compact_cf' is a GLOBAL variable and should be set with SET GLOBAL
|
|
'# Testing with invalid values in global scope #'
|
|
"Trying to set variable @@global.XENGINE_COMPACT_CF to 'abc'"
|
|
SET @@global.XENGINE_COMPACT_CF = 'abc';
|
|
Got one of the listed errors
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
"Trying to set variable @@global.XENGINE_COMPACT_CF to 'cde'"
|
|
SET @@global.XENGINE_COMPACT_CF = 'cde';
|
|
Got one of the listed errors
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
"Trying to set variable @@global.XENGINE_COMPACT_CF to '-1'"
|
|
SET @@global.XENGINE_COMPACT_CF = '-1';
|
|
Got one of the listed errors
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
SET @@global.XENGINE_COMPACT_CF = @start_global_value;
|
|
SELECT @@global.XENGINE_COMPACT_CF;
|
|
@@global.XENGINE_COMPACT_CF
|
|
0
|
|
DROP TABLE valid_values;
|
|
DROP TABLE invalid_values;
|