dble icon indicating copy to clipboard operation
dble copied to clipboard

values x'abc' is changed to 0xabc by druid in insert statement

Open PanternBao opened this issue 4 years ago • 0 comments

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

PanternBao avatar Aug 06 '20 03:08 PanternBao