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 2019/05/30 13:07:39 UTC

[GitHub] [incubator-shardingsphere] tianyijushi opened a new issue #2475: when updating a blob column , the result was modified

tianyijushi opened a new issue #2475: when updating a blob column ,the result was modified
URL: https://github.com/apache/incubator-shardingsphere/issues/2475
 
 
   version of ShardingSphere: Sharding-Proxy-V4.0.0-RC1
   info:
   java project:springboot2 + mybatis 
   sharding-rule:
   ![图片](https://user-images.githubusercontent.com/34736778/58634095-fe488800-831c-11e9-94af-2da2390e8db0.png)
   table desc:
   ![图片](https://user-images.githubusercontent.com/34736778/58634135-18826600-831d-11e9-8ff6-3d3ce5d8fa19.png)
   java resources:
   ![图片](https://user-images.githubusercontent.com/34736778/58634168-30f28080-831d-11e9-9d69-c865ac7ca844.png)
   ![图片](https://user-images.githubusercontent.com/34736778/58634440-e6253880-831d-11e9-9437-3b8e8b1d6c6f.png)
   the test datas are 512 floats combined a binary data,then every float Occupy 8 bytes,
   512*8=4096bit=2048B=2k
   but the result is :
   ![图片](https://user-images.githubusercontent.com/34736778/58634476-f76e4500-831d-11e9-8e3e-e32a77713839.png)
   
   When I connect directly to the mysql :
   ![图片](https://user-images.githubusercontent.com/34736778/58634785-c4788100-831e-11e9-80eb-be05c803b3f3.png)
   
   I see that there are BLOB field types in shardingsphere source code. Did I need special usage methods?
   

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


With regards,
Apache Git Services