It seems that this query has non-deterministic ordering:
SELECT * FROM bup_db1.v6 ORDER BY gender;
On line 161 and 244
When running the tests, I get this error:
@@ -160,10 +160,10 @@
5 43 PHD
SELECT * FROM bup_db1.v6 ORDER BY gender;
education gender
-MS F
-Doctor F
BS F
BE F
+MS F
+Doctor F
Undergrad M
Lawyer M
PHD M
@@ -387,14 +387,14 @@
5 43 PHD
SELECT * FROM bup_db1.v6 ORDER BY gender;
education gender
-Doctor F
BS F
BE F
MS F
+Doctor F
+Undergrad M
Lawyer M
PHD M
School M
-Undergrad M
You probably have to order on both education and gender.
Apart from that, the patch is good to push.
Hema Sridharan wrote:
> #At file:///data0/team6.0aug6/mysql-6.0-backup/
>
> 2676 Hema Sridharan 2008-08-06
> backup_views.test modified to avoid the overlapping of the
> backup_view_on_view.test
> removed:
> mysql-test/r/backup_view_on_view.result
> mysql-test/t/backup_view_on_view.test
> modified:
> mysql-test/r/backup_views.result
> mysql-test/t/backup_views.test
>
--
Jørgen Løland
