Description:
The show_check test fails on a 5.0 tree based on ChangeSet@1.1850.
It doesn't matter if InnoDB is included in the compilation.
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/show_check.result 2005-04-18 13:16:26.000000000 +0300
--- r/show_check.reject 2005-04-21 08:55:14.000000000 +0300
***************
*** 482,499 ****
);
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;
--- 482,499 ----
);
show index from t1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
! def STATISTICS TABLE_NAME Table 253 64 2 N 1 0 63
! def STATISTICS NON_UNIQUE Non_unique 8 1 1 N 32769 0 63
! def STATISTICS INDEX_NAME Key_name 253 64 7 N 1 0 63
! def STATISTICS SEQ_IN_INDEX Seq_in_index 8 2 1 N 32769 0 63
! def STATISTICS COLUMN_NAME Column_name 253 64 6 N 1 0 63
! def STATISTICS COLLATION Collation 253 1 1 Y 0 0 63
! def STATISTICS CARDINALITY Cardinality 8 21 1 Y 32768 0 63
! def STATISTICS SUB_PART Sub_part 8 3 4 Y 32768 0 63
! def STATISTICS PACKED Packed 253 10 0 Y 0 0 63
! def STATISTICS NULLABLE Null 253 3 0 N 1 0 63
! def STATISTICS INDEX_TYPE Index_type 253 16 5 N 1 0 63
! def STATISTICS COMMENT Comment 253 16 0 Y 0 0 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;
-------------------------------------------------------
How to repeat:
BUILD/compile-pentium --without-innodb
or
BUILD/compile-pentium
cd mysql-test-run
./mysql-test-run --do-test=show_check
