Opened 4 years ago

Closed 4 years ago

#983 closed defect (fixed)

Spatial filters may not work in MySQL 8.0

Reported by: jng Owned by: jng
Priority: major Milestone:
Component: MySQL Provider Version:
Severity: 3 Keywords:
Cc: External ID:

Description

For MySQL 8.0, the geometry used for spatial filter testing must have coordinates in the correct axis orientation if the CRS is geographic.

The current MySQL provider is not aware of this new fact and spatial queries on tables with geographic CRSs (eg. srid=4326) will fail as a result.

Attachments (1)

983.patch​ (3.8 KB ) - added by jng 4 years ago.

Download all attachments as: .zip

Change History (2)

by jng, 4 years ago

Attachment: 983.patch​ added

comment:1 by jng, 4 years ago

Resolution: → fixed
Status: assigned → closed

In 8017:

Fix spatial filter SQL generation for MySQL 8.0 due to a breaking change in how geometry coordinates are supposed to be interpreted for geographic SRIDs (they're not expected to be in lat/long orientation instead of long/lat)

Fixes #983

Note: See TracTickets for help on using tickets.