Changeset: 97e5baea06bb for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=97e5baea06bb
Modified Files:
sql/test/testdb/Tests/testdb-load.sql
Branch: geo
Log Message:
testdb-load updated
diffs (33 lines):
diff --git a/sql/test/testdb/Tests/testdb-load.sql
b/sql/test/testdb/Tests/testdb-load.sql
--- a/sql/test/testdb/Tests/testdb-load.sql
+++ b/sql/test/testdb/Tests/testdb-load.sql
@@ -101218,18 +101218,18 @@ COMMIT;
-- geometry test in separate transaction (in case geom is not available)
START TRANSACTION;
CREATE TABLE testschema.geomtest (
- p POINT,
- c CURVE,
- ls LINESTRING,
- s SURFACE,
- pg POLYGON,
- mp MULTIPOINT,
- mc MULTICURVE,
- mls MULTILINESTRING,
- ms MULTISURFACE,
- mpg MULTIPOLYGON,
+ p GEOMETRY(POINT),
+ c GEOMETRY(LINESTRING), --was CURVE but is not supported anymore,
+ ls GEOMETRY(LINESTRING),
+ s GEOMETRY(POLYGON), -- was SURFACE but is not supported anymore,
+ pg GEOMETRY(POLYGON),
+ mp GEOMETRY(MULTIPOINT),
+ mc GEOMETRY(MULTILINESTRING), -- was MULTICURVE but is not supported
anymore,
+ mls GEOMETRY(MULTILINESTRING),
+ ms GEOMETRY(MULTIPOLYGON), --was MULTISURFACE but is not supported
anymore,
+ mpg GEOMETRY(MULTIPOLYGON),
g GEOMETRY,
- gc GEOMCOLLECTION,
+ gc GEOMETRY(GEOMETRYCOLLECTION),
m MBR
);
insert into testschema.geomtest values('POINT(10.5 12.3)', 'LINESTRING(10 10,
20 20, 30 40)', 'LINESTRING(10 10, 20 20, 30 40)', 'POLYGON((10 10, 10 20, 20
20, 20 15, 10 10))', 'POLYGON((10 10, 10 20, 20 20, 20 15, 10 10))',
'MULTIPOINT(20 80, 110 160, 20 160)', 'MULTILINESTRING((0 0,0 80,60 80,60 0,0
0))', 'MULTILINESTRING((0 0,0 80,60 80,60 0,0 0))', 'MULTIPOLYGON(((140 110,
260 110, 170 20, 50 20, 140 110)), ((300 270, 420 270, 340 190, 220 190, 300
270)))', 'MULTIPOLYGON(((140 110, 260 110, 170 20, 50 20, 140 110)), ((300 270,
420 270, 340 190, 220 190, 300 270)))', 'POLYGON((10 10, 10 20, 20 20, 20 15,
10 10))', 'GEOMETRYCOLLECTION (POLYGON ((0 0, 0 100, 100 100, 100 0, 0 0)),
LINESTRING(10 10, 20 20, 30 40))', sys.mbr('POLYGON((10 10, 10 20, 20 20, 20
15, 10 10))'));
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
