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
• Status: Closed
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 6.0.4-alpha
• OS: Any
• Assigned to: Matthias Leich
• CPU Architecture: Any

[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.