diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb_sys_vars/r')
13 files changed, 529 insertions, 208 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_allow_os_buffer_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_allow_os_buffer_basic.result deleted file mode 100644 index 6099c3af344..00000000000 --- a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_allow_os_buffer_basic.result +++ /dev/null @@ -1,7 +0,0 @@ -SET @start_global_value = @@global.ROCKSDB_ALLOW_OS_BUFFER; -SELECT @start_global_value; -@start_global_value -1 -"Trying to set variable @@global.ROCKSDB_ALLOW_OS_BUFFER to 444. It should fail because it is readonly." -SET @@global.ROCKSDB_ALLOW_OS_BUFFER = 444; -ERROR HY000: Variable 'rocksdb_allow_os_buffer' is a read only variable diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_block_cache_size_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_block_cache_size_basic.result index fbd9d97e994..1cfe5385d5c 100644 --- a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_block_cache_size_basic.result +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_block_cache_size_basic.result @@ -1,7 +1,7 @@ SET @start_global_value = @@global.ROCKSDB_BLOCK_CACHE_SIZE; SELECT @start_global_value; @start_global_value -8388608 +536870912 "Trying to set variable @@global.ROCKSDB_BLOCK_CACHE_SIZE to 444. It should fail because it is readonly." SET @@global.ROCKSDB_BLOCK_CACHE_SIZE = 444; ERROR HY000: Variable 'rocksdb_block_cache_size' is a read only variable diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_deadlock_detect_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_deadlock_detect_basic.result new file mode 100644 index 00000000000..f200105b542 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_deadlock_detect_basic.result @@ -0,0 +1,121 @@ +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.ROCKSDB_DEADLOCK_DETECT; +SELECT @start_global_value; +@start_global_value +0 +SET @start_session_value = @@session.ROCKSDB_DEADLOCK_DETECT; +SELECT @start_session_value; +@start_session_value +0 +'# Setting to valid values in global scope#' +"Trying to set variable @@global.ROCKSDB_DEADLOCK_DETECT to 1" +SET @@global.ROCKSDB_DEADLOCK_DETECT = 1; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_DEADLOCK_DETECT = DEFAULT; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +"Trying to set variable @@global.ROCKSDB_DEADLOCK_DETECT to 0" +SET @@global.ROCKSDB_DEADLOCK_DETECT = 0; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_DEADLOCK_DETECT = DEFAULT; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +"Trying to set variable @@global.ROCKSDB_DEADLOCK_DETECT to on" +SET @@global.ROCKSDB_DEADLOCK_DETECT = on; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_DEADLOCK_DETECT = DEFAULT; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +"Trying to set variable @@global.ROCKSDB_DEADLOCK_DETECT to off" +SET @@global.ROCKSDB_DEADLOCK_DETECT = off; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_DEADLOCK_DETECT = DEFAULT; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +'# Setting to valid values in session scope#' +"Trying to set variable @@session.ROCKSDB_DEADLOCK_DETECT to 1" +SET @@session.ROCKSDB_DEADLOCK_DETECT = 1; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +1 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_DEADLOCK_DETECT = DEFAULT; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +0 +"Trying to set variable @@session.ROCKSDB_DEADLOCK_DETECT to 0" +SET @@session.ROCKSDB_DEADLOCK_DETECT = 0; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +0 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_DEADLOCK_DETECT = DEFAULT; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +0 +"Trying to set variable @@session.ROCKSDB_DEADLOCK_DETECT to on" +SET @@session.ROCKSDB_DEADLOCK_DETECT = on; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +1 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_DEADLOCK_DETECT = DEFAULT; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +0 +"Trying to set variable @@session.ROCKSDB_DEADLOCK_DETECT to off" +SET @@session.ROCKSDB_DEADLOCK_DETECT = off; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +0 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_DEADLOCK_DETECT = DEFAULT; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +0 +'# Testing with invalid values in global scope #' +"Trying to set variable @@global.ROCKSDB_DEADLOCK_DETECT to 'aaa'" +SET @@global.ROCKSDB_DEADLOCK_DETECT = 'aaa'; +Got one of the listed errors +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +"Trying to set variable @@global.ROCKSDB_DEADLOCK_DETECT to 'bbb'" +SET @@global.ROCKSDB_DEADLOCK_DETECT = 'bbb'; +Got one of the listed errors +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +SET @@global.ROCKSDB_DEADLOCK_DETECT = @start_global_value; +SELECT @@global.ROCKSDB_DEADLOCK_DETECT; +@@global.ROCKSDB_DEADLOCK_DETECT +0 +SET @@session.ROCKSDB_DEADLOCK_DETECT = @start_session_value; +SELECT @@session.ROCKSDB_DEADLOCK_DETECT; +@@session.ROCKSDB_DEADLOCK_DETECT +0 +DROP TABLE valid_values; +DROP TABLE invalid_values; diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_print_snapshot_conflict_queries_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_print_snapshot_conflict_queries_basic.result new file mode 100644 index 00000000000..02a4b4040d7 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_print_snapshot_conflict_queries_basic.result @@ -0,0 +1,64 @@ +CREATE TABLE valid_values (value varchar(255)) ENGINE=myisam; +INSERT INTO valid_values VALUES(1); +INSERT INTO valid_values VALUES(0); +INSERT INTO valid_values VALUES('on'); +CREATE TABLE invalid_values (value varchar(255)) ENGINE=myisam; +INSERT INTO invalid_values VALUES('\'aaa\''); +INSERT INTO invalid_values VALUES('\'bbb\''); +SET @start_global_value = @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +SELECT @start_global_value; +@start_global_value +0 +'# Setting to valid values in global scope#' +"Trying to set variable @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES to 1" +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = 1; +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = DEFAULT; +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +0 +"Trying to set variable @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES to 0" +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = 0; +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +0 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = DEFAULT; +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +0 +"Trying to set variable @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES to on" +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = on; +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = DEFAULT; +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +0 +"Trying to set variable @@session.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES to 444. It should fail because it is not session." +SET @@session.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = 444; +ERROR HY000: Variable 'rocksdb_print_snapshot_conflict_queries' is a GLOBAL variable and should be set with SET GLOBAL +'# Testing with invalid values in global scope #' +"Trying to set variable @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES to 'aaa'" +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = 'aaa'; +Got one of the listed errors +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +0 +"Trying to set variable @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES to 'bbb'" +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = 'bbb'; +Got one of the listed errors +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +0 +SET @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES = @start_global_value; +SELECT @@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES; +@@global.ROCKSDB_PRINT_SNAPSHOT_CONFLICT_QUERIES +0 +DROP TABLE valid_values; +DROP TABLE invalid_values; diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_rpl_skip_tx_api_basic.test b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_rpl_skip_tx_api_basic.result index 5f6522e4488..5f6522e4488 100644 --- a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_rpl_skip_tx_api_basic.test +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_rpl_skip_tx_api_basic.result diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_store_checksums_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_store_checksums_basic.result deleted file mode 100644 index 904a0bc536e..00000000000 --- a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_store_checksums_basic.result +++ /dev/null @@ -1,100 +0,0 @@ -CREATE TABLE valid_values (value varchar(255)) ENGINE=myisam; -INSERT INTO valid_values VALUES(1); -INSERT INTO valid_values VALUES(0); -INSERT INTO valid_values VALUES('on'); -CREATE TABLE invalid_values (value varchar(255)) ENGINE=myisam; -INSERT INTO invalid_values VALUES('\'aaa\''); -INSERT INTO invalid_values VALUES('\'bbb\''); -SET @start_global_value = @@global.ROCKSDB_STORE_CHECKSUMS; -SELECT @start_global_value; -@start_global_value -0 -SET @start_session_value = @@session.ROCKSDB_STORE_CHECKSUMS; -SELECT @start_session_value; -@start_session_value -0 -'# Setting to valid values in global scope#' -"Trying to set variable @@global.ROCKSDB_STORE_CHECKSUMS to 1" -SET @@global.ROCKSDB_STORE_CHECKSUMS = 1; -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -1 -"Setting the global scope variable back to default" -SET @@global.ROCKSDB_STORE_CHECKSUMS = DEFAULT; -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -0 -"Trying to set variable @@global.ROCKSDB_STORE_CHECKSUMS to 0" -SET @@global.ROCKSDB_STORE_CHECKSUMS = 0; -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -0 -"Setting the global scope variable back to default" -SET @@global.ROCKSDB_STORE_CHECKSUMS = DEFAULT; -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -0 -"Trying to set variable @@global.ROCKSDB_STORE_CHECKSUMS to on" -SET @@global.ROCKSDB_STORE_CHECKSUMS = on; -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -1 -"Setting the global scope variable back to default" -SET @@global.ROCKSDB_STORE_CHECKSUMS = DEFAULT; -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -0 -'# Setting to valid values in session scope#' -"Trying to set variable @@session.ROCKSDB_STORE_CHECKSUMS to 1" -SET @@session.ROCKSDB_STORE_CHECKSUMS = 1; -SELECT @@session.ROCKSDB_STORE_CHECKSUMS; -@@session.ROCKSDB_STORE_CHECKSUMS -1 -"Setting the session scope variable back to default" -SET @@session.ROCKSDB_STORE_CHECKSUMS = DEFAULT; -SELECT @@session.ROCKSDB_STORE_CHECKSUMS; -@@session.ROCKSDB_STORE_CHECKSUMS -0 -"Trying to set variable @@session.ROCKSDB_STORE_CHECKSUMS to 0" -SET @@session.ROCKSDB_STORE_CHECKSUMS = 0; -SELECT @@session.ROCKSDB_STORE_CHECKSUMS; -@@session.ROCKSDB_STORE_CHECKSUMS -0 -"Setting the session scope variable back to default" -SET @@session.ROCKSDB_STORE_CHECKSUMS = DEFAULT; -SELECT @@session.ROCKSDB_STORE_CHECKSUMS; -@@session.ROCKSDB_STORE_CHECKSUMS -0 -"Trying to set variable @@session.ROCKSDB_STORE_CHECKSUMS to on" -SET @@session.ROCKSDB_STORE_CHECKSUMS = on; -SELECT @@session.ROCKSDB_STORE_CHECKSUMS; -@@session.ROCKSDB_STORE_CHECKSUMS -1 -"Setting the session scope variable back to default" -SET @@session.ROCKSDB_STORE_CHECKSUMS = DEFAULT; -SELECT @@session.ROCKSDB_STORE_CHECKSUMS; -@@session.ROCKSDB_STORE_CHECKSUMS -0 -'# Testing with invalid values in global scope #' -"Trying to set variable @@global.ROCKSDB_STORE_CHECKSUMS to 'aaa'" -SET @@global.ROCKSDB_STORE_CHECKSUMS = 'aaa'; -Got one of the listed errors -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -0 -"Trying to set variable @@global.ROCKSDB_STORE_CHECKSUMS to 'bbb'" -SET @@global.ROCKSDB_STORE_CHECKSUMS = 'bbb'; -Got one of the listed errors -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -0 -SET @@global.ROCKSDB_STORE_CHECKSUMS = @start_global_value; -SELECT @@global.ROCKSDB_STORE_CHECKSUMS; -@@global.ROCKSDB_STORE_CHECKSUMS -0 -SET @@session.ROCKSDB_STORE_CHECKSUMS = @start_session_value; -SELECT @@session.ROCKSDB_STORE_CHECKSUMS; -@@session.ROCKSDB_STORE_CHECKSUMS -0 -DROP TABLE valid_values; -DROP TABLE invalid_values; diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_store_row_debug_checksums_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_store_row_debug_checksums_basic.result new file mode 100644 index 00000000000..a838d660a91 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_store_row_debug_checksums_basic.result @@ -0,0 +1,100 @@ +CREATE TABLE valid_values (value varchar(255)) ENGINE=myisam; +INSERT INTO valid_values VALUES(1); +INSERT INTO valid_values VALUES(0); +INSERT INTO valid_values VALUES('on'); +CREATE TABLE invalid_values (value varchar(255)) ENGINE=myisam; +INSERT INTO invalid_values VALUES('\'aaa\''); +INSERT INTO invalid_values VALUES('\'bbb\''); +SET @start_global_value = @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +SELECT @start_global_value; +@start_global_value +0 +SET @start_session_value = @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +SELECT @start_session_value; +@start_session_value +0 +'# Setting to valid values in global scope#' +"Trying to set variable @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS to 1" +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = 1; +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS to 0" +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = 0; +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS to on" +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = on; +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +'# Setting to valid values in session scope#' +"Trying to set variable @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS to 1" +SET @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = 1; +SELECT @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +1 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS to 0" +SET @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = 0; +SELECT @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS to on" +SET @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = on; +SELECT @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +1 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +'# Testing with invalid values in global scope #' +"Trying to set variable @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS to 'aaa'" +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = 'aaa'; +Got one of the listed errors +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS to 'bbb'" +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = 'bbb'; +Got one of the listed errors +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +SET @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = @start_global_value; +SELECT @@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +SET @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS = @start_session_value; +SELECT @@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_STORE_ROW_DEBUG_CHECKSUMS +0 +DROP TABLE valid_values; +DROP TABLE invalid_values; diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_tmpdir_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_tmpdir_basic.result new file mode 100644 index 00000000000..25b19ee56a4 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_tmpdir_basic.result @@ -0,0 +1,29 @@ +SET @start_global_value = @@global.rocksdb_tmpdir; +SELECT @start_global_value; +@start_global_value + +select @@session.rocksdb_tmpdir; +@@session.rocksdb_tmpdir + +show global variables like 'rocksdb_tmpdir'; +Variable_name Value +rocksdb_tmpdir +show session variables like 'rocksdb_tmpdir'; +Variable_name Value +rocksdb_tmpdir +select * from information_schema.global_variables where variable_name='rocksdb_tmpdir'; +VARIABLE_NAME VARIABLE_VALUE +ROCKSDB_TMPDIR +select * from information_schema.session_variables where variable_name='rocksdb_tmpdir'; +VARIABLE_NAME VARIABLE_VALUE +ROCKSDB_TMPDIR +set global rocksdb_tmpdir='value'; +set session rocksdb_tmpdir='value'; +set global rocksdb_tmpdir=1.1; +ERROR 42000: Incorrect argument type to variable 'rocksdb_tmpdir' +set global rocksdb_tmpdir=1e1; +ERROR 42000: Incorrect argument type to variable 'rocksdb_tmpdir' +SET @@global.rocksdb_tmpdir = @start_global_value; +SELECT @@global.rocksdb_tmpdir; +@@global.rocksdb_tmpdir + diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_trace_sst_api_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_trace_sst_api_basic.result new file mode 100644 index 00000000000..d4ffde80001 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_trace_sst_api_basic.result @@ -0,0 +1,100 @@ +CREATE TABLE valid_values (value varchar(255)) ENGINE=myisam; +INSERT INTO valid_values VALUES(1); +INSERT INTO valid_values VALUES(0); +INSERT INTO valid_values VALUES('on'); +CREATE TABLE invalid_values (value varchar(255)) ENGINE=myisam; +INSERT INTO invalid_values VALUES('\'aaa\''); +INSERT INTO invalid_values VALUES('\'bbb\''); +SET @start_global_value = @@global.ROCKSDB_TRACE_SST_API; +SELECT @start_global_value; +@start_global_value +0 +SET @start_session_value = @@session.ROCKSDB_TRACE_SST_API; +SELECT @start_session_value; +@start_session_value +0 +'# Setting to valid values in global scope#' +"Trying to set variable @@global.ROCKSDB_TRACE_SST_API to 1" +SET @@global.ROCKSDB_TRACE_SST_API = 1; +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_TRACE_SST_API = DEFAULT; +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +0 +"Trying to set variable @@global.ROCKSDB_TRACE_SST_API to 0" +SET @@global.ROCKSDB_TRACE_SST_API = 0; +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +0 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_TRACE_SST_API = DEFAULT; +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +0 +"Trying to set variable @@global.ROCKSDB_TRACE_SST_API to on" +SET @@global.ROCKSDB_TRACE_SST_API = on; +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_TRACE_SST_API = DEFAULT; +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +0 +'# Setting to valid values in session scope#' +"Trying to set variable @@session.ROCKSDB_TRACE_SST_API to 1" +SET @@session.ROCKSDB_TRACE_SST_API = 1; +SELECT @@session.ROCKSDB_TRACE_SST_API; +@@session.ROCKSDB_TRACE_SST_API +1 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_TRACE_SST_API = DEFAULT; +SELECT @@session.ROCKSDB_TRACE_SST_API; +@@session.ROCKSDB_TRACE_SST_API +0 +"Trying to set variable @@session.ROCKSDB_TRACE_SST_API to 0" +SET @@session.ROCKSDB_TRACE_SST_API = 0; +SELECT @@session.ROCKSDB_TRACE_SST_API; +@@session.ROCKSDB_TRACE_SST_API +0 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_TRACE_SST_API = DEFAULT; +SELECT @@session.ROCKSDB_TRACE_SST_API; +@@session.ROCKSDB_TRACE_SST_API +0 +"Trying to set variable @@session.ROCKSDB_TRACE_SST_API to on" +SET @@session.ROCKSDB_TRACE_SST_API = on; +SELECT @@session.ROCKSDB_TRACE_SST_API; +@@session.ROCKSDB_TRACE_SST_API +1 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_TRACE_SST_API = DEFAULT; +SELECT @@session.ROCKSDB_TRACE_SST_API; +@@session.ROCKSDB_TRACE_SST_API +0 +'# Testing with invalid values in global scope #' +"Trying to set variable @@global.ROCKSDB_TRACE_SST_API to 'aaa'" +SET @@global.ROCKSDB_TRACE_SST_API = 'aaa'; +Got one of the listed errors +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +0 +"Trying to set variable @@global.ROCKSDB_TRACE_SST_API to 'bbb'" +SET @@global.ROCKSDB_TRACE_SST_API = 'bbb'; +Got one of the listed errors +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +0 +SET @@global.ROCKSDB_TRACE_SST_API = @start_global_value; +SELECT @@global.ROCKSDB_TRACE_SST_API; +@@global.ROCKSDB_TRACE_SST_API +0 +SET @@session.ROCKSDB_TRACE_SST_API = @start_session_value; +SELECT @@session.ROCKSDB_TRACE_SST_API; +@@session.ROCKSDB_TRACE_SST_API +0 +DROP TABLE valid_values; +DROP TABLE invalid_values; diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_use_direct_reads_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_use_direct_reads_basic.result new file mode 100644 index 00000000000..ec36c309dca --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_use_direct_reads_basic.result @@ -0,0 +1,7 @@ +SET @start_global_value = @@global.ROCKSDB_USE_DIRECT_READS; +SELECT @start_global_value; +@start_global_value +0 +"Trying to set variable @@global.ROCKSDB_USE_DIRECT_READS to 444. It should fail because it is readonly." +SET @@global.ROCKSDB_USE_DIRECT_READS = 444; +ERROR HY000: Variable 'rocksdb_use_direct_reads' is a read only variable diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_use_direct_writes_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_use_direct_writes_basic.result new file mode 100644 index 00000000000..4cc787e4586 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_use_direct_writes_basic.result @@ -0,0 +1,7 @@ +SET @start_global_value = @@global.ROCKSDB_USE_DIRECT_WRITES; +SELECT @start_global_value; +@start_global_value +0 +"Trying to set variable @@global.ROCKSDB_USE_DIRECT_WRITES to 444. It should fail because it is readonly." +SET @@global.ROCKSDB_USE_DIRECT_WRITES = 444; +ERROR HY000: Variable 'rocksdb_use_direct_writes' is a read only variable diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_verify_checksums_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_verify_checksums_basic.result deleted file mode 100644 index da4cae7a151..00000000000 --- a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_verify_checksums_basic.result +++ /dev/null @@ -1,100 +0,0 @@ -CREATE TABLE valid_values (value varchar(255)) ENGINE=myisam; -INSERT INTO valid_values VALUES(1); -INSERT INTO valid_values VALUES(0); -INSERT INTO valid_values VALUES('on'); -CREATE TABLE invalid_values (value varchar(255)) ENGINE=myisam; -INSERT INTO invalid_values VALUES('\'aaa\''); -INSERT INTO invalid_values VALUES('\'bbb\''); -SET @start_global_value = @@global.ROCKSDB_VERIFY_CHECKSUMS; -SELECT @start_global_value; -@start_global_value -0 -SET @start_session_value = @@session.ROCKSDB_VERIFY_CHECKSUMS; -SELECT @start_session_value; -@start_session_value -0 -'# Setting to valid values in global scope#' -"Trying to set variable @@global.ROCKSDB_VERIFY_CHECKSUMS to 1" -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = 1; -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -1 -"Setting the global scope variable back to default" -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = DEFAULT; -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -0 -"Trying to set variable @@global.ROCKSDB_VERIFY_CHECKSUMS to 0" -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = 0; -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -0 -"Setting the global scope variable back to default" -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = DEFAULT; -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -0 -"Trying to set variable @@global.ROCKSDB_VERIFY_CHECKSUMS to on" -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = on; -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -1 -"Setting the global scope variable back to default" -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = DEFAULT; -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -0 -'# Setting to valid values in session scope#' -"Trying to set variable @@session.ROCKSDB_VERIFY_CHECKSUMS to 1" -SET @@session.ROCKSDB_VERIFY_CHECKSUMS = 1; -SELECT @@session.ROCKSDB_VERIFY_CHECKSUMS; -@@session.ROCKSDB_VERIFY_CHECKSUMS -1 -"Setting the session scope variable back to default" -SET @@session.ROCKSDB_VERIFY_CHECKSUMS = DEFAULT; -SELECT @@session.ROCKSDB_VERIFY_CHECKSUMS; -@@session.ROCKSDB_VERIFY_CHECKSUMS -0 -"Trying to set variable @@session.ROCKSDB_VERIFY_CHECKSUMS to 0" -SET @@session.ROCKSDB_VERIFY_CHECKSUMS = 0; -SELECT @@session.ROCKSDB_VERIFY_CHECKSUMS; -@@session.ROCKSDB_VERIFY_CHECKSUMS -0 -"Setting the session scope variable back to default" -SET @@session.ROCKSDB_VERIFY_CHECKSUMS = DEFAULT; -SELECT @@session.ROCKSDB_VERIFY_CHECKSUMS; -@@session.ROCKSDB_VERIFY_CHECKSUMS -0 -"Trying to set variable @@session.ROCKSDB_VERIFY_CHECKSUMS to on" -SET @@session.ROCKSDB_VERIFY_CHECKSUMS = on; -SELECT @@session.ROCKSDB_VERIFY_CHECKSUMS; -@@session.ROCKSDB_VERIFY_CHECKSUMS -1 -"Setting the session scope variable back to default" -SET @@session.ROCKSDB_VERIFY_CHECKSUMS = DEFAULT; -SELECT @@session.ROCKSDB_VERIFY_CHECKSUMS; -@@session.ROCKSDB_VERIFY_CHECKSUMS -0 -'# Testing with invalid values in global scope #' -"Trying to set variable @@global.ROCKSDB_VERIFY_CHECKSUMS to 'aaa'" -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = 'aaa'; -Got one of the listed errors -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -0 -"Trying to set variable @@global.ROCKSDB_VERIFY_CHECKSUMS to 'bbb'" -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = 'bbb'; -Got one of the listed errors -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -0 -SET @@global.ROCKSDB_VERIFY_CHECKSUMS = @start_global_value; -SELECT @@global.ROCKSDB_VERIFY_CHECKSUMS; -@@global.ROCKSDB_VERIFY_CHECKSUMS -0 -SET @@session.ROCKSDB_VERIFY_CHECKSUMS = @start_session_value; -SELECT @@session.ROCKSDB_VERIFY_CHECKSUMS; -@@session.ROCKSDB_VERIFY_CHECKSUMS -0 -DROP TABLE valid_values; -DROP TABLE invalid_values; diff --git a/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_verify_row_debug_checksums_basic.result b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_verify_row_debug_checksums_basic.result new file mode 100644 index 00000000000..ad71c8909a6 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_sys_vars/r/rocksdb_verify_row_debug_checksums_basic.result @@ -0,0 +1,100 @@ +CREATE TABLE valid_values (value varchar(255)) ENGINE=myisam; +INSERT INTO valid_values VALUES(1); +INSERT INTO valid_values VALUES(0); +INSERT INTO valid_values VALUES('on'); +CREATE TABLE invalid_values (value varchar(255)) ENGINE=myisam; +INSERT INTO invalid_values VALUES('\'aaa\''); +INSERT INTO invalid_values VALUES('\'bbb\''); +SET @start_global_value = @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +SELECT @start_global_value; +@start_global_value +0 +SET @start_session_value = @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +SELECT @start_session_value; +@start_session_value +0 +'# Setting to valid values in global scope#' +"Trying to set variable @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS to 1" +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = 1; +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS to 0" +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = 0; +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS to on" +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = on; +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +1 +"Setting the global scope variable back to default" +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +'# Setting to valid values in session scope#' +"Trying to set variable @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS to 1" +SET @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = 1; +SELECT @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +1 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS to 0" +SET @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = 0; +SELECT @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS to on" +SET @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = on; +SELECT @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +1 +"Setting the session scope variable back to default" +SET @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = DEFAULT; +SELECT @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +'# Testing with invalid values in global scope #' +"Trying to set variable @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS to 'aaa'" +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = 'aaa'; +Got one of the listed errors +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +"Trying to set variable @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS to 'bbb'" +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = 'bbb'; +Got one of the listed errors +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +SET @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = @start_global_value; +SELECT @@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@global.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +SET @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS = @start_session_value; +SELECT @@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS; +@@session.ROCKSDB_VERIFY_ROW_DEBUG_CHECKSUMS +0 +DROP TABLE valid_values; +DROP TABLE invalid_values; |