Edit File: innodb_file_format_max_basic.result
SET @start_global_value = @@global.innodb_file_format_max; SELECT @start_global_value; @start_global_value Antelope Valid values are 'Antelope' and 'Barracuda' SELECT @@global.innodb_file_format_max in ('Antelope', 'Barracuda'); @@global.innodb_file_format_max in ('Antelope', 'Barracuda') 1 SELECT @@global.innodb_file_format_max; @@global.innodb_file_format_max Antelope SELECT @@session.innodb_file_format_max; ERROR HY000: Variable 'innodb_file_format_max' is a GLOBAL variable SHOW global variables LIKE 'innodb_file_format_max'; Variable_name Value innodb_file_format_max Antelope SHOW session variables LIKE 'innodb_file_format_max'; Variable_name Value innodb_file_format_max Antelope SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_file_format_max'; VARIABLE_NAME VARIABLE_VALUE INNODB_FILE_FORMAT_MAX Antelope SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_file_format_max'; VARIABLE_NAME VARIABLE_VALUE INNODB_FILE_FORMAT_MAX Antelope SET global innodb_file_format_max='Antelope'; SELECT @@global.innodb_file_format_max; @@global.innodb_file_format_max Antelope SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_file_format_max'; VARIABLE_NAME VARIABLE_VALUE INNODB_FILE_FORMAT_MAX Antelope SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_file_format_max'; VARIABLE_NAME VARIABLE_VALUE INNODB_FILE_FORMAT_MAX Antelope SET @@global.innodb_file_format_max='Barracuda'; SELECT @@global.innodb_file_format_max; @@global.innodb_file_format_max Barracuda SELECT * FROM information_schema.global_variables WHERE variable_name='innodb_file_format_max'; VARIABLE_NAME VARIABLE_VALUE INNODB_FILE_FORMAT_MAX Barracuda SELECT * FROM information_schema.session_variables WHERE variable_name='innodb_file_format_max'; VARIABLE_NAME VARIABLE_VALUE INNODB_FILE_FORMAT_MAX Barracuda SET session innodb_file_format_max='Salmon'; ERROR HY000: Variable 'innodb_file_format_max' is a GLOBAL variable and should be set with SET GLOBAL SET @@session.innodb_file_format_max='Salmon'; ERROR HY000: Variable 'innodb_file_format_max' is a GLOBAL variable and should be set with SET GLOBAL SET global innodb_file_format_max=1.1; ERROR 42000: Incorrect argument type to variable 'innodb_file_format_max' SET global innodb_file_format_max=1e1; ERROR 42000: Incorrect argument type to variable 'innodb_file_format_max' SET global innodb_file_format_max='Salmon'; ERROR 42000: Variable 'innodb_file_format_max' can't be set to the value of 'Salmon' SET @@global.innodb_file_format_max = @start_global_value; SELECT @@global.innodb_file_format_max; @@global.innodb_file_format_max Antelope
Back to File Manager