diff options
| author | unknown <monty@hundin.mysql.fi> | 2001-06-21 10:50:14 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2001-06-21 10:50:14 +0300 |
| commit | 066eddd86208ff7aff062efce1957a66618de854 (patch) | |
| tree | 1aa843ac71d84cfb5316c1bc479b55cd0cf74b45 /mysql-test/r/show_check.result | |
| parent | b5f7e2408fdb32f478688f384794e660da457e48 (diff) | |
| download | mariadb-git-066eddd86208ff7aff062efce1957a66618de854.tar.gz | |
UNIQUE keys are not anymore shown as PRIMARY KEY
Docs/manual.texi:
Changelog
mysql-test/r/show_check.result:
Added test for SHOW CREATE
mysql-test/t/show_check.test:
Added test for SHOW CREATE
sql/mysqld.cc:
Fixed messages
Diffstat (limited to 'mysql-test/r/show_check.result')
| -rw-r--r-- | mysql-test/r/show_check.result | 10 |
1 files changed, 10 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 |