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:
   ![70a8ce0a2c5700a8f2c4900d05c492f](https://github.com/user-attachments/assets/990017f2-cc94-44c1-9dbb-9b1385323258)
   
   
   ### 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