1SET @global_start_value = @@global.innodb_flush_log_at_trx_commit; 2SELECT @global_start_value; 3@global_start_value 41 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_flush_log_at_trx_commit = 0; 7SET @@global.innodb_flush_log_at_trx_commit = DEFAULT; 8SELECT @@global.innodb_flush_log_at_trx_commit; 9@@global.innodb_flush_log_at_trx_commit 101 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_flush_log_at_trx_commit = 1; 13ERROR HY000: Variable 'innodb_flush_log_at_trx_commit' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_flush_log_at_trx_commit; 15@@innodb_flush_log_at_trx_commit 161 17SELECT local.innodb_flush_log_at_trx_commit; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_flush_log_at_trx_commit = 0; 20SELECT @@global.innodb_flush_log_at_trx_commit; 21@@global.innodb_flush_log_at_trx_commit 220 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_flush_log_at_trx_commit = 0; 25SELECT @@global.innodb_flush_log_at_trx_commit; 26@@global.innodb_flush_log_at_trx_commit 270 28SET @@global.innodb_flush_log_at_trx_commit = 1; 29SELECT @@global.innodb_flush_log_at_trx_commit; 30@@global.innodb_flush_log_at_trx_commit 311 32SET @@global.innodb_flush_log_at_trx_commit = 2; 33SELECT @@global.innodb_flush_log_at_trx_commit; 34@@global.innodb_flush_log_at_trx_commit 352 36'#--------------------FN_DYNVARS_046_04-------------------------#' 37SET @@global.innodb_flush_log_at_trx_commit = -1; 38Warnings: 39Warning 1292 Truncated incorrect innodb_flush_log_at_trx_commit value: '-1' 40SELECT @@global.innodb_flush_log_at_trx_commit; 41@@global.innodb_flush_log_at_trx_commit 420 43SET @@global.innodb_flush_log_at_trx_commit = "T"; 44ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 45SELECT @@global.innodb_flush_log_at_trx_commit; 46@@global.innodb_flush_log_at_trx_commit 470 48SET @@global.innodb_flush_log_at_trx_commit = "Y"; 49ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 50SELECT @@global.innodb_flush_log_at_trx_commit; 51@@global.innodb_flush_log_at_trx_commit 520 53SET @@global.innodb_flush_log_at_trx_commit = 1001; 54Warnings: 55Warning 1292 Truncated incorrect innodb_flush_log_at_trx_commit value: '1001' 56SELECT @@global.innodb_flush_log_at_trx_commit; 57@@global.innodb_flush_log_at_trx_commit 583 59SET @@global.innodb_flush_log_at_trx_commit = 100156787; 60Warnings: 61Warning 1292 Truncated incorrect innodb_flush_log_at_trx_commit value: '100156787' 62SELECT @@global.innodb_flush_log_at_trx_commit; 63@@global.innodb_flush_log_at_trx_commit 643 65SET @@global.innodb_flush_log_at_trx_commit = " "; 66ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 67SELECT @@global.innodb_flush_log_at_trx_commit; 68@@global.innodb_flush_log_at_trx_commit 693 70SET @@global.innodb_flush_log_at_trx_commit = 1.1; 71ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 72SELECT @@global.innodb_flush_log_at_trx_commit; 73@@global.innodb_flush_log_at_trx_commit 743 75SET @@global.innodb_flush_log_at_trx_commit = ' '; 76ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 77SELECT @@global.innodb_flush_log_at_trx_commit; 78@@global.innodb_flush_log_at_trx_commit 793 80'#----------------------FN_DYNVARS_046_05------------------------#' 81SELECT @@global.innodb_flush_log_at_trx_commit = 82VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 83WHERE VARIABLE_NAME='innodb_flush_log_at_trx_commit'; 84@@global.innodb_flush_log_at_trx_commit = 85VARIABLE_VALUE 861 87SELECT @@global.innodb_flush_log_at_trx_commit; 88@@global.innodb_flush_log_at_trx_commit 893 90SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 91WHERE VARIABLE_NAME='innodb_flush_log_at_trx_commit'; 92VARIABLE_VALUE 933 94'#---------------------FN_DYNVARS_046_06-------------------------#' 95SET @@global.innodb_flush_log_at_trx_commit = OFF; 96ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 97SELECT @@global.innodb_flush_log_at_trx_commit; 98@@global.innodb_flush_log_at_trx_commit 993 100SET @@global.innodb_flush_log_at_trx_commit = ON; 101ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit' 102SELECT @@global.innodb_flush_log_at_trx_commit; 103@@global.innodb_flush_log_at_trx_commit 1043 105'#---------------------FN_DYNVARS_046_07----------------------#' 106SET @@global.innodb_flush_log_at_trx_commit = TRUE; 107SELECT @@global.innodb_flush_log_at_trx_commit; 108@@global.innodb_flush_log_at_trx_commit 1091 110SET @@global.innodb_flush_log_at_trx_commit = FALSE; 111SELECT @@global.innodb_flush_log_at_trx_commit; 112@@global.innodb_flush_log_at_trx_commit 1130 114SET @@global.innodb_flush_log_at_trx_commit = @global_start_value; 115SELECT @@global.innodb_flush_log_at_trx_commit; 116@@global.innodb_flush_log_at_trx_commit 1171 118