Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_default_row_format_basic.test

raw
1 --source include/have_innodb.inc
2
3 # Check the default value
4 SELECT @@global.innodb_default_row_format;
5
6 SET GLOBAL innodb_default_row_format = 'redundant';
7 SELECT @@global.innodb_default_row_format;
8
9 SET GLOBAL innodb_default_row_format = 'dynamic';
10 SELECT @@global.innodb_default_row_format;
11
12 SET GLOBAL innodb_default_row_format = 'compact';
13 SELECT @@global.innodb_default_row_format;
14
15 --error ER_WRONG_VALUE_FOR_VAR
16 SET GLOBAL innodb_default_row_format = 'compressed';
17 SELECT @@global.innodb_default_row_format;
18
19 --error ER_WRONG_VALUE_FOR_VAR
20 SET GLOBAL innodb_default_row_format = 'foobar';
21 SELECT @@global.innodb_default_row_format;
22
23 SET GLOBAL innodb_default_row_format = 0;
24 SELECT @@global.innodb_default_row_format;
25
26 SET GLOBAL innodb_default_row_format = 1;
27 SELECT @@global.innodb_default_row_format;
28
29 SET GLOBAL innodb_default_row_format = 2;
30 SELECT @@global.innodb_default_row_format;
31
32 --error ER_WRONG_VALUE_FOR_VAR
33 SET GLOBAL innodb_default_row_format = 3;
34 SELECT @@global.innodb_default_row_format;
35
36 --error ER_WRONG_VALUE_FOR_VAR
37 SET GLOBAL innodb_default_row_format = 123;
38 SELECT @@global.innodb_default_row_format;
39
40
41 SET GLOBAL innodb_default_row_format = default;