You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "strongduanmu (via GitHub)" <gi...@apache.org> on 2023/07/19 03:11:21 UTC

[GitHub] [shardingsphere] strongduanmu opened a new issue, #27287: Consider refactoring asterisk expansion logic in ProjectionEngine#createProjection to improve SQL support

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

   In the issues reported by the community, we can often see exceptions caused by asterisk expansion errors, such as `Column index out of range`, and exceptions caused by sql execution errors in the sharding and encrypt functions.
   
   These problems affect the sql support of shardingsphere. In order to solve these problems, we need to reconstruct the asterisk expansion logic in ProjectionEngine#createProjection, and perform asterisk expansion on statements such as simple query and associated query according to the characteristics of different databases.
   
   The following is MySQL's description of the asterisk expansion logic,  we will implement asterisk expansion according to the behavior of different databases.
   
   ![image](https://github.com/apache/shardingsphere/assets/10829171/9feb0e9d-d0ec-41d0-9d91-f385d3890ef3)
   
   


-- 
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] FlyingZC closed issue #27287: Consider refactoring asterisk expansion logic in ProjectionEngine#createProjection to improve SQL support

Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC closed issue #27287: Consider refactoring asterisk expansion logic in ProjectionEngine#createProjection to improve SQL support
URL: https://github.com/apache/shardingsphere/issues/27287


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