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.

Sign up for GitHub

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

Jump to bottom

where条件分片字段未加别名时，语句路由不正确 #3063

Closed
bjddd192 opened this issue Jan 10, 2022 · 2 comments
Closed

where条件分片字段未加别名时，语句路由不正确 #3063

bjddd192 opened this issue Jan 10, 2022 · 2 comments
Assignees
@wangjuan-action
Labels
community issue from community
Milestone
3.22.01.0

Comments

@bjddd192
Copy link

  • dble version：
  • actiontech/dble:3.21.10.0
  • preconditions ：
  • 官方镜像
  • steps：
    step1. 执行语句：SELECT * FROM testdb.tb_enum_sharding a where code in (10010)
  • expect result：
    1. 只路由分片所在节点
  • real result：
    1. 路由了全部节点
  • supplements：
    1. 路由多个节点会带来性能损失，期待对这种语句也能精准路由
@dcy10000 dcy10000 added this to the 3.22.01.0 milestone Jan 14, 2022
@dcy10000
Copy link
Member

影响版本>=3.21.02，引入的commit 号 6c5402d

临时解决方案：不用表别名

@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
Assignees

@wangjuan-action wangjuan-action

Labels
community issue from community
Projects
None yet
Milestone
3.22.01.0
Development

No branches or pull requests
4 participants
@bjddd192 @yanhuqing666 @dcy10000 @wangjuan-action