Changeset: 03e5bedac9ee for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=03e5bedac9ee
Modified Files:
sql/test/pg_regress/Tests/box.stable.err
sql/test/pg_regress/Tests/box.stable.out
Branch: default
Log Message:
Approved the box test
diffs (57 lines):
diff --git a/sql/test/pg_regress/Tests/box.stable.err
b/sql/test/pg_regress/Tests/box.stable.err
--- a/sql/test/pg_regress/Tests/box.stable.err
+++ b/sql/test/pg_regress/Tests/box.stable.err
@@ -29,22 +29,22 @@ stderr of test 'box` in directory 'sql/t
# 19:04:23 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-6949" "--port=31707"
# 19:04:23 >
-MAPI = (monetdb) /var/tmp/mtest-8669/.s.monetdb.39481
+MAPI = (monetdb) /var/tmp/mtest-10494/.s.monetdb.39553
QUERY = INSERT INTO BOX_TBL (f1) VALUES (MBR('(2.3, 4.5)'));
ERROR = !ParseException: Unknown type: '('
-MAPI = (monetdb) /var/tmp/mtest-8669/.s.monetdb.39481
+MAPI = (monetdb) /var/tmp/mtest-10494/.s.monetdb.39553
QUERY = INSERT INTO BOX_TBL (f1) VALUES (MBR('linestring(2.3, 4.5)'));
ERROR = !ParseException: Expected number but encountered ','
-MAPI = (monetdb) /var/tmp/mtest-8669/.s.monetdb.39481
+MAPI = (monetdb) /var/tmp/mtest-10494/.s.monetdb.39553
QUERY = INSERT INTO BOX_TBL (f1) VALUES (MBR('asdfasdf(ad'));
ERROR = !ParseException: Unknown type: 'ASDFASDF'
-MAPI = (monetdb) /var/tmp/mtest-8669/.s.monetdb.39481
+MAPI = (monetdb) /var/tmp/mtest-10494/.s.monetdb.39553
QUERY = INSERT INTO BOX_TBL (f1) VALUES (MBR('linestring(asdfasdf(ad)'));
ERROR = !ParseException: Expected number but encountered word: 'asdfasdf'
-MAPI = (monetdb) /var/tmp/mtest-8669/.s.monetdb.39481
+MAPI = (monetdb) /var/tmp/mtest-10494/.s.monetdb.39553
QUERY = SELECT '' AS four, @@(b1.f1) AS p FROM BOX_TBL_VW b1;
ERROR = !syntax error, unexpected AT in: "select '' as four, @@"
-MAPI = (monetdb) /var/tmp/mtest-8669/.s.monetdb.39481
+MAPI = (monetdb) /var/tmp/mtest-10494/.s.monetdb.39553
QUERY = SELECT '' AS four, height(f1), width(f1) FROM BOX_TBL_VW;
ERROR = !SELECT: no such unary operator 'height(mbr)'
diff --git a/sql/test/pg_regress/Tests/box.stable.out
b/sql/test/pg_regress/Tests/box.stable.out
--- a/sql/test/pg_regress/Tests/box.stable.out
+++ b/sql/test/pg_regress/Tests/box.stable.out
@@ -93,8 +93,8 @@ Ready.
% 0, 44 # length
[ "BOX (0 0, 2 2)", "\"BOX (0.000000 0.000000, 2.000000 2.000000)\""
]
[ "BOX (1 1, 3 3)", "\"BOX (1.000000 1.000000, 3.000000 3.000000)\""
]
-[ "BOX (2.5 2.5, 2.5 3.5)", "\"\"" ]
-[ "BOX (3 3, 3 3)", "\"BOX (1.000000 1.000000, 3.000000 3.000000)\""
]
+[ "BOX (2.5 2.5, 2.5 3.5)", "\"BOX (2.500000 2.500000, 2.500000
3.500000)\"" ]
+[ "BOX (3 3, 3 3)", "\"BOX (3.000000 3.000000, 3.000000 3.000000)\""
]
#SELECT '' AS three, b.f1 FROM BOX_TBL_VW b WHERE b.f1 && mbr('linestring(2.5
2.5, 1.0 1.0)');
% .L1, sys.b # table_name
% three, f1 # name
@@ -116,8 +116,8 @@ Ready.
% two, f1, txt # name
% char, mbr, varchar # type
% 0, 0, 44 # length
-[ "", "BOX (0 0, 2 2)", "\"BOX (2.500000 0.000000, 2.000000
2.000000)\"" ]
-[ "", "BOX (2.5 2.5, 2.5 3.5)", "\"BOX (2.500000 0.000000, 2.000000
2.000000)\"" ]
+[ "", "BOX (0 0, 2 2)", "\"BOX (0.000000 0.000000, 2.000000
2.000000)\"" ]
+[ "", "BOX (2.5 2.5, 2.5 3.5)", "\"BOX (2.500000 2.500000, 2.500000
3.500000)\"" ]
#SELECT '' AS two, b1.* FROM BOX_TBL_VW b1 WHERE b1.f1 &> mbr('linestring(2.0
2.0, 2.5 2.5)');
% .L1, sys.b1, sys.b1 # table_name
% two, f1, txt # name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
