You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "stalary (via GitHub)" <gi...@apache.org> on 2023/03/07 08:47:29 UTC
[GitHub] [doris] stalary opened a new issue, #17516: [Bug] Order by error when select use alias same as field
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-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] stalary closed issue #17516: [Bug] Order by error when select use alias same as field
Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary closed issue #17516: [Bug] Order by error when select use alias same as field
URL: https://github.com/apache/doris/issues/17516
--
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] stalary commented on issue #17516: [Bug] Order by error when select use alias same as field
Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary commented on issue #17516:
URL: https://github.com/apache/doris/issues/17516#issuecomment-1620323535
Has fixed
--
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