From 87a0cc9419ef4dc84750a236c90c22f8f2edcc00 Mon Sep 17 00:00:00 2001 From: unknown Date: Sun, 30 Sep 2001 05:47:35 +0300 Subject: Fixed that SHOW CREATE TABLE shows all attributes mysql-test/r/show_check.result: Tests for SHOW CREATE TABLE mysql-test/t/show_check.test: Tests for SHOW CREATE TABLE sql/table.cc: More debugging Docs/manual.texi: Added information about MRG_MYISAM --- mysql-test/t/show_check.test | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/t/show_check.test') diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index 0e0d79e7d16..6bbad3dea59 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -79,3 +79,11 @@ create table t1(n int); insert into t1 values (1); show open tables; drop table t1; + +create table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" TYPE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 DELAY_KEY_WRITE=1 ROW_FORMAT=fixed; +show create table t1; +alter table t1 MAX_ROWS=200 ROW_FORMAT=dynamic PACK_KEYS=0; +show create table t1; +ALTER TABLE t1 AVG_ROW_LENGTH=0 CHECKSUM=0 COMMENT="" MIN_ROWS=0 MAX_ROWS=0 PACK_KEYS=DEFAULT DELAY_KEY_WRITE=0 ROW_FORMAT=default; +show create table t1; +drop table t1; -- cgit v1.2.1