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/11/08 10:06:59 UTC

[GitHub] [shardingsphere] yxiaozhou commented on issue #13498: When executing SQL, the fields do not match the database, and no exception is thrown

yxiaozhou commented on issue #13498:
URL: https://github.com/apache/shardingsphere/issues/13498#issuecomment-962994352


   After checking the document, it is found that there is no description of the problem;
   
   Using mybatis and MySQL
   
   For example, the fields in the database are ID and phone_ Number, area, the SQL actually inserted is:
   insert into personal_phone_2
   ( phone_number,
   area1 , id)
   values (?, ?, ?) ::: [123, 111, 1457646753489616897];
   Obviously, the fields do not match, but the code does not throw an exception
   
   The code screenshot is as follows:
   ![image](https://user-images.githubusercontent.com/33828903/140722953-d655b824-6069-4351-8a32-dd9a1f79e145.png)
   
   The database fields are as follows:
   
   ![image](https://user-images.githubusercontent.com/33828903/140722984-364a23f1-3af4-46a5-9aae-a6445c00240f.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

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