122 lines
4.3 KiB
Plaintext
122 lines
4.3 KiB
Plaintext
CREATE TABLE valid_values (value varchar(255));
|
|
INSERT INTO valid_values VALUES(1);
|
|
INSERT INTO valid_values VALUES(0);
|
|
INSERT INTO valid_values VALUES('on');
|
|
INSERT INTO valid_values VALUES('off');
|
|
CREATE TABLE invalid_values (value varchar(255));
|
|
INSERT INTO invalid_values VALUES('\'aaa\'');
|
|
INSERT INTO invalid_values VALUES('\'bbb\'');
|
|
SET @start_global_value = @@global.XENGINE_DEADLOCK_DETECT;
|
|
SELECT @start_global_value;
|
|
@start_global_value
|
|
0
|
|
SET @start_session_value = @@session.XENGINE_DEADLOCK_DETECT;
|
|
SELECT @start_session_value;
|
|
@start_session_value
|
|
0
|
|
'# Setting to valid values in global scope#'
|
|
"Trying to set variable @@global.XENGINE_DEADLOCK_DETECT to 1"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = 1;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
1
|
|
"Setting the global scope variable back to default"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = DEFAULT;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Trying to set variable @@global.XENGINE_DEADLOCK_DETECT to 0"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = 0;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Setting the global scope variable back to default"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = DEFAULT;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Trying to set variable @@global.XENGINE_DEADLOCK_DETECT to on"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = on;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
1
|
|
"Setting the global scope variable back to default"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = DEFAULT;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Trying to set variable @@global.XENGINE_DEADLOCK_DETECT to off"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = off;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Setting the global scope variable back to default"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = DEFAULT;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
'# Setting to valid values in session scope#'
|
|
"Trying to set variable @@session.XENGINE_DEADLOCK_DETECT to 1"
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = 1;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
1
|
|
"Setting the session scope variable back to default"
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = DEFAULT;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Trying to set variable @@session.XENGINE_DEADLOCK_DETECT to 0"
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = 0;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Setting the session scope variable back to default"
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = DEFAULT;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Trying to set variable @@session.XENGINE_DEADLOCK_DETECT to on"
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = on;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
1
|
|
"Setting the session scope variable back to default"
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = DEFAULT;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Trying to set variable @@session.XENGINE_DEADLOCK_DETECT to off"
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = off;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Setting the session scope variable back to default"
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = DEFAULT;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
'# Testing with invalid values in global scope #'
|
|
"Trying to set variable @@global.XENGINE_DEADLOCK_DETECT to 'aaa'"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = 'aaa';
|
|
Got one of the listed errors
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
"Trying to set variable @@global.XENGINE_DEADLOCK_DETECT to 'bbb'"
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = 'bbb';
|
|
Got one of the listed errors
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
SET @@global.XENGINE_DEADLOCK_DETECT = @start_global_value;
|
|
SELECT @@global.XENGINE_DEADLOCK_DETECT;
|
|
@@global.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
SET @@session.XENGINE_DEADLOCK_DETECT = @start_session_value;
|
|
SELECT @@session.XENGINE_DEADLOCK_DETECT;
|
|
@@session.XENGINE_DEADLOCK_DETECT
|
|
0
|
|
DROP TABLE valid_values;
|
|
DROP TABLE invalid_values;
|