-
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
Can't find column
when count star rewriter is enable
#39506
Labels
Comments
elsa0520
added a commit
to elsa0520/tidb
that referenced
this issue
Nov 30, 2022
If the index and `count_star` optimizations exist at the same time, a `can't find column` error may occur. The main reason is that the `count_star` optimization strategy selects a not null column, but due to the column is not added to the `colsRequiringFullLen` attribute, the planner mistakenly selects the index scan. Eventually the previously selected column could not be found. This PR fixed pingcap#39506 the problem above
12 tasks
ti-chi-bot
added
may-affects-4.0
This bug maybe affects 4.0.x versions.
may-affects-5.0
This bug maybe affects 5.0.x versions.
may-affects-5.1
This bug maybe affects 5.1.x versions.
may-affects-5.2
This bug maybe affects 5.2.x versions.
may-affects-5.3
This bug maybe affects 5.3.x versions.
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.0
may-affects-6.1
may-affects-6.2
may-affects-6.3
may-affects-6.4
labels
Nov 30, 2022
qw4990
removed
may-affects-4.0
This bug maybe affects 4.0.x versions.
may-affects-5.1
This bug maybe affects 5.1.x versions.
may-affects-5.2
This bug maybe affects 5.2.x versions.
may-affects-5.3
This bug maybe affects 5.3.x versions.
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-5.0
This bug maybe affects 5.0.x versions.
may-affects-6.0
may-affects-6.1
may-affects-6.2
may-affects-6.3
may-affects-6.4
labels
Nov 30, 2022
The count star has been changed from logical rule to post phase. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
Bug Report
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
After tidb 6.4 , before tidb 6.5
master branch
The text was updated successfully, but these errors were encountered: