[MDEV-8610] "WHERE CONTAINS(indexed_geometry_column,1)" causes full table scan - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1(EOL)
Fix Version/s: 10.1.7
Component/s: Optimizer
Labels:
None

Description

DROP TABLE IF EXISTS t1;

CREATE TABLE t1  (a GEOMETRY NOT NULL, SPATIAL KEY(a)) ENGINE=MyISAM;

INSERT INTO t1 VALUES (Point(1,1)),(Point(2,2)),(Point(3,3));

EXPLAIN SELECT * FROM t1 WHERE CONTAINS(a,1);

returns

+------+-------------+-------+------+---------------+------+---------+------+------+-------------+

| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | Extra       |

+------+-------------+-------+------+---------------+------+---------+------+------+-------------+

|    1 | SIMPLE      | t1    | ALL  | a             | NULL | NULL    | NULL |    3 | Using where |

+------+-------------+-------+------+---------------+------+---------+------+------+-------------+

This is wrong. CONTAINS() and other spatial relations should report "Impossible WHERE" on attempt to use non-geometry values. There is no a need to do the full table scan, the result will be empty set anyway.

Attachments

Activity

Ascending order - Click to sort in descending order

Alexander Barkov created issue - 2015-08-13 12:13

Alexander Barkov made changes - 2015-08-13 13:38

Field	Original Value	New Value
Fix Version/s		10.1.7 [ 19604 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:41

Workflow

MariaDB v3 [ 71026 ]

MariaDB v4 [ 149468 ]

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2015-08-13 12:13

Updated:: 2015-08-13 13:38

Resolved:: 2015-08-13 13:38

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server