LPexportBug857066.xml
LPexportBug857066_bug857066.sql
[MDEV-3321] LP:857066 - Wrong result with ST_DISJOINT when using an index Created: 2011-09-23 Updated: 2015-02-02 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | ||
| Reporter: | Philip Stoev (Inactive) | Assignee: | Alexey Botchkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
LPexportBug857066.xml
LPexportBug857066_bug857066.sql
|
| Description |
|
The following query: SELECT count returns 300 rows even though the same query executed with a full table scan or in PostGis returns 3711 rows. |
| Comments |
| Comment by Philip Stoev (Inactive) [ 2011-09-23 ] |
|
Re: Wrong result with ST_DISJOINT when using an index |
| Comment by Philip Stoev (Inactive) [ 2011-09-23 ] |
|
Dataset for this bug |
| Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ] |
|
Launchpad bug id: 857066 |
FROM linestring FORCE KEY ( linestring_key ) WHERE ST_DISJOINT( GeomFromText('LINESTRING( 4045 3043 , 3987 3025 , 3757 3154 )') , linestring_key );