Debian Codegraph @

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

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