[GitHub] [doris] zhengzhou-spark commented on issue #18153: [Feature] delete不支持where条件中in使用子查询

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

zhengzhou-spark commented on issue #18153:
URL: https://github.com/apache/doris/issues/18153#issuecomment-1588387757

   delete语句的where条件必须是一个常量值，不能是计算出来的值，例如：
   delete from db.table where date >= date_sub(CURRENT_DATE(), interval 7 day);
   这样的语句也不行，报错：
   SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Right expr of binary predicate should be value。
   
   建议尽快支持这类语法，实时数仓中这类语法场景相当多。


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

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