composite index with != and ==

[HarrisChu]

https://discuss.nebula-graph.com.cn/t/topic/5749

(root@nebula) [sf01]> show create tag Person
+----------+-----------------------------------+
| Tag      | Create Tag                        |
+----------+-----------------------------------+
| "Person" | "CREATE TAG `Person` (            |
|          |  `firstName` string NULL,         |
|          |  `lastName` string NULL,          |
|          |  `gender` string NULL,            |
|          |  `birthday` string NULL,          |
|          |  `creationDate` string NULL,      |
|          |  `locationIP` string NULL,        |
|          |  `browserUsed` string NULL        |
|          | ) ttl_duration = 0, ttl_col = """ |
+----------+-----------------------------------+
Got 1 rows (time spent 1441/5617 us)

Mon, 13 Sep 2021 14:44:22 CST

(root@nebula) [sf01]> show tag indexes
+----------------+----------+-------------------------------------+
| Index Name     | By Tag   | Columns                             |
+----------------+----------+-------------------------------------+
| "idx_person"   | "Person" | ["firstName", "lastName", "gender"] |
+----------------+----------+-------------------------------------+
| "idx_person_1" | "Person" | ["firstName", "gender"]             |
+----------------+----------+-------------------------------------+
Got 2 rows (time spent 1251/8167 us)

Mon, 13 Sep 2021 14:44:50 CST

(root@nebula) [sf01]> match (v:Person) where v.firstName=='Ousmane' and v.gender=='male' return count(v)
+----------+
| count(v) |
+----------+
| 1        |
+----------+
Got 1 rows (time spent 2241/78536 us)

Mon, 13 Sep 2021 14:45:47 CST

(root@nebula) [sf01]> match (v:Person) where v.firstName=='Ousmane' and v.gender!='male' return count(v)
+----------+
| count(v) |
+----------+
| 0        |
+----------+
Got 1 rows (time spent 2197/6042 us)

Mon, 13 Sep 2021 14:45:58 CST

(root@nebula) [sf01]> match (v:Person) where v.firstName!='Ousmane' and v.gender!='male' return count(v)
+----------+
| count(v) |
+----------+
| 778      |
+----------+
Got 1 rows (time spent 35294/39697 us)

Mon, 13 Sep 2021 14:46:09 CST

but

(root@nebula) [sf01]> match (v:Person) where v.firstName!='Ousmane' and v.gender=='male' return count(v)
[ERROR (-1005)]: IndexNotFound: No valid index found

Mon, 13 Sep 2021 14:46:20 CST

[Sophie-Xie]

Technical Committee discuss it which will be fixed in MATCH rearchitecting.

[HarrisChu]

fixed in the master branch.

[czpmango]

Duplicated issue, fixed in #3311