Bug #33599 INFORMATION_SCHEMA.STATISTICS got a new column INDEX_COMMENT: tests fail (2)
Submitted: 31 Dec 2007 16:04 Modified: 28 Mar 2008 19:21
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:6.0.4-alpha OS:Any
Assigned to: Matthias Leich CPU Architecture:Any
Triage: D3 (Medium) / R3 (Medium) / E1 (None/Negligible)

[31 Dec 2007 16:04] Joerg Bruehe
Description:
Same problem as bug#32234,
but in a test which got skipped during the build of 6.0.3:

funcs_1.datadict_help_tables_build [ fail ]

--- /PATH/mysql-test/suite/funcs_1/r/datadict_help_tables_build.result
+++ /PATH/mysql-test/suite/funcs_1/r/datadict_help_tables_build.reject
@@ -11,12 +11,12 @@
 NULL   mysql   help_topic      BASE TABLE      MyISAM  10      Dynamic 380     #ARL#   #DL#    #MDL#   #IL#    #DF#    NUL
L       YYYY-MM-DD hh:mm:ss     YYYY-MM-DD hh:mm:ss     YYYY-MM-DD hh:mm:ss     utf8_general_ci NULL            help topics
 SELECT * FROM INFORMATION_SCHEMA.STATISTICS
 WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME LIKE 'help_%';
-TABLE_CATALOG  TABLE_SCHEMA    TABLE_NAME      NON_UNIQUE      INDEX_SCHEMA    INDEX_NAME      SEQ_IN_INDEX    COLUMN_NAME
        COLLATION       CARDINALITY     SUB_PART        PACKED  NULLABLE        INDEX_TYPE      COMMENT
-NULL   mysql   help_category   0       mysql   PRIMARY 1       help_category_id        A       30      NULL    NULL      BTREE
-...
+TABLE_CATALOG  TABLE_SCHEMA    TABLE_NAME      NON_UNIQUE      INDEX_SCHEMA    INDEX_NAME      SEQ_IN_INDEX    COLUMN_NAME
        COLLATION       CARDINALITY     SUB_PART        PACKED  NULLABLE        INDEX_TYPE      COMMENT INDEX_COMMENT
+NULL   mysql   help_category   0       mysql   PRIMARY 1       help_category_id        A       30      NULL    NULL      BTREE
+...

mysqltest: Result content mismatch

How to repeat:
Run the full test suite.
[11 Mar 2008 13:14] Matthias Leich
WL#4203 Reorganize and fix the data dictionary tests of
        testsuite funcs_1
was pushed to mysql-<version>-build
Version is in (5.0,5.1,6.0).

1. The tests "datadict_help_tables_<build type>"
   do no more exist.
2. The checks where the problem above occured were
   moved into the new tests "is_statistics_..." and
   "is_columns_is".
3. I generated new files with expected results for these
   tests in MySQL 5.0, 5.1 and 6.0.
[27 Mar 2008 22:03] Bugs System
Pushed into 5.1.24-rc
[27 Mar 2008 22:11] Bugs System
Pushed into 5.0.60
[28 Mar 2008 11:10] Bugs System
Pushed into 6.0.5-alpha
[28 Mar 2008 19:21] Paul Dubois
Fix involves test case changes. No changelog entry needed.