UnicornLee opened a new issue, #18153: URL: https://github.com/apache/doris/issues/18153
### 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 delete不支持where条件中in使用子查询，如下sql： ```sql delete from ipo_appr_detail_echart where id in (select id from (SELECT t.id FROM ipo_appr_detail_echart t left JOIN (SELECT iad.appr_date as apprDate FROM ipo_appr_detail iad WHERE iad.statistic_type IS NOT NULL AND iad.statistic_type != '18' AND iad.statistic_type != '' AND iad.case_type = '1' AND ( date_format(iad.appr_date, '%w') = '4' OR iad.appr_date = date_sub(curdate(), interval 1 day)) AND iad.appr_date <= date_sub(curdate(), interval 1 day) and iad.appr_date >= '2017-01-01' GROUP BY iad.appr_date) t1 on t.appr_date = t1.apprDate WHERE t1.apprDate is null) temp); ``` 希望能支持这种sql写法 ### Use case _No response_ ### Related issues _No response_ ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
