Wrong result with ST_DISJOINT when using an index

Bug #857066 reported by Philip Stoev
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.

Revision history for this message
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.