diff options
Diffstat (limited to 'mysql-test/t/maria.test')
| -rw-r--r-- | mysql-test/t/maria.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/t/maria.test b/mysql-test/t/maria.test index a98e2a8acf4..06e5a4d5b45 100644 --- a/mysql-test/t/maria.test +++ b/mysql-test/t/maria.test @@ -638,6 +638,22 @@ checksum table t1; checksum table t2; drop table t1, t2; +CREATE TABLE t1 ( + twenty int(4), + hundred int(4) NOT NULL +) CHECKSUM=1; +INSERT INTO t1 VALUES (11,91); +check table t1 extended; +checksum table t1; +checksum table t1 extended; +alter table t1 row_format=static; +checksum table t1; +alter table t1 row_format=packed; +checksum table t1; +alter table t1 engine=myisam; +checksum table t1; +drop table t1; + # # maria_stats_method variable. # @@ -1130,12 +1146,21 @@ create table t1 (a int) row_format=dynamic transactional=1; show create table t1; alter table t1 row_format=PAGE; show create table t1; +alter table t1 row_format=DYNAMIC; +show create table t1; alter table t1 transactional=0; show create table t1; +alter table t1 row_format=DYNAMIC; +show create table t1; drop table t1; create table t1 (a int) row_format=PAGE; show create table t1; drop table t1; +create table t1 (a int) row_format=PAGE TRANSACTIONAL=DEFAULT; +show create table t1; +alter table t1 row_format=DYNAMIC; +show create table t1; +drop table t1; # Verify that INSERT DELAYED is disabled only for transactional tables create table t1 (a int) row_format=page; |