WHERE count(v) will crash

[wey-gu]

Should this be supported or? It will now crash the server-side.

MATCH (v:player)-[e:follow]->(v1:player) WHERE count(v) > 2 WITH id(v) as src, count(v) as count RETURN src

[Sophie-Xie]

in v2.6.0 there is no crash.

(root@nebula) [basketballplayer]> MATCH (v:player)-[e:follow]->(v1:player) WHERE count(v) > 2 WITH id(v) as src, count(v) as count RETURN src
[ERROR (-1004)]: SyntaxError: Invalid use of aggregating function in this context. near `WHERE count(v) > 2'

Thu, 04 Nov 2021 08:44:24 UTC

(root@nebula) [basketballplayer]> show hosts graph

+-------------+------+----------+---------+--------------+---------+
| Host        | Port | Status   | Role    | Git Info Sha | Version |
+-------------+------+----------+---------+--------------+---------+
| "127.0.0.1" | 9669 | "ONLINE" | "GRAPH" | "3ba41bd"    | "2.6.0" |
+-------------+------+----------+---------+--------------+---------+
Got 1 rows (time spent 1151/1901 us)

Thu, 04 Nov 2021 08:44:51 UTC

[wey-gu]

closing it as it's realized as invalid instead of crashing the server-side.

(root@nebula) [basketballplayer]> show hosts storage
+-------------+------+----------+-----------+--------------+----------------------+
| Host        | Port | Status   | Role      | Git Info Sha | Version              |
+-------------+------+----------+-----------+--------------+----------------------+
| "storaged0" | 9779 | "ONLINE" | "STORAGE" | "07ccfde"    | "2021.11.03-nightly" |
| "storaged1" | 9779 | "ONLINE" | "STORAGE" | "07ccfde"    | "2021.11.03-nightly" |
| "storaged2" | 9779 | "ONLINE" | "STORAGE" | "07ccfde"    | "2021.11.03-nightly" |
+-------------+------+----------+-----------+--------------+----------------------+
Got 3 rows (time spent 962/2582 us)

Wed, 10 Nov 2021 04:28:32 UTC

(root@nebula) [basketballplayer]> MATCH (v:player)-[e:follow]->(v1:player) WHERE count(v) > 2 WITH id(v) as src, count(v) as count RETURN src
[ERROR (-1004)]: SyntaxError: Invalid use of aggregating function in this context. near `WHERE count(v) > 2'

Wed, 10 Nov 2021 04:28:40 UTC

(root@nebula) [basketballplayer]>