[MDEV-32619] ST_PointFromWKB ignores SRID parameter and returns 0 Created: 2023-10-29  Updated: 2023-12-13

Status: Confirmed
Project: MariaDB Server
Component/s: Data types, GIS
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 10.11.4
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Major
Reporter: Ryan Griggs Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 0
Labels: bug, spatial
Environment:

Debian 12


 Description   

The ST_PointFromWKB() function ignores the SRID parameter and returns 0 regardless of specified SRID parameter.

To reproduce this behavior:

SELECT ST_SRID(ST_PointFromWKB(POINT(1,2), 4326));

Should return 4326, but returns 0.

If creating the point from Well Known Text instead, the SRID is preserved (expected behavior)

SELECT ST_SRID(ST_PointFromText('POINT(1 2)', 4326))

Returns 4326 as expected.

 Comments   
Comment by Ryan Griggs [ 2023-10-30 ]

I can also confirm that this problem exists with ST_LineStringFromWKB() and most likely all the ...FromWKB() functions.

Example:
{{SELECT ST_SRID(ST_LineStringFromWKB(LINESTRING(POINT(1.23, 4.56), POINT(4.56,7.89)), 4326));
– Returns 0 (should return 4326)}}

Comment by Ryan Griggs [ 2023-12-13 ]

I'm following up to see when this issue will be fixed. Thanks.

Generated at Thu Feb 08 10:32:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.