[PHOENIX-4290] Full table scan performed for DELETE with table having immutable indexes - ASF JIRA

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 4.13.0
Labels:
- rowDeletion

Description

If a DELETE command is issued with a partial match for the leading part of the primary key, instead of using the data table, when the table has immutable indexes, a full scan will occur against the index.

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending

Attachments

PHOENIX-4290_wip1.patch
25/Oct/17 01:46
57 kB
James Taylor
PHOENIX-4290_wip2.patch
25/Oct/17 07:57
56 kB
James Taylor
PHOENIX-4290_wip3.patch
26/Oct/17 05:32
72 kB
James Taylor
PHOENIX-4290_wip4.patch
26/Oct/17 15:40
72 kB
James Taylor
PHOENIX-4290_wip5.patch
27/Oct/17 08:22
78 kB
James Taylor
PHOENIX-4290_wip6.patch
27/Oct/17 16:31
85 kB
James Taylor
PHOENIX-4290_wip7.patch
27/Oct/17 20:28
89 kB
James Taylor
PHOENIX-4290_wip8.patch
28/Oct/17 06:52
95 kB
James Taylor
PHOENIX-4290_wip9.patch
28/Oct/17 17:52
95 kB
James Taylor
PHOENIX-4290_wip10.patch
29/Oct/17 14:18
95 kB
James Taylor
PHOENIX-4290_v1.patch
29/Oct/17 17:23
102 kB
James Taylor
PHOENIX-4290_v2.patch
29/Oct/17 22:03
103 kB
James Taylor
PHOENIX-4290_v3.patch
31/Oct/17 06:02
103 kB
James Taylor

Activity

People

Assignee:

James Taylor

Reporter:

James Taylor

Votes:

0 Vote for this issue

Watchers:

3 Start watching this issue

Dates

Created:

16/Oct/17 18:47

Updated:

26/Jul/18 01:12

Resolved:

31/Oct/17 06:27