You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "superdiaodiao (via GitHub)" <gi...@apache.org> on 2024/07/17 12:11:53 UTC
[I] [Bug] query result column name wrong [doris]
superdiaodiao opened a new issue, #38020:
URL: https://github.com/apache/doris/issues/38020
### 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
branch: master
latest git version: 715af6eea9f18f0aac690be4dfa5f6330a153ede
### What's Wrong?
Column name is missing and turns into value of it:

### What You Expected?
normal column name:
```
mysql> select now();
+-----------------------+
| now() |
+-----------------------+
| 2024-07-17 19:52:48 |
+-----------------------+
1 row in set (0.07 sec)
mysql>
mysql>
mysql>
mysql> select current_date();
+--------------+
| current_date() |
+--------------+
| 2024-07-17 |
+--------------+
1 row in set (0.00 sec)
```
### How to Reproduce?
pull latest master code and query like: `select now();`
### Anything Else?
It has been appearing a few days before today issue reported.
### 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
Re: [I] [Bug] query result's column name becomes value [doris]
Posted by "superdiaodiao (via GitHub)" <gi...@apache.org>.
superdiaodiao commented on issue #38020:
URL: https://github.com/apache/doris/issues/38020#issuecomment-2244412952
> branch: master
> latest git version: [715af6e](https://github.com/apache/doris/commit/715af6eea9f18f0aac690be4dfa5f6330a153ede)
just like the **describe** above:
branch: master
latest git version: https://github.com/apache/doris/commit/715af6eea9f18f0aac690be4dfa5f6330a153ede
--
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
Re: [I] [Bug] query result's column name becomes value [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on issue #38020:
URL: https://github.com/apache/doris/issues/38020#issuecomment-2244395026
which version do u use? cannot reproduce this. order version have this problem and have be 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
Re: [I] [Bug] query result's column name becomes value [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on issue #38020:
URL: https://github.com/apache/doris/issues/38020#issuecomment-2244395599
<img width="495" alt="image" src="https://github.com/user-attachments/assets/3db83122-0428-4cc1-afe0-c7a0009ef3a1">
--
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
Re: [I] [Bug] query result's column name becomes value [doris]
Posted by "superdiaodiao (via GitHub)" <gi...@apache.org>.
superdiaodiao closed issue #38020: [Bug] query result's column name becomes value
URL: https://github.com/apache/doris/issues/38020
--
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
Re: [I] [Bug] query result's column name becomes value [doris]
Posted by "superdiaodiao (via GitHub)" <gi...@apache.org>.
superdiaodiao commented on issue #38020:
URL: https://github.com/apache/doris/issues/38020#issuecomment-2236133373
Yes, MySQL can display the function name in this situation.
--
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
Re: [I] [Bug] query result's column name becomes value [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on issue #38020:
URL: https://github.com/apache/doris/issues/38020#issuecomment-2233302063
that's because FE constant folding. AFAIK it's not easy or necessary to resolve it.
--
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
Re: [I] [Bug] query result's column name becomes value [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on issue #38020:
URL: https://github.com/apache/doris/issues/38020#issuecomment-2236055513
I think it should be same as MySQL
--
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
Re: [I] [Bug] query result's column name becomes value [doris]
Posted by "superdiaodiao (via GitHub)" <gi...@apache.org>.
superdiaodiao commented on issue #38020:
URL: https://github.com/apache/doris/issues/38020#issuecomment-2244574573
update:
After git version 912a23887fcae26c34ff6d03ad76bd221e44c5c8 on master, this problem was solved.
--
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