Changeset: 851a40a478d5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=851a40a478d5
Modified Files:
sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.test
Branch: mtest
Log Message:
approved output
diffs (49 lines):
diff --git a/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.test
b/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.test
--- a/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.test
+++ b/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.test
@@ -44,24 +44,27 @@ query T nosort
PLAN select * from r
----
project (
-| crossproduct (
-| | table(sys.v) [ "v"."a1", "v"."a2" ] COUNT ,
-| | project (
-| | | crossproduct (
-| | | | project (
-| | | | | select (
-| | | | | | table(sys.input_double) [ "input_double"."a1", "input_double"."a2"
] COUNT
-| | | | | ) [ "input_double"."a1" = clob "latitude" ]
-| | | | ) [ "input_double"."a2" as "tmp_2"."a2" ],
-| | | | project (
-| | | | | select (
-| | | | | | table(sys.input_double) [ "input_double"."a1", "input_double"."a2"
] COUNT
-| | | | | ) [ "input_double"."a1" = clob "longitude" ]
-| | | | ) [ "input_double"."a2" as "tmp_3"."a2" ]
-| | | ) [ ]
-| | ) [ sys.st_point("tmp_2"."a2" as "tmp"."a1", "tmp_3"."a2" as "tmp"."a2")
as "p"."a1" ]
-| ) [ ]
-) [ "v"."a1" as "r"."a1", sys.st_distance("v"."a2" as "tmp"."a2", "p"."a1" as
"tmp"."a3") as "r"."prob" ]
+| project (
+| | crossproduct (
+| | | table(sys.v) [ "v"."a1", "v"."a2" ] COUNT ,
+| | | project (
+| | | | crossproduct (
+| | | | | project (
+| | | | | | select (
+| | | | | | | table(sys.input_double) [ "input_double"."a1",
"input_double"."a2" ] COUNT
+| | | | | | ) [ "input_double"."a1" = clob "latitude" ]
+| | | | | ) [ "input_double"."a2" as "tmp_2"."a2" ],
+| | | | | project (
+| | | | | | select (
+| | | | | | | table(sys.input_double) [ "input_double"."a1",
"input_double"."a2" ] COUNT
+| | | | | | ) [ "input_double"."a1" = clob "longitude" ]
+| | | | | ) [ "input_double"."a2" as "tmp_3"."a2" ]
+| | | | ) [ ]
+| | | ) [ sys.st_point("tmp_2"."a2" as "tmp"."a1", "tmp_3"."a2" as "tmp"."a2")
as "p"."a1" ]
+| | ) [ ]
+| ) [ "v"."a1" as "r"."a1", sys.st_distance("v"."a2" as "tmp"."a2", "p"."a1"
as "tmp"."a3") as "r"."prob" ]
+) [ "r"."a1", "r"."prob" ]
+
statement ok
rollback
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
