You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/07/14 13:53:44 UTC

[GitHub] [doris] King0513 opened a new issue, #10865: Delete statements should support expressions [Feature]

King0513 opened a new issue, #10865:
URL: https://github.com/apache/doris/issues/10865

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Description
   
   delete语句的where条件只能给常量,不能用表达式。这个我刚改在1.0版本上测试还是不行。
   
   
   ### Use case
   
   都支持
   select * from example_db.test_aggkey where bus_date ='2017-11-20';
   select * from example_db.test_aggkey where bus_date =CURRENT_DATE();
   
   支持
   delete from  example_db.test_aggkey where bus_date ='2017-11-20';
   不支持
   delete from  example_db.test_aggkey where bus_date =CURRENT_DATE();
   
   ### Related issues
   
   =和in看能不能都考虑一下。可以继续要求必须是key字段才能作为删除的条件,但是表达式和in最好可以
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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-unsubscribe@doris.apache.org.apache.org

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


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