diff options
| author | unknown <jimw@mysql.com> | 2005-01-13 09:31:54 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-01-13 09:31:54 -0800 |
| commit | 74a964957d0c6defb4795b3387720e27d4ddbb14 (patch) | |
| tree | 4a8a48780059da2512c656c1ced19255c7ece1c4 /mysql-test/t/show_check.test | |
| parent | efa0483ea7f96979a7d8bfd04e2a3d5a68eaf25e (diff) | |
| parent | a28f221f35622b799e34a6e05c66555a6ffe9b81 (diff) | |
| download | mariadb-git-74a964957d0c6defb4795b3387720e27d4ddbb14.tar.gz | |
Merge
mysql-test/r/ctype_utf8.result:
Auto merged
mysql-test/r/show_check.result:
Auto merged
mysql-test/t/show_check.test:
Auto merged
sql/sql_show.cc:
Merge with s/TYPE/USING/ fixes
Diffstat (limited to 'mysql-test/t/show_check.test')
| -rw-r--r-- | mysql-test/t/show_check.test | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index 6aafbed6b97..81e0d9f32ef 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -329,3 +329,35 @@ flush privileges; #--replace_column 7 # 8 # 9 # #show table status from `�` LIKE '�'; #drop database `�`; + +# Test that USING <keytype> is always shown in SHOW CREATE TABLE when it was +# specified during table creation, but not otherwise. (Bug #7235) +CREATE TABLE t1 (i int, KEY (i)) ENGINE=MEMORY; +SHOW CREATE TABLE t1; +DROP TABLE t1; +CREATE TABLE t1 (i int, KEY USING HASH (i)) ENGINE=MEMORY; +SHOW CREATE TABLE t1; +DROP TABLE t1; +CREATE TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MEMORY; +SHOW CREATE TABLE t1; +DROP TABLE t1; +CREATE TABLE t1 (i int, KEY (i)) ENGINE=MyISAM; +SHOW CREATE TABLE t1; +DROP TABLE t1; +CREATE TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MyISAM; +SHOW CREATE TABLE t1; +DROP TABLE t1; +# Test that when an index is created with the default key algorithm and +# altered to another storage engine, it gets the default key algorithm +# for that storage engine, but when it is specified, the specified type is +# preserved. +CREATE TABLE t1 (i int, KEY (i)) ENGINE=MyISAM; +SHOW CREATE TABLE t1; +ALTER TABLE t1 ENGINE=MEMORY; +SHOW CREATE TABLE t1; +DROP TABLE t1; +CREATE TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MyISAM; +SHOW CREATE TABLE t1; +ALTER TABLE t1 ENGINE=MEMORY; +SHOW CREATE TABLE t1; +DROP TABLE t1; |