Debian Codegraph @

mysql-test/suite/innodb/include/default_row_format_create.inc

raw
1 --eval SET GLOBAL innodb_default_row_format = $INNODB_DEFAULT_ROW_FORMAT
2 # Check default row_format without setting new global variable
3 SELECT @@innodb_default_row_format;
4
5 eval CREATE $TEMPORARY TABLE t1(c1 TEXT,c2 BLOB) ENGINE=InnoDB;
6 --source suite/innodb/include/default_row_format_show.inc
7 DROP TABLE t1;
8 --echo
9
10 eval CREATE $TEMPORARY TABLE t1(c1 TEXT,c2 BLOB) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
11 --source suite/innodb/include/default_row_format_show.inc
12 DROP TABLE t1;
13 --echo
14
15 eval CREATE $TEMPORARY TABLE t1(c1 TEXT,c2 BLOB) ENGINE=InnoDB ROW_FORMAT=COMPACT;
16 --source suite/innodb/include/default_row_format_show.inc
17 DROP TABLE t1;
18 --echo
19
20 eval CREATE $TEMPORARY TABLE t1(c1 TEXT,c2 BLOB) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
21 --source suite/innodb/include/default_row_format_show.inc
22 DROP TABLE t1;
23 --echo
24
25 if ($TEMPORARY != 'TEMPORARY') {
26 eval CREATE $TEMPORARY TABLE t1(c1 TEXT,c2 BLOB) ENGINE=InnoDB
27 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
28 --source suite/innodb/include/default_row_format_show.inc
29 DROP TABLE t1;
30 }
31 --echo