MonetDB: default - more specific order by solves instable output

[Niels Nes]

Changeset: b98f3a8d9658 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b98f3a8d9658
Modified Files:
        sql/test/sql_xml/Tests/xml.sql
Branch: default
Log Message:

more specific order by solves instable output


diffs (20 lines):

diff --git a/sql/test/sql_xml/Tests/xml.sql b/sql/test/sql_xml/Tests/xml.sql
--- a/sql/test/sql_xml/Tests/xml.sql
+++ b/sql/test/sql_xml/Tests/xml.sql
@@ -20,14 +20,14 @@ select xmlelement(name "CustomerProj",
        xmlforest(c.CustId, c.Name AS CustName, p.ProjId, p.Name AS ProjName))
 from Customers c, Projects p
 where c.CustId = p.CustId
-order by c.CustId;
+order by c.CustId, p.ProjId;
 
 select xmlelement(name project, 
        xmlattributes(p.ProjId as "id"),
        xmlforest(c.CustId, c.Name AS CustName, p.ProjId, p.Name AS ProjName))
 from Customers c, Projects p
 where c.CustId = p.CustId
-order by c.CustId;
+order by c.CustId, p.ProjId;
 
 
 select 
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list