Bug #32244 Result files not updated with ".inc" file used - tests fail (2)
Submitted: 9 Nov 2007 19:10 Modified: 28 Feb 2008 17:24
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

[9 Nov 2007 19:10] Joerg Bruehe
Description:
Found while running "make test-bt" in current 6.0 (main + build) tree.

The below changeset is incomplete:

ChangeSet@1.2639.5.1, 2007-11-05 15:34:36+01:00, hhunger@hh-nb.hhunger +50 -0
  new wrapper for falcon and some modifications in include file, also due to falcon bugs.
...
  mysql-test/suite/funcs_1/views/views_master.inc@1.10.1.1, 2007-11-05 15:34:29+01:00, hhunger@hh-nb.hhunger +292 -295
    modifications due to falcon bug.

It contains changes to the Falcon tests and results,
but not to those for other storage engines which also use "views_master.inc":
funcs_1.innodb_views
funcs_1.memory_views
funcs_1.myisam_views
funcs_1.ndb_views

The diffs start like this, but are too huge to fully include here:
--- /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/innodb_views.result  2007-11-09 00:34:35.000000000 +0300
+++ /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/innodb_views.reject  2007-11-09 09:02:50.000000000 +0300
@@ -169,58 +169,6 @@
 INSERT INTO tb2 (f59,f60) VALUES( 299,899 );
 INSERT INTO tb2 (f59,f60) VALUES( 242,79  );
 INSERT INTO tb2 (f59,f60) VALUES( 424,89  );
-SELECT * FROM tb2 ORDER BY f59, f60, f61;
-f59    f60     f61     f62     f63     f64     f65     f66     f67     f68     f69     f70     f71     f72     f73     f74     f75     f76     f77     f78     f79     f80     f81     f82     f83     f84     f85     f86     f87     f88     f89     f90     f91     f92     f93     f94     f95     f96     f97     f98     f99     f100    f101    f102    f103    f104    f105    f106    f107    f108    f109
-1      1       0000000001      0000000000000000000000000000000000000000000000000000000000000001        0000000001      0000000000000000000000000000000000000000000000000000000000000001        -5      0.000000000000000000000000000000        1       0.000000000000000000000000000000        0000000001      000000000000000000000000000000000.000000000000000000000000000000        0000000001      000000000000000000000000000000000.000000000000000000000000000000        -1.17549435e-38 1.175494352e
...

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

Suggested fix:
Push the changes for all storage engines.