1
# This is the unit test for bug *47167.
2
# It tests setting the global variable
3
# "innodb_file_format_check" with a
4
# user-Defined Variable.
6
--source include/have_innodb.inc
7
-- source suite/innodb/include/have_innodb_plugin.inc
9
# Save the value (Antelope) in 'innodb_file_format_check' to
10
# 'old_innodb_file_format_check'
11
set @old_innodb_file_format_check=@@innodb_file_format_check;
13
# @old_innodb_file_format_check shall have the value of 'Antelope'
14
select @old_innodb_file_format_check;
16
# Reset the value in 'innodb_file_format_check' to 'Barracuda'
17
set global innodb_file_format_check = Barracuda;
19
select @@innodb_file_format_check;
21
# Set 'innodb_file_format_check' to its default value, which
22
# is the latest file format supported in the current release.
23
set global innodb_file_format_check = DEFAULT;
25
select @@innodb_file_format_check;
27
# Put the saved value back to 'innodb_file_format_check'
28
set global innodb_file_format_check = @old_innodb_file_format_check;
30
# Check whether 'innodb_file_format_check' get its original value.
31
select @@innodb_file_format_check;
33
# Following are negative tests, all should fail.
35
--error ER_WRONG_ARGUMENTS
36
set global innodb_file_format_check = cheetah;
38
--error ER_WRONG_ARGUMENTS
39
set global innodb_file_format_check = Bear;
41
--error ER_WRONG_ARGUMENTS
42
set global innodb_file_format_check = on;
44
--error ER_WRONG_ARGUMENTS
45
set global innodb_file_format_check = off;