dble
dble copied to clipboard
values x'abc' is changed to 0xabc by druid in insert statement
- **dble version:any version,use develop version as example **
- preconditions :
- configs:
sharding.xml
<schema name="testdb" >
<shardingTable name="tb_jump_hash" shardingNode="dn1,dn2" function="func_jumpHash" shardingColumn="code"/>
</schema>
<!-- jumpStringHash partition for string-->
<function name="func_jumpHash" class="jumpStringHash">
<property name="partitionCount">2</property>
<property name="hashSlice">0:2</property>
</function>
-
steps:
step1: drop table if exists schema1. sharding_4_t1; create table sharding_4_t1 (id int,file blob); step2: insert into sharding_4_t1 values(1,x'exc'); -
expect result: insert ok
-
real result: ERROR 1054 (42S22): Unknown column '0xexc' in 'field list',because the statement is changed to 'INSERT INTO tb_hash_sharding_er2 VALUES (1, 0xexc)'
Originally posted by @PanternBao in https://github.com/actiontech/dble/issues/1926#issuecomment-669659178