Match query followd by a with clause report alias redefined semantic error (2)

[nebula-bots]

Please check the FAQ documentation before raising an issue

Describe the bug (required)

A similar problem to #1579 but with a different query and even though we have applied the fix of #1579 (tested on latest community master branch), the query below still report a Redefined alias error:

(root@nebula) [gdlancer]> MATCH (v0:Label_0)<-[e0]-(v1)-[e1]->(v2) WHERE (id(v0) in [23, 5, 3, 13, 12, 29, 27, 30, 16, 2, 28]) AND (e0.Rel_5_0_Bool) MATCH (v1)<-[e2:Rel_3]-()-[e3:Rel_5]->(v3) WHERE (e3.Rel_5_0_Bool) WITH v1, min(e1.Rel_2_0_Int) AS pa0, e2.Rel_3_2_Double AS pa1, e3.Rel_0_3_Int AS pa2, v1.Label_2.Label_2_1_Int AS pa3, v2, v3 WHERE (((pa0 - ((- (- pa1)) - (- 0.297574))) / (((- (v1.Label_2.Label_2_1_Int + v1.Label_2.Label_2_4_Int)) + (- 24)) % (v1.Label_2.Label_2_2_Double - 91))) > v1.Label_2.Label_2_1_Int) MATCH (v4:Label_5:Label_2)-[e4:Rel_1]->(:Label_2:Label_3)<-[e5]-() WHERE (id(v4) in [11, 3, 27, 12, 21, 16, 31, 19, 8, 17, 9]) AND (e5.Rel_2_4_Bool) MATCH (v5)-[e6:Rel_3]->(v6)<-[e7:Rel_2]-(v3) WHERE (id(v5) == 19) AND (e5.Rel_2_4_Bool) MATCH p0 = (v7:Label_3{Label_3_4_String: 'Stephen Curry'})<-[e8]-(v2)-[e9:Rel_3]->(v8:Label_4{Label_4_3_Double: 0.175132}) WHERE (id(v7) in [14, 3, 19, 21, 15, 9, 2, 12, 7, 27, 23]) AND ((v8.Label_0.Label_0_4_Int <= (- v1.Label_2.Label_2_2_Double))) WITH * return count(*)
[ERROR (-1009)]: SemanticError: `v3': Redefined alias

Mon, 28 Nov 2022 11:41:13 CST

(root@nebula) [gdlancer]>

In contrast the same query on Neo4j report no error:

$ MATCH (v0:Label_0)<-[e0]-(v1)-[e1]->(v2) WHERE (v0.id in [23, 5, 3, 13, 12, 29, 27, 30, 16, 2, 28]) AND (e0.Rel_5_0_Bool) MATCH (v1)<-[e2:Rel_3]-()-[e3:Rel_5]->(v3) WHERE (e3.Rel_5_0_Bool) WITH v1, min(e1.Rel_2_0_Int) AS pa0, e2.Rel_3_2_Double AS pa1, e3.Rel_0_3_Int AS pa2, v1.Label_2_1_Int AS pa3, v2, v3 WHERE (((pa0 - ((- (- pa1)) - (- 0.297574))) / (((- (v1.Label_2_1_Int + v1.Label_2_4_Int)) + (- 24)) % (v1.Label_2_2_Double - 91))) > v1.Label_2_1_Int) MATCH (v4:Label_5:Label_2)-[e4:Rel_1]->(:Label_2:Label_3)<-[e5]-() WHERE (v4.id in [11, 3, 27, 12, 21, 16, 31, 19, 8, 17, 9]) AND (e5.Rel_2_4_Bool) MATCH (v5)-[e6:Rel_3]->(v6)<-[e7:Rel_2]-(v3) WHERE (v5.id = 19) AND (e5.Rel_2_4_Bool) MATCH p0 = (v7:Label_3{Label_3_4_String: 'Stephen Curry'})<-[e8]-(v2)-[e9:Rel_3]->(v8:Label_4{Label_4_3_Double: 0.175132}) WHERE (v7.id in [14, 3, 19, 21, 15, 9, 2, 12, 7, 27, 23]) AND ((v8.Label_0_4_Int <= (- v1.Label_2_2_Double))) WITH * return count(*)

╒══════════╕
│"count(*)"│
╞══════════╡
│0         │
└──────────┘

Your Environments (required)

• OS: uname -a
• Compiler: g++ --version or clang++ --version
• CPU: lscpu
• Commit id (e.g. a3ffc7d8) https://github.com/vesoft-inc/nebula/tree/611c6705f9ef57c2f21104dabf9c3b59d45d1e65

How To Reproduce(required)

Steps to reproduce the behavior:

1. Step 1
2. Step 2
3. Step 3

Expected behavior

Additional context