sharding value is a string type,but inside quotes is a hextype,dble will report error #1997
Description
- dble version： 5.6.29-dble-3.20.07.99-bb66c9d3ab238f480f3d620e94c962d8cd229ba5-20200804114836
- preconditions ：
hextype the format is 0x or x' ' - configs：
schema.xml
<shardingTable name="tb_jump_hash" shardingNode="dn1,dn2,dn3,dn4" function="jumpHash" shardingColumn="code"/>
<function name="func_jumpHash" class="jumpStringHash">
<property name="partitionCount">4</property>
</function>
- steps：
step1.
use schema1;
drop table if exists tb_jump_hash;
create table if not exists tb_jump_hash (id int not null,code varchar(250) not null,content varchar(250) not null)engine=innodb charset=utf8;
step2.
insert into tb_jump_hash values (11,'0x74657374696e67',0x74657374696e67);
insert into tb_jump_hash values (12,0x74657374696e67,0x74657374696e67);
- expect result：
- show correct results
MySQL > select * from tb_jump_hash where code='0x74657374696e67';
+----+---------+---------+
| id | code | content |
+----+---------+---------+
| 12 | 0x74657374696e67 | testing |
+----+---------+---------+
1 row in set (0.03 sec)
- real result：
1.
MySQL > select * from tb_jump_hash where code=0x74657374696e67;
+----+---------+---------+
| id | code | content |
+----+---------+---------+
| 12 | testing | testing |
+----+---------+---------+
1 row in set (0.03 sec)
MySQL > select * from tb_jump_hash where code='0x74657374696e67';
Empty set (0.02 sec)
- supplements：