statement was expected to fail but didn't
query started on line 19 of file polygon.test
query text:
INSERT INTO POLYGON_TBL(f1) VALUES ('POLYGON((0.0 1.0, 1.0 1.0, 0.0 1.0))')

received 5 rows, expected 4 rows
query started on line 55 of file polygon.test
query text:
SELECT '' AS four, POLYGON_TBL.* FROM POLYGON_TBL

query result:
|POLYGON ((2 0, 2 4, 0 0, 2 0))
|POLYGON ((3 1, 3 3, 1 0, 3 1))
|POLYGON ((0 1, 1 1, 0 1))
|POLYGON ((0 1, 0 1, 0 1, 0 1))
|POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
unexpected value;
received "POLYGON ((0 1, 1 1, 0 1))"
expected "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
unexpected value;
received "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
expected "POLYGON ((2 0, 2 4, 0 0, 2 0))"
unexpected value;
received "POLYGON ((2 0, 2 4, 0 0, 2 0))"
expected "POLYGON ((3 1, 3 3, 1 0, 3 1))"
query started on line 55 of file polygon.test
query text:
SELECT '' AS four, POLYGON_TBL.* FROM POLYGON_TBL

query result:
(empty)|POLYGON ((0 1, 0 1, 0 1, 0 1))
(empty)|POLYGON ((0 1, 1 1, 0 1))
(empty)|POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
(empty)|POLYGON ((2 0, 2 4, 0 0, 2 0))
(empty)|POLYGON ((3 1, 3 3, 1 0, 3 1))
received 5 rows, expected 4 rows
query started on line 70 of file polygon.test
query text:
SELECT * FROM POLYGON_TBL_VW

query result:
POLYGON ((2 0, 2 4, 0 0, 2 0))|POLYGON ((2 0, 2 4, 0 0, 2 0))
POLYGON ((3 1, 3 3, 1 0, 3 1))|POLYGON ((3 1, 3 3, 1 0, 3 1))
POLYGON ((0 1, 1 1, 0 1))|POLYGON ((0 1, 1 1, 0 1))
POLYGON ((0 1, 0 1, 0 1, 0 1))|POLYGON ((0 1, 0 1, 0 1, 0 1))
POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))|POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
unexpected value;
received "POLYGON ((0 1, 1 1, 0 1))"
expected "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
unexpected value;
received "POLYGON ((0 1, 1 1, 0 1))"
expected "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
unexpected value;
received "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
expected "POLYGON ((2 0, 2 4, 0 0, 2 0))"
unexpected value;
received "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
expected "POLYGON ((2 0, 2 4, 0 0, 2 0))"
unexpected value;
received "POLYGON ((2 0, 2 4, 0 0, 2 0))"
expected "POLYGON ((3 1, 3 3, 1 0, 3 1))"
unexpected value;
received "POLYGON ((2 0, 2 4, 0 0, 2 0))"
expected "POLYGON ((3 1, 3 3, 1 0, 3 1))"
query started on line 70 of file polygon.test
query text:
SELECT * FROM POLYGON_TBL_VW

query result:
POLYGON ((0 1, 0 1, 0 1, 0 1))|POLYGON ((0 1, 0 1, 0 1, 0 1))
POLYGON ((0 1, 1 1, 0 1))|POLYGON ((0 1, 1 1, 0 1))
POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))|POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
POLYGON ((2 0, 2 4, 0 0, 2 0))|POLYGON ((2 0, 2 4, 0 0, 2 0))
POLYGON ((3 1, 3 3, 1 0, 3 1))|POLYGON ((3 1, 3 3, 1 0, 3 1))
received 3 rows, expected 2 rows
query started on line 82 of file polygon.test
query text:
SELECT '' AS three, p.*
   FROM POLYGON_TBL_VW p
   WHERE p.f1 && 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'

query result:
|POLYGON ((2 0, 2 4, 0 0, 2 0))|POLYGON ((2 0, 2 4, 0 0, 2 0))
|POLYGON ((3 1, 3 3, 1 0, 3 1))|POLYGON ((3 1, 3 3, 1 0, 3 1))
|POLYGON ((0 1, 1 1, 0 1))|POLYGON ((0 1, 1 1, 0 1))
unexpected value;
received "POLYGON ((0 1, 1 1, 0 1))"
expected "POLYGON ((2 0, 2 4, 0 0, 2 0))"
unexpected value;
received "POLYGON ((0 1, 1 1, 0 1))"
expected "POLYGON ((2 0, 2 4, 0 0, 2 0))"
unexpected value;
received "POLYGON ((2 0, 2 4, 0 0, 2 0))"
expected "POLYGON ((3 1, 3 3, 1 0, 3 1))"
unexpected value;
received "POLYGON ((2 0, 2 4, 0 0, 2 0))"
expected "POLYGON ((3 1, 3 3, 1 0, 3 1))"
query started on line 82 of file polygon.test
query text:
SELECT '' AS three, p.*
   FROM POLYGON_TBL_VW p
   WHERE p.f1 && 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'

query result:
(empty)|POLYGON ((0 1, 1 1, 0 1))|POLYGON ((0 1, 1 1, 0 1))
(empty)|POLYGON ((2 0, 2 4, 0 0, 2 0))|POLYGON ((2 0, 2 4, 0 0, 2 0))
(empty)|POLYGON ((3 1, 3 3, 1 0, 3 1))|POLYGON ((3 1, 3 3, 1 0, 3 1))
received 5 rows, expected 4 rows
query started on line 103 of file polygon.test
query text:
SELECT '' AS four, p.*
   FROM POLYGON_TBL_VW p
   WHERE p.f1 &< 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'

query result:
|POLYGON ((2 0, 2 4, 0 0, 2 0))|POLYGON ((2 0, 2 4, 0 0, 2 0))
|POLYGON ((3 1, 3 3, 1 0, 3 1))|POLYGON ((3 1, 3 3, 1 0, 3 1))
|POLYGON ((0 1, 1 1, 0 1))|POLYGON ((0 1, 1 1, 0 1))
|POLYGON ((0 1, 0 1, 0 1, 0 1))|POLYGON ((0 1, 0 1, 0 1, 0 1))
|POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))|POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
unexpected value;
received "POLYGON ((0 1, 1 1, 0 1))"
expected "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
unexpected value;
received "POLYGON ((0 1, 1 1, 0 1))"
expected "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
unexpected value;
received "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
expected "POLYGON ((2 0, 2 4, 0 0, 2 0))"
unexpected value;
received "POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))"
expected "POLYGON ((2 0, 2 4, 0 0, 2 0))"
unexpected value;
received "POLYGON ((2 0, 2 4, 0 0, 2 0))"
expected "POLYGON ((3 1, 3 3, 1 0, 3 1))"
unexpected value;
received "POLYGON ((2 0, 2 4, 0 0, 2 0))"
expected "POLYGON ((3 1, 3 3, 1 0, 3 1))"
query started on line 103 of file polygon.test
query text:
SELECT '' AS four, p.*
   FROM POLYGON_TBL_VW p
   WHERE p.f1 &< 'POLYGON((3.0 1.0, 3.0 3.0, 1.0 0.0, 3.0 1.0))'

query result:
(empty)|POLYGON ((0 1, 0 1, 0 1, 0 1))|POLYGON ((0 1, 0 1, 0 1, 0 1))
(empty)|POLYGON ((0 1, 1 1, 0 1))|POLYGON ((0 1, 1 1, 0 1))
(empty)|POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))|POLYGON ((0 2, 0 1, 0 1, 0 1, 0 2))
(empty)|POLYGON ((2 0, 2 4, 0 0, 2 0))|POLYGON ((2 0, 2 4, 0 0, 2 0))
(empty)|POLYGON ((3 1, 3 3, 1 0, 3 1))|POLYGON ((3 1, 3 3, 1 0, 3 1))