You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "gojumprope (via GitHub)" <gi...@apache.org> on 2023/05/17 08:58:02 UTC

[GitHub] [doris] gojumprope opened a new issue, #19748: [Bug] Create view error when using group concat with order by

gojumprope opened a new issue, #19748:
URL: https://github.com/apache/doris/issues/19748

   ### 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
   
   1.2.4.1
   
   ### What's Wrong?
   
   SQL Error [1105] [HY000]: errCode = 2, detailMessage = failed to init view stmt
   
   ### What You Expected?
   
   able to create view with group concat order by
   
   ### How to Reproduce?
   
   CREATE VIEW test_groupconcat_orderby AS
   SELECT day, GROUP_CONCAT(time ORDER BY time) FROM (
   	SELECT 'Monday' day, '15:00-21:00' time
   	UNION
   	SELECT 'Monday' day, '09:00-13:00' time
   ) tab
   GROUP BY day
   
   ### 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-unsubscribe@doris.apache.org.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

[GitHub] [doris] gojumprope closed issue #19748: [Bug] Create view error when using group concat with order by

Posted by "gojumprope (via GitHub)" <gi...@apache.org>.
gojumprope closed issue #19748: [Bug] Create view error when using group concat with order by 
URL: https://github.com/apache/doris/issues/19748


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

[GitHub] [doris] gojumprope commented on issue #19748: [Bug] Create view error when using group concat with order by

Posted by "gojumprope (via GitHub)" <gi...@apache.org>.
gojumprope commented on issue #19748:
URL: https://github.com/apache/doris/issues/19748#issuecomment-1681558450

   Tested no issue in 2.0.0


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