Bug #15631 Test cases 'system_mysql_db' and 'system_mysql_db_fix' failures
Submitted: 9 Dec 2005 11:28 Modified: 9 Dec 2005 12:51
Reporter: Kristian Nielsen Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:clone-5.0.17-release OS:IBM AIX (AIX, Solaris, HPUX)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[9 Dec 2005 11:28] Kristian Nielsen 
Description:
The test cases 'system_mysql_db' and 'system_mysql_db_fix' fail repeatably on AIX, Solaris, and HPUX:

11383: system_mysql_db                [ fail ]
11384: 
11385: Errors are (from /home/mysqldev/aix52-64bit/test/mysql-max-5.0.17-aix5.2-powerpc-64bit/mysql-test/var/log/mysqltest-time) :
11386: mysqltest: Result length mismatch
11387: (the last lines may be the most important ones)
11388: Below are the diffs between actual and expected results:
11389: -------------------------------------------------------
11390: *** r/system_mysql_db.result	Thu Dec  8 08:59:42 2005
11391: --- r/system_mysql_db.reject	Thu Dec  8 10:32:41 2005
11392: ***************
11393: *** 182,184 ****
11394: --- 182,185 ----
11395:   ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'
11396:   show tables;
11397:   Tables_in_test
11398: + fib

11412: system_mysql_db_fix            [ fail ]
11413: 
11414: Errors are (from /home/mysqldev/aix52-64bit/test/mysql-max-5.0.17-aix5.2-powerpc-64bit/mysql-test/var/log/mysqltest-time) :
11415: ERROR 1054 (42S22) at line 26: Unknown column 'Grant_priv' in 'where clause'
11416: ERROR 1146 (42S02) at line 67: Table 'test.procs_priv' doesn't exist
11417: ERROR 1146 (42S02) at line 68: Table 'test.procs_priv' doesn't exist
11418: ERROR 1146 (42S02) at line 70: Table 'test.procs_priv' doesn't exist
11419: ERROR 1146 (42S02) at line 72: Table 'test.procs_priv' doesn't exist
11420: ERROR 1054 (42S22) at line 94: Unknown column 'Type' in 'columns_priv'
11421: ERROR 1060 (42S21) at line 100: Duplicate column name 'type'
11422: ERROR 1054 (42S22) at line 108: Unknown column 'Show_db_priv' in 'where clause'
11423: ERROR 1054 (42S22) at line 247: Unknown column 'Create_view_priv' in 'where clause'
11424: ERROR 1054 (42S22) at line 277: Unknown column 'Create_routine_priv' in 'where clause'
11425: ERROR 1054 (42S22) at line 313: Unknown column 'Create_user_priv' in 'where clause'
11426: mysqltest: Result length mismatch
11427: (the last lines may be the most important ones)

How to repeat:
Run the test cases on the affected platforms.
[9 Dec 2005 11:34] Kristian Nielsen 
The same platforms fail in the 'view' test, it is probably related:

12188: view                           [ fail ]
12189: 
12190: Errors are (from /home/mysqldev/aix52-64bit/test/mysql-max-5.0.17-aix5.2-powerpc-64bit/mysql-test/var/log/mysqltest-time) :
12191: mysqltest: At line 268447576: Result length mismatch
12192: (the last lines may be the most important ones)
12193: Below are the diffs between actual and expected results:
12194: -------------------------------------------------------
12195: *** r/view.result	Thu Dec  8 08:59:46 2005
12196: --- r/view.reject	Thu Dec  8 11:16:40 2005
12197: ***************
12198: *** 131,136 ****
12199: --- 131,137 ----
12200:   Note	1003	select `v6`.`c` AS `c` from `test`.`v6`
12201:   show tables;
12202:   Tables_in_test
12203: + fib
12204:   t1
12205:   v1
12206:   v2
12207: ***************
12208: *** 140,145 ****
12209: --- 141,147 ----
12210:   v6
12211:   show full tables;
12212:   Tables_in_test	Table_type
12213: + fib	BASE TABLE
12214:   t1	BASE TABLE
12215:   v1	VIEW
12216:   v2	VIEW
12217: ***************
12218: *** 149,154 ****
12219: --- 151,157 ----
12220:   v6	VIEW
12221:   show table status;
12222:   Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
12223: + fib	MyISAM	10	Fixed	14	9	126	#	1024	0	NULL	#	#	NULL	latin1_swedish_ci	NULL		
12224:   t1	MyISAM	10	Fixed	5	9	45	#	1024	0	NULL	#	#	NULL	latin1_swedish_ci	NULL		
12225:   v1	NULL	NULL	NULL	NULL	NULL	NULL	#	NULL	NULL	NULL	#	#	NULL	NULL	NULL	NULL	VIEW
12226:   v2	NULL	NULL	NULL	NULL	NULL	NULL	#	NULL	NULL	NULL	#	#	NULL	NULL	NULL	NULL	VIEW
12227: ***************
12228: *** 658,663 ****
12229: --- 661,667 ----
12230:   ERROR HY000: No tables used
12231:   SHOW TABLES;
12232:   Tables_in_test
12233: + fib
12234:   CREATE VIEW v1 AS SELECT EXISTS (SELECT 1 UNION SELECT 2);
12235:   select * from v1;
12236:   EXISTS (SELECT 1 UNION SELECT 2)
12237: ***************
12238: *** 827,832 ****
12239: --- 831,837 ----
12240:   ERROR HY000: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
12241:   show table status;
12242:   Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
12243: + fib	MyISAM	10	Fixed	14	9	126	#	1024	0	NULL	#	#	NULL	latin1_swedish_ci	NULL		
12244:   t1	MyISAM	10	Fixed	0	0	0	#	1024	0	NULL	#	#	NULL	latin1_swedish_ci	NULL		
12245:   v1	NULL	NULL	NULL	NULL	NULL	NULL	#	NULL	NULL	NULL	#	#	NULL	NULL	NULL	NULL	View 'test.v1' references invalid table(s) or column(s) or function(s) or define
12246:   drop view v1;
[9 Dec 2005 12:51] Ramil Kalimullin 
The failures caused by the previous test crash (sp).