From 11e567229ac41541908f976b130ff792bd6754d6 Mon Sep 17 00:00:00 2001
From: "monty@hundin.mysql.fi" <>
Date: Thu, 21 Jun 2001 10:50:14 +0300
Subject: UNIQUE keys are not anymore shown as PRIMARY KEY

---
 mysql-test/r/show_check.result | 10 ++++++++++
 mysql-test/t/show_check.test   |  7 +++++++
 2 files changed, 17 insertions(+)

(limited to 'mysql-test')

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;
-- 
cgit v1.2.1