Changeset: 06f003666e61 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=06f003666e61
Modified Files:
geom/sql/Tests/pg_regression/Tests/regression_load2D.sql
geom/sql/Tests/pg_regression/Tests/regression_load2D.stable.err
geom/sql/Tests/pg_regression/Tests/regression_load2D.stable.out
geom/sql/Tests/pg_regression/Tests/regression_load3D.sql
geom/sql/Tests/pg_regression/Tests/regression_load3D.stable.err
geom/sql/Tests/pg_regression/Tests/regression_load3D.stable.out
geom/sql/Tests/pg_regression/Tests/regression_load4D.sql
geom/sql/Tests/pg_regression/Tests/regression_load4D.stable.err
geom/sql/Tests/pg_regression/Tests/regression_load4D.stable.out
Branch: geo
Log Message:
pg_regression : id in tables made serial
diffs (truncated from 2523 to 300 lines):
diff --git a/geom/sql/Tests/pg_regression/Tests/regression_load2D.sql
b/geom/sql/Tests/pg_regression/Tests/regression_load2D.sql
--- a/geom/sql/Tests/pg_regression/Tests/regression_load2D.sql
+++ b/geom/sql/Tests/pg_regression/Tests/regression_load2D.sql
@@ -1,625 +1,625 @@
--Point
CREATE TABLE "point" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(POINT));
-INSERT INTO "point" VALUES(1, '01010000000000000000000000000000000000F03F');
-INSERT INTO "point" VALUES(2, '01010000000000000000002240000000000000F0BF');
-INSERT INTO "point" VALUES(3, '01010000000000000000002240000000000000F0BF');
---INSERT INTO "point" VALUES(1, ST_PointFromText('POINT (0.0 1.0)'));
---INSERT INTO "point" VALUES(2, ST_PointFromText('POINT (9.0 -1.0)'));
---INSERT INTO "point" VALUES(3, ST_PointFromText('POINT (9.0 -1.0)'));
+INSERT INTO "point"(geom) VALUES('01010000000000000000000000000000000000F03F');
+INSERT INTO "point"(geom) VALUES('01010000000000000000002240000000000000F0BF');
+INSERT INTO "point"(geom) VALUES('01010000000000000000002240000000000000F0BF');
+--INSERT INTO "point"(geom) VALUES (ST_PointFromText('POINT (0.0 1.0)'));
+--INSERT INTO "point"(geom) VALUES (ST_PointFromText('POINT (9.0 -1.0)'));
+--INSERT INTO "point"(geom) VALUES (ST_PointFromText('POINT (9.0 -1.0)'));
--MultiPoint
CREATE TABLE "multipoint" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(MULTIPOINT));
-INSERT INTO "multipoint" VALUES(1,
'01040000000300000001010000000000000000000000000000000000F03F01010000000000000000002240000000000000F0BF01010000000000000000002240000000000000F0BF');
---INSERT INTO "multipoint" VALUES(1, ST_MPointFromText('MULTIPOINT (0.0 1.0,
9.0 -1.0, 9.0 -1.0)'));
+INSERT INTO "multipoint"(geom)
VALUES('01040000000300000001010000000000000000000000000000000000F03F01010000000000000000002240000000000000F0BF01010000000000000000002240000000000000F0BF');
+--INSERT INTO "multipoint"(geom) VALUES (ST_MPointFromText('MULTIPOINT (0.0
1.0, 9.0 -1.0, 9.0 -1.0)'));
--Arc
CREATE TABLE "arc" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(MULTILINESTRING));
-INSERT INTO "arc" VALUES(1,
'01050000000200000001020000000200000000000000000000000000000000000000000000000000F03F000000000000F03F0102000000020000000000000000000840000000000000084000000000000010400000000000001040');
-INSERT INTO "arc" VALUES(2,
'01050000000300000001020000000200000000000000000000000000000000000000000000000000F03F000000000000F03F0102000000020000000000000000000840000000000000084000000000000010400000000000001040010200000003000000000000000000244000000000000024400000000000001440000000000000144000000000000008400000000000000840');
---INSERT INTO "arc" VALUES(1, ST_MLineFromText('MULTILINESTRING ((0.0 0.0, 1.0
1.0), (3.0 3.0, 4.0 4.0))'));
---INSERT INTO "arc" VALUES(2, ST_MLineFromText('MULTILINESTRING ((0.0 0.0, 1.0
1.0), (3.0 3.0, 4.0 4.0), (10.0 10.0, 5.0 5.0, 3.0 3.0))'));
+INSERT INTO "arc"(geom)
VALUES('01050000000200000001020000000200000000000000000000000000000000000000000000000000F03F000000000000F03F0102000000020000000000000000000840000000000000084000000000000010400000000000001040');
+INSERT INTO "arc"(geom)
VALUES('01050000000300000001020000000200000000000000000000000000000000000000000000000000F03F000000000000F03F0102000000020000000000000000000840000000000000084000000000000010400000000000001040010200000003000000000000000000244000000000000024400000000000001440000000000000144000000000000008400000000000000840');
+--INSERT INTO "arc"(geom) VALUES (ST_MLineFromText('MULTILINESTRING ((0.0 0.0,
1.0 1.0), (3.0 3.0, 4.0 4.0))'));
+--INSERT INTO "arc"(geom) VALUES (ST_MLineFromText('MULTILINESTRING ((0.0 0.0,
1.0 1.0), (3.0 3.0, 4.0 4.0), (10.0 10.0, 5.0 5.0, 3.0 3.0))'));
--Polygon
CREATE TABLE "polygon" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(MULTIPOLYGON));
-INSERT INTO "polygon" VALUES(1,
'01060000000200000001030000000200000005000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440000000000000244000000000000000000000000000000000000000000000000005000000000000000000144000000000000014400000000000002040000000000000144000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000144001030000000200000005000000000000000000F0BF000000000000F0BF000000000000F0BF00000000000024C000000000000024C000000000000024C000000000000024C0000000000000F0BF000000000000F0BF000000000000F0BF0500000000000000000014C000000000000014C000000000000020C000000000000014C000000000000020C000000000000020C000000000000014C000000000000020C000000000000014C000000000000014C0');
---INSERT INTO "polygon" VALUES(1, ST_MPolyFromText('MULTIPOLYGON (((0.0 0.0,
0.0 10.0, 10.0 10.0, 10.0 0.0, 0.0 0.0), (5.0 5.0, 8.0 5.0, 8.0 8.0, 5.0 8.0,
5.0 5.0)), ((-1.0 -1.0, -1.0 -10.0, -10.0 -10.0, -10.0 -1.0, -1.0 -1.0), (-5.0
-5.0, -8.0 -5.0, -8.0 -8.0, -5.0 -8.0, -5.0 -5.0)))'));
+INSERT INTO "polygon"(geom)
VALUES('01060000000200000001030000000200000005000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440000000000000244000000000000000000000000000000000000000000000000005000000000000000000144000000000000014400000000000002040000000000000144000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000144001030000000200000005000000000000000000F0BF000000000000F0BF000000000000F0BF00000000000024C000000000000024C000000000000024C000000000000024C0000000000000F0BF000000000000F0BF000000000000F0BF0500000000000000000014C000000000000014C000000000000020C000000000000014C000000000000020C000000000000020C000000000000014C000000000000020C000000000000014C000000000000014C0');
+--INSERT INTO "polygon"(geom) VALUES (ST_MPolyFromText('MULTIPOLYGON (((0.0
0.0, 0.0 10.0, 10.0 10.0, 10.0 0.0, 0.0 0.0), (5.0 5.0, 8.0 5.0, 8.0 8.0, 5.0
8.0, 5.0 5.0)), ((-1.0 -1.0, -1.0 -10.0, -10.0 -10.0, -10.0 -1.0, -1.0 -1.0),
(-5.0 -5.0, -8.0 -5.0, -8.0 -8.0, -5.0 -8.0, -5.0 -5.0)))'));
--TSTPolygon
CREATE TABLE "tstpolygon" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(MULTIPOLYGON));
-INSERT INTO "tstpolygon" VALUES(1,
'01060000000200000001030000000200000005000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440000000000000244000000000000000000000000000000000000000000000000005000000000000000000144000000000000014400000000000002040000000000000144000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000144001030000000200000005000000000000000000F0BF000000000000F0BF000000000000F0BF00000000000024C000000000000024C000000000000024C000000000000024C0000000000000F0BF000000000000F0BF000000000000F0BF0500000000000000000014C000000000000014C000000000000020C000000000000014C000000000000020C000000000000020C000000000000014C000000000000020C000000000000014C000000000000014C0');
---INSERT INTO "tstpolygon" VALUES(1, ST_MPolyFromText('MULTIPOLYGON (((0.0
0.0, 0.0 10.0, 10.0 10.0, 10.0 0.0, 0.0 0.0), (5.0 5.0, 8.0 5.0, 8.0 8.0, 5.0
8.0, 5.0 5.0)), ((-1.0 -1.0, -1.0 -10.0, -10.0 -10.0, -10.0 -1.0, -1.0 -1.0),
(-5.0 -5.0, -8.0 -5.0, -8.0 -8.0, -5.0 -8.0, -5.0 -5.0)))'));
+INSERT INTO "tstpolygon"(geom)
VALUES('01060000000200000001030000000200000005000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440000000000000244000000000000000000000000000000000000000000000000005000000000000000000144000000000000014400000000000002040000000000000144000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000144001030000000200000005000000000000000000F0BF000000000000F0BF000000000000F0BF00000000000024C000000000000024C000000000000024C000000000000024C0000000000000F0BF000000000000F0BF000000000000F0BF0500000000000000000014C000000000000014C000000000000020C000000000000014C000000000000020C000000000000020C000000000000014C000000000000020C000000000000014C000000000000014C0');
+--INSERT INTO "tstpolygon"(geom) VALUES (ST_MPolyFromText('MULTIPOLYGON (((0.0
0.0, 0.0 10.0, 10.0 10.0, 10.0 0.0, 0.0 0.0), (5.0 5.0, 8.0 5.0, 8.0 8.0, 5.0
8.0, 5.0 5.0)), ((-1.0 -1.0, -1.0 -10.0, -10.0 -10.0, -10.0 -1.0, -1.0 -1.0),
(-5.0 -5.0, -8.0 -5.0, -8.0 -8.0, -5.0 -8.0, -5.0 -5.0)))'));
--TSIPolygon
CREATE TABLE "tsipolygon" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(MULTIPOLYGON));
-INSERT INTO "tsipolygon" VALUES(1,
'01060000000200000001030000000200000005000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440000000000000244000000000000000000000000000000000000000000000000005000000000000000000144000000000000014400000000000002040000000000000144000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000144001030000000200000005000000000000000000F0BF000000000000F0BF000000000000F0BF00000000000024C000000000000024C000000000000024C000000000000024C0000000000000F0BF000000000000F0BF000000000000F0BF0500000000000000000014C000000000000014C000000000000020C000000000000014C000000000000020C000000000000020C000000000000014C000000000000020C000000000000014C000000000000014C0');
---INSERT INTO "tsipolygon" VALUES(1, ST_MPolyFromText('MULTIPOLYGON (((0.0
0.0, 0.0 10.0, 10.0 10.0, 10.0 0.0, 0.0 0.0), (5.0 5.0, 8.0 5.0, 8.0 8.0, 5.0
8.0, 5.0 5.0)), ((-1.0 -1.0, -1.0 -10.0, -10.0 -10.0, -10.0 -1.0, -1.0 -1.0),
(-5.0 -5.0, -8.0 -5.0, -8.0 -8.0, -5.0 -8.0, -5.0 -5.0)))'));
+INSERT INTO "tsipolygon"(geom)
VALUES('01060000000200000001030000000200000005000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440000000000000244000000000000000000000000000000000000000000000000005000000000000000000144000000000000014400000000000002040000000000000144000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000144001030000000200000005000000000000000000F0BF000000000000F0BF000000000000F0BF00000000000024C000000000000024C000000000000024C000000000000024C0000000000000F0BF000000000000F0BF000000000000F0BF0500000000000000000014C000000000000014C000000000000020C000000000000014C000000000000020C000000000000020C000000000000014C000000000000020C000000000000014C000000000000014C0');
+--INSERT INTO "tsipolygon"(geom) VALUES (ST_MPolyFromText('MULTIPOLYGON (((0.0
0.0, 0.0 10.0, 10.0 10.0, 10.0 0.0, 0.0 0.0), (5.0 5.0, 8.0 5.0, 8.0 8.0, 5.0
8.0, 5.0 5.0)), ((-1.0 -1.0, -1.0 -10.0, -10.0 -10.0, -10.0 -1.0, -1.0 -1.0),
(-5.0 -5.0, -8.0 -5.0, -8.0 -8.0, -5.0 -8.0, -5.0 -5.0)))'));
--TSTIPolygon
CREATE TABLE "tstipolygon" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(MULTIPOLYGON));
-INSERT INTO "tstipolygon" VALUES(1,
'01060000000200000001030000000200000005000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440000000000000244000000000000000000000000000000000000000000000000005000000000000000000144000000000000014400000000000002040000000000000144000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000144001030000000200000005000000000000000000F0BF000000000000F0BF000000000000F0BF00000000000024C000000000000024C000000000000024C000000000000024C0000000000000F0BF000000000000F0BF000000000000F0BF0500000000000000000014C000000000000014C000000000000020C000000000000014C000000000000020C000000000000020C000000000000014C000000000000020C000000000000014C000000000000014C0');
---INSERT INTO "tstipolygon" VALUES(1, ST_MPolyFromText('MULTIPOLYGON (((0.0
0.0, 0.0 10.0, 10.0 10.0, 10.0 0.0, 0.0 0.0), (5.0 5.0, 8.0 5.0, 8.0 8.0, 5.0
8.0, 5.0 5.0)), ((-1.0 -1.0, -1.0 -10.0, -10.0 -10.0, -10.0 -1.0, -1.0 -1.0),
(-5.0 -5.0, -8.0 -5.0, -8.0 -8.0, -5.0 -8.0, -5.0 -5.0)))'));
+INSERT INTO "tstipolygon"(geom)
VALUES('01060000000200000001030000000200000005000000000000000000000000000000000000000000000000000000000000000000244000000000000024400000000000002440000000000000244000000000000000000000000000000000000000000000000005000000000000000000144000000000000014400000000000002040000000000000144000000000000020400000000000002040000000000000144000000000000020400000000000001440000000000000144001030000000200000005000000000000000000F0BF000000000000F0BF000000000000F0BF00000000000024C000000000000024C000000000000024C000000000000024C0000000000000F0BF000000000000F0BF000000000000F0BF0500000000000000000014C000000000000014C000000000000020C000000000000014C000000000000020C000000000000020C000000000000014C000000000000020C000000000000014C000000000000014C0');
+--INSERT INTO "tstipolygon"(geom) VALUES (ST_MPolyFromText('MULTIPOLYGON
(((0.0 0.0, 0.0 10.0, 10.0 10.0, 10.0 0.0, 0.0 0.0), (5.0 5.0, 8.0 5.0, 8.0
8.0, 5.0 8.0, 5.0 5.0)), ((-1.0 -1.0, -1.0 -10.0, -10.0 -10.0, -10.0 -1.0, -1.0
-1.0), (-5.0 -5.0, -8.0 -5.0, -8.0 -8.0, -5.0 -8.0, -5.0 -5.0)))'));
--NoTransPoint
CREATE TABLE "notranspoint" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(POINT));
-INSERT INTO "notranspoint" VALUES (1,
'01010000000000000000000000000000000000F03F');
-INSERT INTO "notranspoint" VALUES (2,
'01010000000000000000002240000000000000F0BF');
-INSERT INTO "notranspoint" VALUES (3,
'01010000000000000000002240000000000000F0BF');
---INSERT INTO "notranspoint" VALUES(1, ST_PointFromText('POINT (0.0 1.0)'));
---INSERT INTO "notranspoint" VALUES(2, ST_PointFromText('POINT (9.0 -1.0)'));
---INSERT INTO "notranspoint" VALUES(3, ST_PointFromText('POINT (9.0 -1.0)'));
+INSERT INTO "notranspoint"(geom) VALUES
('01010000000000000000000000000000000000F03F');
+INSERT INTO "notranspoint"(geom) VALUES
('01010000000000000000002240000000000000F0BF');
+INSERT INTO "notranspoint"(geom) VALUES
('01010000000000000000002240000000000000F0BF');
+--INSERT INTO "notranspoint"(geom) VALUES (ST_PointFromText('POINT (0.0
1.0)'));
+--INSERT INTO "notranspoint"(geom) VALUES (ST_PointFromText('POINT (9.0
-1.0)'));
+--INSERT INTO "notranspoint"(geom) VALUES (ST_PointFromText('POINT (9.0
-1.0)'));
--NotReallyMultiPoint
CREATE TABLE "notreallymultipoint" (
- gid INTEGER NOT NULL PRIMARY KEY,
+ gid SERIAL,
geom GEOMETRY(MULTIPOINT));
-INSERT INTO "notreallymultipoint" VALUES (1,
'01040000000100000001010000004918204990BA214183150D8612022941');
-INSERT INTO "notreallymultipoint" VALUES (2,
'0104000000010000000101000000EC1D4693DBE71E41BCC6BC83668A2241');
-INSERT INTO "notreallymultipoint" VALUES (3,
'0104000000010000000101000000A7E859ED4B3E23414AECF8EAC01B2041');
-INSERT INTO "notreallymultipoint" VALUES (4,
'01040000000100000001010000008CFB07F801411341EB6BA0416B131541');
-INSERT INTO "notreallymultipoint" VALUES (5,
'0104000000010000000101000000D89395CDBABF1C41943770FCC07B2641');
-INSERT INTO "notreallymultipoint" VALUES (6,
'01040000000100000001010000000F43D46FCA841E41A0BFD68CFEC92241');
-INSERT INTO "notreallymultipoint" VALUES (7,
'0104000000010000000101000000B1BEA9C755CB0A414B24228031491341');
-INSERT INTO "notreallymultipoint" VALUES (8,
'0104000000010000000101000000BF3A52ADE27B134152C4F13F40771341');
-INSERT INTO "notreallymultipoint" VALUES (9,
'0104000000010000000101000000C709818C955A2141FBE47885B81A1C41');
-INSERT INTO "notreallymultipoint" VALUES (10,
'0104000000010000000101000000FCCD213AF2FA2041D29CAB9E4A412641');
-INSERT INTO "notreallymultipoint" VALUES (11,
'0104000000010000000101000000B04CDADE1D5D1F41A358FE7B35712541');
-INSERT INTO "notreallymultipoint" VALUES (12,
'0104000000010000000101000000D982C5E063A92141AC4E3DDFA1F92641');
-INSERT INTO "notreallymultipoint" VALUES (13,
'0104000000010000000101000000B2098737CD87214176EF8464B2782741');
-INSERT INTO "notreallymultipoint" VALUES (14,
'0104000000010000000101000000EA59B7B3B08D20412D86A0C239652441');
-INSERT INTO "notreallymultipoint" VALUES (15,
'0104000000010000000101000000100E6157276E18419C7133118E692641');
-INSERT INTO "notreallymultipoint" VALUES (16,
'0104000000010000000101000000B45BB773BF921B415829246738301941');
-INSERT INTO "notreallymultipoint" VALUES (17,
'010400000001000000010100000037D6CE2A6D642141CCB36FD640111C41');
-INSERT INTO "notreallymultipoint" VALUES (18,
'01040000000100000001010000004E65C0B05B481C41CF622E0A8C5C2541');
-INSERT INTO "notreallymultipoint" VALUES (19,
'0104000000010000000101000000CC902A0B7A722241FAD78DFF5F992641');
-INSERT INTO "notreallymultipoint" VALUES (20,
'010400000001000000010100000092FB869BEEFF1E41038A168DBC9D2541');
-INSERT INTO "notreallymultipoint" VALUES (21,
'010400000001000000010100000092E494F758761941E95C215D64D71E41');
-INSERT INTO "notreallymultipoint" VALUES (22,
'0104000000010000000101000000BD5A28661DA221412AF5E5DD59302541');
-INSERT INTO "notreallymultipoint" VALUES (23,
'0104000000010000000101000000A1583EC4A495214176E67A93E0D12541');
-INSERT INTO "notreallymultipoint" VALUES (24,
'01040000000100000001010000000D728FE2F1A021415D51C7782D3C2541');
-INSERT INTO "notreallymultipoint" VALUES (25,
'01040000000100000001010000008E20E88E57C121411F87B2EDB82C2541');
-INSERT INTO "notreallymultipoint" VALUES (26,
'01040000000100000001010000000A97D2479C7E1D412ED722F206350D41');
-INSERT INTO "notreallymultipoint" VALUES (27,
'0104000000010000000101000000FEE0DEC666D72141F50D28D995282541');
-INSERT INTO "notreallymultipoint" VALUES (28,
'01040000000100000001010000004DCB7C624C39204172F2F014CEDE2541');
-INSERT INTO "notreallymultipoint" VALUES (29,
'01040000000100000001010000003DCD2FBBAEC221413614031918302541');
-INSERT INTO "notreallymultipoint" VALUES (30,
'0104000000010000000101000000AE64248B403B1B4114A0E4BAD9CF2041');
-INSERT INTO "notreallymultipoint" VALUES (31,
'0104000000010000000101000000E782442E3F272041D4F72A03FDA42241');
-INSERT INTO "notreallymultipoint" VALUES (32,
'01040000000100000001010000000ABE377461C12141F535FE67433C2541');
-INSERT INTO "notreallymultipoint" VALUES (33,
'01040000000100000001010000002352C1DF39CF1E413A2D575FAACB2241');
-INSERT INTO "notreallymultipoint" VALUES (34,
'01040000000100000001010000005EADFF4F48FF224156CF7D0FCCF42641');
-INSERT INTO "notreallymultipoint" VALUES (35,
'01040000000100000001010000003CCFABE3D8521541075057AF23281641');
-INSERT INTO "notreallymultipoint" VALUES (36,
'0104000000010000000101000000378A56A9AE27224191FCB4DF06A92041');
-INSERT INTO "notreallymultipoint" VALUES (37,
'0104000000010000000101000000FDC2DE4772EF1A41D929FBFDF5F40B41');
-INSERT INTO "notreallymultipoint" VALUES (38,
'0104000000010000000101000000F4AE108A827B2241176164EBDE8D2741');
-INSERT INTO "notreallymultipoint" VALUES (39,
'01040000000100000001010000006D6859969969134190FC03E057D21841');
-INSERT INTO "notreallymultipoint" VALUES (40,
'01040000000100000001010000007FE15CFBBC842241B377BEAC4FDC2441');
-INSERT INTO "notreallymultipoint" VALUES (41,
'0104000000010000000101000000066A7AFB08131A41ACE49CD727102041');
-INSERT INTO "notreallymultipoint" VALUES (42,
'01040000000100000001010000003586254F0BDF2141025D2833F92A1A41');
-INSERT INTO "notreallymultipoint" VALUES (43,
'010400000001000000010100000077E393E148451541E6F362825C422541');
-INSERT INTO "notreallymultipoint" VALUES (44,
'0104000000010000000101000000A7118D8D27541B412575A06F98DA2041');
-INSERT INTO "notreallymultipoint" VALUES (45,
'0104000000010000000101000000E55BA9E6432721410A9FF6B1BE3E2541');
-INSERT INTO "notreallymultipoint" VALUES (46,
'0104000000010000000101000000B84D9CD8F5751B41B026A8B05F871F41');
-INSERT INTO "notreallymultipoint" VALUES (47,
'01040000000100000001010000000E709B6D7E131F41B3EE965390252241');
-INSERT INTO "notreallymultipoint" VALUES (48,
'01040000000100000001010000008872DCDEB44121418E024E3F4A8E2441');
-INSERT INTO "notreallymultipoint" VALUES (49,
'0104000000010000000101000000F7690D73150E1E41D94439991BF22541');
-INSERT INTO "notreallymultipoint" VALUES (50,
'01040000000100000001010000009203FBFFC4B722412367BD7EF3192541');
-INSERT INTO "notreallymultipoint" VALUES (51,
'01040000000100000001010000001BD2A99205D81441D010C170C7371541');
-INSERT INTO "notreallymultipoint" VALUES (52,
'0104000000010000000101000000F46BD86F6874144157EC25AB53110B41');
-INSERT INTO "notreallymultipoint" VALUES (53,
'01040000000100000001010000008F1BD26F73C41F41456B6EC929892241');
-INSERT INTO "notreallymultipoint" VALUES (54,
'0104000000010000000101000000556B6D21E6A42241FD3100E3710F2541');
-INSERT INTO "notreallymultipoint" VALUES (55,
'0104000000010000000101000000742697F639A1214114606FAE5D382541');
-INSERT INTO "notreallymultipoint" VALUES (56,
'0104000000010000000101000000ED5EB5D900092341879C4299A3472541');
-INSERT INTO "notreallymultipoint" VALUES (57,
'0104000000010000000101000000E715F5F9CFD51A41EC9DEA8290BE2341');
-INSERT INTO "notreallymultipoint" VALUES (58,
'01040000000100000001010000002AD9AA8F14F41E419356037EA4812241');
-INSERT INTO "notreallymultipoint" VALUES (59,
'010400000001000000010100000088EBBDDA2F8F21410BCACBA4FA812641');
-INSERT INTO "notreallymultipoint" VALUES (60,
'01040000000100000001010000002DDB23FB7D38194180CE625863F71F41');
-INSERT INTO "notreallymultipoint" VALUES (61,
'0104000000010000000101000000BA699D5CBE2521410D1485B059C61E41');
-INSERT INTO "notreallymultipoint" VALUES (62,
'010400000001000000010100000029F9077108CE2141A273FFDAD12E2741');
-INSERT INTO "notreallymultipoint" VALUES (63,
'0104000000010000000101000000B20940B36BB219417CA24A6EACD62841');
-INSERT INTO "notreallymultipoint" VALUES (64,
'010400000001000000010100000093DB0FDC7BF622415A8DF395F90E2541');
-INSERT INTO "notreallymultipoint" VALUES (65,
'0104000000010000000101000000C6CE27A31CBF1C41AA07777729F12241');
-INSERT INTO "notreallymultipoint" VALUES (66,
'0104000000010000000101000000C99D8E084F101F41FD01A80341912541');
---INSERT INTO "notreallymultipoint" VALUES(1,
ST_MPointFromText('MULTIPOINT(580936.14282 819465.26182)'));
---INSERT INTO "notreallymultipoint" VALUES(2,
ST_MPointFromText('MULTIPOINT(506358.89382 607539.2573)'));
---INSERT INTO "notreallymultipoint" VALUES(3,
ST_MPointFromText('MULTIPOINT(630565.96358 527840.45893)'));
---INSERT INTO "notreallymultipoint" VALUES(4,
ST_MPointFromText('MULTIPOINT(315456.49222 345306.81409)'));
---INSERT INTO "notreallymultipoint" VALUES(5,
ST_MPointFromText('MULTIPOINT(471022.70077 736736.49304)'));
---INSERT INTO "notreallymultipoint" VALUES(6,
ST_MPointFromText('MULTIPOINT(500018.60921 615679.27508)'));
---INSERT INTO "notreallymultipoint" VALUES(7,
ST_MPointFromText('MULTIPOINT(219498.72249 315980.37513)'));
---INSERT INTO "notreallymultipoint" VALUES(8,
ST_MPointFromText('MULTIPOINT(319224.66926 318928.06245)'));
---INSERT INTO "notreallymultipoint" VALUES(9,
ST_MPointFromText('MULTIPOINT(568650.77442 460462.13034)'));
---INSERT INTO "notreallymultipoint" VALUES(10,
ST_MPointFromText('MULTIPOINT(556409.11354 729253.3099)'));
---INSERT INTO "notreallymultipoint" VALUES(11,
ST_MPointFromText('MULTIPOINT(513863.46763 702618.74217)'));
---INSERT INTO "notreallymultipoint" VALUES(12,
ST_MPointFromText('MULTIPOINT(578737.93901 752848.93601)'));
---INSERT INTO "notreallymultipoint" VALUES(13,
ST_MPointFromText('MULTIPOINT(574438.60845 769113.19633)'));
---INSERT INTO "notreallymultipoint" VALUES(14,
ST_MPointFromText('MULTIPOINT(542424.35101 668316.88013)'));
---INSERT INTO "notreallymultipoint" VALUES(15,
ST_MPointFromText('MULTIPOINT(400265.83533 734407.0336)'));
---INSERT INTO "notreallymultipoint" VALUES(16,
ST_MPointFromText('MULTIPOINT(451759.863 412686.10072)'));
---INSERT INTO "notreallymultipoint" VALUES(17,
ST_MPointFromText('MULTIPOINT(569910.58361 459856.20941)'));
---INSERT INTO "notreallymultipoint" VALUES(18,
ST_MPointFromText('MULTIPOINT(463382.92261 699974.01989)'));
---INSERT INTO "notreallymultipoint" VALUES(19,
ST_MPointFromText('MULTIPOINT(604477.02181 740527.99913)'));
---INSERT INTO "notreallymultipoint" VALUES(20,
ST_MPointFromText('MULTIPOINT(507899.65188 708318.27556)'));
---INSERT INTO "notreallymultipoint" VALUES(21,
ST_MPointFromText('MULTIPOINT(417174.24178 505305.09095)'));
---INSERT INTO "notreallymultipoint" VALUES(22,
ST_MPointFromText('MULTIPOINT(577806.69953 694316.9334)'));
---INSERT INTO "notreallymultipoint" VALUES(23,
ST_MPointFromText('MULTIPOINT(576210.38329 714992.28805)'));
---INSERT INTO "notreallymultipoint" VALUES(24,
ST_MPointFromText('MULTIPOINT(577656.9425 695830.7359)'));
---INSERT INTO "notreallymultipoint" VALUES(25,
ST_MPointFromText('MULTIPOINT(581803.77911 693852.46425)'));
---INSERT INTO "notreallymultipoint" VALUES(26,
ST_MPointFromText('MULTIPOINT(483239.07014 239264.86823)'));
---INSERT INTO "notreallymultipoint" VALUES(27,
ST_MPointFromText('MULTIPOINT(584627.38842 693322.92413)'));
---INSERT INTO "notreallymultipoint" VALUES(28,
ST_MPointFromText('MULTIPOINT(531622.19236 716647.0409)'));
---INSERT INTO "notreallymultipoint" VALUES(29,
ST_MPointFromText('MULTIPOINT(581975.3656 694284.04885)'));
---INSERT INTO "notreallymultipoint" VALUES(30,
ST_MPointFromText('MULTIPOINT(446160.13588 550892.86503)'));
---INSERT INTO "notreallymultipoint" VALUES(31,
ST_MPointFromText('MULTIPOINT(529311.59037 610942.50619)'));
---INSERT INTO "notreallymultipoint" VALUES(32,
ST_MPointFromText('MULTIPOINT(581808.72699 695841.70311)'));
---INSERT INTO "notreallymultipoint" VALUES(33,
ST_MPointFromText('MULTIPOINT(504782.46851 615893.18621)'));
---INSERT INTO "notreallymultipoint" VALUES(34,
ST_MPointFromText('MULTIPOINT(622500.15625 752230.03026)'));
---INSERT INTO "notreallymultipoint" VALUES(35,
ST_MPointFromText('MULTIPOINT(349366.22234 363016.92123)'));
---INSERT INTO "notreallymultipoint" VALUES(36,
ST_MPointFromText('MULTIPOINT(594903.33074 545923.43693)'));
---INSERT INTO "notreallymultipoint" VALUES(37,
ST_MPointFromText('MULTIPOINT(441308.57019 229022.74901)'));
---INSERT INTO "notreallymultipoint" VALUES(38,
ST_MPointFromText('MULTIPOINT(605633.26966 771823.45975)'));
---INSERT INTO "notreallymultipoint" VALUES(39,
ST_MPointFromText('MULTIPOINT(318054.39683 406677.96877)'));
---INSERT INTO "notreallymultipoint" VALUES(40,
ST_MPointFromText('MULTIPOINT(606814.49094 683559.83739)'));
---INSERT INTO "notreallymultipoint" VALUES(41,
ST_MPointFromText('MULTIPOINT(427202.24558 526355.92112)'));
---INSERT INTO "notreallymultipoint" VALUES(42,
ST_MPointFromText('MULTIPOINT(585605.65458 428734.29996)'));
---INSERT INTO "notreallymultipoint" VALUES(43,
ST_MPointFromText('MULTIPOINT(348498.22029 696622.25466)'));
---INSERT INTO "notreallymultipoint" VALUES(44,
ST_MPointFromText('MULTIPOINT(447753.88823 552268.21802)'));
---INSERT INTO "notreallymultipoint" VALUES(45,
ST_MPointFromText('MULTIPOINT(562081.95051 696159.34758)'));
---INSERT INTO "notreallymultipoint" VALUES(46,
ST_MPointFromText('MULTIPOINT(449917.46153 516567.92252)'));
---INSERT INTO "notreallymultipoint" VALUES(47,
ST_MPointFromText('MULTIPOINT(509151.60704 594632.16326)'));
---INSERT INTO "notreallymultipoint" VALUES(48,
ST_MPointFromText('MULTIPOINT(565466.43528 673573.12364)'));
---INSERT INTO "notreallymultipoint" VALUES(49,
ST_MPointFromText('MULTIPOINT(492421.36236 719117.79927)'));
---INSERT INTO "notreallymultipoint" VALUES(50,
ST_MPointFromText('MULTIPOINT(613346.49996 691449.74754)'));
---INSERT INTO "notreallymultipoint" VALUES(51,
ST_MPointFromText('MULTIPOINT(341505.39323 347633.86011)'));
---INSERT INTO "notreallymultipoint" VALUES(52,
ST_MPointFromText('MULTIPOINT(335130.10922 221738.45857)'));
---INSERT INTO "notreallymultipoint" VALUES(53,
ST_MPointFromText('MULTIPOINT(520476.8592 607380.89342)'));
---INSERT INTO "notreallymultipoint" VALUES(54,
ST_MPointFromText('MULTIPOINT(610931.06529 690104.94336)'));
---INSERT INTO "notreallymultipoint" VALUES(55,
ST_MPointFromText('MULTIPOINT(577692.98162 695342.84069)'));
---INSERT INTO "notreallymultipoint" VALUES(56,
ST_MPointFromText('MULTIPOINT(623744.42521 697297.79934)'));
---INSERT INTO "notreallymultipoint" VALUES(57,
ST_MPointFromText('MULTIPOINT(439667.9941 646984.2557)'));
---INSERT INTO "notreallymultipoint" VALUES(58,
ST_MPointFromText('MULTIPOINT(507141.1403 606418.24612)'));
---INSERT INTO "notreallymultipoint" VALUES(59,
ST_MPointFromText('MULTIPOINT(575383.92723 737533.32187)'));
---INSERT INTO "notreallymultipoint" VALUES(60,
ST_MPointFromText('MULTIPOINT(413215.49525 523736.83631)'));
---INSERT INTO "notreallymultipoint" VALUES(61,
ST_MPointFromText('MULTIPOINT(561887.18089 504214.42238)'));
---INSERT INTO "notreallymultipoint" VALUES(62,
ST_MPointFromText('MULTIPOINT(583428.22076 759656.92773)'));
---INSERT INTO "notreallymultipoint" VALUES(63,
ST_MPointFromText('MULTIPOINT(421018.92505 813910.21541)'));
---INSERT INTO "notreallymultipoint" VALUES(64,
ST_MPointFromText('MULTIPOINT(621373.92981 690044.79287)'));
---INSERT INTO "notreallymultipoint" VALUES(65,
ST_MPointFromText('MULTIPOINT(470983.15933 620692.73333)'));
---INSERT INTO "notreallymultipoint" VALUES(66,
ST_MPointFromText('MULTIPOINT(508947.75836 706720.50714)'));
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000004918204990BA214183150D8612022941');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000EC1D4693DBE71E41BCC6BC83668A2241');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000A7E859ED4B3E23414AECF8EAC01B2041');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000008CFB07F801411341EB6BA0416B131541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000D89395CDBABF1C41943770FCC07B2641');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000000F43D46FCA841E41A0BFD68CFEC92241');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000B1BEA9C755CB0A414B24228031491341');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000BF3A52ADE27B134152C4F13F40771341');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000C709818C955A2141FBE47885B81A1C41');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000FCCD213AF2FA2041D29CAB9E4A412641');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000B04CDADE1D5D1F41A358FE7B35712541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000D982C5E063A92141AC4E3DDFA1F92641');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000B2098737CD87214176EF8464B2782741');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000EA59B7B3B08D20412D86A0C239652441');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000100E6157276E18419C7133118E692641');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000B45BB773BF921B415829246738301941');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('010400000001000000010100000037D6CE2A6D642141CCB36FD640111C41');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000004E65C0B05B481C41CF622E0A8C5C2541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000CC902A0B7A722241FAD78DFF5F992641');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('010400000001000000010100000092FB869BEEFF1E41038A168DBC9D2541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('010400000001000000010100000092E494F758761941E95C215D64D71E41');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000BD5A28661DA221412AF5E5DD59302541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000A1583EC4A495214176E67A93E0D12541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000000D728FE2F1A021415D51C7782D3C2541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000008E20E88E57C121411F87B2EDB82C2541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000000A97D2479C7E1D412ED722F206350D41');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000FEE0DEC666D72141F50D28D995282541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000004DCB7C624C39204172F2F014CEDE2541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000003DCD2FBBAEC221413614031918302541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000AE64248B403B1B4114A0E4BAD9CF2041');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000E782442E3F272041D4F72A03FDA42241');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000000ABE377461C12141F535FE67433C2541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000002352C1DF39CF1E413A2D575FAACB2241');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000005EADFF4F48FF224156CF7D0FCCF42641');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000003CCFABE3D8521541075057AF23281641');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000378A56A9AE27224191FCB4DF06A92041');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000FDC2DE4772EF1A41D929FBFDF5F40B41');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000F4AE108A827B2241176164EBDE8D2741');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000006D6859969969134190FC03E057D21841');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000007FE15CFBBC842241B377BEAC4FDC2441');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000066A7AFB08131A41ACE49CD727102041');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000003586254F0BDF2141025D2833F92A1A41');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('010400000001000000010100000077E393E148451541E6F362825C422541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000A7118D8D27541B412575A06F98DA2041');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000E55BA9E6432721410A9FF6B1BE3E2541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000B84D9CD8F5751B41B026A8B05F871F41');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000000E709B6D7E131F41B3EE965390252241');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000008872DCDEB44121418E024E3F4A8E2441');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('0104000000010000000101000000F7690D73150E1E41D94439991BF22541');
+INSERT INTO "notreallymultipoint"(geom) VALUES
('01040000000100000001010000009203FBFFC4B722412367BD7EF3192541');
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
