Changes between Initial Version and Version 1 of Ticket #5580


Ignore:
Timestamp:
Oct 18, 2023, 9:10:48 PM (7 months ago)
Author:
Wenjing
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5580

    • Property Priority medium → high

  • Ticket #5580 – Description

    initial v1  
    11Consider this query:
    22
     3{{{
     4SELECT
     5ST_Intersects(a1, a2)
     6FROM ST_GeomFromText('GEOMETRYCOLLECTION(POINT EMPTY, POINT (0 0))') As a1
     7, ST_GeomFromText('POINT (0 0)') As a2;
     8--excepted{t}
     9}}}
     10When using the 2D Intersects function in this situation, the expected result is true and PostGIS returns true.
     11
     12But consider its 3D version:
    313{{{
    414SELECT
    … …  
    1222But the 3DIntersects function doesn't consider they intersect only when inserting an empty geometry before this point.
    1323
    14 Moreover, using the 2D Intersects function in this situation, we can get the expected result that they intersect.