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 2020/08/05 04:58:33 UTC

[GitHub] [shardingsphere] karkaw opened a new issue #6629: the class "BindingTableRule" to get the ActualTable's name been toLowerCase

karkaw opened a new issue #6629:
URL: https://github.com/apache/shardingsphere/issues/6629


   When the logical table is uppercase, when bindrule is set, the BindingTableRule.getBindingActualTable Is converted to lowercase. The result is that the table cannot be found。


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

[GitHub] [shardingsphere] karkaw commented on issue #6629: the class "BindingTableRule" to get the ActualTable's name been toLowerCase

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


   1、the env is hibernate + spring +mysql (the mysql config ： lower_case_table_names = 0 大小写敏感 ) ，and the all logic lable 's name is uppercase 。
   2、the sharding config as :
        <sharding:binding-table-rules>
                   <sharding:binding-table-rule logic-tables="JC_ZONE,JC_ZONE_ORGANIZATION" />
        </sharding:binding-table-rules>
   3、To execute the SQL as  "select * from JC_ZONE z join JC_ZONE_ORGANIZATION zo " , the exception as "the table's jc_zone_organization_1 not exist" 。 notice ：JC_ZONE and JC_ZONE_ORGANIZATION is a one to many relationship。
   
   End
   
   I've tracked the code  to lowercase  in the BindingTableRule.getBindingActualTable() ,
   as " each.getActualDataNodes().get(index).getTableName().toLowerCase()" 。
   
   Please confirm if there is the problem


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

[GitHub] [shardingsphere] terrymanu closed issue #6629: the class "BindingTableRule" to get the ActualTable's name been toLowerCase

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #6629:
URL: https://github.com/apache/shardingsphere/issues/6629


   


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

[GitHub] [shardingsphere] menghaoranss commented on issue #6629: the class "BindingTableRule" to get the ActualTable's name been toLowerCase

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


   @karkaw refer to [#3635](https://github.com/apache/shardingsphere/issues/3635)


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

[GitHub] [shardingsphere] menghaoranss commented on issue #6629: the class "BindingTableRule" to get the ActualTable's name been toLowerCase

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


   Could you provide any configuration or log to describe your problem?


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