[I] ST_EqualsIdentical returns false for a stored 2D geometry and the same geometry parsed from WKT [sedona]

["jiayuasu (via GitHub)" <gi...@apache.org>]

jiayuasu opened a new issue, #3458:
URL: https://github.com/apache/sedona/issues/3458

   `ST_EqualsIdentical` compares two coordinate sequences only when they have the same in-memory dimension. WKT parsing produces JTS default coordinate sequences, which hold ordinary 2D coordinates with a NaN Z ordinate (dimension 3), while the geometry serializer reads a stored 2D geometry back as declared XY (dimension 2). So a 2D geometry from a stored geometry column is never identical to the same geometry built in the query:
   
   ```sql
   -- t.geom stores POINT (1 2)
   SELECT ST_EqualsIdentical(geom, ST_GeomFromWKT('POINT (1 2)')) FROM t  -- false
   ```
   
   The same happens for line strings, polygons and multi geometries. Comparing two stored columns, or two parsed geometries, is not affected.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@sedona.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] ST_EqualsIdentical returns false for a stored 2D geometry and the same geometry parsed from WKT [sedona]

["jiayuasu (via GitHub)" <gi...@apache.org>]

jiayuasu closed issue #3458: ST_EqualsIdentical returns false for a stored 2D geometry and the same geometry parsed from WKT
URL: https://github.com/apache/sedona/issues/3458


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@sedona.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org