Re: [I] MERGE using array not working in some cases [age]

2024-03-07 Thread via GitHub
mingfang closed issue #1630: MERGE using array not working in some cases URL: https://github.com/apache/age/issues/1630 -- 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

Re: [I] MERGE using array not working in some cases [age]

2024-03-07 Thread via GitHub
mingfang commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1984246692 confirmed fixed -- 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.

Re: [I] MERGE using array not working in some cases [age]

2024-03-07 Thread via GitHub
mingfang commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1984229522 I was just about to say the master will need an upgrade script to change the `age_unnest()`. -- This is an automated message from the Apache Git Service. To respond to the message,

Re: [I] MERGE using array not working in some cases [age]

2024-03-07 Thread via GitHub
jrgemignani commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1984226718 @mingfang You may need to drop the extension and then reload it. ``` psql-16.1-5432-pgsql=# SELECT * FROM cypher('test', $$ unwind ['a'] as v return v $$) AS (v agtype);

Re: [I] MERGE using array not working in some cases [age]

2024-03-07 Thread via GitHub
mingfang commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1983658459 I might not be building the master branch correctly because now I'm seeing a weird completely unrelated error with `unwind` clause. Here is my output ```sql SELECT * FROM

Re: [I] MERGE using array not working in some cases [age]

2024-03-06 Thread via GitHub
jrgemignani commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1981603551 @mingfang The master branch is currently PG16. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL

Re: [I] MERGE using array not working in some cases [age]

2024-03-06 Thread via GitHub
mingfang commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1981555838 @jrgemignani Thanks. Is the master compatible with PG16? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and

Re: [I] MERGE using array not working in some cases [age]

2024-03-06 Thread via GitHub
jrgemignani commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1981528716 @mingfang The PR was approved and applied to the master branch. This should be resolved. Please verify, at your convenience, and consider closing the ticket if this is resolved :)

Re: [I] MERGE using array not working in some cases [age]

2024-03-04 Thread via GitHub
jrgemignani commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1977491224 PR #1636 created to fix this issue in the master branch. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the

Re: [I] MERGE using array not working in some cases [age]

2024-03-04 Thread via GitHub
mingfang commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1977373778 @jrgemignani Amazing detective work! Thanks for figuring it out so quickly. -- This is an automated message from the Apache Git Service. To respond to the message, please log

Re: [I] MERGE using array not working in some cases [age]

2024-03-04 Thread via GitHub
jrgemignani commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1977315056 @mingfang I should have a PR for the fix today. This particular bug is due to PG function `remove_unused_subquery_outputs`. For whatever reason, the PG logic feels that it is okay

Re: [I] MERGE using array not working in some cases [age]

2024-02-29 Thread via GitHub
jrgemignani commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1972291444 @mingfang I found the issue and am working on 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

Re: [I] MERGE using array not working in some cases [age]

2024-02-29 Thread via GitHub
jrgemignani commented on issue #1630: URL: https://github.com/apache/age/issues/1630#issuecomment-1972069360 @mingfang Thank you for finding this bug. We will look into fixing it. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to

[I] MERGE using array not working in some cases [age]

2024-02-27 Thread via GitHub
mingfang opened a new issue, #1630: URL: https://github.com/apache/age/issues/1630 ```cypher WITH ['jon', 'snow'] AS cols MERGE (v:PERSION {first: cols[0], last: cols[1]}) RETURN v ``` returns wrong result. person is missing first and last name. ```json {