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
Unexpected Result by MERGE_JOIN #47345
Comments
/label fuzz/sqlancer |
@bajinsheng: The label(s) In response to this:
Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository. |
/assign @elsa0520 |
The correct result should be empty. So the first sql result is error. The error plan is following:
The predicate I close the join order rule, the plan is correct. So I suspect the join order rule incorrect allocate the predicate.
|
PTAL @winoros |
/assign @winoros |
We need some time to resolve it. Move down its severity to major. |
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
Both queries should return the same result, but not.
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
The text was updated successfully, but these errors were encountered: