[SEDONA-182] ST_AsText should not return SRID

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Martin Andersson
• Created: 25/Oct/22 11:17
• Updated: 25/Oct/22 19:07
• Resolved: 25/Oct/22 19:07

Description

There was a regression that changed the behavior of ST_AsText. Now it returns EWKT instead of WKT. See  https://github.com/apache/incubator-sedona/commit/26aba91ead4f06558880be7dda745cf3c05581e8

ST_AsText should return WKT, without SRID. From postgis:

dw=> select ST_AsText(ST_SetSRID(ST_Point(1,1), 3021));
 st_astext  
------------
 POINT(1 1)
(1 row)

dw=> select ST_AsEWKT(ST_SetSRID(ST_Point(1,1), 3021));
      st_asewkt       
----------------------
 SRID=3021;POINT(1 1)
(1 row)

 

Issue Links

• links to: GitHub Pull Request #703