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
8
# Save the value (Antelope) in 'innodb_file_format_check' to
9
# 'old_innodb_file_format_check'
10
set @old_innodb_file_format_check=@@innodb_file_format_check;
12
# @old_innodb_file_format_check shall have the value of 'Antelope'
13
select @old_innodb_file_format_check;
15
# Reset the value in 'innodb_file_format_check' to 'Barracuda'
16
set global innodb_file_format_check = Barracuda;
18
select @@innodb_file_format_check;
20
# Set 'innodb_file_format_check' to its default value, which
21
# is the latest file format supported in the current release.
22
set global innodb_file_format_check = DEFAULT;
24
select @@innodb_file_format_check;
26
# Put the saved value back to 'innodb_file_format_check'
27
set global innodb_file_format_check = @old_innodb_file_format_check;
29
# Check whether 'innodb_file_format_check' get its original value.
30
select @@innodb_file_format_check;
32
# Following are negative tests, all should fail.
34
--error ER_WRONG_ARGUMENTS
35
set global innodb_file_format_check = cheetah;
37
--error ER_WRONG_ARGUMENTS
38
set global innodb_file_format_check = Bear;
40
--error ER_WRONG_ARGUMENTS
41
set global innodb_file_format_check = on;
43
--error ER_WRONG_ARGUMENTS
44
set global innodb_file_format_check = off;