[jira] [Updated] (IMPALA-15193) st_intersects incorrect with multlinestring

["Quanlong Huang (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-15193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Quanlong Huang updated IMPALA-15193:
------------------------------------
    Fix Version/s: Impala 5.0.0

> st_intersects incorrect with multlinestring
> -------------------------------------------
>
>                 Key: IMPALA-15193
>                 URL: https://issues.apache.org/jira/browse/IMPALA-15193
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Jason Fehr
>            Assignee: Jason Fehr
>            Priority: Critical
>             Fix For: Impala 5.0.0
>
>
> select st_intersects(st_geomfromtext('LINESTRING(1 0, 1 1)'), st_geomfromtext('MULTILINESTRING((0 0, 0 1), (2 0, 2 1))'));
> The x coordinate is 1 in the linestring, while 0 and 2 own the multilinestring, so they obviously don't intersect.
> The query above returns true in Hive.
> Cross checked with postgis, which returns false.
> Discovered this when testing Apache Impala's new c++ implementation that used boost::geometry, which also returns false.
> The following query also returns true when it should return false:
> select st_intersects(st_geomfromtext('MULTILINESTRING((2 0, 2 2),(3 0, 3 2))'), st_geomfromtext('MULTILINESTRING((0 0, 0 2), (4 0, 4 2))'));



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org