Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_default_row_format_basic.result

raw
1 SELECT @@global.innodb_default_row_format;
2 @@global.innodb_default_row_format
3 dynamic
4 SET GLOBAL innodb_default_row_format = 'redundant';
5 SELECT @@global.innodb_default_row_format;
6 @@global.innodb_default_row_format
7 redundant
8 SET GLOBAL innodb_default_row_format = 'dynamic';
9 SELECT @@global.innodb_default_row_format;
10 @@global.innodb_default_row_format
11 dynamic
12 SET GLOBAL innodb_default_row_format = 'compact';
13 SELECT @@global.innodb_default_row_format;
14 @@global.innodb_default_row_format
15 compact
16 SET GLOBAL innodb_default_row_format = 'compressed';
17 ERROR 42000: Variable 'innodb_default_row_format' can't be set to the value of 'compressed'
18 SELECT @@global.innodb_default_row_format;
19 @@global.innodb_default_row_format
20 compact
21 SET GLOBAL innodb_default_row_format = 'foobar';
22 ERROR 42000: Variable 'innodb_default_row_format' can't be set to the value of 'foobar'
23 SELECT @@global.innodb_default_row_format;
24 @@global.innodb_default_row_format
25 compact
26 SET GLOBAL innodb_default_row_format = 0;
27 SELECT @@global.innodb_default_row_format;
28 @@global.innodb_default_row_format
29 redundant
30 SET GLOBAL innodb_default_row_format = 1;
31 SELECT @@global.innodb_default_row_format;
32 @@global.innodb_default_row_format
33 compact
34 SET GLOBAL innodb_default_row_format = 2;
35 SELECT @@global.innodb_default_row_format;
36 @@global.innodb_default_row_format
37 dynamic
38 SET GLOBAL innodb_default_row_format = 3;
39 ERROR 42000: Variable 'innodb_default_row_format' can't be set to the value of '3'
40 SELECT @@global.innodb_default_row_format;
41 @@global.innodb_default_row_format
42 dynamic
43 SET GLOBAL innodb_default_row_format = 123;
44 ERROR 42000: Variable 'innodb_default_row_format' can't be set to the value of '123'
45 SELECT @@global.innodb_default_row_format;
46 @@global.innodb_default_row_format
47 dynamic
48 SET GLOBAL innodb_default_row_format = default;