[GitHub] [doris] francis-xjl opened a new issue, #11412: [Bug] doris子查询顺序会乱掉

[GitBox]

francis-xjl opened a new issue, #11412:
URL: https://github.com/apache/doris/issues/11412

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Version
   
   0.15.3
   
   ### What's Wrong?
   
   直接查询以下语句：
   select * from (
       select 1 as a
   union all
   select 2 as a ) b order by b.a desc
   返回结果：
   <img width="294" alt="image" 
src="https://user-images.githubusercontent.com/17879879/182283406-9cfd9de8-b313-48ec-b130-5d15961245ba.png";>
   
   但是在最外层再套一层select，顺序就会乱掉：
   select * from (
   select * from (
       select 1 as a
   union all
   select 2 as a ) b order by b.a desc) c
   
   顺序会变成：
   ![Uploading image.png…]()
   
   
   
   ### What You Expected?
   
   希望子查询不会改变内部的顺序
   
   ### How to Reproduce?
   
   _No response_
   
   ### 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