gojumprope opened a new issue, #24430: URL: https://github.com/apache/doris/issues/24430
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.0 ### What's Wrong? When a query select from an any table and union just a query without selecting from any table will cause "where" condition to only filter the query with selecting table ### What You Expected? return correct result ### How to Reproduce? ``` SELECT * FROM ( SELECT DISTINCT 'A' AS `Type` FROM any_table UNION SELECT 'B' AS `Type` UNION SELECT 'C' AS `Type` UNION SELECT 'D' AS `Type` ) t WHERE `Type` in ('A') ``` Type| ----+ B | C | D | A | ``` SELECT * FROM ( SELECT DISTINCT 'A' AS `Type` FROM any_table UNION SELECT 'B' AS `Type` UNION SELECT 'C' AS `Type` UNION SELECT 'D' AS `Type` ) t WHERE `Type` in ('B', 'C') ``` Type| ----+ B | C | D | ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] 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
