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

update语句中,分片键使用`符号包围,不能正常路由 #3160

Closed
xhailiang opened this issue Feb 25, 2022 · 2 comments
Closed

update语句中,分片键使用`符号包围,不能正常路由 #3160

xhailiang opened this issue Feb 25, 2022 · 2 comments
Assignees
Labels
community issue from community
Milestone

Comments

@xhailiang
Copy link

xhailiang commented Feb 25, 2022

  • dble version:
  • 3.21.10.1
  • preconditions :
    usr_id为分片键
  • configs:

schema.xml



rule.xml



server.xml



  • steps:
    step1. update t18_order set ord_sts='9X' where usr_id=9999999 and ID=999999999;
    usr_id 被 ` 符号引用
  • expect result:
    1.命中路由
    explain update t18_order set ord_sts='9X' where usr_id=9999999 and ID=999999999 \G
    SHARDING_NODE: dn13
    TYPE: BASE SQL
    SQL/REF: update t18_order set ord_sts='9X' where usr_id=9999999 and ID=999999999
  • real result:
  • 广播了
    explain update t18_order set ord_sts='9X' where usr_id=9999999 and ID=999999999 \G
    *************************** 1. row ***************************
    SHARDING_NODE: dn1
    TYPE: BASE SQL
    SQL/REF: update t18_order set ord_sts='9X' where usr_id=9999999 and ID=999999999
    *************************** 2. row ***************************
    ................................省略dn2-dn17
    ................................
    *************************** 18. row ***************************
    SHARDING_NODE: dn18
    TYPE: BASE SQL
    SQL/REF: update t18_order set ord_sts='9X' where usr_id=9999999 and ID=999999999
  • supplements:
    1.
@dcy10000 dcy10000 self-assigned this Feb 25, 2022
@dcy10000
Copy link
Member

影响版本>=3.21.02,引入的issue号 #2152
临时解决方案:不要用`符号

@yanhuqing666 yanhuqing666 added this to the 3.22.01.0 milestone Mar 4, 2022
@yanhuqing666 yanhuqing666 added the community issue from community label Mar 4, 2022
@dcy10000 dcy10000 assigned wangjuan-action and unassigned dcy10000 Mar 10, 2022
@wangjuan-action
Copy link
Member

verified version:
5.7.21-dble-3.21.10.99-c87a0806f42c3c106b49be3bdd84348d87cc0c40-20220309052451
5.7.21-dble-3.21.06.99-39054a4576d526dae95b1711da031723ddc19f89-20220309052343
5.7.21-dble-3.21.02.99-39e08a50878fcec64c71b9103b4c40d1feba87a1-20220309052944

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
community issue from community
Projects
None yet
Development

No branches or pull requests

4 participants