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 2021/03/16 04:58:00 UTC

[GitHub] [shardingsphere] zhkj0001 opened a new issue #9683: Data was inserted into inccorect table

zhkj0001 opened a new issue #9683:
URL: https://github.com/apache/shardingsphere/issues/9683


   Dear team,
   I'm sorry to report a problem here, To be honest , i have not searched all issues here, Our team met a problem when we are using shardingSphere to insert data into a logical table.
   The problem is that we have 23 physical table and one logical table. We try to insert data through logical table and every data has proper shardingColumn, but finally there were few data inserted into another physical table.
   Eg. we had data with sharding column ky, then insertted into table with sharding column Joker.
   by the way, we insert these data in batch manner .
   Would you like to figure out what's problem is ?


----------------------------------------------------------------
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] zhkj0001 commented on issue #9683: Data was inserted into inccorect table

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


   The following is the configuration: 
   tpg_record:  
             actualDataNodes: master.tpg_record_$->{['KY','Joker']}
             tableStrategy:
               inline:   
                 shardingColumn: thirdparty_platform
                 algorithmExpression: tpg_record_$->{thirdparty_platform}


----------------------------------------------------------------
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 commented on issue #9683: Data was inserted into inccorect table

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


   No response anymore, I just close the issue.


-- 
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 edited a comment on issue #9683: Data was inserted into inccorect table

Posted by GitBox <gi...@apache.org>.
RaigorJiang edited a comment on issue #9683:
URL: https://github.com/apache/shardingsphere/issues/9683#issuecomment-813803823


   Hi @zhkj0001 
   
   which version do you use? sharding-jdbc or sharding-proxy?
   
   would you please give more details, thank you.


-- 
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] RaigorJiang commented on issue #9683: Data was inserted into inccorect table

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


   Hi @zhkj0001 
   
   which version do you use? sharding-jdbc or sharding-proxy?
   
   would you please give mere details, thank you.


-- 
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 #9683: Data was inserted into inccorect table

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


   


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