Changeset: 7eced1a4e333 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7eced1a4e333
Modified Files:
        sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.sql
        sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.stable.out
Branch: Jun2016
Log Message:

used new geometry functions


diffs (46 lines):

diff --git a/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.sql 
b/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.sql
--- a/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.sql
+++ b/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.sql
@@ -7,13 +7,13 @@ INSERT INTO input_double VALUES ('longit
 
 
 CREATE TABLE v(a1 int, a2 point, prob double);
-insert into v values(0,sys.point(50,4),1);
-insert into v values(1,sys.point(51,5),1);
-insert into v values(2,sys.point(52,6),1);
+insert into v values(0,'point(50 4)',1);
+insert into v values(1,'point(51 5)',1);
+insert into v values(2,'point(52 6)',1);
 
 
 CREATE VIEW p AS 
-SELECT sys.point(a1,a2) AS a1, prob AS prob 
+SELECT ST_Point(a1,a2) AS a1, prob AS prob 
 FROM (
          SELECT tmp_2.a2 AS a1, tmp_3.a2 AS a2, tmp_2.prob * tmp_3.prob AS 
prob 
          FROM 
@@ -22,7 +22,7 @@ FROM (
 ) AS tmp;
 
 CREATE VIEW r AS 
-SELECT a1 AS a1, sys.distance(a2,a3) AS prob 
+SELECT a1 AS a1, ST_Distance(a2,a3) AS prob 
 FROM (
          SELECT v.a1 AS a1, v.a2 AS a2, p.a1 AS a3, v.prob * p.prob AS prob 
          FROM v,p
diff --git a/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.stable.out 
b/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.stable.out
--- a/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.stable.out
+++ b/sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.stable.out
@@ -79,10 +79,10 @@ project (
 | | | | | | | ) [ input_double.a1 = clob "longitude" ]
 | | | | | | ) [ input_double.a2 as tmp_3.a2 ]
 | | | | | ) [  ]
-| | | | ) [ sys.point(tmp_2.a2 as tmp.a1, tmp_3.a2 as tmp.a2) as L.a1 ]
+| | | | ) [ sys.st_point(tmp_2.a2 as tmp.a1, tmp_3.a2 as tmp.a2) as L.a1 ]
 | | | ) [  ]
 | | ) [ v.a1, v.a2, L.a1 as p.a1 ]
-| ) [ v.a1 as L.a1, sys.distance(v.a2 as tmp.a2, p.a1 as tmp.a3) as L.prob ]
+| ) [ v.a1 as L.a1, sys.st_distance(v.a2 as tmp.a2, p.a1 as tmp.a3) as L.prob ]
 ) [ L.a1 as r.a1, L.prob as r.prob ]
 
 # 14:00:10 >  
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to