[DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 13

2024-02-16 Thread John Gemignani
Dear Apache Community,

We would like to open a discussion for the Apache AGE release 1.5.0 for
PostgreSQL 13.

To learn more about Apache AGE, please see http://age.apache.org/

Functionalities included and addressed in this release are:

*
Release Notes for Apache AGE release 1.5.0 for PostgreSQL version 13

Apache AGE 1.5.0 - Release Notes

NOTE: Due to the complexity and the amount of additions, there are no
upgrade scripts to this release.

NOTE: Some of these reference the master branch PR that was
either applied to lower versions via a separate PR or
merged into a newly created branch.

Add additional index support and performance enhancements (#1232)
Add an additional way to find a previous variable ref (#1450)
Add auto apply labeler workflow for PRs (#1161)
Add checks for array functions to recognize and decode VPC (#1064)
Add concat || operator to agtype (#1198)
Add exist(?, ?|, ?&) operators for agtype (#1218)
Add missing dependency in cypher_expr.c (#1256)
Add path extraction(#>, #>>)operators to agtype (#1224)
Add support for chained expressions in CASE (#1431)
Clean up agtype_to_int8, agtype_to_int4, & agtype_to_int2 (#1354)
Clean up #included files in parser directory (#1465)
Converted SQL main file into multiple files. (#1401)
docs: Add to Docker setup (#1204)
Extend access(->, ->>), addition and subtraction operators (#1258)
Extend agtype containment operators (@>, <@) (#1285)
Extend EXPLAIN and add config param to switch transformation of property
filter (#1262)
Fix ambiguous conditions (#1373)
Fix DockerHub warning messages for latest (#1380)
Fix issue #1045 - error using path var in WHERE (#1295)
Fix Issue #1159 - Server terminates for SET plus-equal (#1160)
Fix issue #1219 - MERGE not seeing previous clause var (#1441)
Fix issue #1302 - crash on NULL input to UNWIND (#1304)
Fix issue #1303 - Server crashes on executing SELECT * FROM agtype(null);
(#1317)
Fix Issue #1305 - drop_label NULL cases (#1306)
Fix Issue #1329 - agtype_to_int4 crash (#1339)
Fix issue #1347 - unknow type of agtype container 0 (#1349)
Fix issue #1389 - Server crash on using null operand for access operators
(#1390)
Fix issue #1393 - previous clause variables not seen with EXISTS (#1426)
Fix issue #1398 - SET followed by DELETE does not delete (#1412)
Fix issue #1399 - EXISTS doesn't handle non-existent labels (#1400)
Fix Issue #945 - incorrect count(*) return values (#1288)
Fix typo in agtype_raw.h header guard (#1368)
Implement chained expression order of operations (#1402)
Implemented age_tail function (#1283)
Implemented the toBooleanList() function (#1014)
Implement EXISTS subquery for CASE (#1345)
Minor fix in agtype_volatile_wrapper function (#1172)
Modify COUNT() to output agtype (#1311)
Optimize performance of detach delete (#1271)
Optimize vertex and edge builder functions (#1252)
py_driver : optimised Antlr4ResultHandler to improve time (#1107)
Refactor Regression Tests for CASE statement (#1268)
Refactor the IN operator to use '= ANY()' syntax (#1236)
Removed unnecessary assignment (#1185)
Remove redundant job from CIs (#1473)
Remove unnecessary #include in src/backend/utils
Updated age.control.
Updated files, format, and version information.
Updated Makefile.
Updated RELEASE.
Update Discord channel in README.md (#1253)
Update README.md file for PostgreSQL version 16 support (#1463)
Update the Python Driver (#1246)

*

The git tag to be discussed and voted on:
https://github.com/apache/age/releases/tag/PG13/v1.5.0-rc0

The git commit hash:
commit 57d39228edae28182bd93e7233fa7d90c069f137

The release files for 1.5.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG13/1.5.0.rc0/

Signatures used for AGE RCs can be found in this file:
https://downloads.apache.org/age/KEYS

The fingerprint of key to sign release artifacts:
4293 0603 8E35 AC05 4DBB  4B58 26B6 CD9D CD5B 0045

For information about the contents of this release see:
https://github.com/apache/age/releases/tag/PG13/v1.5.0-rc0

Please verify the above links, files, and signatures in addition to sharing
your thoughts and feedback and if we can call for a vote.

Thank you for your time.

John Gemignani


[RESULT][VOTE] Apache AGE 1.5.0 Release for PostgreSQL 14

2024-02-16 Thread John Gemignani
Dear Apache Community,

The vote successfully passed with 4 +1 (binding) and 2 +1 (non-binding)

votes. There were no 0 or -1 votes.


Following are the detailed results :

Total of 6 (+1) votes.

4 +1 (binding)

Muhammad Shoaib

Dehowe Feng

Rafsun Masud

Eya Badal

2 +1 (non-binding)

Muhammad Taha Naveed

Zainab Saad

VOTE thread:

https://lists.apache.org/thread/7zy8w53szpsl2nxt1cqppv6xn7vsf23p


Thank you all!

John Gemignani


Re: [VOTE] Apache AGE 1.5.0 Release for PostgreSQL 14

2024-02-16 Thread John Gemignani
Dear Apache Community,

We would like to thank everyone who participated in the voting process and
are now closing this vote and will be sending out the results shortly.

John Gemignani

On Fri, Feb 16, 2024 at 9:03 AM Eya Badal  wrote:

> +1 Binding
> I've checked the following:
>
> - Signature and hash
> - License and notice
> - Links and tags
> - No unexpected binary files
>
> On 2024/02/09 22:46:04 John Gemignani wrote:
> > Dear Apache Community,
> >
> > Please carefully read all instructions as they may have changed since the
> > last vote thread.
> >
> > This is an official vote for Apache AGE release 1.5.0 for PostgreSQL 14.
> >
> > To learn more about Apache AGE, please see http://age.apache.org/
> >
> > Functionalities included and addressed in this release are:
> >
> > *
> > Release Notes for Apache AGE release 1.5.0 for PostgreSQL version 14
> >
> > Apache AGE 1.5.0 - Release Notes
> >
> > NOTE: Due to the complexity and the amount of additions, there are no
> >upgrade scripts to this release.
> >
> > NOTE: Some of these reference the master branch PR that was
> > either applied to lower versions via a separate PR or
> > merged into a newly created branch.
> >
> > Add additional index support and performance enhancements (#1232)
> > Add an additional way to find a previous variable ref (#1450)
> > Add auto apply labeler workflow for PRs (#1161)
> > Add checks for array functions to recognize and decode VPC (#1064)
> > Add concat || operator to agtype (#1198)
> > Add exist(?, ?|, ?&) operators for agtype (#1218)
> > Add missing dependency in cypher_expr.c (#1256)
> > Add path extraction(#>, #>>)operators to agtype (#1224)
> > Add support for chained expressions in CASE (#1431)
> > Clean up agtype_to_int8, agtype_to_int4, & agtype_to_int2 (#1354)
> > Clean up #included files in parser directory (#1465)
> > Converted SQL main file into multiple files. (#1401)
> > docs: Add to Docker setup (#1204)
> > Extend access(->, ->>), addition and subtraction operators (#1258)
> > Extend agtype containment operators (@>, <@) (#1285)
> > Extend EXPLAIN and add config param to switch transformation of property
> > filter (#1262)
> > Fix ambiguous conditions (#1373)
> > Fix DockerHub warning messages for latest (#1380)
> > Fix issue #1045 - error using path var in WHERE (#1295)
> > Fix Issue #1159 - Server terminates for SET plus-equal (#1160)
> > Fix issue #1219 - MERGE not seeing previous clause var (#1441)
> > Fix issue #1302 - crash on NULL input to UNWIND (#1304)
> > Fix issue #1303 - Server crashes on executing SELECT * FROM agtype(null);
> > (#1317)
> > Fix Issue #1305 - drop_label NULL cases (#1306)
> > Fix Issue #1329 - agtype_to_int4 crash (#1339)
> > Fix issue #1347 - unknow type of agtype container 0 (#1349)
> > Fix issue #1389 - Server crash on using null operand for access operators
> > (#1390)
> > Fix issue #1393 - previous clause variables not seen with EXISTS (#1426)
> > Fix issue #1398 - SET followed by DELETE does not delete (#1412)
> > Fix issue #1399 - EXISTS doesn't handle non-existent labels (#1400)
> > Fix Issue #945 - incorrect count(*) return values (#1288)
> > Fix typo in agtype_raw.h header guard (#1368)
> > Implement chained expression order of operations (#1402)
> > Implemented age_tail function (#1283)
> > Implemented the toBooleanList() function (#1014)
> > Implement EXISTS subquery for CASE (#1345)
> > Master to PostgreSQL version 16 (#1451)
> > Minor fix in agtype_volatile_wrapper function (#1172)
> > Modify COUNT() to output agtype (#1311)
> > Optimize performance of detach delete (#1271)
> > Optimize vertex and edge builder functions (#1252)
> > py_driver : optimised Antlr4ResultHandler to improve time (#1107)
> > Refactor Regression Tests for CASE statement (#1268)
> > Refactor the IN operator to use '= ANY()' syntax (#1236)
> > Removed unnecessary assignment (#1185)
> > Remove redundant job from CIs (#1473)
> > Remove unnecessary #include in src/backend/utils
> > Updated age.control.
> > Updated files, format, and version information.
> > Updated Makefile.
> > Updated RELEASE.
> > Update Discord channel in README.md (#1253)
> > Update README.md file for PostgreSQL version 16 support (#1463)
> > Update the Python Driver (#1246)
> >
> > *
> > !!! PLEASE VERIFY ALL of the below tags, hash, links, signatures, and
> keys
> > !!!
> >
> > The git tag to be discussed and voted on:
> > https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0
> >
> > The git commit hash:
> > commit ffc3072127f4a6da72eb4b99c4aca6dce28fd145
> >
> > The release files for 1.5.0, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG14/1.5.0.rc0/
> >
> > Signatures used for AGE RCs can be found in this file:
> > https://downloads.apache.org/age/KEYS
> >
> > The fingerprint of key to sign release artifacts:
> > 4293 0603 8E35 AC05 

Re: [VOTE] Apache AGE 1.5.0 Release for PostgreSQL 14

2024-02-16 Thread Eya Badal
+1 Binding
I've checked the following:

- Signature and hash
- License and notice
- Links and tags
- No unexpected binary files

On 2024/02/09 22:46:04 John Gemignani wrote:
> Dear Apache Community,
> 
> Please carefully read all instructions as they may have changed since the
> last vote thread.
> 
> This is an official vote for Apache AGE release 1.5.0 for PostgreSQL 14.
> 
> To learn more about Apache AGE, please see http://age.apache.org/
> 
> Functionalities included and addressed in this release are:
> 
> *
> Release Notes for Apache AGE release 1.5.0 for PostgreSQL version 14
> 
> Apache AGE 1.5.0 - Release Notes
> 
> NOTE: Due to the complexity and the amount of additions, there are no
>upgrade scripts to this release.
> 
> NOTE: Some of these reference the master branch PR that was
> either applied to lower versions via a separate PR or
> merged into a newly created branch.
> 
> Add additional index support and performance enhancements (#1232)
> Add an additional way to find a previous variable ref (#1450)
> Add auto apply labeler workflow for PRs (#1161)
> Add checks for array functions to recognize and decode VPC (#1064)
> Add concat || operator to agtype (#1198)
> Add exist(?, ?|, ?&) operators for agtype (#1218)
> Add missing dependency in cypher_expr.c (#1256)
> Add path extraction(#>, #>>)operators to agtype (#1224)
> Add support for chained expressions in CASE (#1431)
> Clean up agtype_to_int8, agtype_to_int4, & agtype_to_int2 (#1354)
> Clean up #included files in parser directory (#1465)
> Converted SQL main file into multiple files. (#1401)
> docs: Add to Docker setup (#1204)
> Extend access(->, ->>), addition and subtraction operators (#1258)
> Extend agtype containment operators (@>, <@) (#1285)
> Extend EXPLAIN and add config param to switch transformation of property
> filter (#1262)
> Fix ambiguous conditions (#1373)
> Fix DockerHub warning messages for latest (#1380)
> Fix issue #1045 - error using path var in WHERE (#1295)
> Fix Issue #1159 - Server terminates for SET plus-equal (#1160)
> Fix issue #1219 - MERGE not seeing previous clause var (#1441)
> Fix issue #1302 - crash on NULL input to UNWIND (#1304)
> Fix issue #1303 - Server crashes on executing SELECT * FROM agtype(null);
> (#1317)
> Fix Issue #1305 - drop_label NULL cases (#1306)
> Fix Issue #1329 - agtype_to_int4 crash (#1339)
> Fix issue #1347 - unknow type of agtype container 0 (#1349)
> Fix issue #1389 - Server crash on using null operand for access operators
> (#1390)
> Fix issue #1393 - previous clause variables not seen with EXISTS (#1426)
> Fix issue #1398 - SET followed by DELETE does not delete (#1412)
> Fix issue #1399 - EXISTS doesn't handle non-existent labels (#1400)
> Fix Issue #945 - incorrect count(*) return values (#1288)
> Fix typo in agtype_raw.h header guard (#1368)
> Implement chained expression order of operations (#1402)
> Implemented age_tail function (#1283)
> Implemented the toBooleanList() function (#1014)
> Implement EXISTS subquery for CASE (#1345)
> Master to PostgreSQL version 16 (#1451)
> Minor fix in agtype_volatile_wrapper function (#1172)
> Modify COUNT() to output agtype (#1311)
> Optimize performance of detach delete (#1271)
> Optimize vertex and edge builder functions (#1252)
> py_driver : optimised Antlr4ResultHandler to improve time (#1107)
> Refactor Regression Tests for CASE statement (#1268)
> Refactor the IN operator to use '= ANY()' syntax (#1236)
> Removed unnecessary assignment (#1185)
> Remove redundant job from CIs (#1473)
> Remove unnecessary #include in src/backend/utils
> Updated age.control.
> Updated files, format, and version information.
> Updated Makefile.
> Updated RELEASE.
> Update Discord channel in README.md (#1253)
> Update README.md file for PostgreSQL version 16 support (#1463)
> Update the Python Driver (#1246)
> 
> *
> !!! PLEASE VERIFY ALL of the below tags, hash, links, signatures, and keys
> !!!
> 
> The git tag to be discussed and voted on:
> https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0
> 
> The git commit hash:
> commit ffc3072127f4a6da72eb4b99c4aca6dce28fd145
> 
> The release files for 1.5.0, can be found at:
> https://dist.apache.org/repos/dist/dev/age/PG14/1.5.0.rc0/
> 
> Signatures used for AGE RCs can be found in this file:
> https://downloads.apache.org/age/KEYS
> 
> The fingerprint of key to sign release artifacts:
> 4293 0603 8E35 AC05 4DBB  4B58 26B6 CD9D CD5B 0045
> 
> For information about the contents of this release see:
> https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0
> 
> *
> 
> !!! IMPORTANT PLEASE READ !!!
> 
> Please note that Apache REQUIRES the following information to be in your
> response to the vote, in order for it to be valid -
> 
> - If you are a binding vote, a PMC, 

[I] Can we add support for ON CREATE SET and ON MATCH SET. (like neo4j) [age]

2024-02-16 Thread via GitHub


sanket-uptycs opened a new issue, #1619:
URL: https://github.com/apache/age/issues/1619

   **Is your feature request related to a problem? Please describe.**
   While using MERGE clause need support for ON CREATE SET and ON MATCH SET 
   currently i have change my queries to SET instead of ON CREATE SET.
   
   **Describe the solution you'd like**
   Add support got ON CREATE SET and ON MATCH SET
   
   **Describe alternatives you've considered**
   Using SET for setting properties.
   
   **Additional context**
   
https://memgraph.com/docs/querying/clauses/merge#3-merging-with-on-create-set-and-on-match-set
   
https://neo4j.com/docs/cypher-manual/current/clauses/merge/#query-merge-on-create-on-match


-- 
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: dev-unsubscr...@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



Re: [I] Need postgres with graph extensions running on windows OS [age]

2024-02-16 Thread via GitHub


muhammadshoaib commented on issue #1542:
URL: https://github.com/apache/age/issues/1542#issuecomment-1948334108

   Hi, 
   
   Could you please provide the information about your environment weather you 
are running AGE on windows using Visual Studio compiler or you are using WSL. 
We have done a testing on WSL long time ago. 
   
   Your feedback will help in determining the issue and will lead to eventual 
solution. 
   
   Thanks. 
   MS


-- 
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: dev-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



Re: [I] The Go driver becomes "undefined: parser", and the application cannot be built. [age]

2024-02-16 Thread via GitHub


sanket-uptycs commented on issue #1455:
URL: https://github.com/apache/age/issues/1455#issuecomment-1948013885

   @jrgemignani Thanks man ! 


-- 
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: dev-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org