LiBinfeng-01 opened a new pull request, #22840:
URL: https://github.com/apache/doris/pull/22840

   ## Proposed changes
   
   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:
   Add table informations to outside analyzer from inside view.
   
   ## 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

Reply via email to