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.
© 2024, Oracle Corporation and/or its affiliates
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.