Bug #32242 Result files not updated with ".inc" file used - tests fail
Submitted: 9 Nov 2007 18:28 Modified: 28 Feb 2008 17:23
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: Horst Hunger CPU Architecture:Any
Triage: D3 (Medium)

[9 Nov 2007 18:28] Joerg Bruehe
Description:
Detected in the current 6.0 tree, while running "make test-bt".
See this change in  mysql-test/suite/funcs_1/triggers/triggers_09.inc :

-hhunger 1.1   | 	select  @tr_var_af_118, @tr_var_af_121, @tr_var_af_122, 
-hhunger 1.1   | 		@tr_var_af_136, @tr_var_af_163;
+hhunger 1.5   | #FIXME 31561
+hhunger 1.5   | #	select  @tr_var_af_118, @tr_var_af_121, @tr_var_af_122, 
+hhunger 1.5   | #		@tr_var_af_136, @tr_var_af_163;

This would need changes in all results files whose test uses that include file - but these are missing, like here:

--- /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/innodb_trig_09.result        2007-07-30 18:28:43.000000000 +0300
+++ /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/innodb_trig_09.reject        2007-11-09 09:02:33.000000000 +0300
@@ -142,10 +142,6 @@
 @tr_var_b4_136, @tr_var_b4_163;
 @tr_var_b4_118 @tr_var_b4_121  @tr_var_b4_122  @tr_var_b4_136  @tr_var_b4_163
 a      NULL    Test 3.5.9.3    8       123.170000000000000000000000000000
-select  @tr_var_af_118, @tr_var_af_121, @tr_var_af_122,
-@tr_var_af_136, @tr_var_af_163;
-@tr_var_af_118 @tr_var_af_121  @tr_var_af_122  @tr_var_af_136  @tr_var_af_163
-a      NULL    Test 3.5.9.3    8       123.170000000000000000000000000000
 drop trigger trg2_a;
 drop trigger trg2_b;
 drop trigger trg2_c;

That affects all "*_trig_09" tests:
funcs_1.innodb_trig_09
funcs_1.memory_trig_09
funcs_1.myisam_trig_09
funcs_1.ndb_trig_09

How to repeat:
Run "make test-bt".