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.

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

AND type mv index filter mutations generating logic is wrong #50380

Closed
AilinKid opened this issue Jan 12, 2024 · 0 comments · Fixed by #50379
Closed

AND type mv index filter mutations generating logic is wrong #50380

AilinKid opened this issue Jan 12, 2024 · 0 comments · Fixed by #50379
Assignees
Labels

Comments

@AilinKid
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

fix the AND mv index filter mutations generating logic.
SELECT * FROM t WHERE 15975127 member of (domains) AND 15975128 member of (domains) AND a = 1 AND b = 2
for mv index mvi(a, domains, b)
the accessFilters should be [a = 1, ?, b = 1], here ? is pos occupation here stands for set {15975127 member of (domains), 15975128 member of (domains)}
when building index partial path, we have two mutation here
a=1 and 15975127 member of (domains) and b=2
a=1 and 15975128 member of (domains) and b=2

2. What did you expect to see? (Required)

accessFilters [a = 1, 15975127 member of (domains), b = 1]
MvIndexMutations[15975127 member of (domains), 15975128 member of (domains)]

3. What did you see instead (Required)

currently, in CollectFilters4MVIndexMutations, it will output

accessFilters as [a = 1, 15975127 member of (domains), 15975128 member of (domains), b = 1]
MvIndexMutations[15975127 member of (domains), 15975128 member of (domains)]

which is not desirable.

4. What is your TiDB version? (Required)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant