1SET @@SESSION.innodb_strict_mode=OFF;
2CREATE TABLE t1 (a INT) ENGINE=InnoDB ROW_FORMAT=TOKUDB_UNCOMPRESSED;
3Warnings:
4Warning	1478	InnoDB: assuming ROW_FORMAT=DYNAMIC.
5ALTER TABLE t1 ROW_FORMAT=TOKUDB_DEFAULT;
6Warnings:
7Warning	1478	InnoDB: assuming ROW_FORMAT=DYNAMIC.
8ALTER TABLE t1 ROW_FORMAT=TOKUDB_ZLIB;
9Warnings:
10Warning	1478	InnoDB: assuming ROW_FORMAT=DYNAMIC.
11ALTER TABLE t1 ROW_FORMAT=TOKUDB_SNAPPY;
12Warnings:
13Warning	1478	InnoDB: assuming ROW_FORMAT=DYNAMIC.
14ALTER TABLE t1 ROW_FORMAT=TOKUDB_QUICKLZ;
15Warnings:
16Warning	1478	InnoDB: assuming ROW_FORMAT=DYNAMIC.
17ALTER TABLE t1 ROW_FORMAT=TOKUDB_LZMA;
18Warnings:
19Warning	1478	InnoDB: assuming ROW_FORMAT=DYNAMIC.
20ALTER TABLE t1 ROW_FORMAT=TOKUDB_FAST;
21Warnings:
22Warning	1478	InnoDB: assuming ROW_FORMAT=DYNAMIC.
23ALTER TABLE t1 ROW_FORMAT=TOKUDB_SMALL;
24Warnings:
25Warning	1478	InnoDB: assuming ROW_FORMAT=DYNAMIC.
26ALTER TABLE t1 ROW_FORMAT=TOKUDB_UNDEFINED;
27ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TOKUDB_UNDEFINED' at line 1
28SET @@SESSION.innodb_strict_mode=ON;
29ALTER TABLE t1 ROW_FORMAT=TOKUDB_DEFAULT;
30ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
31ALTER TABLE t1 ROW_FORMAT=TOKUDB_ZLIB;
32ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
33ALTER TABLE t1 ROW_FORMAT=TOKUDB_SNAPPY;
34ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
35ALTER TABLE t1 ROW_FORMAT=TOKUDB_QUICKLZ;
36ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
37ALTER TABLE t1 ROW_FORMAT=TOKUDB_LZMA;
38ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
39ALTER TABLE t1 ROW_FORMAT=TOKUDB_FAST;
40ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
41ALTER TABLE t1 ROW_FORMAT=TOKUDB_SMALL;
42ERROR HY000: Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE'
43CREATE TABLE t2 (a INT) ENGINE=MyISAM ROW_FORMAT=TOKUDB_ZLIB;
44CREATE TABLE t3 (a INT) ENGINE=MEMORY ROW_FORMAT=TOKUDB_SNAPPY;
45CREATE TABLE t4 (a INT) ENGINE=MEMORY ROW_FORMAT=TOKUDB_QUICKLZ;
46CREATE TABLE t5 (a INT) ENGINE=MEMORY ROW_FORMAT=TOKUDB_DEFAULT;
47DROP TABLE t1, t2, t3, t4, t5;
48CREATE TABLE TOKUDB_UNCOMPRESSED(TOKUDB_ZLIB INT, TOKUDB_SNAPPY INT, TOKUDB_QUICKLZ INT, TOKUDB_LZMA INT, TOKUDB_FAST INT, TOKUDB_SMALL INT, TOKUDB_DEFAULT INT);
49DROP TABLE TOKUDB_UNCOMPRESSED;
50