[PHOENIX-619] Support DELETE over table with immutable index when possible

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.2.0, 3.2.0
• Labels: enhancement
• old issue number: 488
• Assignee: Unassigned
• Reporter: Artur Denysenko
• Created: 10/Mar/14 23:47
• Updated: 21/Nov/15 02:16
• Resolved: 21/Oct/14 20:57

Description

I try to delete rows in this table:
```sql
CREATE TABLE test.date2(
id BIGINT NOT NULL PRIMARY KEY,
d DATE NOT NULL
) IMMUTABLE_ROWS=true;

CREATE INDEX idx_d ON test.date2(d);

DELETE FROM test.date2;
```

I do not understand why we have this limitation.
DELETE works fine in tables with "IMMUTABLE_ROWS=false" and no "PK column in index".

It's must be also reflected in "Phoenix Language Reference".