Changeset: d944724918a7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d944724918a7 Added Files: geom/BugTracker/Tests/X_crash.SF-1971632.test geom/BugTracker/Tests/copy_into_crash.SF-1975402.test geom/BugTracker/Tests/copy_into_mbr.3492.test Branch: mtest Log Message:
geom/BugTracker tests converted diffs (103 lines): diff --git a/geom/BugTracker/Tests/X_crash.SF-1971632.test b/geom/BugTracker/Tests/X_crash.SF-1971632.test new file mode 100644 --- /dev/null +++ b/geom/BugTracker/Tests/X_crash.SF-1971632.test @@ -0,0 +1,30 @@ +statement ok +set optimizer = 'sequential_pipe' + +statement ok +CREATE TABLE geoms (id INTEGER, g GEOMETRY) + +statement ok +INSERT INTO geoms values (1, 'POINT(10 10)') + +statement ok +INSERT INTO geoms values (2, 'LINESTRING(10 10, 20 20, 30 40)') + +statement ok +INSERT INTO geoms values (3, 'POLYGON((10 10, 10 20, 20 20, 20 15, 10 10))') + +statement ok +INSERT INTO geoms values (4, 'POLYGON((10 10, 10 20, 20 20, 20 15, 10 10), (15 15, 15 20, 10 15, 15 15))') + +query I rowsort +select count(*) from geoms +---- +4 + +statement error +select ST_X(g) from geoms order by id + +statement ok +DROP TABLE geoms + + diff --git a/geom/BugTracker/Tests/copy_into_crash.SF-1975402.test b/geom/BugTracker/Tests/copy_into_crash.SF-1975402.test new file mode 100644 --- /dev/null +++ b/geom/BugTracker/Tests/copy_into_crash.SF-1975402.test @@ -0,0 +1,15 @@ +statement ok +CREATE TABLE nodes (id serial, p GEOMETRY(POINT)) + +statement ok +insert into nodes (id, p) values (45111955, 'POINT(52.0697 4.3723)') + +statement error +COPY 1 RECORDS INTO nodes from STDIN USING DELIMITERS ',', E'\n' +<COPY_INTO_DATA> +45111956, \'POINT(52.0697 4.3723)\' + +statement ok +drop table nodes + + diff --git a/geom/BugTracker/Tests/copy_into_mbr.3492.test b/geom/BugTracker/Tests/copy_into_mbr.3492.test new file mode 100644 --- /dev/null +++ b/geom/BugTracker/Tests/copy_into_mbr.3492.test @@ -0,0 +1,43 @@ +statement ok +CREATE TABLE geom (id INTEGER, g GEOMETRY, b MBR) + +statement ok +INSERT INTO geom values (5, NULL, NULL) + +statement ok +INSERT INTO geom values (1, 'POLYGON((1 2, 3 2, 3 4, 1 4, 1 2))', NULL) + +statement ok +INSERT INTO geom values (2, 'POLYGON((1 2, 3 2, 3 4, 1 4, 1 2))', 'MBR(1 2,3 4)') + +statement ok +INSERT INTO geom values (3, 'POLYGON((1 2, 3 2, 3 4, 1 4, 1 2))', 'MBR (1 2,3 4)') + +statement ok +INSERT INTO geom values (4, NULL, NULL) + +statement error +SELECT * FROM geom ORDER BY id + +statement ok +UPDATE geom SET b = MBR(g) + +statement error +SELECT * FROM geom ORDER BY id + +statement ok +CREATE TABLE newgeom (id INTEGER, g GEOMETRY, b MBR) + +statement ok +INSERT INTO newgeom SELECT * FROM geom ORDER BY id + +statement error +SELECT * FROM newgeom ORDER BY id + +statement ok +DROP TABLE geom + +statement ok +DROP TABLE newgeom + + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
