Bug #39126 New system columns not added to test result files
Submitted: 29 Aug 2008 16:46
Reporter: Joerg Bruehe Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-5.1-telco-6.3 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: mysql-5.1-telco- 6.3.17

[29 Aug 2008 16:46] Joerg Bruehe 
Description:
Found while testing the build of Cluster 6.3.17:

=====
funcs_1.is_statistics_mysql    [ fail ]

--- /PATH/mysql-test/suite/funcs_1/r/is_statistics_mysql.result
+++ /PATH/mysql-test/suite/funcs_1/r/is_statistics_mysql.reject
@@ -30,6 +30,8 @@
 NULL   mysql   host    0       mysql   PRIMARY 1       Host    A       #CARD#  NULL    NULL            BTREE
 NULL   mysql   host    0       mysql   PRIMARY 2       Db      A       #CARD#  NULL    NULL            BTREE
 NULL   mysql   ndb_binlog_index        0       mysql   PRIMARY 1       epoch   A       #CARD#  NULL    NULL BTREE
+NULL   mysql   ndb_binlog_index        0       mysql   PRIMARY 2       orig_server_id  A       #CARD#  NULL NULL             BTREE
+NULL   mysql   ndb_binlog_index        0       mysql   PRIMARY 3       orig_epoch      A       #CARD#  NULL NULL             BTREE
 NULL   mysql   plugin  0       mysql   PRIMARY 1       name    A       #CARD#  NULL    NULL            BTREE
 NULL   mysql   proc    0       mysql   PRIMARY 1       db      A       #CARD#  NULL    NULL            BTREE
 NULL   mysql   proc    0       mysql   PRIMARY 2       name    A       #CARD#  NULL    NULL            BTREE

mysqltest: Result content mismatch
=====

My understanding is that the server now has additional columns "orig_server_id" and "orig_epoch", but the test result files were not updated accordingly.

How to repeat:
Run the extra tests.

They are easily available by dong "make test-bt".

Suggested fix:
Run the extra tests when changing system tables and columns !
[29 Aug 2008 16:47] Joerg Bruehe 
Bug is considered severe because it shows the extra tests were never run in the development phase.
[29 Aug 2008 16:53] Joerg Bruehe 
A similar effect, server output changed without updating test result files, is showing in this build with test "is_columns_mysql".
[29 Aug 2008 17:01] Joerg Bruehe 
It is even more widespread:

Some unexpected information about "STORAGE FORMAT" is now reported in these tests:
is_columns
is_columns_innodb
is_columns_is
is_columns_memory
is_columns_myisam
is_columns_mysql
is_columns_ndb