[Django] #35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on MariaDB 11.7+

19 views
Skip to first unread message

Django

unread,
Sep 28, 2024, 11:37:43 AM9/28/24
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz | Owner: Mariusz Felisiak
Felisiak |
Type: New | Status: assigned
feature |
Component: GIS | Version: dev
Severity: Normal | Keywords: mariadb
Triage Stage: | Has patch: 1
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Support for `MBRCoveredBy`, `ST_GeoHash`, `ST_IsValid`, `ST_Collect`
[https://mariadb.com/kb/en/mariadb-11-7-0-release-notes/#gis was added in
MariaDB 11.7].

Moreover, [https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-
functions-mbr.html#function_mbrcoveredby MySQL support] `MBRCoveredBy`.
--
Ticket URL: <https://code.djangoproject.com/ticket/35803>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Sep 28, 2024, 11:37:57 AM9/28/24
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: GIS | Version: dev
Severity: Normal | Resolution:
Keywords: mariadb | Triage Stage:
| Unreviewed
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Mariusz Felisiak):

[https://github.com/django/django/pull/18631 PR]
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:1>

Django

unread,
Sep 29, 2024, 5:39:38 AM9/29/24
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: GIS | Version: dev
Severity: Normal | Resolution:
Keywords: mariadb | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Claude Paroz):

* stage: Unreviewed => Accepted

Comment:

Thanks!
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:2>

Django

unread,
Oct 24, 2024, 3:06:36 AM10/24/24
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: GIS | Version: dev
Severity: Normal | Resolution:
Keywords: mariadb | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Sarah Boyce <42296566+sarahboyce@…>):

In [changeset:"ef28b05767482bf9c98acc19ffd1334f75165b5a" ef28b057]:
{{{#!CommitTicketReference repository=""
revision="ef28b05767482bf9c98acc19ffd1334f75165b5a"
Refs #35803 -- Added more tests for __coveredby and __covers GIS lookups.

Co-authored-by: David Smith <smi...@gmail.com>
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:3>

Django

unread,
Oct 25, 2024, 1:55:31 AM10/25/24
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: GIS | Version: dev
Severity: Normal | Resolution:
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Sarah Boyce):

* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:4>

Django

unread,
Oct 25, 2024, 1:56:04 AM10/25/24
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: closed
Component: GIS | Version: dev
Severity: Normal | Resolution: fixed
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Sarah Boyce <42296566+sarahboyce@…>):

* resolution: => fixed
* status: assigned => closed

Comment:

In [changeset:"c77573716a58af32ffcfc4fe87ff9e5c97909bd2" c7757371]:
{{{#!CommitTicketReference repository=""
revision="c77573716a58af32ffcfc4fe87ff9e5c97909bd2"
Fixed #35803 -- Added support for Collect, GeoHash, and IsValid on MariaDB
11.7+.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:6>

Django

unread,
Oct 25, 2024, 1:56:04 AM10/25/24
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: closed
Component: GIS | Version: dev
Severity: Normal | Resolution: fixed
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Sarah Boyce <42296566+sarahboyce@…>):

In [changeset:"5cf88dcc570f6c9ed04f5183e7884ea49048b9ea" 5cf88dcc]:
{{{#!CommitTicketReference repository=""
revision="5cf88dcc570f6c9ed04f5183e7884ea49048b9ea"
Refs #35803 -- Added support for __covers GIS lookup on MySQL.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:7>

Django

unread,
Oct 25, 2024, 1:56:05 AM10/25/24
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: GIS | Version: dev
Severity: Normal | Resolution:
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Sarah Boyce <42296566+sarahboyce@…>):

In [changeset:"0b7edb9fcdd33d47ec5701b4f9b9553e27a88e95" 0b7edb9]:
{{{#!CommitTicketReference repository=""
revision="0b7edb9fcdd33d47ec5701b4f9b9553e27a88e95"
Refs #35803 -- Added support for __coveredby GIS lookup on MySQL and
MariaDB 11.7+.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:5>

Django

unread,
Feb 12, 2025, 5:22:48 PMFeb 12
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: new
Component: GIS | Version: 5.2
Severity: Release blocker | Resolution:
Keywords: mariadb | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* resolution: fixed =>
* severity: Normal => Release blocker
* stage: Ready for checkin => Accepted
* status: closed => new
* version: dev => 5.2

Comment:

Unfortunately, MariaDB decided to revert GIS functions:
- https://jira.mariadb.org/browse/MDEV-34120
- https://mariadb.com/kb/en/mariadb-11-7-0-release-notes/#gis
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:8>

Django

unread,
Feb 12, 2025, 5:22:57 PMFeb 12
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: GIS | Version: 5.2
Severity: Release blocker | Resolution:
Keywords: mariadb | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* status: new => assigned

--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:9>

Django

unread,
Feb 13, 2025, 3:35:19 AMFeb 13
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: assigned
Component: GIS | Version: 5.2
Severity: Release blocker | Resolution:
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Sarah Boyce):

* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:10>

Django

unread,
Feb 13, 2025, 4:38:14 AMFeb 13
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: closed
Component: GIS | Version: 5.2
Severity: Release blocker | Resolution: fixed
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Sarah Boyce <42296566+sarahboyce@…>):

* resolution: => fixed
* status: assigned => closed

Comment:

In [changeset:"eb70aafdba18ac30e53056162c32ee6c21dea0b4" eb70aafd]:
{{{#!CommitTicketReference repository=""
revision="eb70aafdba18ac30e53056162c32ee6c21dea0b4"
Reverted "Fixed #35803 -- Added support for Collect, GeoHash, and IsValid
on MariaDB 11.7+."

This reverts commit c77573716a58af32ffcfc4fe87ff9e5c97909bd2.

MariaDB reverted GIS functions.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:11>

Django

unread,
Feb 13, 2025, 4:38:15 AMFeb 13
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: closed
Component: GIS | Version: 5.2
Severity: Release blocker | Resolution: fixed
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Sarah Boyce <42296566+sarahboyce@…>):

In [changeset:"54a902c6e81214462388f79a7c42f1c88c863dfd" 54a902c]:
{{{#!CommitTicketReference repository=""
revision="54a902c6e81214462388f79a7c42f1c88c863dfd"
Reverted "Refs #35803 -- Added support for __coveredby GIS lookup on
MariaDB 11.7+."

This partly reverts commit 0b7edb9fcdd33d47ec5701b4f9b9553e27a88e95.

MariaDB reverted GIS functions.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:12>

Django

unread,
Feb 13, 2025, 4:41:33 AMFeb 13
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: closed
Component: GIS | Version: 5.2
Severity: Release blocker | Resolution: fixed
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Sarah Boyce <42296566+sarahboyce@…>):

In [changeset:"fc1961817115ae9737d64ca92942d02ce77d5fc2" fc196181]:
{{{#!CommitTicketReference repository=""
revision="fc1961817115ae9737d64ca92942d02ce77d5fc2"
[5.2.x] Reverted "Fixed #35803 -- Added support for Collect, GeoHash, and
IsValid on MariaDB 11.7+."

This reverts commit c77573716a58af32ffcfc4fe87ff9e5c97909bd2.

MariaDB reverted GIS functions.

Backport of eb70aafdba18ac30e53056162c32ee6c21dea0b4 from main.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:13>

Django

unread,
Feb 13, 2025, 4:41:35 AMFeb 13
to django-...@googlegroups.com
#35803: Add support for Collect, GeoHash, IsValid, and __coveredby lookup on
MariaDB 11.7+
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
| Felisiak
Type: New feature | Status: closed
Component: GIS | Version: 5.2
Severity: Release blocker | Resolution: fixed
Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Sarah Boyce <42296566+sarahboyce@…>):

In [changeset:"d3d9f3a5a4a0864dd626d1fe634c19c3ec9336d4" d3d9f3a5]:
{{{#!CommitTicketReference repository=""
revision="d3d9f3a5a4a0864dd626d1fe634c19c3ec9336d4"
[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.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35803#comment:14>
Reply all
Reply to author
Forward
0 new messages