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/08/13 03:53:01 UTC

[GitHub] [shardingsphere] qanson opened a new issue #11795: Insert too long data, no exception be thrown,no error log, no rollback. [it should throw exception]

qanson opened a new issue #11795:
URL: https://github.com/apache/shardingsphere/issues/11795


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   5.0-Beta
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-JDBC
   ### Expected behavior
   The database field length is only 50, however when inserting test data , the length of data is more than 50. It should have thrown 
   an exception. There should be  exception and rollback.
   ### Actual behavior
   No exception ,the log runs well without err log and the program continue to run and no rollback happen. There should throw an exception
   ### Reason analyze (If you can)
   I assume in the ShardingSphere-JDBC source code, there may try catch the sql exception ,so we can't rollback. 
    
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   code:
   ![image](https://user-images.githubusercontent.com/16503640/129301894-6db29add-76bc-4813-b8b3-ec1ef6a4608b.png)
   
   log:
   ![log](https://user-images.githubusercontent.com/16503640/129302556-74208340-27e6-4e49-8d5b-728567bc95ec.png)
   
   ### Example codes for reproduce this issue (such as a github link).
   only the sharding-jdbc-tables example, and in java code , insert the status field more than 50 charcaters.


-- 
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 #11795: Insert too long data, no exception be thrown,no error log, no rollback. [it should throw exception]

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


   


-- 
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] zjcnb removed a comment on issue #11795: Insert too long data, no exception be thrown,no error log, no rollback. [it should throw exception]

Posted by GitBox <gi...@apache.org>.
zjcnb removed a comment on issue #11795:
URL: https://github.com/apache/shardingsphere/issues/11795#issuecomment-898228917


   Hi, you can try it again in ShardingSphere 5.0.0-RC1-SNAPSHOT


-- 
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] zjcnb commented on issue #11795: Insert too long data, no exception be thrown,no error log, no rollback. [it should throw exception]

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


   Hi @qanson,  you can try it at 5.0.0-RC1-SNAPSHOT. It should be fixed.


-- 
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] qanson commented on issue #11795: Insert too long data, no exception be thrown,no error log, no rollback. [it should throw exception]

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


   > Hi @qanson, you can try it at 5.0.0-RC1-SNAPSHOT. It should be fixed.
   
   Thanks a lot .


-- 
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] zjcnb commented on issue #11795: Insert too long data, no exception be thrown,no error log, no rollback. [it should throw exception]

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


   Hi, you can try it again in ShardingSphere 5.0.0-RC1-SNAPSHOT


-- 
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 #11795: Insert too long data, no exception be thrown,no error log, no rollback. [it should throw exception]

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


   Duplicate with #10138.


-- 
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] tristaZero commented on issue #11795: Insert too long data, no exception be thrown,no error log, no rollback. [it should throw exception]

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


   @qanson Hi if this issue is fixed, could you close it?


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