Wrong result with ST_DISJOINT when using an index

Bug #857066 reported by Philip Stoev on 2011-09-23
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Undecided
Alexey Botchkov

Bug Description

The following query:

SELECT count(*) FROM linestring FORCE KEY ( linestring_key ) WHERE ST_DISJOINT( GeomFromText('LINESTRING( 4045 3043 , 3987 3025 , 3757 3154 )') , linestring_key );

returns 300 rows even though the same query executed with a full table scan or in PostGis returns 3711 rows.

Philip Stoev (pstoev-askmonty) wrote :
Changed in maria:
assignee: nobody → Alexey Botchkov (holyfoot)
Changed in maria:
milestone: none → 5.3
Changed in maria:
status: New → Fix Committed
Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers