-
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
prefixed column inside clustered index's TableScan only read prefix data #22811
Labels
Comments
lysu
changed the title
prefix column clustered index's IndexScan and TableScan got different result
prefixed column inside clustered index's IndexScan and TableScan got different result
Feb 19, 2021
This was referenced Feb 19, 2021
To my understanding, the |
jebter
added
sig/transaction
SIG:Transaction
and removed
sig/sql-infra
SIG: SQL Infra
labels
Feb 22, 2021
Closed
lysu
changed the title
prefixed column inside clustered index's IndexScan and TableScan got different result
prefixed column inside clustered index's TableScan only read prefix data
Feb 22, 2021
ti-chi-bot
pushed a commit
to tikv/tikv
that referenced
this issue
Mar 1, 2021
Signed-off-by: lysu <sulifx@gmail.com> <!-- Thank you for contributing to TiKV! If you haven't already, please read TiKV's [CONTRIBUTING](https://github.com/tikv/tikv/blob/master/CONTRIBUTING.md) document. If you're unsure about anything, just ask; somebody should be along to answer within a day or two. PR Title Format: 1. module [, module2, module3]: what's changed 2. *: what's changed If you want to open the **Challenge Program** pull request, please use the following template: https://raw.githubusercontent.com/tikv/.github/master/.github/PULL_REQUEST_TEMPLATE/challenge-program.md You can use it with query parameters: https://github.com/tikv/tikv/compare/master...${you branch}?template=challenge-program.md --> ### What problem does this PR solve? Issue Number: close pingcap/tidb#22811 Problem Summary: tikv will avoid read value when required column in common handle but common handle's columns maybe not contain full columns value (like `primary key(c(1))`) ### What is changed and how it works? What's Changed: read kv's value when required column in common handle is the prefix of column need merge pingcap/tidb#22829 first ### Related changes - n/a ### Check List <!--REMOVE the items that are not applicable--> Tests <!-- At least one of them must be included. --> - Integration test(WIP) Side effects - n/a ### Release note <!-- bugfixes or new feature need a release note --> - no release note <!-- Reviewable:start --> --- This change is [<img src="https://reviewable.io/review_button.svg" height="34" align="absmiddle" alt="Reviewable"/>](https://reviewable.io/reviews/tikv/tikv/9670) <!-- Reviewable:end -->
Please edit this comment or add a new comment to complete the following informationNot a bug
Duplicate bug
BugNote: Make Sure that 'component', and 'severity' labels are added 1. Root Cause Analysis (RCA) (optional)2. Symptom (optional)3. All Trigger Conditions (optional)4. Workaround (optional)5. Affected versionsmaster 6. Fixed versionsmaster |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
start a cluster with tikv(not unistore)
run queries:
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
The text was updated successfully, but these errors were encountered: