You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/04/24 10:13:28 UTC

[GitHub] [shardingsphere] wangwangwangBoy opened a new issue, #17060: Querying with the 'select *' syntax reports an error

wangwangwangBoy opened a new issue, #17060:
URL: https://github.com/apache/shardingsphere/issues/17060

   ## Bug Report
   
   
   ### 5.1.1-SNAPSHOT(Master)
   
   ###  ShardingSphere-JDBC
   
   After updating the latest master branch. Using select * reported an error, the master in October last year can be executed normally
   
   ![image](https://user-images.githubusercontent.com/46279672/164971487-02671fc1-986d-4f38-b94a-dd432098a6a2.png)
   
   After replacing select *, it can run normally
   ![image](https://user-images.githubusercontent.com/46279672/164971599-25dc3cd5-9680-423f-b544-e1222c4700a1.png)
   
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

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

[GitHub] [shardingsphere] wangwangwangBoy commented on issue #17060: Querying with the 'select *' syntax reports an error

Posted by GitBox <gi...@apache.org>.
wangwangwangBoy commented on issue #17060:
URL: https://github.com/apache/shardingsphere/issues/17060#issuecomment-1107990440

   > Hi @wangwangwangBoy, thank you for your feedback. Can you provide the original sql string?
   
   thank you for your feedback. The last reply is our original sql


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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

[GitHub] [shardingsphere] strongduanmu commented on issue #17060: Querying with the 'select *' syntax reports an error

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #17060:
URL: https://github.com/apache/shardingsphere/issues/17060#issuecomment-1107813378

   Hi @wangwangwangBoy, thank you for your feedback. Can you provide the original sql string?


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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

[GitHub] [shardingsphere] github-actions[bot] commented on issue #17060: Querying with the 'select *' syntax reports an error

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #17060:
URL: https://github.com/apache/shardingsphere/issues/17060#issuecomment-1272349941

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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

[GitHub] [shardingsphere] github-actions[bot] closed issue #17060: Querying with the 'select *' syntax reports an error

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #17060: Querying with the 'select *' syntax reports an error
URL: https://github.com/apache/shardingsphere/issues/17060


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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

[GitHub] [shardingsphere] wangwangwangBoy commented on issue #17060: Querying with the 'select *' syntax reports an error

Posted by GitBox <gi...@apache.org>.
wangwangwangBoy commented on issue #17060:
URL: https://github.com/apache/shardingsphere/issues/17060#issuecomment-1107990047

       select * from (
           select
           distinct
           di.device_id AS deviceId,
           b.id AS projectId,
           bai.project_status,
           ifnull(ds.status,0) AS deviceStatus,
           di.device_name deviceName,b.name projectName,
           date_format(ds.update_time,'%Y-%m-%d %H:%i:%S') updateTime,
           CONCAT(left(e.district_name_path,3),'-',d.name,'-',c.name) parkName
           from
           device_info di left join device_status ds on (di.device_id = ds.device_id  
           and di.project_id = ds.project_id and di.tenant_id = ds.tenant_id and DATE_FORMAT( ds.update_time, '%Y-%m-%d' )
           = CURDATE())
           left join bid_area b on di.project_id = b.id and di.tenant_id = b.tenant_id
           left join bid_area_info bai ON bai.bid_area_id = b.id and bai.tenant_id = b.tenant_id
           left join park c on c.id = b.park_id and c.tenant_id = b.tenant_id
           left join sys_org d on d.id = c.sys_org_id and d.tenant_id = c.tenant_id
           LEFT JOIN sys_tenant e ON e.id = di.tenant_id
           WHERE
           b.is_enable =1
           ORDER BY c.name,b.name ) tmp where (tmp.project_status != 7 OR tmp.project_status IS NULL)


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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

[GitHub] [shardingsphere] RaigorJiang commented on issue #17060: Querying with the 'select *' syntax reports an error

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #17060:
URL: https://github.com/apache/shardingsphere/issues/17060#issuecomment-1407575895

   This issue has been inactive for a long time, and ShardingSphere has released several new versions, so I will close it.
   Please try the latest version, and if the problem reproduces, please reopen it or submit a new one.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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

[GitHub] [shardingsphere] RaigorJiang closed issue #17060: Querying with the 'select *' syntax reports an error

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #17060: Querying with the 'select *' syntax reports an error
URL: https://github.com/apache/shardingsphere/issues/17060


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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