From 46d472d636a0b33dfffb77b8b61eead94e285839 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 7 Jul 2005 14:44:28 +0200 Subject: BUG#11635 mysqldump exports TYPE instead of USING for HASH Cluster indexes - Change output from SHOW CREATE TABLE to use USING instead of TYPE mysql-test/r/ctype_utf8.result: Update test results mysql-test/r/show_check.result: Update test results mysql-test/r/sql_mode.result: Update test results mysql-test/t/show_check.test: Add test for BUG#11635 sql/sql_show.cc: Change TYPE to USING as output from SHOW CREATE TABLE --- mysql-test/t/show_check.test | 9 +++++++++ 1 file changed, 9 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 f80e720275a..76691ad79b1 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -368,3 +368,12 @@ show index from t1; --disable_metadata drop table t1; +# Test for BUG#11635: mysqldump exports TYPE instead of USING for HASH +create table t1 ( + c1 int NOT NULL, + c2 int NOT NULL, + PRIMARY KEY USING HASH (c1), + INDEX USING BTREE(c2) +); +SHOW CREATE TABLE t1; +DROP TABLE t1; -- cgit v1.2.1