Bug #32234 INFORMATION_SCHEMA.STATISTICS got a new column INDEX_COMMENT: tests fail
Submitted: 9 Nov 2007 14:26 Modified: 18 Dec 2007 4:45
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Sergei Glukhov CPU Architecture:Any

[9 Nov 2007 14:26] Joerg Bruehe 
Description:
Found in local tests of current 6.0:

--- /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/datadict_help_tables_dev.result      2007-08-28 19:35:22.000000000 +0300
+++ /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/datadict_help_tables_dev.reject      2007-11-09 09:00:17.000000000 +0300
@@ -7,12 +7,12 @@
 NULL   mysql   help_topic      BASE TABLE      MyISAM  10      Dynamic 0       #ARL#   #DL#    #MDL#   #IL#    #DF#    NULL    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       0       NULL    NULL            BTREE
-NULL   mysql   help_category   0       mysql   name    1       name    A       0       NULL    NULL            BTREE
-NULL   mysql   help_keyword    0       mysql   PRIMARY 1       help_keyword_id A       0       NULL    NULL            BTREE
-NULL   mysql   help_keyword    0       mysql   name    1       name    A       0       NULL    NULL            BTREE
-NULL   mysql   help_relation   0       mysql   PRIMARY 1       help_keyword_id A       NULL    NULL    NULL            BTREE
-NULL   mysql   help_relation   0       mysql   PRIMARY 2       help_topic_id   A       0       NULL    NULL            BTREE
-NULL   mysql   help_topic      0       mysql   PRIMARY 1       help_topic_id   A       0       NULL    NULL            BTREE
-NULL   mysql   help_topic      0       mysql   name    1       name    A       0       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       0       NULL    NULL            BTREE
+NULL   mysql   help_category   0       mysql   name    1       name    A       0       NULL    NULL            BTREE      
+NULL   mysql   help_keyword    0       mysql   PRIMARY 1       help_keyword_id A       0       NULL    NULL            BTREE
+NULL   mysql   help_keyword    0       mysql   name    1       name    A       0       NULL    NULL            BTREE      
+NULL   mysql   help_relation   0       mysql   PRIMARY 1       help_keyword_id A       NULL    NULL    NULL            BTREE
+NULL   mysql   help_relation   0       mysql   PRIMARY 2       help_topic_id   A       0       NULL    NULL            BTREE
+NULL   mysql   help_topic      0       mysql   PRIMARY 1       help_topic_id   A       0       NULL    NULL            BTREE
+NULL   mysql   help_topic      0       mysql   name    1       name    A       0       NULL    NULL            BTREE      

How to repeat:
Run the full tests, including "funcs_1".

Proposal: Use "make test-bt".
[14 Nov 2007 14:59] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/37752

ChangeSet@1.2685, 2007-11-14 18:54:41+04:00, gluh@mysql.com +1 -0
  Bug#32234 INFORMATION_SCHEMA.STATISTICS got a new column INDEX_COMMENT: tests fail
  updated result file because of new field I_S.STATISTICS.INDEX_COMMENT
[16 Nov 2007 10:03] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/37931

ChangeSet@1.2673, 2007-11-16 13:57:13+04:00, gluh@mysql.com +1 -0
  Bug#32234 INFORMATION_SCHEMA.STATISTICS got a new column INDEX_COMMENT: tests fail
  updated reasult file
[14 Dec 2007 8:20] Bugs System 
Pushed into 6.0.5-alpha
[18 Dec 2007 4:45] Paul DuBois 
Test case change. No changelog entry needed.