[GitHub] [doris] lsy3993 commented on issue #13639: [Bug] Select后的字段解析有问题。

[GitBox]

lsy3993 commented on issue #13639:
URL: https://github.com/apache/doris/issues/13639#issuecomment-1291434301

   when you write 
   ```
     select month_id
              standard_app_id, xxx
   ```
   
   doris will think you want to do that:
   ```
     select month_id as standard_app_id, xxx
   ```
   
   But this behavior is OK, you can alias 'month_id' to 'standard_app_id', even 
if 'standard_app_id' is a column name in your table.
   
   The problem does not relate to 'lateral view',  simple queries can also be 
reproduced, for exapmle
   
![doris_alias](https://user-images.githubusercontent.com/110876560/197924749-ea85172f-8c43-4ad8-85eb-c7986a1378ec.jpeg)
   And this behavior is same as mysql, the following picture shows mysql's 
behavior:
   
![mysql_alias](https://user-images.githubusercontent.com/110876560/197924908-402a97cd-1cdc-4409-ad4d-862da63af288.jpeg)
   
   
   


-- 
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

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