1SET @start_value = @@global.log_slow_queries; 2SELECT @start_value; 3@start_value 41 5'#---------------------FN_DYNVARS_004_01-------------------------#' 6SET @@global.log_slow_queries = DEFAULT; 7Warnings: 8Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 9SELECT @@global.log_slow_queries = 0; 10@@global.log_slow_queries = 0 111 12'#--------------------FN_DYNVARS_004_02------------------------#' 13SET @@global.log_slow_queries = ON; 14Warnings: 15Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 16SELECT @@global.log_slow_queries; 17@@global.log_slow_queries 181 19SET @@global.log_slow_queries = OFF; 20Warnings: 21Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 22SELECT @@global.log_slow_queries; 23@@global.log_slow_queries 240 25'#--------------------FN_DYNVARS_004_03-------------------------#' 26SET @@global.log_slow_queries = 2; 27ERROR 42000: Variable 'log_slow_queries' can't be set to the value of '2' 28SET @@global.log_slow_queries = -1; 29ERROR 42000: Variable 'log_slow_queries' can't be set to the value of '-1' 30SET @@global.log_slow_queries = TRUEF; 31ERROR 42000: Variable 'log_slow_queries' can't be set to the value of 'TRUEF' 32SET @@global.log_slow_queries = TRUE_F; 33ERROR 42000: Variable 'log_slow_queries' can't be set to the value of 'TRUE_F' 34SET @@global.log_slow_queries = FALSE0; 35ERROR 42000: Variable 'log_slow_queries' can't be set to the value of 'FALSE0' 36SET @@global.log_slow_queries = OON; 37ERROR 42000: Variable 'log_slow_queries' can't be set to the value of 'OON' 38SET @@global.log_slow_queries = ONN; 39ERROR 42000: Variable 'log_slow_queries' can't be set to the value of 'ONN' 40SET @@global.log_slow_queries = OOFF; 41ERROR 42000: Variable 'log_slow_queries' can't be set to the value of 'OOFF' 42SET @@global.log_slow_queries = 0FF; 43ERROR 42000: Variable 'log_slow_queries' can't be set to the value of '0FF' 44SET @@global.log_slow_queries = ' '; 45ERROR 42000: Variable 'log_slow_queries' can't be set to the value of ' ' 46SET @@global.log_slow_queries = " "; 47ERROR 42000: Variable 'log_slow_queries' can't be set to the value of ' ' 48SET @@global.log_slow_queries = ''; 49ERROR 42000: Variable 'log_slow_queries' can't be set to the value of '' 50'#-------------------FN_DYNVARS_004_04----------------------------#' 51SET @@session.log_slow_queries = OFF; 52ERROR HY000: Variable 'log_slow_queries' is a GLOBAL variable and should be set with SET GLOBAL 53SELECT @@session.log_slow_queries; 54ERROR HY000: Variable 'log_slow_queries' is a GLOBAL variable 55'#----------------------FN_DYNVARS_004_05------------------------#' 56SELECT IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 57FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 58WHERE VARIABLE_NAME='log_slow_queries'; 59IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 601 61'#---------------------FN_DYNVARS_004_06----------------------#' 62SET @@global.log_slow_queries = 0; 63Warnings: 64Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 65SELECT @@global.log_slow_queries; 66@@global.log_slow_queries 670 68SELECT IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 69FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 70WHERE VARIABLE_NAME='log_slow_queries'; 71IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 721 73SET @@global.log_slow_queries = 1; 74Warnings: 75Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 76SELECT @@global.log_slow_queries; 77@@global.log_slow_queries 781 79SELECT IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 80FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 81WHERE VARIABLE_NAME='log_slow_queries'; 82IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 831 84'#---------------------FN_DYNVARS_004_07----------------------#' 85SET @@global.log_slow_queries = TRUE; 86Warnings: 87Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 88SELECT @@global.log_slow_queries; 89@@global.log_slow_queries 901 91SELECT IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 92FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 93WHERE VARIABLE_NAME='log_slow_queries'; 94IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 951 96SET @@global.log_slow_queries = FALSE; 97Warnings: 98Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 99SELECT @@global.log_slow_queries; 100@@global.log_slow_queries 1010 102SELECT IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 103FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 104WHERE VARIABLE_NAME='log_slow_queries'; 105IF(@@global.log_slow_queries, "ON", "OFF") = VARIABLE_VALUE 1061 107'#---------------------FN_DYNVARS_004_08----------------------#' 108SET @@global.log_slow_queries = ON; 109Warnings: 110Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 111SELECT @@log_slow_queries = @@global.log_slow_queries; 112@@log_slow_queries = @@global.log_slow_queries 1131 114'#---------------------FN_DYNVARS_004_09----------------------#' 115SET log_slow_queries = ON; 116ERROR HY000: Variable 'log_slow_queries' is a GLOBAL variable and should be set with SET GLOBAL 117SET local.log_slow_queries = OFF; 118ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'log_slow_queries = OFF' at line 1 119SELECT local.log_slow_queries; 120ERROR 42S02: Unknown table 'local' in field list 121SET global.log_slow_queries = ON; 122ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'log_slow_queries = ON' at line 1 123SELECT global.log_slow_queries; 124ERROR 42S02: Unknown table 'global' in field list 125SELECT log_slow_queries = @@session.log_slow_queries; 126ERROR 42S22: Unknown column 'log_slow_queries' in 'field list' 127SET @@global.log_slow_queries = @start_value; 128Warnings: 129Warning 1287 '@@log_slow_queries' is deprecated and will be removed in a future release. Please use '@@slow_query_log' instead 130SELECT @@global.log_slow_queries; 131@@global.log_slow_queries 1321 133