diff options
| author | unknown <sergefp@mysql.com> | 2005-04-16 23:35:39 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-04-16 23:35:39 +0400 |
| commit | 9e5325ab5ccbee693e2837865786c65888b75658 (patch) | |
| tree | 9e457f16f8e9bf7d9240be2a5ad78046d134ab09 /mysql-test/t/show_check.test | |
| parent | 4528fd15278cfefc98cf106ee299cf41ccc3d01e (diff) | |
| download | mariadb-git-9e5325ab5ccbee693e2837865786c65888b75658.tar.gz | |
Fix for BUG#9439:
Changed type of "Sub_part" column in SHOW KEYS from TINYINT to SMALLINT (as MAX_KEY_LENGTH=1024)
(this is the final cset with proper tests)
mysql-test/r/show_check.result:
Testcase for BUG#9439
mysql-test/t/show_check.test:
Testcase for BUG#9439
sql/sql_show.cc:
Fix for BUG#9439:
Changed type of "Sub_part" column in SHOW KEYS from TINYINT to SMALLINT (as MAX_KEY_LENGTH=1024)
Diffstat (limited to 'mysql-test/t/show_check.test')
| -rw-r--r-- | mysql-test/t/show_check.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index 0cf1476b24c..f80e720275a 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -357,3 +357,14 @@ SHOW CREATE TABLE t1; ALTER TABLE t1 ENGINE=MEMORY; SHOW CREATE TABLE t1; DROP TABLE t1; + +# Test for BUG#9439 "Reporting wrong datatype for sub_part on show index" +CREATE TABLE t1( + field1 text NOT NULL, + PRIMARY KEY(field1(1000)) +); +--enable_metadata +show index from t1; +--disable_metadata +drop table t1; + |