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