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

planner: make join order hint and join method hint compatible #36600

Closed
Reminiscent opened this issue Jul 27, 2022 · 1 comment · Fixed by #41637
Closed

planner: make join order hint and join method hint compatible #36600

Reminiscent opened this issue Jul 27, 2022 · 1 comment · Fixed by #41637
Assignees
@Reminiscent
Labels
affects-6.5 This bug affects the 6.5.x(LTS) versions. report/customer Customers have encountered this bug. sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@Reminiscent
Copy link
Contributor

Now, the leading hint can not take effect when we use the join method hint(like hash_join hint) at the same time. So we should make them compatible.
@Reminiscent Reminiscent added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner labels Jul 27, 2022
@Reminiscent Reminiscent self-assigned this Jul 27, 2022
@Reminiscent Reminiscent mentioned this issue Jul 27, 2022
Closed
12 tasks
@Reminiscent Reminiscent mentioned this issue Jan 17, 2023
Closed
12 tasks
@Reminiscent Reminiscent mentioned this issue Feb 15, 2023
Merged
12 tasks
ti-chi-bot pushed a commit that referenced this issue Feb 20, 2023
@Reminiscent
planner: distinguish the source of join hint information (#41440)
fca20d6 
ref #36600
@Reminiscent Reminiscent mentioned this issue Feb 21, 2023
Merged
12 tasks
@Reminiscent Reminiscent mentioned this issue Mar 1, 2023
Merged
12 tasks
ti-chi-bot pushed a commit that referenced this issue Mar 1, 2023
@Reminiscent
planner: resolve the compatibility problems for the join hint (#41804)
4f0e6ca 
ref #36600
ti-chi-bot pushed a commit that referenced this issue Mar 3, 2023
@Reminiscent
planner: resolve the conflict for join hint (#41637)
324c3c2 
close #36600
This was referenced Mar 6, 2023
Merged
Merged
ti-chi-bot pushed a commit that referenced this issue Mar 8, 2023
@Reminiscent
planner: set the tidb_opt_advanced_join_hint to off when upgrade (#42016
49bf4ce 
)

ref #36600
ti-chi-bot pushed a commit that referenced this issue Mar 9, 2023
@Reminiscent
planner: add more test cases for join hint compatibility (#41954)
a1b5cb8 
ref #36600
@ti-chi-bot ti-chi-bot mentioned this issue Jul 28, 2023
Merged
12 tasks
@qw4990 qw4990 added the affects-6.5 This bug affects the 6.5.x(LTS) versions. label Jul 28, 2023
ti-chi-bot bot pushed a commit that referenced this issue Jul 28, 2023
@ti-chi-bot
planner: distinguish the source of join hint information (#41440) (#4…
230b5ff 
…5642)

ref #36600
@seiya-annie
Copy link

/found customer

@ti-chi-bot ti-chi-bot bot added the report/customer Customers have encountered this bug. label Jun 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Reminiscent Reminiscent

Labels
affects-6.5 This bug affects the 6.5.x(LTS) versions. report/customer Customers have encountered this bug. sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
3 participants
@qw4990 @Reminiscent @seiya-annie