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

filtering [un-indexed prop/cross indexes] behavior #3296

Closed
wey-gu opened this issue Nov 10, 2021 · 1 comment
Closed

filtering [un-indexed prop/cross indexes] behavior #3296

wey-gu opened this issue Nov 10, 2021 · 1 comment
Labels
type/question Type: question about the product

Comments

@wey-gu
Copy link
Contributor

wey-gu commented Nov 10, 2021

For un-indexed or condition filtering props from different indexes, is this behavior expected?

(root@nebula) [basketballplayer]> show tag indexes
+--------------------+----------+----------+
| Index Name         | By Tag   | Columns  |
+--------------------+----------+----------+
| "player_age_index" | "player" | ["age"]  |
| "player_index_0"   | "player" | []       |
| "player_index_1"   | "player" | ["name"] |
+--------------------+----------+----------+
Got 3 rows (time spent 1518/4259 us)

Wed, 10 Nov 2021 04:08:39 UTC

(root@nebula) [basketballplayer]> lookup on player where player.age > 2 and player.name == "Tim Duncan"
+-------------+
| VertexID    |
+-------------+
| "player100" |
+-------------+
Got 1 rows (time spent 2655/6866 us)

Wed, 10 Nov 2021 04:08:45 UTC

(root@nebula) [basketballplayer]> match (v:player) where v.name == "Tim Duncan" and v.age > 2 return v
[ERROR (-1005)]: IndexNotFound: No valid index found

Wed, 10 Nov 2021 04:08:52 UTC
@wey-gu wey-gu added type/bug Type: something is unexpected type/question Type: question about the product and removed type/bug Type: something is unexpected labels Nov 10, 2021
@wey-gu wey-gu changed the title filtering un-indexed prop behavior filtering [un-indexed prop/cross indexes] behavior Nov 10, 2021
@czpmango
Copy link
Contributor

Same as #3246.
Closed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/question Type: question about the product
Projects
None yet
Development

No branches or pull requests

2 participants