diff options
| author | unknown <monty@hundin.mysql.fi> | 2001-09-30 05:47:35 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2001-09-30 05:47:35 +0300 |
| commit | 87a0cc9419ef4dc84750a236c90c22f8f2edcc00 (patch) | |
| tree | f62e9813e447863e2dcddb0cd15e7b4231fb6435 /mysql-test | |
| parent | 4b019c6f1cf2fa68e46602b9fee7cd097daf54f6 (diff) | |
| download | mariadb-git-87a0cc9419ef4dc84750a236c90c22f8f2edcc00.tar.gz | |
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
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/show_check.result | 18 | ||||
| -rw-r--r-- | mysql-test/t/show_check.test | 8 |
2 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result index a8be3f04249..2e323f73793 100644 --- a/mysql-test/r/show_check.result +++ b/mysql-test/r/show_check.result @@ -93,3 +93,21 @@ t1 CREATE TABLE `t1` ( Database Table In_use Name_locked Database Table In_use Name_locked test t1 0 0 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL default '0', + `b` char(10) default NULL, + KEY `b` (`b`) +) TYPE=MyISAM MIN_ROWS=10 MAX_ROWS=100 AVG_ROW_LENGTH=10 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED COMMENT='test' +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL default '0', + `b` varchar(10) default NULL, + KEY `b` (`b`) +) TYPE=MyISAM MIN_ROWS=10 MAX_ROWS=200 AVG_ROW_LENGTH=10 PACK_KEYS=0 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='test' +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL default '0', + `b` varchar(10) default NULL, + KEY `b` (`b`) +) TYPE=MyISAM 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; |