Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
PanternBao opened this issue Aug 6, 2020 · 0 comments
Open

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

PanternBao opened this issue Aug 6, 2020 · 0 comments

Comments

@PanternBao
Copy link
Member

PanternBao commented Aug 6, 2020

  • **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 #1926 (comment)

@PanternBao PanternBao changed the title values x'abc' is chaned to 0xabc by druid in insert statement values x'abc' is changed to 0xabc by druid in insert statement Aug 6, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants