diff options
| author | monty@hundin.mysql.fi <> | 2001-06-21 10:50:14 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-06-21 10:50:14 +0300 |
| commit | 11e567229ac41541908f976b130ff792bd6754d6 (patch) | |
| tree | 1aa843ac71d84cfb5316c1bc479b55cd0cf74b45 /mysql-test | |
| parent | 34b528f13fea33b7ca15a31e91e627f7c1c72ace (diff) | |
| download | mariadb-git-11e567229ac41541908f976b130ff792bd6754d6.tar.gz | |
UNIQUE keys are not anymore shown as PRIMARY KEY
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/show_check.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/show_check.test | 7 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result index ce2e5d4f58d..099ea2fa109 100644 --- a/mysql-test/r/show_check.result +++ b/mysql-test/r/show_check.result @@ -80,3 +80,13 @@ t1 CREATE TABLE `t1` ( `test_set` set('val1','val2','val3') NOT NULL default '', `name` char(20) default 'O''Brien' ) TYPE=MyISAM COMMENT='it''s a table' +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL default '0', + UNIQUE KEY `aa` (`a`) +) TYPE=MyISAM +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL default '0', + PRIMARY KEY (`a`) +) TYPE=MyISAM diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index f4f58c8c885..476d8dcdf0d 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -65,3 +65,10 @@ create table t1 ( ) comment = 'it\'s a table' ; show create table t1 ; drop table t1; + +create table t1 (a int not null, unique aa (a)); +show create table t1; +drop table t1; +create table t1 (a int not null, primary key (a)); +show create table t1; +drop table t1; |