Changeset: 90066d9863df for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/90066d9863df
Modified Files:
sql/test/BugTracker-2022/Tests/incomplete-sql-script.Bug-7298.SQL.py
testing/sqllogictest.py
Branch: default
Log Message:
Merge with Dec2023 branch.
diffs (truncated from 2912 to 300 lines):
diff --git a/documentation/monetdbe/manual_pages/monetdbe_options.rst
b/documentation/monetdbe/manual_pages/monetdbe_options.rst
--- a/documentation/monetdbe/manual_pages/monetdbe_options.rst
+++ b/documentation/monetdbe/manual_pages/monetdbe_options.rst
@@ -31,9 +31,9 @@ MonetDBe options struct. Object can be p
(2) int querytimeout. Gracefully terminate query after a few seconds.
(3) int sessiontimeout. Graceful terminate the session after a few seconds.
(4) int nr_threads. Maximum number of worker treads, limits level of
parallelism.
-(5) monetdbe_remote* remote. Pointer to a monetdbe_remote object.
-(6) monetdbe_mapi_server* mapi_server. Pointer to a monetdbe_mapi_server
object.
-(7) const char *trace_file. File to which log output should be written.
+(5) monetdbe_remote\* remote. Pointer to a monetdbe_remote object.
+(6) monetdbe_mapi_server\* mapi_server. Pointer to a monetdbe_mapi_server
object.
+(7) const char \*trace_file. File to which log output should be written.
EXAMPLES
========
diff --git a/geom/sql/functions/Tests/All b/geom/sql/functions/Tests/All
--- a/geom/sql/functions/Tests/All
+++ b/geom/sql/functions/Tests/All
@@ -3,18 +3,15 @@ HAVE_GEOM?loadTestWKT
HAVE_GEOM?ST_PointFromText
HAVE_GEOM?ST_LineFromText
HAVE_GEOM?ST_PolygonFromText
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_MPointFromText
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_MPointFromText-3.12
+HAVE_GEOM?ST_MPointFromText
HAVE_GEOM?ST_MLineFromText
HAVE_GEOM?ST_MPolygonFromText
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_GeomFromText
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_GeomFromText-3.12
+HAVE_GEOM?ST_GeomFromText
HAVE_GEOM?dropTestWKT
HAVE_GEOM?ST_MakePoint
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_Collect
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_Collect-3.12
+HAVE_GEOM?ST_Collect
HAVE_GEOM?ST_MakeLine
HAVE_GEOM?loadTestPolygons
HAVE_GEOM?ST_Intersects
@@ -27,50 +24,38 @@ HAVE_GEOM?ST_DWithinRTree
HAVE_GEOM?loadTestGeometries
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_GeometryType
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_GeometryType-3.12
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_AsText
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_AsText-3.12
+HAVE_GEOM?ST_GeometryType
+HAVE_GEOM?ST_AsText
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_IsClosed
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_IsClosed-3.12
+HAVE_GEOM?ST_IsClosed
HAVE_GEOM?ST_IsEmpty
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_IsSimple
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_IsSimple-3.12
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_IsValid
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_IsValid-3.12
+HAVE_GEOM?ST_IsSimple
+HAVE_GEOM?ST_IsValid
HAVE_GEOM?ST_IsRing
HAVE_GEOM?XYZ
HAVE_GEOM?XYZMinMax
#HAVE_GEOM?srid
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_GeometryN
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_GeometryN-3.12
+HAVE_GEOM?ST_GeometryN
HAVE_GEOM?ST_NumGeometries
HAVE_GEOM?ST_NumPoints
HAVE_GEOM?ST_NPoints
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_NumInteriorRings
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_NumInteriorRings-3.12
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_NRings
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_NRings-3.12
+HAVE_GEOM?ST_NumInteriorRings
+HAVE_GEOM?ST_NRings
#HAVE_GEOM?transform
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_Contains
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_Contains-3.12
+HAVE_GEOM?ST_Contains
#HAVE_GEOM?equals
-HAVE_GEOM&GEOS_VERSION>=3.11.1&!GEOS_VERSION>=3.12.0?ST_Boundary
-HAVE_GEOM&GEOS_VERSION>=3.11.1&GEOS_VERSION>=3.12.0?ST_Boundary-3.12
+HAVE_GEOM&GEOS_VERSION>=3.11.1?ST_Boundary
HAVE_GEOM?ST_Dimension
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_CoordDim
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_CoordDim-3.12
+HAVE_GEOM?ST_CoordDim
-HAVE_GEOM&!GEOS_VERSION>=3.12.0?ST_AsEWKT
-HAVE_GEOM&GEOS_VERSION>=3.12.0?ST_AsEWKT-3.12
+HAVE_GEOM?ST_AsEWKT
#HAVE_GEOM?ST_Covers #Look at ST_Covers.sql for more details on the problem
#HAVE_GEOM?ST_CoveredBy #Look at ST_CoveredBy.sql for more details on the
problem
@@ -92,7 +77,6 @@ HAVE_GEOM?ST_MakeBox2D
HAVE_GEOM?dropTestGeometries
HAVE_GEOM?ST_DWithin2
-HAVE_GEOM&!GEOS_VERSION>=3.12.0&HAVE_PROJ?ST_Transform
-HAVE_GEOM&GEOS_VERSION>=3.12.0&HAVE_PROJ?ST_Transform-3.12
+HAVE_GEOM&HAVE_PROJ?ST_Transform
HAVE_GEOM?geomcasts
diff --git a/geom/sql/functions/Tests/ST_AsEWKT-3.12.reqtests
b/geom/sql/functions/Tests/ST_AsEWKT-3.12.reqtests
deleted file mode 100644
--- a/geom/sql/functions/Tests/ST_AsEWKT-3.12.reqtests
+++ /dev/null
@@ -1,1 +0,0 @@
-loadTestGeometries
diff --git a/geom/sql/functions/Tests/ST_AsEWKT-3.12.test
b/geom/sql/functions/Tests/ST_AsEWKT-3.12.test
deleted file mode 100644
--- a/geom/sql/functions/Tests/ST_AsEWKT-3.12.test
+++ /dev/null
@@ -1,219 +0,0 @@
-query T rowsort
-select st_asEWKT(st_pointfromtext('point(10 10)'))
-----
-SRID:0;POINT (10 10)
-
-query T rowsort
-select st_asEWKT(st_pointfromtext('point(20 20)', 4326))
-----
-SRID:4326;POINT (20 20)
-
-query T rowsort
-select st_asEWKT(st_pointfromtext('point(10 10 10)'))
-----
-SRID:0;POINT Z (10 10 10)
-
-query T rowsort
-select st_asEWKT(st_makepoint(10, 10))
-----
-SRID:0;POINT (10 10)
-
-query T rowsort
-select st_asEWKT(st_point(20, 20))
-----
-SRID:0;POINT (20 20)
-
-query T rowsort
-select st_asEWKT(st_makepoint(10, 10, 10))
-----
-SRID:0;POINT Z (10 10 10)
-
-query T rowsort
-select st_asEWKT(st_linefromtext('linestring(10 10, 20 20, 30 30)'))
-----
-SRID:0;LINESTRING (10 10, 20 20, 30 30)
-
-query T rowsort
-select st_asEWKT(st_linefromtext('linestring(20 20, 30 30, 40 40)', 4326))
-----
-SRID:4326;LINESTRING (20 20, 30 30, 40 40)
-
-query T rowsort
-select st_asEWKT(st_linefromtext('linestring(20 20 20, 30 30 30, 40 40 40)',
4326))
-----
-SRID:4326;LINESTRING Z (20 20 20, 30 30 30, 40 40 40)
-
-query T rowsort
-select st_asEWKT(st_polygonfromtext('polygon((10 10, 20 20, 30 30, 10 10))'))
-----
-SRID:0;POLYGON ((10 10, 20 20, 30 30, 10 10))
-
-query T rowsort
-select st_asEWKT(st_polygonfromtext('polygon((20 20, 30 30, 40 40, 20 20))',
4326))
-----
-SRID:4326;POLYGON ((20 20, 30 30, 40 40, 20 20))
-
-query T rowsort
-select st_asEWKT(st_polygonfromtext('polygon((10 10 10, 20 20 20, 30 30 30, 10
10 10))'))
-----
-SRID:0;POLYGON Z ((10 10 10, 20 20 20, 30 30 30, 10 10 10))
-
-query T rowsort
-select st_asEWKT(st_mpointfromtext('multipoint(10 10, 20 20)'))
-----
-SRID:0;MULTIPOINT ((10 10), (20 20))
-
-query T rowsort
-select st_asEWKT(st_mpointfromtext('multipoint(20 20, 30 30)', 4326))
-----
-SRID:4326;MULTIPOINT ((20 20), (30 30))
-
-query T rowsort
-select st_asEWKT(st_mpointfromtext('multipoint(20 20 20, 30 30 30)', 4326))
-----
-SRID:4326;MULTIPOINT Z ((20 20 20), (30 30 30))
-
-query T rowsort
-select st_asEWKT(st_mlinefromtext('multilinestring((10 10, 20 20, 30 30), (40
40, 50 50, 60 60))'))
-----
-SRID:0;MULTILINESTRING ((10 10, 20 20, 30 30), (40 40, 50 50, 60 60))
-
-query T rowsort
-select st_asEWKT(st_mlinefromtext('multilinestring((20 20, 30 30, 40 40), (50
50, 60 60, 70 70))', 4326))
-----
-SRID:4326;MULTILINESTRING ((20 20, 30 30, 40 40), (50 50, 60 60, 70 70))
-
-query T rowsort
-select st_asEWKT(st_mlinefromtext('multilinestring((20 20 20, 30 30 30, 40 40
40), (50 50 50, 60 60 60, 70 70 70))', 4326))
-----
-SRID:4326;MULTILINESTRING Z ((20 20 20, 30 30 30, 40 40 40), (50 50 50, 60 60
60, 70 70 70))
-
-query T rowsort
-select st_asEWKT(st_mpolyfromtext('multipolygon(((10 10, 20 20, 30 30, 10
10),(100 100, 200 200, 300 300, 100 100)))'))
-----
-SRID:0;MULTIPOLYGON (((10 10, 20 20, 30 30, 10 10), (100 100, 200 200, 300
300, 100 100)))
-
-query T rowsort
-select st_asEWKT(st_mpolyfromtext('multipolygon(((20 20, 30 30, 40 40, 20
20),(200 200, 300 300, 400 400, 200 200)))', 4326))
-----
-SRID:4326;MULTIPOLYGON (((20 20, 30 30, 40 40, 20 20), (200 200, 300 300, 400
400, 200 200)))
-
-query T rowsort
-select st_asEWKT(st_mpolyfromtext('multipolygon(((10 10 10, 20 20 20, 30 30
30, 10 10 10),(100 100 100, 200 200 200, 300 300 300, 100 100 100)))'))
-----
-SRID:0;MULTIPOLYGON Z (((10 10 10, 20 20 20, 30 30 30, 10 10 10), (100 100
100, 200 200 200, 300 300 300, 100 100 100)))
-
-query T rowsort
-select st_asEWKT(st_geomfromtext('point(10 10)'))
-----
-SRID:0;POINT (10 10)
-
-query T rowsort
-select st_asEWKT(st_geomfromtext('linestring(10 10, 20 20, 30 30)'))
-----
-SRID:0;LINESTRING (10 10, 20 20, 30 30)
-
-query T rowsort
-select st_asEWKT(st_geomfromtext('polygon((10 10, 20 20, 30 30, 10 10))'))
-----
-SRID:0;POLYGON ((10 10, 20 20, 30 30, 10 10))
-
-query T rowsort
-select st_asEWKT(st_geomfromtext('multipoint(10 10, 20 20)'))
-----
-SRID:0;MULTIPOINT ((10 10), (20 20))
-
-query T rowsort
-select st_asEWKT(st_geomfromtext('multilinestring((10 10, 20 20, 30 30), (40
40, 50 50, 60 60))'))
-----
-SRID:0;MULTILINESTRING ((10 10, 20 20, 30 30), (40 40, 50 50, 60 60))
-
-query T rowsort
-select st_asEWKT(st_geomfromtext('multipolygon(((10 10, 20 20, 30 30, 10
10),(100 100, 200 200, 300 300, 100 100)))'))
-----
-SRID:0;MULTIPOLYGON (((10 10, 20 20, 30 30, 10 10), (100 100, 200 200, 300
300, 100 100)))
-
-statement ok
-create table points_tbl(g geometry(point))
-
-statement ok
-insert into points_tbl values (st_pointfromtext('point(10 10)'))
-
-query T rowsort
-select st_asEWKT(g) from points_tbl
-----
-SRID:0;POINT (10 10)
-
-statement ok
-drop table points_tbl
-
-statement ok
-create table lines_tbl(g geometry(linestring))
-
-statement ok
-insert into lines_tbl values (st_linefromtext('linestring(10 10, 20 20, 30
30)'))
-
-query T rowsort
-select st_asEWKT(g) from lines_tbl
-----
-SRID:0;LINESTRING (10 10, 20 20, 30 30)
-
-statement ok
-drop table lines_tbl
-
-statement ok
-create table polygons_tbl(g geometry(polygon))
-
-statement ok
-insert into polygons_tbl values (st_polygonfromtext('polygon((10 10, 20 20, 30
30, 10 10))'))
-
-query T rowsort
-select st_asEWKT(g) from polygons_tbl
-----
-SRID:0;POLYGON ((10 10, 20 20, 30 30, 10 10))
-
-statement ok
-drop table polygons_tbl
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
