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

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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.