Describe the bug getting no result when introduce multiple geospa

Hi <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="

[BUG] getting incorrect result with multiple geospatial conditions in query about redisearch HOT 1 OPEN

atakavci commented on June 22, 2024

[BUG] getting incorrect result with multiple geospatial conditions in query

from redisearch.

Comments (1)

raz-mon commented on June 22, 2024

Hi @atakavci, thanks for reaching out!
I have checked and verified your findings:
No result is returned for the interserction:

127.0.0.1:6379> "FT.SEARCH" "idx" "@geofield:[DISJOINT $geospatials0] @geofield2:[INTERSECTS $geospatials1]" "PARAMS" "4" "geospatials0" "POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))" "geospatials1" "POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))" "DIALECT" "3"
1) (integer) 0

While the correct result is returned when searching for each component of the intersection:

127.0.0.1:6379> "FT.SEARCH" "idx" "@geofield:[DISJOINT $geospatials0]" "PARAMS" "4" "geospatials0" "POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))" "geospatials1" "POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))" "DIALECT" "3"
1) (integer) 1
2) "doc1"
3) 1) "geofield"
   2) "POINT (10  10)"
   3) "geofield2"
   4) "POLYGON ((20 20, 25 35, 35 25, 20 20))"
127.0.0.1:6379> "FT.SEARCH" "idx" "@geofield2:[INTERSECTS $geospatials1]" "PARAMS" "4" "geospatials0" "POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))" "geospatials1" "POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))" "DIALECT" "3"
1) (integer) 1
2) "doc1"
3) 1) "geofield"
   2) "POINT (10  10)"
   3) "geofield2"
   4) "POLYGON ((20 20, 25 35, 35 25, 20 20))"

It seems that the parsing is fine:

127.0.0.1:6379> "FT.EXPLAINCLI" "idx" "@geofield:[DISJOINT $geospatials0] @geofield2:[INTERSECTS $geospatials1]" "PARAMS" "4" "geospatials0" "POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))" "geospatials1" "POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))" "DIALECT" "3"
1) INTERSECT {
2)   GEOSHAPE{3 POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))}
3)   GEOSHAPE{4 POLYGON ((15 15, 75 15, 50 70, 20 40, 15 15))}
4) }
5)

There indeed may be a problem here. An internal ticket was created, we will look into this and update when we have more details

from redisearch.

Recommend Projects