1SET @start_global_value = @@global.innodb_file_format_check; 2SELECT @start_global_value; 3@start_global_value 41 5Valid values are 'ON' and 'OFF' 6SELECT @@global.innodb_file_format_check in (0, 1); 7@@global.innodb_file_format_check in (0, 1) 81 9SELECT @@global.innodb_file_format_check; 10@@global.innodb_file_format_check 111 12SELECT @@session.innodb_file_format_check; 13ERROR HY000: Variable 'innodb_file_format_check' is a GLOBAL variable 14SHOW global variables LIKE 'innodb_file_format_check'; 15Variable_name Value 16innodb_file_format_check ON 17SHOW session variables LIKE 'innodb_file_format_check'; 18Variable_name Value 19innodb_file_format_check ON 20SELECT * FROM information_schema.global_variables 21WHERE variable_name='innodb_file_format_check'; 22VARIABLE_NAME VARIABLE_VALUE 23INNODB_FILE_FORMAT_CHECK ON 24SELECT * FROM information_schema.session_variables 25WHERE variable_name='innodb_file_format_check'; 26VARIABLE_NAME VARIABLE_VALUE 27INNODB_FILE_FORMAT_CHECK ON 28SET @@global.innodb_file_format_check='Off'; 29ERROR HY000: Variable 'innodb_file_format_check' is a read only variable 30Expected error 'Read only variable' 31SET @@global.innodb_file_format_check=1; 32ERROR HY000: Variable 'innodb_file_format_check' is a read only variable 33Expected error 'Read only variable' 34SET @@global.innodb_file_format_check=0; 35ERROR HY000: Variable 'innodb_file_format_check' is a read only variable 36Expected error 'Read only variable' 37SET @@global.innodb_file_format_check='On'; 38ERROR HY000: Variable 'innodb_file_format_check' is a read only variable 39Expected error 'Read only variable' 40SET session innodb_large_prefix='OFF'; 41ERROR HY000: Variable 'innodb_large_prefix' is a GLOBAL variable and should be set with SET GLOBAL 42SET @@session.innodb_stats_on_metadata='ON'; 43ERROR HY000: Variable 'innodb_stats_on_metadata' is a GLOBAL variable and should be set with SET GLOBAL 44SELECT IF(@@GLOBAL.innodb_file_format_check, "ON", "OFF") = VARIABLE_VALUE 45FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 46WHERE VARIABLE_NAME='innodb_file_format_check'; 47IF(@@GLOBAL.innodb_file_format_check, "ON", "OFF") = VARIABLE_VALUE 481 491 Expected 50SELECT COUNT(@@GLOBAL.innodb_file_format_check); 51COUNT(@@GLOBAL.innodb_file_format_check) 521 531 Expected 54SELECT COUNT(VARIABLE_VALUE) 55FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 56WHERE VARIABLE_NAME='innodb_file_format_check'; 57COUNT(VARIABLE_VALUE) 581 591 Expected 60SELECT @@innodb_file_format_check = @@GLOBAL.innodb_file_format_check; 61@@innodb_file_format_check = @@GLOBAL.innodb_file_format_check 621 631 Expected 64SELECT COUNT(@@innodb_file_format_check); 65COUNT(@@innodb_file_format_check) 661 671 Expected 68SELECT COUNT(@@local.innodb_file_format_check); 69ERROR HY000: Variable 'innodb_file_format_check' is a GLOBAL variable 70Expected error 'Variable is a GLOBAL variable' 71SELECT COUNT(@@SESSION.innodb_file_format_check); 72ERROR HY000: Variable 'innodb_file_format_check' is a GLOBAL variable 73Expected error 'Variable is a GLOBAL variable' 74SELECT COUNT(@@GLOBAL.innodb_file_format_check); 75COUNT(@@GLOBAL.innodb_file_format_check) 761 771 Expected 78SELECT innodb_file_format_check = @@SESSION.innodb_file_format_check; 79ERROR 42S22: Unknown column 'innodb_file_format_check' in 'field list' 80Expected error 'Readonly variable' 81