[PR] [fix] Fix fail when drop table column when sync mv which not use the dropped column exits on table [doris]

[via GitHub]

seawinde opened a new pull request, #48565:
URL: https://github.com/apache/doris/pull/48565

   ### What problem does this PR solve?
   
   this is brought by https://github.com/apache/doris/pull/4014
   
   schema is as following:
   
   ```sql
   drop database db;
   
   create database db;
   
   CREATE TABLE db.t (
       id int null,
       k largeint null,
       d date null,
       k1 int
   )
   PARTITION BY RANGE (`id`) (
       partition p1 values [(1), (2))
   )
   DISTRIBUTED BY HASH(`k`, `id`) BUCKETS 16
   PROPERTIES (
       "replication_num" = "1"
   );
   
   create materialized view db.mv_t as select d from db.t;
   
   ```
   
   if run drop sql as following  would fail with message 
`OriginStatement{originStmt='create materialized view db.mv_t as select d from 
db.t', idx=0}`, the pr fix this
   
   ```sql
   
   alter table db.t drop column k1;
   ```
   
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   
   ### Release note
   
   Fix fail when drop table column when sync mv exits on table
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [x] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: 
https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should 
merge into -->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org