doris icon indicating copy to clipboard operation
doris copied to clipboard

[Improvement](delete) check delete from column exists on mv

Open BiteTheDDDDt opened this issue 1 year ago • 2 comments

Proposed changes

check delete from column exists on mv

# before
mysql [test]>delete from a_table where k2=1;
ERROR 1064 (HY000): errCode = 2, detailMessage = delete job timeout, timeout(ms):30000, msg:unfinished replicas [BackendId=TabletId]: 10006=1228738, 10006=1229051, 10006=1228736, 10006=1228734, 10006=1229055

# after
set enable_fallback_to_original_planner=false;

mysql [test]>delete from a_table where k2=1;
ERROR 1105 (HY000): errCode = 2, detailMessage = Column[k2] not exist in index ma1. maybe you need drop the corresponding materialized-view.

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...

BiteTheDDDDt avatar Feb 23 '24 07:02 BiteTheDDDDt

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR

doris-robot avatar Feb 23 '24 07:02 doris-robot

run buildall

BiteTheDDDDt avatar Feb 23 '24 07:02 BiteTheDDDDt

PR approved by at least one committer and no changes requested.

github-actions[bot] avatar Feb 26 '24 01:02 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Feb 26 '24 01:02 github-actions[bot]