zhengzhou-spark opened a new issue, #20705: URL: https://github.com/apache/doris/issues/20705
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description 删除语句中的动态条件，目前版本是不支持的。如果执行SQL语句： delete from db.table where stat_date >= date_sub(CURRENT_DATE(), interval 7 day); 报错： SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Right expr of binary predicate should be value Doris后续版本能否支持这个动态删除条件？哪个版本能够支持？实时数仓中，类似"删除昨天的数据"场景是比较多的。 ### Solution from db.table where stat_date >= date_sub(CURRENT_DATE(), interval 7 day);能够正常执行，不报错。 ### 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-unsubscr...@doris.apache.org.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
