[GitHub] [shardingsphere] gavenpeng commented on issue #8605: table for unconfigured "SELECT t.*, t2.col FROM t LEFT JOIN t2" not work

[GitBox <gi...@apache.org>]

gavenpeng commented on issue #8605:
URL: https://github.com/apache/shardingsphere/issues/8605#issuecomment-751230371


   we have the same problem,the fllower sql is can.t run :
   ```
   select ta.*,tb.track_count from (select ID,activity_id,name,begin_time,end_time,first_shelf_time,last_shelf_time,description,operate_surface_url,big_surface_url,sort,status,show_status,created_by,updated_by,create_time,update_time 
   from dub_read_activity) ta left join (
   select activity_id,count(*) as track_count
   from dub_read_track
   where is_deleted = 0 and status = 1 group by activity_id ) tb on ta.activity_id = tb.activity_id
   limit
     1, 10 
   ```
   the result is only contain id clumn if the sql constain * 
   
   
   
   but not write * is ok,example:
   ```
   select ta.ID,ta.name,ta.last_shelf_time,ta.create_time,tb.track_count from (select ID,activity_id,name,begin_time,end_time,first_shelf_time,last_shelf_time,description,operate_surface_url,big_surface_url,sort,status,show_status,created_by,updated_by,create_time,update_time 
   from dub_read_activity) ta left join (
   select activity_id,count(*) as track_count
   from dub_read_track
   where is_deleted = 0 and status = 1 group by activity_id ) tb on ta.activity_id = tb.activity_id
   order by
     track_count desc,
     last_shelf_time desc,
     create_time desc
   limit
     1, 10 
   
   ```


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org