-
Notifications
You must be signed in to change notification settings - Fork 5.8k
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
incorrect result using CTE and subquery #53857
Labels
affects-6.5
affects-7.1
affects-7.5
affects-8.1
affects-8.2
fuzz/randomtest
impact/wrong-result
severity/major
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
Comments
ti-chi-bot
bot
added
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
may-affects-7.5
may-affects-8.1
labels
Jun 7, 2024
We generated a minimal reproducible sql.
then we check the planner. We cannot find any filters in the planner. it may be the root cause.
|
We transfer this planner into the join. it still triggers the bug.
|
This was referenced Jun 26, 2024
hawkingrei
added
affects-6.5
affects-7.1
affects-7.5
affects-8.1
and removed
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
may-affects-7.5
may-affects-8.1
labels
Jun 27, 2024
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
affects-6.5
affects-7.1
affects-7.5
affects-8.1
affects-8.2
fuzz/randomtest
impact/wrong-result
severity/major
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
MySQL:
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
b69f81b
The text was updated successfully, but these errors were encountered: