Execution failed with:"Error found in optimization stage: IndexNotFound: No valid index found"

[stupalpa]

Environment

Nebula Version: nightly Operating System: Ubuntu22.04 Installation Method: Docker API: Docker

Steps to Reproduce

1. Create the graph database:log.txt
2. Execute the following two queries:

• query1:

MATCH (n0 :L3)<-[*1..2]-(n1 :L3) WHERE ((n1.L3.k17) <= 'F') RETURN * 

• query2:

MATCH (n0:L3)<-[]-(n1:L3) WHERE (CASE WHEN FALSE THEN NULL ELSE ( n1.L3.k17) <= 'F' END ) RETURN * UNION ALL MATCH (n0:L3)<-[]-()<-[]-(n1:L3) WHERE ( CASE WHEN FALSE THEN NULL ELSE ( n1 . L3 . k17 ) <= 'F' END ) RETURN * 

Expected Result

Both queries return the same result

Actual Result

The first query returns:

[ERROR (-1005)]: Error found in optimization stage: IndexNotFound: No valid index found

The second query returns:

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| n0                                                                                                                                                                                                                            | n1                                                                                                                                                                                                                            |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ("n11" :L3{k15: -380718778, k16: 1926370660, k17: "nR9i", k18: "U", k19: 485555273})                                                                                                                                          | ("n12" :L3{k15: -2092386644, k16: -1656097964, k17: "E8gLUc1rQ", k18: "o", k19: 1570485166} :L2{k10: false, k11: false, k12: "LAZYSB9", k13: "V", k14: true} :L1{k5: __NULL__, k6: "j", k7: true, k8: 688301225, k9: "waEy"}) |
| ("n14" :L3{k15: -1762334119, k16: 1588528464, k17: "X", k18: "K7", k19: -550580174})                                                                                                                                          | ("n12" :L3{k15: -2092386644, k16: -1656097964, k17: "E8gLUc1rQ", k18: "o", k19: 1570485166} :L2{k10: false, k11: false, k12: "LAZYSB9", k13: "V", k14: true} :L1{k5: __NULL__, k6: "j", k7: true, k8: 688301225, k9: "waEy"}) |
| ("n12" :L3{k15: -2092386644, k16: -1656097964, k17: "E8gLUc1rQ", k18: "o", k19: 1570485166} :L2{k10: false, k11: false, k12: "LAZYSB9", k13: "V", k14: true} :L1{k5: __NULL__, k6: "j", k7: true, k8: 688301225, k9: "waEy"}) | ("n12" :L3{k15: -2092386644, k16: -1656097964, k17: "E8gLUc1rQ", k18: "o", k19: 1570485166} :L2{k10: false, k11: false, k12: "LAZYSB9", k13: "V", k14: true} :L1{k5: __NULL__, k6: "j", k7: true, k8: 688301225, k9: "waEy"}) |
| ("n14" :L3{k15: -1762334119, k16: 1588528464, k17: "X", k18: "K7", k19: -550580174})                                                                                                                                          | ("n12" :L3{k15: -2092386644, k16: -1656097964, k17: "E8gLUc1rQ", k18: "o", k19: 1570485166} :L2{k10: false, k11: false, k12: "LAZYSB9", k13: "V", k14: true} :L1{k5: __NULL__, k6: "j", k7: true, k8: 688301225, k9: "waEy"}) |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Got 4 rows (time spent 11.915ms/13.386214ms)