[GitHub] [incubator-doris] wangbo opened a new issue #1626: Insert select Stmt keep the same semantics with mysql

[GitBox <gi...@apache.org>]

wangbo opened a new issue #1626: Insert select Stmt  keep the same semantics with mysql
URL: https://github.com/apache/incubator-doris/issues/1626
 
 
   **Question**
   When doing Insert Select stmt in doris,if the select stmt returns epmty set, it will returns a error which content is "all partitions have no load data".
   But when the same case won't happends in MySQL
   It's neccessary to make doris keep the same semantics with mysql
   
   **Key point:how to know Select stmt returns empty set**
   - When Insert Select stmt finish executing,all be fragment reports OK status to fe,the Coordinator.tabletCommitInfos is empty means Select stmt returns empty set
   - When Insert Select stmt finish executing,at least one fragment reports Error status to fe,then the whole stmt will return error,there is no need to check Coordinator.tabletCommitInfos
   
   **What to do when Select stmt return empty set**
   - set status of ConnectContext  to OK and return, before method Catalog.getCurrentGlobalTransactionMgr().commitAndPublishTransaction,this will skip checking Coordinator.tabletCommitInfos,and error won't happen
   
   
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@doris.apache.org
For additional commands, e-mail: dev-help@doris.apache.org