Changeset: af3298029902 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=af3298029902
Added Files:
geom/BugTracker/Tests/copy_into_mbr.3492.SQL.py
Removed Files:
geom/BugTracker/Tests/copy_into_mbr.3492.test
Branch: mtest
Log Message:
fix geom/BugTracker/Tests/copy_into_mbr.3492
diffs (110 lines):
diff --git a/geom/BugTracker/Tests/copy_into_mbr.3492.SQL.py
b/geom/BugTracker/Tests/copy_into_mbr.3492.SQL.py
new file mode 100644
--- /dev/null
+++ b/geom/BugTracker/Tests/copy_into_mbr.3492.SQL.py
@@ -0,0 +1,9 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ # optional or default connection
+ tc.connect()
+ with open('copy_into_mbr.3492.sql') as f:
+ tc.execute(query=None, client='mclient', stdin=f)\
+ .assertSucceeded()\
+ .assertMatchStableOut(fout='copy_into_mbr.3492.stable.out')
diff --git a/geom/BugTracker/Tests/copy_into_mbr.3492.test
b/geom/BugTracker/Tests/copy_into_mbr.3492.test
deleted file mode 100644
--- a/geom/BugTracker/Tests/copy_into_mbr.3492.test
+++ /dev/null
@@ -1,91 +0,0 @@
-statement ok
-CREATE TABLE geom (id INTEGER, g GEOMETRY, b MBR)
-
-statement ok
-INSERT INTO geom values (5, NULL, NULL)
-
-statement ok
-INSERT INTO geom values (1, 'POLYGON((1 2, 3 2, 3 4, 1 4, 1 2))', NULL)
-
-statement ok
-INSERT INTO geom values (2, 'POLYGON((1 2, 3 2, 3 4, 1 4, 1 2))', 'MBR(1 2,3
4)')
-
-statement ok
-INSERT INTO geom values (3, 'POLYGON((1 2, 3 2, 3 4, 1 4, 1 2))', 'MBR (1 2,3
4)')
-
-statement ok
-INSERT INTO geom values (4, NULL, NULL)
-
-query ITT nosort
-SELECT * FROM geom ORDER BY id
-----
-1
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-NULL
-2
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-BOX (1.000000 2.000000, 3.000000 4.000000)
-3
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-BOX (1.000000 2.000000, 3.000000 4.000000)
-4
-NULL
-NULL
-5
-NULL
-NULL
-
-statement ok
-UPDATE geom SET b = MBR(g)
-
-query ITT nosort
-SELECT * FROM geom ORDER BY id
-----
-1
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-BOX (1.000000 2.000000, 3.000000 4.000000)
-2
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-BOX (1.000000 2.000000, 3.000000 4.000000)
-3
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-BOX (1.000000 2.000000, 3.000000 4.000000)
-4
-NULL
-NULL
-5
-NULL
-NULL
-
-statement ok
-CREATE TABLE newgeom (id INTEGER, g GEOMETRY, b MBR)
-
-statement ok
-INSERT INTO newgeom SELECT * FROM geom ORDER BY id
-
-query ITT nosort
-SELECT * FROM newgeom ORDER BY id
-----
-1
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-BOX (1.000000 2.000000, 3.000000 4.000000)
-2
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-BOX (1.000000 2.000000, 3.000000 4.000000)
-3
-POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))
-BOX (1.000000 2.000000, 3.000000 4.000000)
-4
-NULL
-NULL
-5
-NULL
-NULL
-
-statement ok
-DROP TABLE geom
-
-statement ok
-DROP TABLE newgeom
-
-
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
