[GitHub] [doris] zhengzhou-spark opened a new issue, #20705: Right expr of binary predicate should be value

["zhengzhou-spark (via GitHub)" <gi...@apache.org>]

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-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