[GitHub] [doris] stalary opened a new issue, #17516: [Bug] Order by error when select use alias same as field

[via GitHub]

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

   ### 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.1.3 and 1.2.2
   
   ### What's Wrong?
   
   ```sql
   select    CASE
           WHEN MONTH = '5月' THEN '0_5月'
           WHEN MONTH = '4月' THEN '1_4月'
           WHEN MONTH = '8月' THEN '2_8月'
           WHEN MONTH = '12月' THEN '3_12月'
           WHEN MONTH = '11月' THEN '4_11月'
           WHEN MONTH = '3月' THEN '5_3月'
           WHEN MONTH = '10月' THEN '6_10月'
           WHEN MONTH = '1月' THEN '7_1月'
           WHEN MONTH = '6月' THEN '8_6月'
           WHEN MONTH = '7月' THEN '9_7月'
           WHEN MONTH = '9月' THEN '10_9月'
           WHEN MONTH = '2月' THEN '11_2月'
           ELSE 'Others'
       END AS MONTH
   FROM
       ads.test
   ORDER BY
       CASE
           WHEN MONTH = '5月' THEN '0_5月'
           WHEN MONTH = '4月' THEN '1_4月'
           WHEN MONTH = '8月' THEN '2_8月'
           WHEN MONTH = '12月' THEN '3_12月'
           WHEN MONTH = '11月' THEN '4_11月'
           WHEN MONTH = '3月' THEN '5_3月'
           WHEN MONTH = '10月' THEN '6_10月'
           WHEN MONTH = '1月' THEN '7_1月'
           WHEN MONTH = '6月' THEN '8_6月'
           WHEN MONTH = '7月' THEN '9_7月'
           WHEN MONTH = '9月' THEN '10_9月'
           WHEN MONTH = '2月' THEN '11_2月'
           ELSE 'Others'
       END ASC
   LIMIT
       1000;
   ```
   return 
   ```
   2_8月
   9_7月
   10_9月
   8_6月
   8_6月
   0_5月
   5_3月
   3_12月
   11_2月
   ```
   
   
   ### What You Expected?
   
   ```
   0_5月
   10_9月
   11_2月
   2_8月
   3_12月
   5_3月
   8_6月
   8_6月
   9_7月
   ```
   
   ### 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