MuhammadTahaNaveed commented on issue #1850:
URL: https://github.com/apache/age/issues/1850#issuecomment-2104329239
> @MuhammadTahaNaveed, hello! One more crash on postgres REL_16_STABLE and
Age PG16 on build without cassert.
hello @saygoodbyye
The issue is with the query that you have already reported before i.e.
```
SELECT * FROM cypher('list_comprehension', $$ MATCH(u {list: [0, 2, 4, 6, 8,
10, 12]}) WITh u, collect(u.list) AS v SET u += {b: [u IN range(0, 5)]} SET u.c
= [u IN v[0]] RETURN u $$) AS (u agtype);
```
The following query is expected to return error and it does
```
issue_1850=# SELECT * FROM cypher('list_comprehension', $$ MATCH(u {list:
[0, 2, 4, 6, 8, 10, 12]}) SET u.c = collect(u.list) RETURN u $$) AS (u agtype);
2024-05-10 15:00:58.312 PKT [44331] ERROR: Invalid use of aggregation in
this context at character 92
2024-05-10 15:00:58.312 PKT [44331] STATEMENT: SELECT * FROM
cypher('list_comprehension', $$ MATCH(u {list: [0, 2, 4, 6, 8, 10, 12]}) SET
u.c = collect(u.list) RETURN u $$) AS (u agtype);
ERROR: Invalid use of aggregation in this context
LINE 1: ..., $$ MATCH(u {list: [0, 2, 4, 6, 8, 10, 12]}) SET u.c = coll...
^
```
I am working on a fix for the bug that you reported. I will update you as
soon as I have an update or a fix.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
