Changeset: d6b443345c5e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d6b443345c5e Modified Files: sql/backends/monet5/LSST/Tests/lsst_htmxmatch.sql sql/backends/monet5/LSST/Tests/lsst_htmxmatch.stable.out Branch: default Log Message:
lsst_htmxmatch: add order by to create deterministic result (-order) diffs (64 lines): diff --git a/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.sql b/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.sql --- a/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.sql +++ b/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.sql @@ -5,9 +5,9 @@ insert into htm values (120), (121), (12 insert into htm values (130), (131), (132), (133); -- select identical pairs -select * from htm a, htm b where [a.id] xmatch [b.id,0]; +select * from htm a, htm b where [a.id] xmatch [b.id,0] order by a.id, b.id; -- select pairs at distance one -select * from htm a, htm b where [a.id] xmatch [b.id,1]; +select * from htm a, htm b where [a.id] xmatch [b.id,1] order by a.id, b.id; drop table htm; diff --git a/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.stable.out b/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.stable.out --- a/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.stable.out +++ b/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.stable.out @@ -62,18 +62,18 @@ Ready. % 3, 3 # length [ 100, 100 ] [ 100, 101 ] +[ 100, 102 ] +[ 100, 103 ] [ 101, 100 ] [ 101, 101 ] -[ 100, 102 ] -[ 100, 103 ] [ 101, 102 ] [ 101, 103 ] [ 102, 100 ] [ 102, 101 ] +[ 102, 102 ] +[ 102, 103 ] [ 103, 100 ] [ 103, 101 ] -[ 102, 102 ] -[ 102, 103 ] [ 103, 102 ] [ 103, 103 ] [ 110, 110 ] @@ -86,18 +86,18 @@ Ready. [ 113, 113 ] [ 120, 120 ] [ 120, 121 ] +[ 120, 122 ] +[ 120, 123 ] [ 121, 120 ] [ 121, 121 ] -[ 120, 122 ] -[ 120, 123 ] [ 121, 122 ] [ 121, 123 ] [ 122, 120 ] [ 122, 121 ] +[ 122, 122 ] +[ 122, 123 ] [ 123, 120 ] [ 123, 121 ] -[ 122, 122 ] -[ 122, 123 ] [ 123, 122 ] [ 123, 123 ] [ 130, 130 ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
