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

match statement index status quo #3190

Closed
czpmango opened this issue Oct 22, 2021 · 0 comments · Fixed by #3457
Closed

match statement index status quo #3190

czpmango opened this issue Oct 22, 2021 · 0 comments · Fixed by #3457
Assignees
Labels
type/bug Type: something is unexpected
Milestone

Comments

@czpmango
Copy link
Contributor

czpmango commented Oct 22, 2021

test:


(czp@nebula) [nba]> show tag indexes
+---------------------+----------+-----------------+
| Index Name          | By Tag   | Columns         |
+---------------------+----------+-----------------+
| "multiIndex"        | "player" | ["name", "age"] |
+---------------------+----------+-----------------+
| "multiIndex2"       | "player" | ["age", "name"] |
+---------------------+----------+-----------------+
| "player_age_index"  | "player" | ["age"]         |
+---------------------+----------+-----------------+
| "player_name_index" | "player" | ["name"]        |
+---------------------+----------+-----------------+
| "team_name_index"   | "team"   | ["name"]        |
+---------------------+----------+-----------------+

(czp@nebula) [nba]> explain match (v:player)-[]->(n) where v.name=="Tim Duncan" and v.age>40 return v
Execution succeeded (time spent 4917/6426 us)

(czp@nebula) [nba]> explain match (v:player)-[]->(n) where v.name=="Tim Duncan" and v.age>40 and v.name>"A" return v
[ERROR (-1009)]: SemanticError:

(czp@nebula) [nba]> drop tag index multiIndex
Execution succeeded (time spent 2151/2850 us)

(czp@nebula) [nba]> drop tag index multiIndex2
Execution succeeded (time spent 1560/2294 us)

(czp@nebula) [nba]> show tag indexes
+---------------------+----------+----------+
| Index Name          | By Tag   | Columns  |
+---------------------+----------+----------+
| "player_age_index"  | "player" | ["age"]  |
+---------------------+----------+----------+
| "player_name_index" | "player" | ["name"] |
+---------------------+----------+----------+
| "team_name_index"   | "team"   | ["name"] |
+---------------------+----------+----------+
Got 3 rows (time spent 1403/2235 us)

(czp@nebula) [nba]> explain match (v:player)-[]->(n) where v.name=="Tim Duncan" and v.age>40 and v.name>"A" return v
[ERROR (-1009)]: SemanticError:

(czp@nebula) [nba]> explain match (v:player)-[]->(n) where v.name=="Tim Duncan" and v.age>40 return v
[ERROR (-1005)]: IndexNotFound: No valid index found

(czp@nebula) [nba]> explain match (v:player)-[]->(n) where v.name=="Tim Duncan" and 41>40 return v
Execution succeeded (time spent 4590/5144 us)

(czp@nebula) [nba]> explain match (v:player)-[]->(n) where v.name>="Tim Duncan" and v.name=="Tim Duncan" return v
[ERROR (-1009)]: SemanticError:

(czp@nebula) [nba]> explain match (v:player)-[]->(n) where v.name>="Tim Duncan" and v.name starts with "Tim Duncan" return v
Execution succeeded (time spent 4816/5494 us)

(czp@nebula) [nba]> explain match (v:player) where v.age>30 and (v.name starts with "Tim Duncan" and v.name=="Tim Duncan")   return v
[ERROR (-1005)]: IndexNotFound: No valid index found

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

Successfully merging a pull request may close this issue.

3 participants