From d3d9f3a5a4a0864dd626d1fe634c19c3ec9336d4 Mon Sep 17 00:00:00 2001 From: Mariusz Felisiak Date: Wed, 12 Feb 2025 23:16:34 +0100 Subject: [5.2.x] Reverted "Refs #35803 -- Added support for __coveredby GIS lookup on MariaDB 11.7+." This partly reverts commit 0b7edb9fcdd33d47ec5701b4f9b9553e27a88e95. MariaDB reverted GIS functions. Backport of 54a902c6e81214462388f79a7c42f1c88c863dfd from main. --- docs/ref/contrib/gis/db-api.txt | 2 +- docs/ref/contrib/gis/geoquerysets.txt | 5 ++--- 2 files changed, 3 insertions(+), 4 deletions(-) (limited to 'docs/ref') diff --git a/docs/ref/contrib/gis/db-api.txt b/docs/ref/contrib/gis/db-api.txt index 02b8fafb34..f2b036dac4 100644 --- a/docs/ref/contrib/gis/db-api.txt +++ b/docs/ref/contrib/gis/db-api.txt @@ -347,7 +347,7 @@ Lookup Type PostGIS Oracle MariaDB MySQL [#]_ S :lookup:`contained` X X X X N :lookup:`contains ` X X X X X B :lookup:`contains_properly` X B -:lookup:`coveredby` X X X (≥ 11.7) X X B +:lookup:`coveredby` X X X X B :lookup:`covers` X X X X B :lookup:`crosses` X X X X C :lookup:`disjoint` X X X X X B diff --git a/docs/ref/contrib/gis/geoquerysets.txt b/docs/ref/contrib/gis/geoquerysets.txt index 6384dad2c9..d73367465f 100644 --- a/docs/ref/contrib/gis/geoquerysets.txt +++ b/docs/ref/contrib/gis/geoquerysets.txt @@ -183,7 +183,7 @@ PostGIS ``ST_ContainsProperly(poly, geom)`` ------------- *Availability*: `PostGIS `__, -Oracle, MariaDB 11.7+, MySQL, PGRaster (Bilateral), SpatiaLite +Oracle, MySQL, PGRaster (Bilateral), SpatiaLite Tests if no point in the geometry field is outside the lookup geometry. [#fncovers]_ @@ -197,14 +197,13 @@ Backend SQL Equivalent ========== ============================= PostGIS ``ST_CoveredBy(poly, geom)`` Oracle ``SDO_COVEREDBY(poly, geom)`` -MariaDB ``MBRCoveredBy(poly, geom)`` MySQL ``MBRCoveredBy(poly, geom)`` SpatiaLite ``CoveredBy(poly, geom)`` ========== ============================= .. versionchanged:: 5.2 - MySQL and MariaDB 11.7+ support was added. + MySQL support was added. .. fieldlookup:: covers -- cgit v1.3