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 | |
| 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')
| -rw-r--r-- | mysql-test/r/show_check.result | 21 | ||||
| -rw-r--r-- | mysql-test/t/show_check.test | 11 |
2 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result index 0d580ae2505..4a9e28e9ea4 100644 --- a/mysql-test/r/show_check.result +++ b/mysql-test/r/show_check.result @@ -477,3 +477,24 @@ t1 CREATE TABLE `t1` ( KEY `i` TYPE BTREE (`i`) ) ENGINE=HEAP DEFAULT CHARSET=latin1 DROP TABLE t1; +CREATE TABLE t1( +field1 text NOT NULL, +PRIMARY KEY(field1(1000)) +); +show index from t1; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def Table 253 64 2 N 129 31 63 +def Non_unique 1 1 1 N 32929 0 63 +def Key_name 253 64 7 N 129 31 63 +def Seq_in_index 1 2 1 N 32929 0 63 +def Column_name 253 64 6 N 129 31 63 +def Collation 253 1 1 Y 128 31 63 +def Cardinality 8 21 1 Y 32896 0 63 +def Sub_part 2 3 4 Y 32928 0 63 +def Packed 253 10 0 Y 128 31 63 +def Null 253 3 0 N 129 31 63 +def Index_type 253 16 5 N 129 31 63 +def Comment 253 255 0 N 129 31 63 +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 field1 A 0 1000 NULL BTREE +drop table t1; 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; + |