LiBinfeng-01 opened a new pull request, #23073: URL: https://github.com/apache/doris/pull/23073
cherry pick from master pr (#22840) commit id: 2dbca7a68874f257deac9b329a1f831fe2b2856c Problem: When executing group_concat with order by inside in view, column can not be found when analyze. Example: create view if not exists test_view as select group_concat(c1,',' order by c1 asc) from table_group_concat; select * from test_view; it will return an error like: "can not find c1 in table_list" Reason: When we executing this sql in multi-instance environment, Planner would try to create plan in multi phase aggregation. And because we analyze test_view independent with tables outside view. So we can not get table informations inside view. Solution: Substitute order by expression of merge aggregation expressions. ## Proposed changes Issue Number: close #xxx <!--Describe your changes.--> ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- 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 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
