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
• Status: Closed
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 6.0.4-alpha
• OS: Any
• Assigned to: Horst Hunger
• CPU Architecture: Any

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