Changeset: ad3ccae0aa9f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ad3ccae0aa9f
Modified Files:
sql/test/pg_regress/Tests/box.test
Branch: default
Log Message:
use correct output
diffs (153 lines):
diff --git a/sql/test/pg_regress/Tests/box.test
b/sql/test/pg_regress/Tests/box.test
--- a/sql/test/pg_regress/Tests/box.test
+++ b/sql/test/pg_regress/Tests/box.test
@@ -42,47 +42,134 @@ INSERT INTO BOX_TBL (f1) VALUES (MBR('as
statement error
INSERT INTO BOX_TBL (f1) VALUES (MBR('linestring(asdfasdf(ad)'))
-statement error
+query TT rowsort
SELECT '' AS four, BOX_TBL.* FROM BOX_TBL
+----
+(empty)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+(empty)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+(empty)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+(empty)
+BOX (3.000000 3.000000, 3.000000 3.000000)
-statement error
+query TTT rowsort
SELECT '' AS four, b.f1, cast(f1 as varchar(44)) as txt FROM BOX_TBL b
+----
+(empty)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+(empty)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+(empty)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+(empty)
+BOX (3.000000 3.000000, 3.000000 3.000000)
+BOX (3.000000 3.000000, 3.000000 3.000000)
statement ok
CREATE VIEW BOX_TBL_VW AS SELECT f1, cast(f1 as varchar(44)) as txt FROM
BOX_TBL
-statement error
+query TT rowsort
SELECT * FROM BOX_TBL_VW
-
-statement error
-SELECT '' AS three, b.f1 FROM BOX_TBL_VW b WHERE b.f1 && mbr('linestring(2.5
2.5, 1.0 1.0)')
+----
+BOX (0.000000 0.000000, 2.000000 2.000000)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+BOX (3.000000 3.000000, 3.000000 3.000000)
+BOX (3.000000 3.000000, 3.000000 3.000000)
-statement error
-SELECT '' AS three, b.f1 FROM BOX_TBL_VW b WHERE ST_Overlaps(b.f1,
mbr('linestring(2.5 2.5, 1.0 1.0)'))
+query TT rowsort
+SELECT '' AS three, b.f1 FROM BOX_TBL_VW b WHERE b.f1 && mbr('linestring(2.5
2.5, 1.0 1.0)')
+----
+(empty)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+(empty)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+(empty)
+BOX (2.500000 2.500000, 2.500000 3.500000)
-statement error
+query TT rowsort
+SELECT '' AS three, b.f1 FROM BOX_TBL_VW b WHERE ST_Overlaps(b.f1,
mbr('linestring(2.5 2.5, 1.0 1.0)'))
+----
+(empty)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+(empty)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+(empty)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+
+query TTT rowsort
SELECT '' AS two, b1.* FROM BOX_TBL_VW b1 WHERE b1.f1 &< mbr('linestring(2.0
2.0, 2.5 2.5)')
+----
+(empty)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+(empty)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+BOX (2.500000 2.500000, 2.500000 3.500000)
-statement error
+query TTT rowsort
SELECT '' AS two, b1.* FROM BOX_TBL_VW b1 WHERE b1.f1 &> mbr('linestring(2.0
2.0, 2.5 2.5)')
+----
+(empty)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+BOX (2.500000 2.500000, 2.500000 3.500000)
+(empty)
+BOX (3.000000 3.000000, 3.000000 3.000000)
+BOX (3.000000 3.000000, 3.000000 3.000000)
-statement error
+query TT rowsort
SELECT '' AS two, b.f1 FROM BOX_TBL_VW b WHERE b.f1 << mbr('linestring(3.0
3.0, 5.0 5.0)')
+----
+(empty)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+(empty)
+BOX (2.500000 2.500000, 2.500000 3.500000)
-statement error
+query TT rowsort
SELECT '' AS three, b.f1 FROM BOX_TBL_VW b WHERE b.f1 @ mbr('linestring(0 0, 3
3)')
+----
+(empty)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+(empty)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+(empty)
+BOX (3.000000 3.000000, 3.000000 3.000000)
-statement error
+query TT rowsort
SELECT '' AS three, b.f1 FROM BOX_TBL_VW b WHERE mbr('linestring(0 0, 3 3)') ~
b.f1
+----
+(empty)
+BOX (0.000000 0.000000, 2.000000 2.000000)
+(empty)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+(empty)
+BOX (3.000000 3.000000, 3.000000 3.000000)
-statement error
+query TT rowsort
SELECT '' AS one, b.f1 FROM BOX_TBL_VW b WHERE mbr('linestring(1 1, 3 3)') ~=
b.f1
+----
+(empty)
+BOX (1.000000 1.000000, 3.000000 3.000000)
statement error
SELECT '' AS four, @@(b1.f1) AS p FROM BOX_TBL_VW b1
-statement error
+query TTTTT rowsort
SELECT '' AS one, b1.*, b2.* FROM BOX_TBL_VW b1, BOX_TBL_VW b2 WHERE b1.f1 ~
b2.f1 and not b1.f1 ~= b2.f1
+----
+(empty)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+BOX (1.000000 1.000000, 3.000000 3.000000)
+BOX (3.000000 3.000000, 3.000000 3.000000)
+BOX (3.000000 3.000000, 3.000000 3.000000)
statement error
SELECT '' AS four, height(f1), width(f1) FROM BOX_TBL_VW
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
