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

Inactive indexes should not be selected #4314

Closed
czpmango opened this issue Jun 13, 2022 · 1 comment
Closed

Inactive indexes should not be selected #4314

czpmango opened this issue Jun 13, 2022 · 1 comment
Labels
severity/minor Severity of bug type/bug Type: something is unexpected
Milestone

Comments

@czpmango
Copy link
Contributor

czpmango commented Jun 13, 2022

Describe the bug (required)
A newly created index that has not been rebuilt is selected causing a query exception.

Your Environments (required)
version: v3.0

How To Reproduce(required)

(root@nebula) [nba]> match (v:player) return v limit 3
+-------------------------------------------------------+
| v                                                     |
+-------------------------------------------------------+
| ("Dwyane Wade" :player{age: 37, name: "Dwyane Wade"}) |
| ("Tony Parker" :player{age: 36, name: "Tony Parker"}) |
| ("Null2" :player{age: -2, name: __NULL__})            |
+-------------------------------------------------------+
Got 3 rows (time spent 5547/5879 us)

(root@nebula) [nba]> create tag index player_age_index on player(age)
Execution succeeded (time spent 1349/1603 us)

(root@nebula) [nba]> match (v:player) return v limit 3
+---+
| v |
+---+
+---+
Empty set (time spent 4065/4675 us)

Expected behavior
Ensure the query result is correct.

Additional context
Redesign the create index statements.

@czpmango czpmango added the type/bug Type: something is unexpected label Jun 13, 2022
@Sophie-Xie Sophie-Xie added this to the v3.2.0 milestone Jun 13, 2022
@czpmango czpmango changed the title Unactive indexes should not be selected Inactive indexes should not be selected Jun 13, 2022
@Sophie-Xie Sophie-Xie added the priority/low-pri Priority: low label Jun 14, 2022
@Sophie-Xie Sophie-Xie removed the priority/low-pri Priority: low label Jul 1, 2022
@Sophie-Xie Sophie-Xie modified the milestones: v3.2.0, v3.3.0 Jul 4, 2022
@Sophie-Xie
Copy link
Contributor

Discuss with Fang Yang offline.
Whether it can be judged that the index has been created but has not been rebuilt, and if so, a prompt will be given;
If not, do not change it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/minor Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

5 participants