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
