Re: [DISCUSS] Apache AGE - fully Graph DBMS PR

2024-05-24 Thread John Gemignani
So long as it stays in its own branch, it shouldn't have any conflicts with
AGE's source code. As it stands now, the PR was merged into the branch
PROPOSAL_PG_Graph, by me.

Again, this needs to go through the proper procedures. Otherwise, I'm fine
with the addition.

john

On Fri, May 24, 2024 at 2:54 PM Rafsun Masud  wrote:

> Hi Everyone,
>
> To add one top of what has already been mentioned,
>
> AGE as an independent graph DBMS sounds interesting. It seems the file and
> folder structure of such a project will be very different from the AGE as
> an extension. In my opinion, there may be some challenges to maintain them
> in the same repository.
>
> --
> *Rafsun Masud*
>
>
> On Fri, May 24, 2024 at 8:32 AM John Gemignani 
> wrote:
>
> > If I am understanding this correctly, this is a PR for a new project
> along
> > side of the Apache AGE extension. It does not modify nor extend the
> actual
> > extension itself, which is Apache AGE. It merely adds an alternative,
> > rooted in PostgreSQL version 13, to the extension.
> >
> > I am not opposed to thinking of Apache AGE as a suite of openCypher
> > implementations and adding this as a fully integrated openCypher
> > implementation option; this could give more options to users.
> >
> > However, as this PR is donated code, I believe it will need to go through
> > the whole donation process.
> >
> > Additional questions to think about -
> >
> > How fully does it implement the openCypher specification compared to the
> > extension?
> > How does it perform relative to the extension?
> > Will we have the resources to bring them into line and across all
> > supported versions?
> > Does the community want or need this?
> >
> > john
> >
> > On 2024/05/06 21:52:08 Eya Badal wrote:
> > > Dear Everyone,
> > >
> > > I hope you are doing great.
> > >
> > > We would like to have a conversation about a recent Pull Request [1]
> > that we received for Apache AGE. This Pull Request seems to introduce new
> > extension features for AGE within the DBMS core engine. Currently, it
> > utilizes PostgreSQL13 and aims to transform AGE from its existing
> extension
> > format into a fully Graph DBMS built on top of PostgreSQL[2].
> > >
> > > Please let us know what you think.
> > >
> > > [1] https://github.com/apache/age/pull/1801
> > > [2] https://github.com/apache/age/issues/1802
> > >
> > >
> > > Thank you very much,
> > > Eya Badal
> > >
> >
>


Re: [DISCUSS] Apache AGE - fully Graph DBMS PR

2024-05-24 Thread John Gemignani
If I am understanding this correctly, this is a PR for a new project along side 
of the Apache AGE extension. It does not modify nor extend the actual extension 
itself, which is Apache AGE. It merely adds an alternative, rooted in 
PostgreSQL version 13, to the extension.

I am not opposed to thinking of Apache AGE as a suite of openCypher 
implementations and adding this as a fully integrated openCypher implementation 
option; this could give more options to users.

However, as this PR is donated code, I believe it will need to go through the 
whole donation process. 

Additional questions to think about - 

How fully does it implement the openCypher specification compared to the 
extension?
How does it perform relative to the extension?
Will we have the resources to bring them into line and across all supported 
versions?
Does the community want or need this?

john

On 2024/05/06 21:52:08 Eya Badal wrote:
> Dear Everyone,
> 
> I hope you are doing great.
> 
> We would like to have a conversation about a recent Pull Request [1] that we 
> received for Apache AGE. This Pull Request seems to introduce new extension 
> features for AGE within the DBMS core engine. Currently, it utilizes 
> PostgreSQL13 and aims to transform AGE from its existing extension format 
> into a fully Graph DBMS built on top of PostgreSQL[2].
> 
> Please let us know what you think. 
> 
> [1] https://github.com/apache/age/pull/1801
> [2] https://github.com/apache/age/issues/1802
> 
> 
> Thank you very much,
> Eya Badal
> 


Re: Releases on Docker Hub

2024-05-10 Thread John Gemignani
Hi Justin,

Here is what I have done so far to clean up and organize the DockerHub
builds and tags. I have attempted to make it pretty clear on its own -

https://hub.docker.com/repository/docker/apache/age/tags

I will have whomever is responsible for the general page add in something
explaining what is what, preferably at the top of the page -

https://hub.docker.com/repository/docker/apache/age/general

John

On Thu, May 9, 2024 at 10:13 PM Justin Mclean  wrote:

> H,
>
> Please remember that the word "release" has a specific ASF meaning, i.e.
> an artifact voted on a PMC.
>
> The main issue here is that you are getting users to download unreleased
> code. Please don't do that. Doing so means the PMC doesn't have the legal
> protection the ASF gives by following its release procedures.
>
> Kind Regards,
> Justin
>


Re: Releases on Docker Hub

2024-05-09 Thread John Gemignani
Hi Justin,

"The advice given to incubating projects is to only include voted releases
on DockerHub and not use the latest.[1]"

Per the link you gave [1] it does not state that, it only states that they
must be properly tagged.

Links [1] & [2] either contradict or are ambiguous on what can be on
DockerHub.

"PMCs can host product releases on Docker Hub for users to download, build,
and deploy. " [2]


   -

   Release candidates, nightlys or snapshots need to be clearly tagged.
   -

   The latest tag should not point to an artifact containing unapproved
   code e.g. to master or dev branches or to a RC or snapshot.

[1]

[2] Does not state what you can't have. [1] States that you can, just that
it needs to be properly labeled.

I will look at other projects to see how they do it and adjust it
accordingly.

John



On Wed, May 8, 2024 at 10:40 PM Justin Mclean  wrote:

> Hi,
>
> The advice given to incubating projects is to only include voted releases
> on DockerHub and not use the latest.[1]  Infa policy say the same thing
> about only hosting releases. [2]
>
> Kind Regards,
> Justin
> 1. https://incubator.apache.org/guides/distribution.html#docker
> 2. https://infra.apache.org/docker-hub-policy.html
>


Re: Releases on Docker Hub

2024-05-07 Thread John Gemignani
Hi Justin,

Are you saying that we need to remove the Docker hub link in the download
page? Or, am I missing something?

Thanks!

John

On Mon, May 6, 2024 at 11:34 PM Justin Mclean  wrote:

> HI,
>
> I was looking at [1], and you are pushing non-released versions there,
> which are linked to your download page. ASF release policy does not allow
> this [2], so it would be great if you could fix this.
>
> Kind Regards,
> Justin
>
> 1. https://hub.docker.com/r/apache/age/tags
> 2. https://www.apache.org/legal/release-policy.html#publication
>


Re: Change default branch for age-website repo?

2024-04-05 Thread John Gemignani
Hi Sebb,

Just letting you know that I have brought this email to the attention of
those responsible for the website repo.

john

On Thu, Apr 4, 2024 at 4:32 PM sebb  wrote:

> Another reason for changing the default branch is that GH search only
> applies to the default branch.
>
> On Thu, 4 Apr 2024 at 17:19, sebb  wrote:
> >
> > The AGE website is currently built from the new-web branch rather than
> > the default master branch.
> > This is confusing for outsiders who may wish generate PRs or issues
> > relating to the site.
> >
> > It might be time to ask raise an INFRA Jira to ask for the default to
> > be changed.
> >
> > Or at least the README in the master branch should be edited make it
> > clear that the source for the site is located elsewhere.
> >
> > Note: you may need to copy some settings from .asf.yaml in the master
> branch.
> >
> > Sebb
>


Re: PR 289 broke the site build

2024-04-04 Thread John Gemignani
ty Sebb!

I have brought it up with the people working on the website.

john

On Thu, Apr 4, 2024 at 3:07 PM sebb  wrote:

> It looks like the build failures were not sent to the project.
> You can enable this in .asf.yaml:
>
>
> https://github.com/apache/infrastructure-asfyaml/blob/main/README.md#github-actions-build-status-emails
>
> On Thu, 4 Apr 2024 at 22:53, John Gemignani  wrote:
> >
> > Yep. We should have a fix shortly.
> >
> > john
> >
> > On Thu, Apr 4, 2024 at 2:50 PM sebb  wrote:
> >
> > > Looks like a change in PR289 broke the site build:
> > >
> > > https://github.com/apache/age-website/actions/runs/8550540429
> > >
> > > Error message:
> > > error Error processing Markdown file
> > > /home/runner/work/age-website/age-website/src/pages/index.md:
> > > bad indentation of a mapping entry at line 12, column 2:
> > >  
> > > ^
> > >
> > > Sebb
> > >
>


Re: PR 289 broke the site build

2024-04-04 Thread John Gemignani
Yep. We should have a fix shortly.

john

On Thu, Apr 4, 2024 at 2:50 PM sebb  wrote:

> Looks like a change in PR289 broke the site build:
>
> https://github.com/apache/age-website/actions/runs/8550540429
>
> Error message:
> error Error processing Markdown file
> /home/runner/work/age-website/age-website/src/pages/index.md:
> bad indentation of a mapping entry at line 12, column 2:
>  
> ^
>
> Sebb
>


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

2024-03-19 Thread John Gemignani
Dear Apache Community,

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

votes. There were no 0 or -1 votes.

Following are the detailed results :

Total of 5 (+1) votes.

3 +1 (binding)

Muhammad Shoaib

Dehowe Feng

Rafsun Masud

2 +1 (non-binding)

Zainab Saad

Muhammad Taha Naveed


VOTE thread:

https://lists.apache.org/thread/k6qgjnzp3p0k70wgyf72tg5xgpr1xol3

Thank you all for your support of this release process!

John Gemignani


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

2024-03-19 Thread John Gemignani
Dear Apache AGE 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 Mon, Mar 18, 2024 at 12:05 PM Muhammad Taha Naveed
 wrote:

> +1
>
> - Signature and Hash => checked
> - Tags and links => checked
> - No unexpected binary files => checked
> - Validity of release notes => checked
> - Regression tests => checked (all passing)
> - Driver tests => checked
>
> Regards
> Muhammad Taha Naveed
>
> On Sat, Mar 16, 2024 at 3:03 AM 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
> > version 11.
> >
> > 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 11
> >
> > 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)
> &g

[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 11

2024-03-15 Thread John Gemignani
ay
be thrown out.

!!! IMPORTANT PLEASE READ !!!

Please vote as follows -

+1, Release this package as Apache AGE 1.5.0 for PostgreSQL 11.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

 !!! Followed by what you checked !!!

Sample responses, two for PMCs (binding) and two for regular committers.
These are only samples, do not copy/paste.

Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
binding. If you are a PMC, you must state it.

   +1 (binding)   +1
   Checked the following:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 11

2024-03-15 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the DISCUSS thread and will
open the official VOTE thread for Apache AGE 1.5.0 for PostgreSQL 11
shortly.

Thank you all for your time and effort!


John Gemignani


On Thu, Mar 14, 2024 at 2:25 PM Eya Badal  wrote:

> Looks good to me. Thank you.
>
> On 2024/03/11 22:56:48 John Gemignani wrote:
> > Dear Apache Community,
> >
> > We would like to open a discussion for the Apache AGE release 1.5.0 for
> > PostgreSQL 11.
> >
> > 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 11
> >
> > 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/PG11/v1.5.0-rc0
> >
> > The git commit hash:
> > commit 95bf818d4d83be704bbd33be43d266b90d234e55
> >
> > The release files for 1.5.0, can

[DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 11

2024-03-11 Thread John Gemignani
Dear Apache Community,

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

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 11

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/PG11/v1.5.0-rc0

The git commit hash:
commit 95bf818d4d83be704bbd33be43d266b90d234e55

The release files for 1.5.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG11/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/PG11/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 12

2024-03-11 Thread John Gemignani
Dear Apache Community,

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

votes. There were no 0 or -1 votes.

Following are the detailed results :

Total of 5 (+1) votes.

3 +1 (binding)

Dehowe Feng

Rafsun Masud

Muhammad Shoaib

2 +1 (non-binding)

Zainab Saad

Muhamad Taha Naveed


VOTE thread:

https://lists.apache.org/thread/wz5z4jhtmp2qmjbh24dggkm1fq37rd3h


Again, thank you all!

John Gemignani


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

2024-03-11 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.

Thank you all for your time and effort.

John Gemignani

On Fri, Mar 8, 2024 at 9:34 AM Zainab Saad
 wrote:

> +1
>
> Checked the following:
> - Release notes
> - Tag
> - Commit hash
> - Links and Signature
>
> Regards,
> Zainab Saad
>
> On Fri, Mar 8, 2024 at 1:35 PM Muhammad Taha Naveed
>  wrote:
>
> > +1
> >
> > - Signature and Hash => checked
> > - Tags and links => checked
> > - No unexpected binary files => checked
> > - Validity of release notes => checked
> > - Regression tests => checked (all passing)
> > - Driver tests => checked
> >
> > Regards
> > Muhammad Taha Naveed
> >
> > On Thu, Mar 7, 2024, 05:18 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
> > > version 12.
> > >
> > > 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 12
> > >
> > > 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)
> > > Opt

[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 12

2024-03-06 Thread John Gemignani
ay
be thrown out.

!!! IMPORTANT PLEASE READ !!!

Please vote as follows -

+1, Release this package as Apache AGE 1.5.0 for PostgreSQL 12.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

 !!! Followed by what you checked !!!

Sample responses, two for PMCs (binding) and two for regular committers.
These are only samples, do not copy/paste.

Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
binding. If you are a PMC, you must state it.

   +1 (binding)   +1
   Checked the following:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 12

2024-03-06 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official [VOTE] thread for Apache AGE 1.5.0 for PostgreSQL 12
shortly.

Thank you all for your efforts!


John Gemignani


On Wed, Mar 6, 2024 at 11:24 AM Eya Badal  wrote:

> Looks good to me. Great job!!
>
> On 2024/02/29 01:34:41 John Gemignani wrote:
> > Dear Apache Community,
> >
> > We would like to open a discussion for the Apache AGE release 1.5.0 for
> > PostgreSQL 12.
> >
> > 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 12
> >
> > 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/PG12/v1.5.0-rc0
> >
> > The git commit hash:
> > commit 033a3c563b16ce9a12318cd09d0a5981e6c52225
> >
> > The release files for 1.5.

[DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 12

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

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

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 12

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/PG12/v1.5.0-rc0

The git commit hash:
commit 033a3c563b16ce9a12318cd09d0a5981e6c52225

The release files for 1.5.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG12/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/PG12/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 13

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

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

votes. There were no 0 or -1 votes.

Following are the detailed results :

Total of 5 (+1) votes.

3 +1 (binding)

Muhammad Shoaib

Rafsun Masud

Eya Badal

2 +1 (non-binding)

Muhammad Taha Naveed

Zainab Saad

VOTE thread:

https://lists.apache.org/thread/m0w5glgbndy3r756w8nlcshxfhjb819q


Thank you all!

John Gemignani


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

2024-02-28 Thread John Gemignani
Dear Apache Community,
We would like to thank everyone who participated in the voting process and
are now closing this vote. We will be sending out the results shortly.

John Gemignani

On Fri, Feb 23, 2024 at 7:18 AM Zainab Saad
 wrote:

> +1
>
> Checked the following:
> - Release notes
> - Tag
> - Commit hash
> - Links and Signature
>
> Regards,
> Zainab Saad
>
> On Fri, Feb 23, 2024 at 5:04 AM Eya Badal  wrote:
>
> > +1(Binding)
> >
> > - Signature and Hash (checked)
> > - Tags and links (checked)
> > - No unexpected binary files (checked)
> > - Licesne (checked)
> >
> > On 2024/02/22 20:03:53 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
> > > version 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)
> > > Remov

[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 13

2024-02-22 Thread John Gemignani
MPORTANT PLEASE READ !!!

Please vote as follows -

+1, Release this package as Apache AGE 1.5.0 for PostgreSQL 13.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

 !!! Followed by what you checked !!!

Sample responses, two for PMCs (binding) and two for regular committers.
These are only samples, do not copy/paste.

Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
binding. If you are a PMC, you must state it.

   +1 (binding)   +1
   Checked the following:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 13

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

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official [VOTE] thread for Apache AGE 1.5.0 for PostgreSQL 13
shortly.

Thank you all for your input and time,


John Gemignani

On Thu, Feb 22, 2024 at 10:45 AM Muhammad Taha Naveed
 wrote:

> Looks good to me. Checked links, signatures, git tag and release notes.
>
> Regards
> Muhammad Taha Naveed
>
> On Sat, Feb 17, 2024, 04:59 John Gemignani 
> wrote:
>
> > 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

[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 

[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 14

2024-02-09 Thread John Gemignani
 0. You need to state what items
  you checked.

If your vote DOES NOT follow the above guidelines or samples below, it may
be thrown out.

!!! IMPORTANT PLEASE READ !!!

Please vote as follows -

+1, Release this package as Apache AGE 1.5.0 for PostgreSQL 14.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

 !!! Followed by what you checked !!!

Sample responses, two for PMCs (binding) and two for regular committers.
These are only samples, do not copy/paste.

Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
binding. If you are a PMC, you must state it.

   +1 (binding)   +1
   Checked the following:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


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

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

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official [VOTE] thread for Apache AGE 1.5.0 for PostgreSQL 14
shortly.

Thank you all for your input,

John Gemignani

On Fri, Feb 9, 2024 at 11:42 AM Eya Badal  wrote:

> Checked the following:
> - Release Notes
> - Git Tag
> - Commit Hash
> - Links and signature
>
> Thank you!!
>
> On 2024/02/06 23:19:44 John Gemignani wrote:
> > Dear Apache Community,
> >
> > We would like to open a discussion for the 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)
> >
> > *
> >
> > The git tag to be discussed and voted on:
> > https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0

[DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 14

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

We would like to open a discussion for the 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)

*

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

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 15

2024-02-06 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/543l4965546d43phz9qjokz1pd0kr3o7


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

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

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

Again, thank you for your time and effort.

John Gemignani

On Tue, Feb 6, 2024 at 1:14 PM Eya Badal  wrote:

> +1 (binding)
>
> Checked:
> - Signature and hash
> - License and notice
> - Links and tags
> - No unexpected binary files
>
> Great Job!!
>
> On 2024/02/01 18:23:37 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 15.
> >
> > 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 15
> >
> > 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 Docker file to reflect PostgreSQL version 15 (#1449)
> > 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)

[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 15

2024-02-01 Thread John Gemignani
natures for validity.

- You CANNOT just say, +1 or 0. You need to state what items
  you checked.

If your vote DOES NOT follow the above guidelines or samples below, it may
be thrown out.

!!! IMPORTANT PLEASE READ !!!

Please vote as follows -

+1, Release this package as Apache AGE 1.5.0 for PostgreSQL 15.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

 !!! Followed by what you checked !!!

Sample responses, two for PMCs (binding) and two for regular committers.
These are only samples, do not copy/paste.

Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
binding. If you are a PMC, you must state it.

   +1 (binding)   +1
   Checked the following:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


[CANCELLED] [VOTE] Apache AGE 1.5.0 Release for PostgreSQL 15

2024-02-01 Thread John Gemignani
Cancelled due to an error in the email.

I will reissue a correction shortly.

John Gemignani


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

2024-02-01 Thread John Gemignani
CANCELLING this vote due to an error. I will resend the correct one shortly.

Sorry for the inconvenience.

John Gemignani

On Thu, Feb 1, 2024 at 2:17 AM Dehowe Feng  wrote:

> +1 (binding)
>
> I've checked the following, as mentioned in the discussion thread:
>
> - Signature and hash
> - License and notice
> - Links and tags
> - No unexpected binary files
>
> Looks good to me.
>
> Cheers.
>
> On Thu, Feb 1, 2024 at 9:27 AM 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 15.
> >
> > 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 15
> >
> > 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 Docker file to reflect PostgreSQL version 15 (#1449)
> > 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)
> &g

[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 15

2024-01-31 Thread John Gemignani
natures for validity.

- You CANNOT just say, +1 or 0. You need to state what items
  you checked.

If your vote DOES NOT follow the above guidelines or samples below, it may
be thrown out.

!!! IMPORTANT PLEASE READ !!!

Please vote as follows -

+1, Release this package as Apache AGE 1.5.0 for PostgreSQL 15.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

 !!! Followed by what you checked !!!

Sample responses, two for PMCs (binding) and two for regular committers.
These are only samples, do not copy/paste.

Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
binding. If you are a PMC, you must state it.

   +1 (binding)   +1
   Checked the following:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 15

2024-01-31 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official [VOTE] thread for Apache AGE 1.5.0 for PostgreSQL 15
shortly.

Thank you for your time and effort,


John Gemignani


On Wed, Jan 31, 2024 at 4:40 PM Eya Badal  wrote:

> Thank you, John. Great Job!!
>
> - Signature and hash - Checked.
> - License and notice - Checked.
> - Links and tags - Checked.
> - No unexpected binary files - Checked.
>
> Thank you again!!
>
> On 2024/01/26 01:08:56 John Gemignani wrote:
> > Dear Apache Community,
> >
> > We would like to open a discussion for the Apache AGE release 1.5.0 for
> > PostgreSQL 15.
> >
> > 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 15
> >
> > 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 Docker file to reflect PostgreSQL version 15 (#1449)
> > 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)
> >
> > **

[DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 15

2024-01-25 Thread John Gemignani
Dear Apache Community,

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

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 15

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 Docker file to reflect PostgreSQL version 15 (#1449)
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)

*

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

The git commit hash:
commit 89e90671bb34439d21a6abe49d1c08aa76c7f014

The release files for 1.5.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG15/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/PG15/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 16

2024-01-25 Thread John Gemignani
Dear Apache Community,

The vote successfully passed with 3 +1 (binding) and 3 +1 (non-binding)
votes. There were no 0 or -1 votes.

Following are the detailed results :

Total of 6 (+1) votes.

3 +1 (binding)
Dehowe Feng
Muhammad Shoaib
Eya Badal

3 +1 (non-binding)
Zainab Saad
Muhammad Taha
Rafsun Masud

VOTE thread:
https://lists.apache.org/thread/tzyd66m7101c2pyj6fr7m0rsks5lvz4r

Thank you all!

John Gemignani


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

2024-01-25 Thread John Gemignani
We would like to thank everyone who participated in the voting process.

We will now close this vote and will be sending out the results shortly.

Again, thank you all for your time and effort!

John Gemignani

On Thu, Jan 25, 2024 at 2:49 PM Eya Badal  wrote:

> +1 (binding)
>
> Checked:
> * Signature and hash
> * License and notice
> * Links and tags
> * No unexpected binary files
>
> Great job, thank you, John!!
>
> On 2024/01/17 22:12:53 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 16.
> >
> > 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 16
> >
> > Apache AGE 1.5.0 - Release Notes
> >
> > NOTE: This is an initial release of Apache AGE for PostgreSQL version
> > 16. There are no upgrade scripts to this release.
> >
> > 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 Docker file to reflect PostgreSQL version 15 (#1449)
> > 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
> > !!

[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 16

2024-01-17 Thread John Gemignani
 samples below, it may
be thrown out.

!!! IMPORTANT PLEASE READ !!!

Please vote as follows -

+1, Release this package as Apache AGE 1.5.0 for PostgreSQL 16.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

 !!! Followed by what you checked !!!

Sample responses, two for PMCs (binding) and two for regular committers.
These are only samples, do not copy/paste.

Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
binding. If you are a PMC, you must state it.

   +1 (binding)   +1
   Checked the following:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 16

2024-01-17 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official [VOTE] thread for Apache AGE 1.5.0 for PostgreSQL 16
shortly.

Thank you for your time,

John Gemignani

On Wed, Jan 10, 2024 at 8:56 AM Dehowe Feng  wrote:

> Updating to Postgres 16 would bring AGE into the most up-to-date version of
> Postgres. Looking forward to the release.
>
> I’ve checked:
>
> - Signature and hash
> - License and notice
> - Links and tags
> - No unexpected binary files
>
> Best,
>
> Dehowe
>
>
>
>
>
> On Jan 10, 2024, at 6:41 AM, Muhammad Shoaib 
> wrote:
>
> Hi,
>
> I have checked the following aspects:
>
>
>   - Links
>   - Files
>   - Signature
>   - Commit hash
>   - Git tags
>   - Release contents
>
> All the elements seem to be in order,
>
> Kind Regards
> Shoaib
>
> On Tue, Jan 9, 2024 at 8:06 PM Rafsun Masud  wrote:
>
> Looks good!
>
>
> Checked:
>
>  - Links
>
>  - Files
>
>  - Signature
>
>  - Commit hash
>
>  - Git tags
>
>  - Release contents
>
>
> --
>
> *Rafsun Masud*
>
> rafsu...@bitnine.net
>
>
>
> On Mon, Jan 8, 2024 at 4:33 PM John Gemignani 
>
> wrote:
>
>
> Dear Apache Community,
>
>
> We would like to open a discussion for the Apache AGE release 1.5.0 for
>
> PostgreSQL 16.
>
>
> 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 16
>
>
> Apache AGE 1.5.0 - Release Notes
>
>
> NOTE: This is an initial release of Apache AGE for PostgreSQL version
>
>16. There are no upgrade scripts to this release.
>
>
> 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 Docker file to reflect PostgreSQL version 15 (#1449)
>
> 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 

[DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 16

2024-01-08 Thread John Gemignani
Dear Apache Community,

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

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 16

Apache AGE 1.5.0 - Release Notes

NOTE: This is an initial release of Apache AGE for PostgreSQL version
16. There are no upgrade scripts to this release.

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 Docker file to reflect PostgreSQL version 15 (#1449)
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)

*

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

The git commit hash:
commit 0048900f372d4dfd5c236f78b8a8453bcdbb458e

The release files for 1.5.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG16/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/PG16/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


Re: [PR] Extend access(->, ->>), addition and subtraction operators(#1258) [age]

2023-12-27 Thread John Gemignani
Please also provide one for PG15.

Thanks!

John

On Tue, Dec 26, 2023 at 8:50 AM Zainab-Saad (via GitHub) 
wrote:

>
> Zainab-Saad opened a new pull request, #1459:
> URL: https://github.com/apache/age/pull/1459
>
>This PR is a part of a patch originally authored by Josh Innis for #282
> . The tasks done here are:
>
>- Enabled the use of access operator with agtype as the RHS operand,
> allowing this operator to be used within cypher queries
>- Extended addition operator to concatenate in case any or both
> operands are non-scalar or scalar vertex/edge/path
>- Extended subtract operator to delete specified keys from object or
> elements at specified indexes from array
>- Added and modified regression tests relevant to the above changes
>
>
> --
> 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: commits-unsubscr...@age.apache.org
>
> For queries about this service, please contact Infrastructure at:
> us...@infra.apache.org
>
>


[RESULT][VOTE] Apache AGE 1.4.0 Release for PostgreSQL 11

2023-11-03 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)

Dehowe Feng

Nicholas Sorrel

Eya Badal

Muhammad Shoaib

2 +1 (non-binding)

Rafsun Masud

Muhammad Taha Naveed

VOTE thread:
https://lists.apache.org/thread/8chs4ycog4spq4r5z7yb434p9yh14hs4

Thank you all!

John Gemignani


Re: [VOTE] Apache AGE 1.4.0 Release for PostgreSQL 11

2023-11-03 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.

Again, thank you!

John Gemignani

On Fri, Nov 3, 2023 at 8:37 AM Muhammad Shoaib 
wrote:

> +1 (binding)
> - Checked signature and Hash
> - Checked tags and Links
> - Checked license and Notice
> - Checked, and no unexpected binary files
>
> On Fri, Nov 3, 2023 at 3:39 PM Eya Badal  wrote:
>
> > +1 (binding)
> > - Checked signature and Hash
> > - Checked tags and Links
> > - Checked license and Notice
> > - Checked, and no unexpected binary files
> >
> > On 2023/10/27 16:55:02 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.4.0 for PostgreSQL
> 11.
> > >
> > > To learn more about Apache AGE, please see http://age.apache.org/
> > >
> > > Functionalities included and issues addressed in this release are:
> > >
> > > *
> > > Release Notes for Apache AGE release v1.4.0 for PostgreSQL 11
> > >
> > > 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.
> > >
> > > Added license in Python driver README.md (#956)
> > > Added the toStringList() function (#1128)
> > > Added toBooleanList() (#1165)
> > > Added toFloatList() function (#1016)
> > > Added toIntegerList() function (#1025)
> > > Added regression tests for MATCH clause using labels only (#1019)
> > > Added REGTYPEOID to toString function (#1036)
> > > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > > Fixed complex MERGE causes crash (#897) (#961)
> > > Fixed docker build files (#1104)
> > > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > > Fixed issue 1000: Indexes created on WHERE (#1133)
> > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > > Fixed issue 1033: access operator on vle edge lists (#1037)
> > > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > > Fixed issue 870: regarding orderability and added regression tests
> (#994)
> > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> > (#931)
> > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > > Fixed memory leak issues with age_load (#1142)
> > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > > Fixed MERGE crashes due to incorrect label type (#957)
> > > Fixed MERGE variable reuse (#997)
> > > Fixed misspellings in many AGE files (#985)
> > > Fixed warning messages in DockerHub builds. (#1075)
> > > Modified test_agtypes to view useful testing message (#992)
> > > Optimised Antlr4ResultHandler initialization (#1169)
> > > Updated CIs to pull correct image based on branch (#1105)
> > > Updated files, format, and version information (#1063)
> > > Updated README.
> > >
> > > *
> > >
> > > !!! PLEASE VERIFY ALL of the below tags, hash, links, signatures, &
> keys
> > !!!
> > >
> > > The git tag to be discussed and voted on:
> > > https://github.com/apache/age/releases/tag/PG11/v1.4.0-rc0
> > >
> > > The git commit hash:
> > > commit 8dee6cec0b826addf50fb0a0d578a0a6015dd72e
> > >
> > > The release files for 1.4.0, can be found at:
> > > https://dist.apache.org/repos/dist/dev/age/PG11/1.4.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/PG11/v1.4.0-rc0
> > 

[VOTE] Apache AGE 1.4.0 Release for PostgreSQL 11

2023-10-27 Thread John Gemignani
 - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not good practice to copy/paste someone else's
response either, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 11

2023-10-27 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official [VOTE] thread for Apache AGE 1.4.0 for PostgreSQL 11
shortly.

Thank you all for your time and effort!


John Gemignani


On Thu, Oct 26, 2023 at 1:52 PM Eya Badal  wrote:

> +1
>
> Checked:
> - Signature and hash
> - LICENSE and notice
> - Links and Tags
> - No unexpected binary files
>
> Best regards,
> Eya
>
> On 2023/10/18 00:20:54 Dehowe Feng wrote:
> > Awesome!! The team has been working hard on AGE and these updates will
> > bring AGE for PG11 in line with the other versions that have released.
> > Looking forward to it.
> >
> > I checked:
> > - Signature and hash
> > - License and notice
> > - Links + tags
> > - No unexpected binary files.
> >
> > Best,
> >
> > Dehowe
> >
> > On Tue, Oct 17, 2023 at 4:50 PM John Gemignani <
> john.gemign...@bitnine.net>
> > wrote:
> >
> > > Dear Apache Community,
> > >
> > > We would like to open a discussion for the Apache AGE release 1.4.0 for
> > > PostgreSQL 11.
> > >
> > > 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 v1.4.0 for PostgreSQL 11
> > >
> > > 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.
> > >
> > > Added license in Python driver README.md (#956)
> > > Added the toStringList() function (#1128)
> > > Added toBooleanList() (#1165)
> > > Added toFloatList() function (#1016)
> > > Added toIntegerList() function (#1025)
> > > Added regression tests for MATCH clause using labels only (#1019)
> > > Added REGTYPEOID to toString function (#1036)
> > > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > > Fixed complex MERGE causes crash (#897) (#961)
> > > Fixed docker build files (#1104)
> > > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > > Fixed issue 1000: Indexes created on WHERE (#1133)
> > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > > Fixed issue 1033: access operator on vle edge lists (#1037)
> > > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > > Fixed issue 870: regarding orderability and added regression tests
> (#994)
> > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> > > (#931)
> > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > > Fixed memory leak issues with age_load (#1142)
> > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > > Fixed MERGE crashes due to incorrect label type (#957)
> > > Fixed MERGE variable reuse (#997)
> > > Fixed misspellings in many AGE files (#985)
> > > Fixed warning messages in DockerHub builds. (#1075)
> > > Modified test_agtypes to view useful testing message (#992)
> > > Optimised Antlr4ResultHandler initialization (#1169)
> > > Updated CIs to pull correct image based on branch (#1105)
> > > Updated files, format, and version information (#1063)
> > > Updated README.
> > >
> > > *
> > >
> > > The git tag to be discussed and voted on:
> > > https://github.com/apache/age/releases/tag/PG11/v1.4.0-rc0
> > >
> > > The git commit hash:
> > > commit 8dee6cec0b826addf50fb0a0d578a0a6015dd72e
> > >
> > > The release files for 1.4.0, can be found at:
> > > https://dist.apache.org/repos/dist/dev/age/PG11/1.4.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/PG11/v1.4.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
> > >
> >
>


[DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 11

2023-10-17 Thread John Gemignani
Dear Apache Community,

We would like to open a discussion for the Apache AGE release 1.4.0 for
PostgreSQL 11.

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 v1.4.0 for PostgreSQL 11

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.

Added license in Python driver README.md (#956)
Added the toStringList() function (#1128)
Added toBooleanList() (#1165)
Added toFloatList() function (#1016)
Added toIntegerList() function (#1025)
Added regression tests for MATCH clause using labels only (#1019)
Added REGTYPEOID to toString function (#1036)
Added Dockerfile.dev & move docker-related files to "docker/" (#943)
Fixed complex MERGE causes crash (#897) (#961)
Fixed docker build files (#1104)
Fixed case sensitivity on label usage of reserved keyword (#1040)
Fixed issue 1000: Indexes created on WHERE (#1133)
Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
Fixed issue 1033: access operator on vle edge lists (#1037)
Fixed issue 1043: ERROR:  container must be an array or object (#1046)
Fixed issue 1124: Segmentation fault when using specific tables (#1125)
Fixed issue 395: ERROR: container is not an agtype array (#1039)
Fixed issue 870: regarding orderability and added regression tests (#994)
Fixed issue 876: column reference "_age_default_alias_0" is ambiguous (#931)
Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
Fixed issue 989: Impossible to create array with > 100 items (#1001)
Fixed memory leak issues with age_load (#1142)
Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
Fixed MERGE crashes due to incorrect label type (#957)
Fixed MERGE variable reuse (#997)
Fixed misspellings in many AGE files (#985)
Fixed warning messages in DockerHub builds. (#1075)
Modified test_agtypes to view useful testing message (#992)
Optimised Antlr4ResultHandler initialization (#1169)
Updated CIs to pull correct image based on branch (#1105)
Updated files, format, and version information (#1063)
Updated README.

*

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

The git commit hash:
commit 8dee6cec0b826addf50fb0a0d578a0a6015dd72e

The release files for 1.4.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG11/1.4.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/PG11/v1.4.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.4.0 Release for PostgreSQL 12

2023-10-17 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 abbreviated detailed results :

Total of 6 (+1) votes.

4 +1 (binding)

Dehowe Feng

Nicholas Sorrel

Eya Badal

Muhammad Shoaib

2 +1 (non-binding)

Rafsun Masud

Muhammad Taha Naveed

VOTE thread:
https://lists.apache.org/thread/dx3o3dfg0sbb0d8fjjfpjm0bv9002qhy

I would like to thank everyone for their participation!

John Gemignani


Re: [VOTE] Apache AGE 1.4.0 Release for PostgreSQL 12

2023-10-17 Thread John Gemignani
Dear Apache Community,

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


John Gemignani


On Tue, Oct 17, 2023 at 10:22 AM Eya Badal  wrote:

> +1 (binding)
>
> Checked and verified:
> - Signature and hash
> - License and notice
> - Links and tags
> - No unexpected binary files
>
> On 2023/10/12 16:04:52 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.4.0 for PostgreSQL 12.
> >
> > To learn more about Apache AGE, please see http://age.apache.org/
> >
> > Functionalities included and issues addressed in this release are:
> >
> > *
> > Release Notes for Apache AGE release v1.4.0 for PostgreSQL 12
> >
> > 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.
> >
> > Added license in Python driver README.md (#956)
> > Added the toStringList() function (#1128)
> > Added toBooleanList() (#1165)
> > Added toFloatList() function (#1016)
> > Added toIntegerList() function (#1025)
> > Added regression tests for MATCH clause using labels only (#1019)
> > Added REGTYPEOID to toString function (#1036)
> > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > Fixed complex MERGE causes crash (#897) (#961)
> > Fixed docker build files (#1104)
> > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > Fixed issue 1000: Indexes created on WHERE (#1133)
> > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > Fixed issue 1033: access operator on vle edge lists (#1037)
> > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > Fixed issue 870: regarding orderability and added regression tests (#994)
> > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> (#931)
> > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > Fixed memory leak issues with age_load (#1142)
> > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > Fixed MERGE crashes due to incorrect label type (#957)
> > Fixed MERGE variable reuse (#997)
> > Fixed misspellings in many AGE files (#985)
> > Fixed warning messages in DockerHub builds. (#1075)
> > Modified test_agtypes to view useful testing message (#992)
> > Optimised Antlr4ResultHandler initialization (#1169)
> > Updated CIs to pull correct image based on branch (#1105)
> > Updated files, format, and version information (#1063)
> > Updated README.
> >
> > *
> >
> > !!! PLEASE VERIFY ALL of the below tags, hash, links, signatures, & keys
> !!!
> >
> > The git tag to be discussed and voted on:
> > https://github.com/apache/age/releases/tag/PG12/v1.4.0-rc0
> >
> > The git commit hash:
> > commit 8c9554214acdc76db7d1e4e836ccf6f48e2e782d
> >
> > The release files for 1.4.0, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG12/1.4.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/PG12/v1.4.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, then you MUST state it in your
> >   response. Otherwise, leave it out. Do not mention it if you are
> >   not a PMC.
> >
> > - You MUST state what you checked to support your vote. See
> >   the samples given below for guidance.
> >
> > - You MUST, at a minimum, check the ab

[VOTE] Apache AGE 1.4.0 Release for PostgreSQL 12

2023-10-12 Thread John Gemignani
 - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not good practice to copy/paste someone else's
response either, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 12

2023-10-12 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the DISCUSS thread and will
open the official VOTE thread for Apache AGE 1.4.0 for PostgreSQL 12
shortly.

John Gemignani

On Mon, Oct 9, 2023 at 5:06 PM Eya Badal  wrote:

> Checked and verified:
>  - Signature and Hash
> - License and Notice
> - Links and tags
> - No unexpected binary files
>
> Thank you, as always, for the great work!!!
>
> On 2023/10/06 17:27:40 John Gemignani wrote:
> > Dear Apache Community,
> >
> > We would like to open a discussion for the Apache AGE release 1.4.0 for
> > PostgreSQL 12.
> >
> > 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 v1.4.0 for PostgreSQL 12
> >
> > 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.
> >
> > Added license in Python driver README.md (#956)
> > Added the toStringList() function (#1128)
> > Added toBooleanList() (#1165)
> > Added toFloatList() function (#1016)
> > Added toIntegerList() function (#1025)
> > Added regression tests for MATCH clause using labels only (#1019)
> > Added REGTYPEOID to toString function (#1036)
> > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > Fixed complex MERGE causes crash (#897) (#961)
> > Fixed docker build files (#1104)
> > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > Fixed issue 1000: Indexes created on WHERE (#1133)
> > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > Fixed issue 1033: access operator on vle edge lists (#1037)
> > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > Fixed issue 870: regarding orderability and added regression tests (#994)
> > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> (#931)
> > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > Fixed memory leak issues with age_load (#1142)
> > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > Fixed MERGE crashes due to incorrect label type (#957)
> > Fixed MERGE variable reuse (#997)
> > Fixed misspellings in many AGE files (#985)
> > Fixed warning messages in DockerHub builds. (#1075)
> > Modified test_agtypes to view useful testing message (#992)
> > Optimised Antlr4ResultHandler initialization (#1169)
> > Updated CIs to pull correct image based on branch (#1105)
> > Updated files, format, and version information (#1063)
> > Updated README.
> >
> > *
> >
> > The git tag to be discussed and voted on:
> > https://github.com/apache/age/releases/tag/PG12/v1.4.0-rc0
> >
> > The git commit hash:
> > commit 8c9554214acdc76db7d1e4e836ccf6f48e2e782d
> >
> > The release files for 1.4.0, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG12/1.4.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/PG12/v1.4.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
> >
>


[DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 12

2023-10-06 Thread John Gemignani
Dear Apache Community,

We would like to open a discussion for the Apache AGE release 1.4.0 for
PostgreSQL 12.

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 v1.4.0 for PostgreSQL 12

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.

Added license in Python driver README.md (#956)
Added the toStringList() function (#1128)
Added toBooleanList() (#1165)
Added toFloatList() function (#1016)
Added toIntegerList() function (#1025)
Added regression tests for MATCH clause using labels only (#1019)
Added REGTYPEOID to toString function (#1036)
Added Dockerfile.dev & move docker-related files to "docker/" (#943)
Fixed complex MERGE causes crash (#897) (#961)
Fixed docker build files (#1104)
Fixed case sensitivity on label usage of reserved keyword (#1040)
Fixed issue 1000: Indexes created on WHERE (#1133)
Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
Fixed issue 1033: access operator on vle edge lists (#1037)
Fixed issue 1043: ERROR:  container must be an array or object (#1046)
Fixed issue 1124: Segmentation fault when using specific tables (#1125)
Fixed issue 395: ERROR: container is not an agtype array (#1039)
Fixed issue 870: regarding orderability and added regression tests (#994)
Fixed issue 876: column reference "_age_default_alias_0" is ambiguous (#931)
Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
Fixed issue 989: Impossible to create array with > 100 items (#1001)
Fixed memory leak issues with age_load (#1142)
Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
Fixed MERGE crashes due to incorrect label type (#957)
Fixed MERGE variable reuse (#997)
Fixed misspellings in many AGE files (#985)
Fixed warning messages in DockerHub builds. (#1075)
Modified test_agtypes to view useful testing message (#992)
Optimised Antlr4ResultHandler initialization (#1169)
Updated CIs to pull correct image based on branch (#1105)
Updated files, format, and version information (#1063)
Updated README.

*

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

The git commit hash:
commit 8c9554214acdc76db7d1e4e836ccf6f48e2e782d

The release files for 1.4.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG12/1.4.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/PG12/v1.4.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.4.0 Release for PostgreSQL 13

2023-10-05 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)

Dehowe Feng

Nicholas Sorrel

Eya Badal

Muhammad Shoaib

2 +1 (non-binding)

Rafsun Masud

Muhammad Taha Naveed

VOTE thread:
https://lists.apache.org/thread/8pdvbvjcvbks648lq0fhq01cjwppm33f


Re: [VOTE] Apache AGE 1.4.0 Release for PostgreSQL 13

2023-10-05 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.

Thank you,

John Gemignani

On Thu, Oct 5, 2023 at 3:04 PM Dehowe Feng  wrote:

> +1 (binding)
>
> Checked:
> - Signature and hash
> - Tags and links
> - License and Notice
> - No unexpected binary files
>
> -Dehowe
>
> On Thu, Oct 5, 2023 at 11:14 AM Eya Badal  wrote:
>
> > +1 (binding)
> >
> > Checked and verified:
> > - Signature and Hash
> > - Tags and Links
> > - LICENSE and NOTICE
> > - No unexpected binary files
> >
> > Thank you,
> >
> > On 2023/10/04 00:46:40 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.4.0 for PostgreSQL
> 13.
> > >
> > > To learn more about Apache AGE, please see http://age.apache.org/
> > >
> > > Functionalities included and issues addressed in this release are:
> > >
> > > *
> > > Release Notes for Apache AGE release v1.4.0 for PostgreSQL 13
> > >
> > > 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.
> > >
> > > Added license in Python driver README.md (#956)
> > > Added the toStringList() function (#1128)
> > > Added toBooleanList() (#1165)
> > > Added toFloatList() function (#1016)
> > > Added toIntegerList() function (#1025)
> > > Added regression tests for MATCH clause using labels only (#1019)
> > > Added REGTYPEOID to toString function (#1036)
> > > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > > Fixed complex MERGE causes crash (#897) (#961)
> > > Fixed docker build files (#1104)
> > > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > > Fixed issue 1000: Indexes created on WHERE (#1133)
> > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > > Fixed issue 1033: access operator on vle edge lists (#1037)
> > > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > > Fixed issue 870: regarding orderability and added regression tests
> (#994)
> > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> > (#931)
> > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > > Fixed memory leak issues with age_load (#1142)
> > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > > Fixed MERGE crashes due to incorrect label type (#957)
> > > Fixed MERGE variable reuse (#997)
> > > Fixed misspellings in many AGE files (#985)
> > > Fixed warning messages in DockerHub builds. (#1075)
> > > Modified test_agtypes to view useful testing message (#992)
> > > Optimised Antlr4ResultHandler initialization (#1169)
> > > Updated CIs to pull correct image based on branch (#1105)
> > > Updated files, format, and version information (#1063)
> > > Updated README.
> > >
> > > *
> > >
> > > !!! PLEASE VERIFY ALL of the below tags, hash, links, signatures, &
> keys
> > !!!
> > >
> > > The git tag to be discussed and voted on:
> > > https://github.com/apache/age/releases/tag/PG13/v1.4.0-rc0
> > >
> > > The git commit hash:
> > > commit 01ccda78ad06186aaba8975dd6d1cf67e91535bc
> > >
> > > The release files for 1.4.0, can be found at:
> > > https://dist.apache.org/repos/dist/dev/age/PG13/1.4.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/ta

[VOTE] Apache AGE 1.4.0 Release for PostgreSQL 13

2023-10-03 Thread John Gemignani
 - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not good practice to copy/paste someone else's
response either, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 13

2023-10-03 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official [VOTE] thread for Apache AGE 1.4.0 for PostgreSQL 13
shortly.

Best regards,

John Gemignani

On Tue, Oct 3, 2023 at 9:10 AM Muhammad Shoaib 
wrote:

> Hi,
>
> I checked the following:
>
>- Signature and hash
>- Links and tags
>- LICENSE and NOTICE
>- No unexpected binary files
>
>
> Kind Regards
> Shoaib
>
> On Tue, Oct 3, 2023 at 6:00 PM Rafsun Masud  wrote:
>
> > Checked:
> > - Signature and commit hash
> > - Links and tags
> > - LICENSE and NOTICE
> > - Unexpected binary files (none)
> >
> > This release looks ready for a vote. Great job!
> >
> > Regards,
> > Rafsun Masud
> >
> > On Mon, Sep 25, 2023 at 2:50 PM John Gemignani <
> john.gemign...@bitnine.net
> > >
> > wrote:
> >
> > > Dear Apache Community,
> > >
> > > We would like to open a discussion for the Apache AGE release 1.4.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 v1.4.0 for PostgreSQL 13
> > >
> > > 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.
> > >
> > > Added license in Python driver README.md (#956)
> > > Added the toStringList() function (#1128)
> > > Added toBooleanList() (#1165)
> > > Added toFloatList() function (#1016)
> > > Added toIntegerList() function (#1025)
> > > Added regression tests for MATCH clause using labels only (#1019)
> > > Added REGTYPEOID to toString function (#1036)
> > > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > > Fixed complex MERGE causes crash (#897) (#961)
> > > Fixed docker build files (#1104)
> > > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > > Fixed issue 1000: Indexes created on WHERE (#1133)
> > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > > Fixed issue 1033: access operator on vle edge lists (#1037)
> > > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > > Fixed issue 870: regarding orderability and added regression tests
> (#994)
> > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> > > (#931)
> > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > > Fixed memory leak issues with age_load (#1142)
> > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > > Fixed MERGE crashes due to incorrect label type (#957)
> > > Fixed MERGE variable reuse (#997)
> > > Fixed misspellings in many AGE files (#985)
> > > Fixed warning messages in DockerHub builds. (#1075)
> > > Modified test_agtypes to view useful testing message (#992)
> > > Optimised Antlr4ResultHandler initialization (#1169)
> > > Updated CIs to pull correct image based on branch (#1105)
> > > Updated files, format, and version information (#1063)
> > > Updated README.
> > >
> > > *
> > >
> > > The git tag to be discussed and voted on:
> > > https://github.com/apache/age/releases/tag/PG13/v1.4.0-rc0
> > >
> > > The git commit hash:
> > > commit 01ccda78ad06186aaba8975dd6d1cf67e91535bc
> > >
> > > The release files for 1.4.0, can be found at:
> > > https://dist.apache.org/repos/dist/dev/age/PG13/1.4.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.4.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
> > >
> >
>


[DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 13

2023-09-25 Thread John Gemignani
Dear Apache Community,

We would like to open a discussion for the Apache AGE release 1.4.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 v1.4.0 for PostgreSQL 13

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.

Added license in Python driver README.md (#956)
Added the toStringList() function (#1128)
Added toBooleanList() (#1165)
Added toFloatList() function (#1016)
Added toIntegerList() function (#1025)
Added regression tests for MATCH clause using labels only (#1019)
Added REGTYPEOID to toString function (#1036)
Added Dockerfile.dev & move docker-related files to "docker/" (#943)
Fixed complex MERGE causes crash (#897) (#961)
Fixed docker build files (#1104)
Fixed case sensitivity on label usage of reserved keyword (#1040)
Fixed issue 1000: Indexes created on WHERE (#1133)
Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
Fixed issue 1033: access operator on vle edge lists (#1037)
Fixed issue 1043: ERROR:  container must be an array or object (#1046)
Fixed issue 1124: Segmentation fault when using specific tables (#1125)
Fixed issue 395: ERROR: container is not an agtype array (#1039)
Fixed issue 870: regarding orderability and added regression tests (#994)
Fixed issue 876: column reference "_age_default_alias_0" is ambiguous (#931)
Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
Fixed issue 989: Impossible to create array with > 100 items (#1001)
Fixed memory leak issues with age_load (#1142)
Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
Fixed MERGE crashes due to incorrect label type (#957)
Fixed MERGE variable reuse (#997)
Fixed misspellings in many AGE files (#985)
Fixed warning messages in DockerHub builds. (#1075)
Modified test_agtypes to view useful testing message (#992)
Optimised Antlr4ResultHandler initialization (#1169)
Updated CIs to pull correct image based on branch (#1105)
Updated files, format, and version information (#1063)
Updated README.

*

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

The git commit hash:
commit 01ccda78ad06186aaba8975dd6d1cf67e91535bc

The release files for 1.4.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG13/1.4.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.4.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.4.0 Release for PostgreSQL 15

2023-09-25 Thread John Gemignani
Dear Apache Community,

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

votes. There were no 0 or -1 votes.

Following are the detailed results:

Total of 5 (+1) votes.

3 BINDING (+1) VOTES
Dehowe Feng
Eya Badal
Muhammad Shoaib

2 NON-BINDING (+1) VOTES
Muhammad Taha Naveed
Rafsun Masud

VOTE thread:
https://lists.apache.org/thread/wg86tw1cjft23cpd6sb5zvz72qr1tfn8

Thank you all!

John Gemignani


Re: [VOTE] Apache AGE 1.4.0 Release for PostgreSQL 15

2023-09-25 Thread John Gemignani
Dear Apache Community,

We would like to thank everyone who participated in the voting process and are
now closing this vote.

We will be sending out the results shortly.

Sincerely,

John Gemignani


On Fri, Sep 22, 2023 at 8:48 AM Eya Badal  wrote:

> +1(Binding)
>
> Checked:
> - Signature, hash
> - Links, tags
> - LICENSE and NOTICE
> - Unexpected binary files (none)
>
> Great job as always!!
>
> On 2023/09/14 00:14:38 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.4.0 for PostgreSQL 15.
> >
> > To learn more about Apache AGE, please see http://age.apache.org/
> >
> > Functionalities included and issues addressed in this release are:
> >
> > *
> > Release Notes for Apache AGE release v1.4.0 for PostgreSQL 15
> >
> > NOTE: This is an initial release of PG15. 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.
> >
> > Added license in Python driver README.md (#956)
> > Added the toStringList() function (#1128)
> > Added toBooleanList() (#1165)
> > Added toFloatList() function (#1016)
> > Added toIntegerList() function (#1025)
> > Added regression tests for MATCH clause using labels only (#1019)
> > Added REGTYPEOID to toString function (#1036)
> > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > Fixed complex MERGE causes crash (#897) (#961)
> > Fixed docker build files (#1104)
> > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > Fixed issue 1000: Indexes created on WHERE (#1133)
> > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > Fixed issue 1033: access operator on vle edge lists (#1037)
> > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > Fixed issue 870: regarding orderability and added regression tests (#994)
> > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> (#931)
> > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > Fixed memory leak issues with age_load (#1142)
> > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > Fixed MERGE crashes due to incorrect label type (#957)
> > Fixed MERGE variable reuse (#997)
> > Fixed misspellings in many AGE files (#985)
> > Fixed warning messages in DockerHub builds. (#1075)
> > Modified test_agtypes to view useful testing message (#992)
> > Optimised Antlr4ResultHandler initialization (#1169)
> > Updated CIs to pull correct image based on branch (#1105)
> > Updated files, format, and version information (#1063)
> > Updated README.
> >
> > *
> >
> > !!! PLEASE VERIFY ALL of the below tags, hash, links, signatures, & keys
> !!!
> >
> > The git tag to be discussed and voted on:
> > https://github.com/apache/age/releases/tag/PG15/v1.4.0-rc0
> >
> > The git commit hash:
> > commit 45f936bd0de92d57c4393ccfb5758d12230cbe24
> >
> > The release files for 1.4.0, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG15/1.4.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/PG15/v1.4.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, then you MUST state it in your
> >   response. Otherwise, leave it out. Do not mention it if you are
> >   not a PMC.
> >
> > - You MUST state what you checked to supp

[VOTE] Apache AGE 1.4.0 Release for PostgreSQL 15

2023-09-13 Thread John Gemignani
   - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not good practice to copy/paste someone else's
response either, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 15

2023-09-13 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the DISCUSS thread and will
open the official VOTE thread for Apache AGE 1.4.0 for PostgreSQL 15
shortly.

Thank you!


John Gemignani


On Wed, Sep 13, 2023 at 2:36 PM Muhammad Shoaib 
wrote:

> Dear Apache AGE Community,
>
> I am pleased to confirm the following checks for the Apache AGE Version
> 1.4.0 release for PostgreSQL 15:
>
> 1. Signature and Hash - Verified.
> 2. Links and Tags - Verified.
> 3. License and Notice - In compliance.
> 4. Release Notes - Accurate.
> 5. No Unexpected Binary Files - Confirmed.
>
> These checks ensure the quality and reliability of the release. We are
> ready to proceed confidently.
>
> Thanks for the hard work.
>
> Best regards,
> Shoaib
>
> On Wed, Sep 13, 2023 at 6:14 PM Rafsun Masud  wrote:
>
> > Looks perfect!
> >
> > Checked:
> > - Signature and hash
> > - Links and tags
> > - License and notice
> > - Binary files (none)
> >
> > On Wed, Sep 6, 2023 at 3:26 PM John Gemignani <
> john.gemign...@bitnine.net>
> > wrote:
> >
> > > Dear Apache Community,
> > >
> > > We would like to open a discussion for the Apache AGE release 1.4.0 for
> > > PostgreSQL 15.
> > >
> > > 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 v1.4.0 for PostgreSQL 15
> > >
> > > NOTE: This is an initial release of PG15. 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.
> > >
> > > Added license in Python driver README.md (#956)
> > > Added the toStringList() function (#1128)
> > > Added toBooleanList() (#1165)
> > > Added toFloatList() function (#1016)
> > > Added toIntegerList() function (#1025)
> > > Added regression tests for MATCH clause using labels only (#1019)
> > > Added REGTYPEOID to toString function (#1036)
> > > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > > Fixed complex MERGE causes crash (#897) (#961)
> > > Fixed docker build files (#1104)
> > > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > > Fixed issue 1000: Indexes created on WHERE (#1133)
> > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > > Fixed issue 1033: access operator on vle edge lists (#1037)
> > > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > > Fixed issue 870: regarding orderability and added regression tests
> (#994)
> > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> > > (#931)
> > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > > Fixed memory leak issues with age_load (#1142)
> > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > > Fixed MERGE crashes due to incorrect label type (#957)
> > > Fixed MERGE variable reuse (#997)
> > > Fixed misspellings in many AGE files (#985)
> > > Fixed warning messages in DockerHub builds. (#1075)
> > > Modified test_agtypes to view useful testing message (#992)
> > > Optimised Antlr4ResultHandler initialization (#1169)
> > > Updated CIs to pull correct image based on branch (#1105)
> > > Updated files, format, and version information (#1063)
> > > Updated README.
> > >
> > > *
> > >
> > > The git tag to be discussed and voted on:
> > > https://github.com/apache/age/releases/tag/PG15/v1.4.0-rc0
> > >
> > > The git commit hash:
> > > commit 45f936bd0de92d57c4393ccfb5758d12230cbe24
> > >
> > > The release files for 1.4.0, can be found at:
> > > https://dist.apache.org/repos/dist/dev/age/PG15/1.4.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/PG15/v1.4.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.4.0 Release for PostgreSQL 14

2023-09-12 Thread John Gemignani
Dear Apache Community,

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

votes. There were no 0 or -1 votes.

Following are the detailed results:

Total of 7 (+1) votes.

4 BINDING (+1) VOTES
Dehowe Feng
Nicholas Sorrell
Eya Badal
Muhammad Shoaib

3 NON-BINDING (+1) VOTES
Muhammad Taha Naveed
Bhaskar Sharma
Rafsun Masud

VOTE thread:
https://lists.apache.org/thread/wf7lr8x7mw19z9cygoknrwqzvqz5opwd

Thank you all!

John Gemignani


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

2023-09-12 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 Mon, Sep 11, 2023 at 8:37 AM Muhammad Shoaib 
wrote:

> Dear Apache AGE Community,
>
> I hope this message finds you well. I am writing to formally cast my vote
> for the approval of Apache AGE version 1.4.0 for PG14.
>
> My vote is as follows:
> +1 (Binding)
>
> I have conducted a thorough review of the release candidate and have
> ensured that the following criteria have been met:
>
> 1. Signature and hash - I have checked and verified the cryptographic
> signature and hash of the release candidate.
> 2. Links and tags - I have confirmed that all relevant links and tags in
> the release are accurate and functional.
> 3. License and Notice - I have reviewed the license and notice files to
> ensure compliance with Apache licensing requirements.
> 4. Release notes - I have examined the release notes and found them to be
> comprehensive and accurate to the best of my knowledge.
> 5. No unexpected binary files - I have confirmed that there are no
> unexpected binary files in the release.
>
> Based on my assessment, I believe that Apache AGE version 1.4.0 meets the
> necessary criteria for a successful release. I appreciate the hard work and
> dedication of the contributors who have made this release possible.
>
> Thank you to everyone involved in this release, and I look forward to
> seeing the continued progress of the Apache AGE project.
>
> Best regards,
> Shoaib
>
>
> On Mon, Sep 11, 2023 at 5:16 PM Eya Badal  wrote:
>
> > +1(Binding)
> >
> > Checked the following:
> > * Signature and hash - Verified
> > * Links and tags - Verified
> > * License and Notice - Verified
> > * Release notes - Verified
> > * No unexpected binary files - Verified
> >
> > Great job, and thank you!!
> >
> >
> > On 2023/09/06 19:15:29 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.4.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 v1.4.0 for PostgreSQL 14
> > >
> > > NOTE: This is an initial release of PG14. 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.
> > >
> > > Added license in Python driver README.md (#956)
> > > Added the toStringList() function (#1128)
> > > Added toBooleanList() (#1165)
> > > Added toFloatList() function (#1016)
> > > Added toIntegerList() function (#1025)
> > > Added regression tests for MATCH clause using labels only (#1019)
> > > Added REGTYPEOID to toString function (#1036)
> > > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > > Fixed complex MERGE causes crash (#897) (#961)
> > > Fixed docker build files (#1104)
> > > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > > Fixed issue 1000: Indexes created on WHERE (#1133)
> > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > > Fixed issue 1033: access operator on vle edge lists (#1037)
> > > Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> > > Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> > > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > > Fixed issue 870: regarding orderability and added regression tests
> (#994)
> > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> > (#931)
> > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > > Fixed memory leak issues with age_load (#1142)
> > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > > Fixed MERGE crashes due to incorrect label type (#957)
> > > Fixed MERGE variable reuse (#997)
> > > Fi

[DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 15

2023-09-06 Thread John Gemignani
Dear Apache Community,

We would like to open a discussion for the Apache AGE release 1.4.0 for
PostgreSQL 15.

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 v1.4.0 for PostgreSQL 15

NOTE: This is an initial release of PG15. 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.

Added license in Python driver README.md (#956)
Added the toStringList() function (#1128)
Added toBooleanList() (#1165)
Added toFloatList() function (#1016)
Added toIntegerList() function (#1025)
Added regression tests for MATCH clause using labels only (#1019)
Added REGTYPEOID to toString function (#1036)
Added Dockerfile.dev & move docker-related files to "docker/" (#943)
Fixed complex MERGE causes crash (#897) (#961)
Fixed docker build files (#1104)
Fixed case sensitivity on label usage of reserved keyword (#1040)
Fixed issue 1000: Indexes created on WHERE (#1133)
Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
Fixed issue 1033: access operator on vle edge lists (#1037)
Fixed issue 1043: ERROR:  container must be an array or object (#1046)
Fixed issue 1124: Segmentation fault when using specific tables (#1125)
Fixed issue 395: ERROR: container is not an agtype array (#1039)
Fixed issue 870: regarding orderability and added regression tests (#994)
Fixed issue 876: column reference "_age_default_alias_0" is ambiguous (#931)
Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
Fixed issue 989: Impossible to create array with > 100 items (#1001)
Fixed memory leak issues with age_load (#1142)
Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
Fixed MERGE crashes due to incorrect label type (#957)
Fixed MERGE variable reuse (#997)
Fixed misspellings in many AGE files (#985)
Fixed warning messages in DockerHub builds. (#1075)
Modified test_agtypes to view useful testing message (#992)
Optimised Antlr4ResultHandler initialization (#1169)
Updated CIs to pull correct image based on branch (#1105)
Updated files, format, and version information (#1063)
Updated README.

*

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

The git commit hash:
commit 45f936bd0de92d57c4393ccfb5758d12230cbe24

The release files for 1.4.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG15/1.4.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/PG15/v1.4.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


[VOTE] Apache AGE 1.4.0 Release for PostgreSQL 14

2023-09-06 Thread John Gemignani
   - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.


Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.


Please note that it is not a good practice to copy/paste someone else's
response either, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 14

2023-09-06 Thread John Gemignani
Please do not respond to this as it has the incorrect subject.

john

On Wed, Sep 6, 2023 at 12:09 PM 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.4.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 v1.4.0 for PostgreSQL 14
>
> NOTE: This is an initial release of PG14. 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.
>
> Added license in Python driver README.md (#956)
> Added the toStringList() function (#1128)
> Added toBooleanList() (#1165)
> Added toFloatList() function (#1016)
> Added toIntegerList() function (#1025)
> Added regression tests for MATCH clause using labels only (#1019)
> Added REGTYPEOID to toString function (#1036)
> Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> Fixed complex MERGE causes crash (#897) (#961)
> Fixed docker build files (#1104)
> Fixed case sensitivity on label usage of reserved keyword (#1040)
> Fixed issue 1000: Indexes created on WHERE (#1133)
> Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> Fixed issue 1033: access operator on vle edge lists (#1037)
> Fixed issue 1043: ERROR:  container must be an array or object (#1046)
> Fixed issue 1124: Segmentation fault when using specific tables (#1125)
> Fixed issue 395: ERROR: container is not an agtype array (#1039)
> Fixed issue 870: regarding orderability and added regression tests (#994)
> Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> (#931)
> Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> Fixed issue 989: Impossible to create array with > 100 items (#1001)
> Fixed memory leak issues with age_load (#1142)
> Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> Fixed MERGE crashes due to incorrect label type (#957)
> Fixed MERGE variable reuse (#997)
> Fixed misspellings in many AGE files (#985)
> Fixed warning messages in DockerHub builds. (#1075)
> Modified test_agtypes to view useful testing message (#992)
> Optimised Antlr4ResultHandler initialization (#1169)
> Updated CIs to pull correct image based on branch (#1105)
> Updated files, format, and version information (#1063)
> Updated README.
>
> *
>
>
> !!! 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.4.0-rc0
>
> The git commit hash:
> commit a33b3cf996edaa6d334e30a153ad1ff712c65518
>
> The release files for 1.4.0, can be found at:
> https://dist.apache.org/repos/dist/dev/age/PG14/1.4.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.4.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, then you MUST state it in your
>
>   response. Otherwise, leave it out. Do not mention it if you are
>
>   not a PMC.
>
>
> - You MUST state what you checked to support your vote. See
>
>   the samples given below for guidance.
>
>
> - You MUST, at a minimum, check the above tags, hash,
>
> links, and signatures for validity.
>
>
> - You CANNOT just say, +1 or 0. You need to state what items
>
>   you checked.
>
>
> If your vote DOES NOT follow the above guidelines or samples below, it may
> be thrown out.
>
>
> !!! IMPORTANT PLEASE READ !!!
>
>
> Please vote as follows -
>
>
> +1, Release this package as Apache AGE 1.4.0 for PostgreSQL 14.
>
>   0, I won't get in the way of the vote.
>
>  -1, Do not release this package because 
>
>
>  !!! Followed by what you checked !!!
>
>
> Sampl

[DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 14

2023-09-06 Thread John Gemignani
g:

   - Signature and Hash. - Signature and Hash.

   - Tags and Links. - Tags and Links.

   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.

   - No unexpected binary files.  - No unexpected binary files.



Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.


Please note that it is not a good practice to copy/paste someone else's
response either, you may inadvertently misrepresent yourself or your vote.


This vote will be open for 72 hours.


Thank you for your time.


John Gemignani


Re: [DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 14

2023-09-06 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the DISCUSS thread and will
open the official VOTE thread for Apache AGE 1.4.0 for PostgreSQL 14
shortly.

Thank you all for your input.


John Gemignani


On Wed, Aug 30, 2023 at 9:33 AM Muhammad Shoaib 
wrote:

> Looks good.
> - Verified signature
> - Checked commit hash and links
> - Checked License and Notice file
> - Checked for binary files
>
>
>
> On Wed, 30 Aug 2023 at 18:31, Rafsun Masud  wrote:
>
> > +1 Looks good.
> > - Verified signature
> > - Checked commit hash and links
> > - Checked License and Notice file
> > - Checked for binary files
> >
> > Thanks for the good work!
> >
> > Regards,
> > Rafsun Masud
> >
> >
> > On Tue, Aug 29, 2023 at 3:51 PM Dehowe Feng 
> > wrote:
> >
> > > Looks good to me. Exciting for this release
> > >
> > > I checked the signature and hash,
> > > tags and links,
> > > the license and notice,
> > > made sure there was no unexpected binary files.
> > >
> > > I also reviewed the patch notes as well
> > >
> > > Cheers.
> > >
> > > On Wed, Aug 23, 2023 at 12:12 PM John Gemignani <
> > > john.gemign...@bitnine.net>
> > > wrote:
> > >
> > > > Dear Apache Community,
> > > >
> > > > We would like to open a discussion for the Apache AGE release 1.4.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 v1.4.0 for PostgreSQL 14
> > > >
> > > > NOTE: This is an initial release of PG14. 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.
> > > >
> > > > Added license in Python driver README.md (#956)
> > > > Added the toStringList() function (#1128)
> > > > Added toBooleanList() (#1165)
> > > > Added toFloatList() function (#1016)
> > > > Added toIntegerList() function (#1025)
> > > > Added regression tests for MATCH clause using labels only (#1019)
> > > > Added REGTYPEOID to toString function (#1036)
> > > > Added Dockerfile.dev & move docker-related files to "docker/" (#943)
> > > > Fixed complex MERGE causes crash (#897) (#961)
> > > > Fixed docker build files (#1104)
> > > > Fixed case sensitivity on label usage of reserved keyword (#1040)
> > > > Fixed issue 1000: Indexes created on WHERE (#1133)
> > > > Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
> > > > Fixed issue 1033: access operator on vle edge lists (#1037)
> > > > Fixed issue 1043: ERROR:  container must be an array or object
> (#1046)
> > > > Fixed issue 1124: Segmentation fault when using specific tables
> (#1125)
> > > > Fixed issue 395: ERROR: container is not an agtype array (#1039)
> > > > Fixed issue 870: regarding orderability and added regression tests
> > (#994)
> > > > Fixed issue 876: column reference "_age_default_alias_0" is ambiguous
> > > > (#931)
> > > > Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
> > > > Fixed issue 989: Impossible to create array with > 100 items (#1001)
> > > > Fixed memory leak issues with age_load (#1142)
> > > > Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
> > > > Fixed MERGE crashes due to incorrect label type (#957)
> > > > Fixed MERGE variable reuse (#997)
> > > > Fixed misspellings in many AGE files (#985)
> > > > Fixed warning messages in DockerHub builds. (#1075)
> > > > Modified test_agtypes to view useful testing message (#992)
> > > > Optimised Antlr4ResultHandler initialization (#1169)
> > > > Updated CIs to pull correct image based on branch (#1105)
> > > > Updated files, format, and version information (#1063)
> > > > Updated README.
> > > >
> > > > **

[DISCUSS] Apache AGE 1.4.0 Release for PostgreSQL 14

2023-08-23 Thread John Gemignani
Dear Apache Community,

We would like to open a discussion for the Apache AGE release 1.4.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 v1.4.0 for PostgreSQL 14

NOTE: This is an initial release of PG14. 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.

Added license in Python driver README.md (#956)
Added the toStringList() function (#1128)
Added toBooleanList() (#1165)
Added toFloatList() function (#1016)
Added toIntegerList() function (#1025)
Added regression tests for MATCH clause using labels only (#1019)
Added REGTYPEOID to toString function (#1036)
Added Dockerfile.dev & move docker-related files to "docker/" (#943)
Fixed complex MERGE causes crash (#897) (#961)
Fixed docker build files (#1104)
Fixed case sensitivity on label usage of reserved keyword (#1040)
Fixed issue 1000: Indexes created on WHERE (#1133)
Fixed issue 1002: Invalid reuse of variables in MATCH clause (#1003)
Fixed issue 1033: access operator on vle edge lists (#1037)
Fixed issue 1043: ERROR:  container must be an array or object (#1046)
Fixed issue 1124: Segmentation fault when using specific tables (#1125)
Fixed issue 395: ERROR: container is not an agtype array (#1039)
Fixed issue 870: regarding orderability and added regression tests (#994)
Fixed issue 876: column reference "_age_default_alias_0" is ambiguous (#931)
Fixed issue 975: Invalid reuse of variables in CREATE clause (#977)
Fixed issue 989: Impossible to create array with > 100 items (#1001)
Fixed memory leak issues with age_load (#1142)
Fixed memory leaks in MERGE (merge_edge & merge_vertex) (#958)
Fixed MERGE crashes due to incorrect label type (#957)
Fixed MERGE variable reuse (#997)
Fixed misspellings in many AGE files (#985)
Fixed warning messages in DockerHub builds. (#1075)
Modified test_agtypes to view useful testing message (#992)
Optimised Antlr4ResultHandler initialization (#1169)
Updated CIs to pull correct image based on branch (#1105)
Updated files, format, and version information (#1063)
Updated README.

*

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

The git commit hash:
commit a33b3cf996edaa6d334e30a153ad1ff712c65518

The release files for 1.4.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG14/1.4.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.4.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


Re: Release Nomenclature and Process

2023-06-28 Thread John Gemignani
Hi Taylor,

Thank you for your interest in Apache AGE!

Our goal is to have a complete version of AGE for each supported version of
PostgreSQL. That is our goal. I'm sorry if that sounded too much like
marketing talk.

As our project has grown a lot in the past few months and years, we have
had to reassess our versioning, branching, support, and CI strategies. What
you are seeing right now is our team trying to iron out a lot of these
issues in real time.

So, to address your questions, given that quick background,...

For the "pre-release" tags, we are still cleaning up our release procedure
documents and process and this item needs to be addressed and clarified.
The page that you linked is outdated and needs to be corrected as well.
Thank you for bringing this to our attention.

The distinction between pre-release and release is, before and after the
Apache vote, for the official release; assuming it was successful. It
appears that was overlooked in the documentation and it too needs to be
updated.  Thank you for bringing this to our attention as well.  Btw, for
clarification, the latest release should be the highest PostgreSQL version
of AGE.

There are separate releases for each version of PostgreSQL due to,
sometimes significant, changes between the different versions of
PostgreSQL. For example, PostgreSQL 11 and 12 are significantly different
due to the removal of OIDs. This created a huge undertaking to rewrite code
to address those changes.

Our policy is to drop off support of versions of PostgreSQL as PostgreSQL
drops support for them. As for newer versions, we are currently trying to
catch up to the latest fully released versions of PostgreSQL. After we
reach that point, we will need to work out the best strategy for the beta
versions of PostgreSQL.

As for a timeline or timeframe for PostgreSQL 14 and 15 support: 14 is
nearly ready, 15 is close behind. I would rather not give anything more
specific than that because something inevitably happens to cause delays.
For example, right now we are finishing off some significant features and
bug fixes in the master. We will then be propagating them to all supported
PostgreSQL versions and then 14 and 15.

For clarification, the latest versions of AGE are 1.3.0 and are available
for PostgreSQL 11, 12, & 13.

Hopefully this helps cover all of your questions. If not, please let me
know.

I should point out that our policies are always subject to change if a
better approach is found.

john

On Mon, Jun 26, 2023 at 10:09 AM Riggan, Taylor 
wrote:

> Hi all,
>
> In reviewing the Release process on the website (
> https://age.apache.org/contribution/process) I'm not seeing any reference
> to "pre-releases".  There are currently two pre-releases available on the
> GitHub repo (1.2.0 and 1.3.0) for Apache AGE.  What constitutes a release
> being a "pre-release" and when does this become a full "release"?
>
> There are also separate releases for each version of Postgres.  What is
> the rationale behind having separate releases for each Postgres release
> versus building a version scheme that mirrors the Postgres versioning?
>
> What is the policy for back-porting bugs/features for older version of
> Postgres?  Is there intent to always maintain a version of Apache AGE for
> every version of Postgres starting with v11, or will support for older
> versions drop off at some point?   Along those same lines, what is the
> planned cadence (or lag) for keeping up with Postgres versions?  Postgres
> is now shipping 16-beta.  Which means there are production versions of
> Postgres 14 and 15.  When will Apache AGE have support for those versions?
>
> Thank you,
>
> --
> Taylor Riggan
> Sr. Graph Architect | Amazon Neptune | AWS
>
>


Re: Offset and out of bounds

2023-06-19 Thread John Gemignani
You are looking at why it is called, right? In gdb you can use the *up *command
to look up the call stack to see what called something.

That function, btw, will get called by anything that needs to deserialize
agtype to agtype_value, even multiple times within a single agtype, due to
nested structures.

john



On Mon, Jun 12, 2023 at 12:08 PM Panagiotis Foliadis 
wrote:

> Yes of course.
>
> When we run the basic select * from cypher
> ('test', $$ create (u) return u) as (u agtype), fill_agtype_value() is
> being called multiple times.
> There are times when its called with the base_addr having the value
> "idlabelproperties" and the offset
> helps breaking down this string to fill correctly the json object that
> will be return to the client. But there
> are cases that when the fill_agtype_value() is called, for example when
> the node we are creating has
> no label, that the offset is 32, which is larger than the length of the
> base_addr. Running gdb with
> fill_agtype_value() as a breaking point would make it easier to understand
> what im trying to say.
>
> 
> Από: John Gemignani 
> Στάλθηκε: Δευτέρα, 12 Ιουνίου 2023 10:03 μμ
> Προς: dev@age.apache.org 
> Θέμα: Re: Offset and out of bounds
>
> Could you give some example cases?
>
> john
>
> On Mon, Jun 12, 2023 at 11:12 AM Panagiotis Foliadis <
> pfolia...@hotmail.com>
> wrote:
>
> > Hey all,
> >
> > I'm having a hard time understanding the offset​ functionality in
> > fill_agtype_value​().
> > There are many times when this function is called that the offset​ is
> > greater than the
> > length of the base_addr​ resulting in fetching a value from out of
> bounds.
> > How do the
> > out-of-bounds values get initialized and what are we trying to achieve by
> > having the offset
> > reach for the out-of-bounds values?
> >
>


Re: Offset and out of bounds

2023-06-12 Thread John Gemignani
Could you give some example cases?

john

On Mon, Jun 12, 2023 at 11:12 AM Panagiotis Foliadis 
wrote:

> Hey all,
>
> I'm having a hard time understanding the offset​ functionality in
> fill_agtype_value​().
> There are many times when this function is called that the offset​ is
> greater than the
> length of the base_addr​ resulting in fetching a value from out of bounds.
> How do the
> out-of-bounds values get initialized and what are we trying to achieve by
> having the offset
> reach for the out-of-bounds values?
>


[RESULT][VOTE] Apache AGE release 1.3.0 for PostgreSQL 11

2023-05-19 Thread John Gemignani
Dear Apache Community,

The vote successfully passed with 3 +1 (binding) and 11 +1 (non-binding)

votes. There were no 0 or -1 votes.


Following are the detailed results :

Total of 14 (+1) votes.

3 +1(Binding): Nick Sorrel
Eya Badal Dehowe Feng 11 +1(Non Binding) Fatima Raza Carla Sanches Muneeb
Khan Arunabh Das Mohamad Mokhtar Muhammad Shoaib Rahimullah Shaheen Daniel
John Bhaskar Sharma Mahmudul Islam JawadAli Abbasi

VOTE thread:
https://lists.apache.org/thread/hc4znhck7k0074f8kvpfjfqkz341x09j

Thank you all for your participation!

John Gemignani


Re: [VOTE] Apache AGE release 1.3.0 for PostgreSQL 11

2023-05-19 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 Tue, May 9, 2023 at 2:30 PM 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.3.0 for PostgreSQL 11.
>
> 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 v1.3.0 for PostgreSQL 11
>
> Add additional comments for create_graph function. (#582)
> Optimize age_exists function. (#586)
> Implement plus-equal operator in SET clause. (#638)
> Implement CI test for python driver. (#587)
> Move from travis CI to github actions for build. (#673)
> Update all driver CIs to Github actions.
> Fix build warnings.
> Fix golang driver workflow (#563)
> Updated Readme for drivers folder. (#642)
> Removed async from function definitions. (#680)
> Barbell graph generation (#648) and Barbell regress tests. (#708)
> Updated Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
> Modify docker url for JDBC driver tests (#716)
> Fix WITH ignoring WHERE clause. (#646)
> Implement isEmpty() predicate function. (#710)
> Fix cypher function input argument checks. (#718)
> Fix Issue 693 - server termination from return exists(path). (#721)
> Update regression tests for cypher_with. (#725)
> Fix issue 733 - create_complete_graph() terminates the server. (#734)
> Prevent MATCH from following OPTIONAL MATCH. (#740)
> Fix property constraints against resolved variables. (#724) (#751) (#701)
> (#747)
> Include invalid labels in reused variables. (#751) (#762)
> Remove check for scalar agtypes in unwind. (#736)
> Update PG11 CI workflows.
> Update readme and version for python driver. (#780)
> Update README.md
> *
>
> The git tag to be discussed and voted on:
> https://github.com/apache/age/releases/tag/PG11/v1.3.0-rc0
>
> The git commit hash:
> commit 1a452595fe59975c1df4941e4f8eeb12c097bab7
>
> The release files for 1.3.0, can be found at:
> https://dist.apache.org/repos/dist/dev/age/PG11/1.3.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/PG11/v1.3.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, then you MUST state it in your
>   response. Otherwise, leave it out. Do not mention it if you are
>   not a PMC.
>
> - You MUST state what you checked to support your vote. See
>   the samples given below for guidance.
>
> - You MUST, at a minimum, check the above tags, hash,
>links, and signatures for validity.
>
> - You CANNOT just say, +1 or 0. You need to state what items
>   you checked.
>
> If your vote DOES NOT follow the above guidelines or samples below, it may
> be thrown out.
>
> !!! IMPORTANT PLEASE READ !!!
>
> Please vote as follows -
>
> +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 11.
>   0, I won't get in the way of the vote.
>  -1, Do not release this package because 
>
>  !!! Followed by what you checked !!!
>
> Sample responses, two for PMCs (binding) and two for regular committers.
> These are only samples, do not copy/paste.
>
> Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
> binding. If you are a PMC, you must state it.
>
>+1 (binding)   +1
>Checked the following:   Checked the following:
>- Signature and Hash.   - Signature and Hash.
>- Tags and Links.   - Tags and Links.
>- LICENSE and NOTICE.  - LICENSE and NOTICE.
>- No unexpected binary files. - No unexpected binary files.
>
> -1, Failed due to 0 (binding)
> Checked the following:   Checked the following:
>- Signature and Hash. - Signature and Hash.
>- Tags and Links. - Tags and Links.
>- BAD LICENSE and NOTICE.   - LICENSE and 

[VOTE] Apache AGE release 1.3.0 for PostgreSQL 11

2023-05-09 Thread John Gemignani
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.3.0 for PostgreSQL 11.

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 v1.3.0 for PostgreSQL 11

Add additional comments for create_graph function. (#582)
Optimize age_exists function. (#586)
Implement plus-equal operator in SET clause. (#638)
Implement CI test for python driver. (#587)
Move from travis CI to github actions for build. (#673)
Update all driver CIs to Github actions.
Fix build warnings.
Fix golang driver workflow (#563)
Updated Readme for drivers folder. (#642)
Removed async from function definitions. (#680)
Barbell graph generation (#648) and Barbell regress tests. (#708)
Updated Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
Modify docker url for JDBC driver tests (#716)
Fix WITH ignoring WHERE clause. (#646)
Implement isEmpty() predicate function. (#710)
Fix cypher function input argument checks. (#718)
Fix Issue 693 - server termination from return exists(path). (#721)
Update regression tests for cypher_with. (#725)
Fix issue 733 - create_complete_graph() terminates the server. (#734)
Prevent MATCH from following OPTIONAL MATCH. (#740)
Fix property constraints against resolved variables. (#724) (#751) (#701)
(#747)
Include invalid labels in reused variables. (#751) (#762)
Remove check for scalar agtypes in unwind. (#736)
Update PG11 CI workflows.
Update readme and version for python driver. (#780)
Update README.md
*

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

The git commit hash:
commit 1a452595fe59975c1df4941e4f8eeb12c097bab7

The release files for 1.3.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG11/1.3.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/PG11/v1.3.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, then you MUST state it in your
  response. Otherwise, leave it out. Do not mention it if you are
  not a PMC.

- You MUST state what you checked to support your vote. See
  the samples given below for guidance.

- You MUST, at a minimum, check the above tags, hash,
   links, and signatures for validity.

- You CANNOT just say, +1 or 0. You need to state what items
  you checked.

If your vote DOES NOT follow the above guidelines or samples below, it may
be thrown out.

!!! IMPORTANT PLEASE READ !!!

Please vote as follows -

+1, Release this package as Apache AGE 1.3.0 for PostgreSQL 11.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

 !!! Followed by what you checked !!!

Sample responses, two for PMCs (binding) and two for regular committers.
These are only samples, do not copy/paste.

Remember, (binding) is ONLY for PMCs. If you are not a PMC, DO NOT say
binding. If you are a PMC, you must state it.

   +1 (binding)   +1
   Checked the following:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 11

2023-05-09 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the DISCUSS thread and will
open the official VOTE thread for Apache AGE 1.3.0 for PostgreSQL 11
shortly.

Thank you for your time.

John Gemignani

On Tue, May 9, 2023 at 11:14 AM Muhammad Shoaib 
wrote:

> +1 Looks good to me.
>
> I have checked the following
>
> - Signature and hash - check.
> - LICENSE and NOTICE - check.
> - No unexpected binary files - check.
>
> Ciao,
> Shoaib
>
>
> On Wed, May 3, 2023 at 8:51 PM Muneeb Khan 
> wrote:
>
> > +1
> > - Signature and hash - checked.
> > - LICENSE and NOTICE - checked.
> > - No unexpected binary files - checked.
> > - Merged Pull Requests - checked.
> >
> > Thanks
> >
> > On Fri, Apr 28, 2023 at 11:52 PM John Gemignani <
> > john.gemign...@bitnine.net>
> > wrote:
> >
> > > Dear Apache Community,
> > >
> > > We would like to open a discussion for the Apache AGE release 1.3.0 for
> > > PostgreSQL 11.
> > >
> > > 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 v1.3.0 for PostgreSQL 11
> > >
> > > Add additional comments for create_graph function. (#582)
> > > Optimize age_exists function. (#586)
> > > Implement plus-equal operator in SET clause. (#638)
> > > Implement CI test for python driver. (#587)
> > > Move from travis CI to github actions for build. (#673)
> > > Update all driver CIs to Github actions.
> > > Fix build warnings.
> > > Fix golang driver workflow (#563)
> > > Updated Readme for drivers folder. (#642)
> > > Removed async from function definitions. (#680)
> > > Barbell graph generation (#648) and Barbell regress tests. (#708)
> > > Updated Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
> > > Modify docker url for JDBC driver tests (#716)
> > > Fix WITH ignoring WHERE clause. (#646)
> > > Implement isEmpty() predicate function. (#710)
> > > Fix cypher function input argument checks. (#718)
> > > Fix Issue 693 - server termination from return exists(path). (#721)
> > > Update regression tests for cypher_with. (#725)
> > > Fix issue 733 - create_complete_graph() terminates the server. (#734)
> > > Prevent MATCH from following OPTIONAL MATCH. (#740)
> > > Fix property constraints against resolved variables. (#724) (#751)
> (#701)
> > > (#747)
> > > Include invalid labels in reused variables. (#751) (#762)
> > > Remove check for scalar agtypes in unwind. (#736)
> > > Update PG11 CI workflows.
> > > Update readme and version for python driver. (#780)
> > > Update README.md
> > > *
> > >
> > > The git tag to be discussed and voted on:
> > > https://github.com/apache/age/releases/tag/PG11/v1.3.0-rc0
> > >
> > > The git commit hash:
> > > commit 1a452595fe59975c1df4941e4f8eeb12c097bab7
> > >
> > > The release files for 1.3.0, can be found at:
> > > https://dist.apache.org/repos/dist/dev/age/PG11/1.3.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/PG11/v1.3.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
> > >
> >
>


[DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 11

2023-04-28 Thread John Gemignani
Dear Apache Community,

We would like to open a discussion for the Apache AGE release 1.3.0 for
PostgreSQL 11.

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 v1.3.0 for PostgreSQL 11

Add additional comments for create_graph function. (#582)
Optimize age_exists function. (#586)
Implement plus-equal operator in SET clause. (#638)
Implement CI test for python driver. (#587)
Move from travis CI to github actions for build. (#673)
Update all driver CIs to Github actions.
Fix build warnings.
Fix golang driver workflow (#563)
Updated Readme for drivers folder. (#642)
Removed async from function definitions. (#680)
Barbell graph generation (#648) and Barbell regress tests. (#708)
Updated Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
Modify docker url for JDBC driver tests (#716)
Fix WITH ignoring WHERE clause. (#646)
Implement isEmpty() predicate function. (#710)
Fix cypher function input argument checks. (#718)
Fix Issue 693 - server termination from return exists(path). (#721)
Update regression tests for cypher_with. (#725)
Fix issue 733 - create_complete_graph() terminates the server. (#734)
Prevent MATCH from following OPTIONAL MATCH. (#740)
Fix property constraints against resolved variables. (#724) (#751) (#701)
(#747)
Include invalid labels in reused variables. (#751) (#762)
Remove check for scalar agtypes in unwind. (#736)
Update PG11 CI workflows.
Update readme and version for python driver. (#780)
Update README.md
*

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

The git commit hash:
commit 1a452595fe59975c1df4941e4f8eeb12c097bab7

The release files for 1.3.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG11/1.3.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/PG11/v1.3.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.3.0 Release for PostgreSQL 12

2023-04-26 Thread John Gemignani
Dear Apache Community,

The vote successfully passed with 3 +1 (binding) and 7 +1 (non-binding)
votes. There were no 0 or -1 votes.

Following are the detailed results :

Total of 10 (+1) votes.

3 +1 (binding)
Dehowe Feng
Nicholas Sorrel
Eya Badal

7 +1 (non-binding)
Bhaskar Sharma
Carla Sanches
Moiez Ibrar
JawadAli Abbasi
Kamlesh Kumar
Mohamed Mokhtar
Mohammad Taha Naveed

VOTE thread:
https://lists.apache.org/thread/t4kjb9rhbkyxscvbx4948wrbcz0hj2fq

Thank you all!

John Gemignani


Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-26 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.

Thank you!

John Gemignani

On Wed, Apr 26, 2023 at 3:32 PM Bhaskar Sharma 
wrote:

> +1
>
> - Signature and Hash - checked
> - Tags and links - checked
> - No unexpected binary files - checked
> - Validity of release notes - checked
> - Regression tests - checked
> - Driver tests - checked
>
> On Wed, Apr 26, 2023 at 5:03 AM Carla Sanches 
> wrote:
>
> > +1
> > Checked the following:
> > - Signature and hash.
> > - Tags and links.
> > - No unexpected binary files.
> > - Regression tests.
> > - LICENSE and NOTICE.
> >
> > Checked the following merged Pull Requests:
> > - Create complete graph function. (#342) (#662);
> > - Update SET clause to support assigning a map to a variable. (#468);
> > - Implement isEmpty() predicate function. (#710);
> > - Graph names with the empty string '' are no more allowed. (#251);
> > - Fix typos at multiple locations. (#470);
> > - Update CONTRIBUTING.md (#348);
> > - Additional regression tests added for age_global_graph. (#341);
> > - Fix issue 317: Graph naming convention. (#349);
> > - Fix cypher function input argument checks. (#718);
> > - Fix Issue 693 - server termination from return exists(path). (#721);
> > - Update regression tests for cypher_with. (#725);
> > - Fix issue 733 - create_complete_graph() terminates the server. (#734);
> > - Prevent MATCH from following OPTIONAL MATCH. (#740);
> > - Update README.md.
> >
> > Em sex., 21 de abr. de 2023 às 21:02, John Gemignani <
> > john.gemign...@bitnine.net> escreveu:
> >
> > > 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.3.0 for PostgreSQL
> 12.
> > > This release corrects an issue with the RELEASE notes from the previous
> > > vote.
> > >
> > > To learn more about Apache AGE, please see http://age.apache.org/
> > >
> > > Functionalities included and addressed in this release are:
> > >
> > > *
> > > Apache AGE 1.3.0 for PostgreSQL 12 Release Notes
> > >
> > > NOTE: Due to modifications to core tables, there is no upgrade
> > > path from previous versions.
> > >
> > > Implement CALL ...[YIELD] for cypher functions. (#630)
> > > Graph names with the empty string '' are no longer allowed. (#251)
> > > Fix typos at multiple locations. (#470)
> > > Fix Bug with CALL... [YIELD], clause ignores WHERE.
> > > Fix EXPLAIN to allow for nested cypher commands.
> > > Fix delete_global_graphs and add regression tests. (#336)
> > > Invalid labels now return NULL.
> > > Update CONTRIBUTING.md (#348)
> > > Fix null pointer on name compare. (#376)
> > > Fix Travis CI warning messages.
> > > Additional regression tests added for age_global_graph. (#341)
> > > Readme Added for AGE-JDBC-Driver. (#383)
> > > Updated volatility categories for many functions.
> > > Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)
> > > Create complete graph function. (#342) (#662)
> > > Fix issue 317: Graph naming convention. (#349)
> > > Update SET clause to support assigning a map to a variable. (#468)
> > > Patch to address PR 203 that appears to be inactive. (#671)
> > > Add additional comments for create_graph function. (#582)
> > > Optimize age_exists function. (#586)
> > > Implement plus-equal operator in SET clause. (#638)
> > > Implement CI test for python driver. (#587)
> > > Move from travis CI to github actions for build. (#673)
> > > Update all driver CIs to Github actions.
> > > Fix build warnings.
> > > Updated Readme for drivers folder. (#642)
> > > Remove async from function definitions. (#680)
> > > Barbell graph generation (#648) and Barbell regress tests. (#708)
> > > Update Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
> > > Fix WITH ignoring WHERE clause. (#646)
> > > Implement isEmpty() predicate function. (#710)
> > > Fix cypher function input argument checks. (#718)
> > > Fix Issue 693 - server termination from return exists(path). (#721)
> > > Update regression tests for cypher_with. (#725)
> > > Fix issue 733 - create_complete_graph()

[VOTE] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-21 Thread John Gemignani
nks.- Tags and Links.
   - LICENSE, RELEASE, &   - LICENSE, RELEASE, &
 NOTICE. NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

  -1, Failed due to  0 (binding)
  Checked the following:Checked the following:
- Signature and Hash. - Signature and Hash.
- Tags and Links. - Tags and Links.
- BAD LICENSE and NOTICE.   - LICENSE, RELEASE, &
- No unexpected binary files. NOTICE.
- No unexpected
binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-21 Thread John Gemignani
Dear Apache Community,

Due to an error in the RELEASE file, I will be canceling this release. Once
the issue has been corrected and all files have been updated, I will
reissue the vote.

Thank you for your time and effort.

John Gemignani

On Thu, Apr 20, 2023 at 10:15 PM Muhammad Taha Naveed
 wrote:

> -1
>
> - Found error in release notes. PR #709 (Fix build warnings) was only meant
> for PG13 but it is also included in PG12 release notes.
>
> Regards
> Muhammad Taha Naveed
>
> On Fri, Apr 21, 2023, 01:38 Arunabh Das  wrote:
>
> > +1
> > Checked:
> > - Signature and Hash
> > - Tags and Links
> > - LICENSE and NOTICE
> > - Merged Pull Requests
> > - No unexpected binary files.
> >
> > With regards,
> > Arunabh
> >
> > __
> > LinkedIn: https://www.linkedin.com/in/arunabh-das-b9959720b
> >
> > On Tue, 18 Apr 2023, 05:33 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.3.0 for PostgreSQL
> 12.
> > >
> > > To learn more about Apache AGE, please see http://age.apache.org/
> > >
> > > Functionalities included and addressed in this release are:
> > >
> > > *
> > > Apache AGE 1.3.0 for PostgreSQL 12 Release Notes
> > >
> > >
> > > NOTE: Due to modifications to core tables, there is no upgrade
> > > path from previous versions.
> > >
> > > Implement CALL ...[YIELD] for cypher functions. (#630)
> > >
> > > Graph names with the empty string '' are no longer allowed. (#251)
> > >
> > > Fix typos at multiple locations. (#470)
> > >
> > > Fix Bug with CALL... [YIELD], clause ignores WHERE.
> > >
> > > Fix EXPLAIN to allow for nested cypher commands.
> > >
> > > Fix delete_global_graphs and add regression tests. (#336)
> > >
> > > Invalid labels now return NULL.
> > >
> > > Update CONTRIBUTING.md (#348)
> > >
> > > Fix null pointer on name compare. (#376)
> > >
> > > Fix Travis CI warning messages.
> > >
> > > Additional regression tests added for age_global_graph. (#341)
> > >
> > > Readme Added for AGE-JDBC-Driver. (#383)
> > >
> > > Updated volatility categories for many functions.
> > >
> > > Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)
> > >
> > > Create complete graph function. (#342) (#662)
> > >
> > > Fix issue 317: Graph naming convention. (#349)
> > >
> > > Update SET clause to support assigning a map to a variable. (#468)
> > >
> > > Patch to address PR 203 that appears to be inactive. (#671)
> > >
> > > Add additional comments for create_graph function. (#582)
> > >
> > > Optimize age_exists function. (#586)
> > >
> > > Implement plus-equal operator in SET clause. (#638)
> > >
> > > Implement CI test for python driver. (#587)
> > >
> > > Move from travis CI to github actions for build. (#673)
> > >
> > > Update all driver CIs to Github actions.
> > >
> > > Fix build warnings. (#709)
> > >
> > > Updated Readme for drivers folder. (#642)
> > >
> > > Remove async from function definitions. (#680)
> > >
> > > Barbell graph generation (#648) and Barbell regress tests. (#708)
> > >
> > > Update Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
> > >
> > > Fix WITH ignoring WHERE clause. (#646)
> > >
> > > Implement isEmpty() predicate function. (#710)
> > >
> > > Fix cypher function input argument checks. (#718)
> > >
> > > Fix Issue 693 - server termination from return exists(path). (#721)
> > >
> > > Update regression tests for cypher_with. (#725)
> > >
> > > Fix issue 733 - create_complete_graph() terminates the server. (#734)
> > > Prevent MATCH from following OPTIONAL MATCH. (#740)
> > > Fix property constraints against resolved variables. (#724) (#751)
> (#701)
> > > (#747)
> > > Include invalid labels in reused variables. (#751) (#762)
> > > Fix update_entity_tuple to use correct CommandId. (#769)
> > > Remove check for scalar agtypes in unwind.

[VOTE] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-17 Thread John Gemignani
NSE and NOTICE.  - LICENSE and NOTICE.

   - No unexpected binary files. - No unexpected binary files.


-1, Failed due to 0 (binding)

Checked the following:   Checked the following:

   - Signature and Hash. - Signature and Hash.

   - Tags and Links. - Tags and Links.

   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.

   - No unexpected binary files.  - No unexpected binary files.



Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.


Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.


This vote will be open for 72 hours.


Thank you for your time.


John Gemignani


Re: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-17 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the DISCUSS thread and will
open the official VOTE thread for Apache AGE 1.3.0 for PostgreSQL 12
shortly.

Thank you,

John Gemignani

On Tue, Apr 11, 2023 at 11:30 AM Aditya Gupta  wrote:

> It looks good to me.
>
> Best
> Aditya Gupta
>
> On Tue, Apr 11, 2023, 11:30 PM Muneeb Khan 
> wrote:
>
> > +1
> >
> > I have checked:
> >
> > > Graph names with the empty string '' are no longer allowed. (#251)
> >
> > > Fix typos at multiple locations. (#470)
> >
> > > Fix Bug with CALL... [YIELD], clause ignores WHERE.
> >
> > > Fix EXPLAIN to allow for nested cypher commands.
> >
> > > Fix delete_global_graphs and add regression tests. (#336)
> >
> > > Invalid labels now return NULL.
> >
> > > Fix null pointer on name compare. (#376)
> >
> > > Updated volatility categories for many functions.
> >
> > > Fix issue 317: Graph naming convention. (#349)
> >
> > These changes are correct, to the best of my knowledge.
> >
> > Regards,
> > Muneeb
> >
> > On Tue, Apr 11, 2023 at 1:17 AM Eya Badal  wrote:
> >
> > > Looks good to me!!
> > >
> > > I checked the following:
> > >
> > > - Signature and hash - check.
> > > - LICENSE and NOTICE - check.
> > > - No unexpected binary files - check.
> > >
> > > Great Job!!
> > >
> > > Best,
> > > Eya
> > >
> > > On 2023/04/05 22:34:23 John Gemignani wrote:
> > > > Dear Apache Community,
> > > >
> > > > We would like to open a discussion for the Apache AGE release 1.3.0
> for
> > > > PostgreSQL 12.
> > > >
> > > > To learn more about Apache AGE, please see http://age.apache.org/
> > > >
> > > > Functionalities included and addressed in this release are:
> > > >
> > > >
> > > > Apache AGE 1.3.0 for PostgreSQL 12 Release Notes
> > > >
> > > >
> > > > NOTE: Due to modifications to core tables, there is no upgrade
> > > > path from previous versions.
> > > >
> > > > Implement CALL ...[YIELD] for cypher functions. (#630)
> > > >
> > > > Graph names with the empty string '' are no longer allowed. (#251)
> > > >
> > > > Fix typos at multiple locations. (#470)
> > > >
> > > > Fix Bug with CALL... [YIELD], clause ignores WHERE.
> > > >
> > > > Fix EXPLAIN to allow for nested cypher commands.
> > > >
> > > > Fix delete_global_graphs and add regression tests. (#336)
> > > >
> > > > Invalid labels now return NULL.
> > > >
> > > > Update CONTRIBUTING.md (#348)
> > > >
> > > > Fix null pointer on name compare. (#376)
> > > >
> > > > Fix Travis CI warning messages.
> > > >
> > > > Additional regression tests added for age_global_graph. (#341)
> > > >
> > > > Readme Added for AGE-JDBC-Driver. (#383)
> > > >
> > > > Updated volatility categories for many functions.
> > > >
> > > > Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)
> > > >
> > > > Create complete graph function. (#342) (#662)
> > > >
> > > > Fix issue 317: Graph naming convention. (#349)
> > > >
> > > > Update SET clause to support assigning a map to a variable. (#468)
> > > >
> > > > Patch to address PR 203 that appears to be inactive. (#671)
> > > >
> > > > Add additional comments for create_graph function. (#582)
> > > >
> > > > Optimize age_exists function. (#586)
> > > >
> > > > Implement plus-equal operator in SET clause. (#638)
> > > >
> > > > Implement CI test for python driver. (#587)
> > > >
> > > > Move from travis CI to github actions for build. (#673)
> > > >
> > > > Update all driver CIs to Github actions.
> > > >
> > > > Fix build warnings. (#709)
> > > >
> > > > Updated Readme for drivers folder. (#642)
> > > >
> > > > Remove async from function definitions. (#680)
> > > >
> > > > Barbell graph generation (#648) and Barbell regress tests. (#708)
> > > >
> > > > Update Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
>

[RESULT][VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-17 Thread John Gemignani
Dear Apache Community,

The vote successfully passed with 3 +1 (binding) and 33 +1 (non-binding)
votes. There were no 0 or -1 votes. There was 1 voided vote due to not
following voting instructions.

Following are the abbreviated detailed results :

Total of 36 (+1) votes.

3 +1 (binding)
Dehowe Feng
Nicholas Sorrel
Eya Badal

33 +1 (non-binding)
Due to the large number of votes, please see the vote thread for these.

1 voided vote
fatima raza (stated binding when not a binding vote)

VOTE thread:
https://lists.apache.org/thread/k6qgjnzp3p0k70wgyf72tg5xgpr1xol3

Thank you all!

John Gemignani


Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-17 Thread John Gemignani
Dear Apache Community,

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

John Gemignani

On Sat, Apr 15, 2023 at 5:11 AM JawadAli Abbasi
 wrote:

> +1
> I've checked the following:
> Signature and HashNo unexpected binary filesLicense and NoticeTags and
> Links
>
> Sent from Yahoo Mail on Android
>
>   On Sat, Apr 15, 2023 at 1:44 AM, Omar Saad
> wrote:   +1
> checked :
> - Signature and Hash - checked
> - License and Notice - checked
> - Merged Pull Requests - checked
>
> On Wed, Apr 12, 2023 at 6:57 PM 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.3.0 for PostgreSQL 13.
> >
> > To learn more about Apache AGE, please see http://age.apache.org/
> >
> > Functionalities included and issues addressed in this release:
> > *
> >  Apache AGE 1.3.0 for PostgreSQL 13 Release Notes
> >
> >  NOTE: Due to this being the first release for PostgreSQL 13, there
> >  is no upgrade path from other versions.
> >
> >  Implement CALL ...[YIELD] for cypher functions. (#630)
> >  Graph names with the empty string '' are disallowed. (#251)
> >  Fix typos at multiple locations. (#470)
> >  Fix Bug with CALL... [YIELD], clause ignores WHERE.
> >  Fix EXPLAIN to allow for nested cypher commands.
> >  Fix delete_global_graphs and add regression tests. (#336)
> >  Invalid labels now return NULL.
> >  Update CONTRIBUTING.md (#348)
> >  Fix null pointer on name compare. (#376)
> >  Fix Travis CI warning messages.
> >  Additional regression tests added for age_global_graph. (#341)
> >  Readme Added for AGE-JDBC-Driver. (#383)
> >  Updated volatility categories for many functions.
> >  Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)
> >  Create complete graph function. (#342) (#662)
> >  Fix issue 317: Graph naming convention. (#349)
> >  Update SET clause to support assigning a map to a variable. (#468)
> >  Patch to address PR 203 that appears to be inactive. (#671)
> >  Add additional comments for create_graph function. (#582)
> >  Optimize age_exists function. (#586)
> >  Implement plus-equal operator in SET clause. (#638)
> >  Implement CI test for python driver. (#587)
> >  Move from travis CI to github actions for build. (#673)
> >  Update all driver CIs to Github actions.
> >  Fix build warnings. (#709)
> >  Updated Readme for drivers folder. (#642)
> >  Removed async from function definitions. (#680)
> >  Barbell graph generation (#648) and Barbell regress tests. (#708)
> >  Updated Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
> >  Fix WITH ignoring WHERE clause. (#646)
> >  Implement isEmpty() predicate function. (#710)
> >  Fix cypher function input argument checks. (#718)
> >  Fix Issue 693 - server termination from return exists(path). (#721)
> >  Update regression tests for cypher_with. (#725)
> >  Fix issue 733 - create_complete_graph() terminates the server.
> (#734)
> >  Prevent MATCH from following OPTIONAL MATCH. (#740)
> >  Fix property constraints against resolved variables. (#724) (#751)
> > (#701) (#747)
> >  Include invalid labels in reused variables. (#751) (#762)
> >  Fix update_entity_tuple to use correct CommandId. (#769)
> >  Remove check for scalar agtypes in unwind. (#736)
> >  Update PG13 CI workflows. (#775)
> >  Update readme and version for python driver. (#780)
> >  Update README.md
> > *
> >
> > !!! 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/PG13/v1.3.0-rc0
> >
> > The git commit hash:
> > commit 09e8cb4495f19badeb1aa20bf0990a874a120fbe
> >
> > The release files for 1.3.0, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG13/1.3.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  4

Re: ID generation for vertices and edges

2023-04-12 Thread John Gemignani
My understanding for having the label ID as part of the ID for the vertices
or edges was due to vertices and edges only being allowed to have 1 label,
a design decision.

Since vertices and edges could only have 1 label, they could be stored in a
table named as such. The idea was that this would increase performance by
having vertices and edges separated by labels, and therefore speed up
access to them. By storing the label ID in the vertex or edge ID, it
allowed one to find the label table more easily, and then the actual entry.

However, I'm not sure that this would necessarily increase performance as
going between multiple tables may be just as inefficient as keeping all the
entries in one. And, everything comes at a cost. The cost here is at the
expense of making it more difficult to support multiple labels or using the
maximum number of graph components.

Hopefully, this was helpful.

john

Below are some queries showing this structure, for reference -

psql-11.5-5432-pgsql=# select * from ag_label;
   name   | graph | id | kind |relation |
 seq_name
--+---++--+-+-
 _ag_label_vertex | 16943 |  1 | v| graph1._ag_label_vertex |
_ag_label_vertex_id_seq
 _ag_label_edge   | 16943 |  2 | e| graph1._ag_label_edge   |
_ag_label_edge_id_seq
 zero | 16943 |  3 | v| graph1.zero |
zero_id_seq
 knows| 16943 | 36 | e| graph1.knows|
knows_id_seq
(4 rows)

psql-11.5-5432-pgsql=# select * from graph1.zero;
   id| properties
-+-
 844424930131969 | {"name": "Zero", "value": 2.71828182845905}
(1 row)

psql-11.5-5432-pgsql=# select * from graph1.knows;
id |start_id | end_id  | properties
---+-+-+
 10133099161583617 | 281474976710657 | 281474976710658 | {}
(1 row)

psql-11.5-5432-pgsql=# SELECT * from cypher('graph1', $$ MATCH (n:zero)
RETURN n $$) as (result agtype);
   result
-
 {"id": 844424930131969, "label": "zero", "properties": {"name": "Zero",
"value": 2.71828182845905}}::vertex
(1 row)

psql-11.5-5432-pgsql=# SELECT * from cypher('graph1', $$ MATCH
()-[e:knows]->() RETURN e $$) as (result agtype);
   result
-
 {"id": 10133099161583617, "label": "knows", "end_id": 281474976710658,
"start_id": 281474976710657, "properties": {}}::edge
(1 row)

psql-11.5-5432-pgsql=#

On Wed, Apr 12, 2023 at 1:45 PM Panagiotis Foliadis 
wrote:

> Hey all,
> After digging around in the source code I've discovered that the id's for
> vertices and edges are generated
> through the same procedure (by applying a mask on the label id of the
> different vertices and edges). That leads
> to the fact that the id's generated are solely based on the id of the
> label that they would be inserted, and also
> that the potential id's are huge numbers (since the mask applied is
> 0x). Is there a reason for this?
> Why can't the sequence be used and generated id's starting from 1, without
> applying the mask, for each vertix and edge?
>


[VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-12 Thread John Gemignani
ing:   Checked the following:
   - Signature and Hash.   - Signature and Hash.
   - Tags and Links.   - Tags and Links.
   - LICENSE and NOTICE.  - LICENSE and NOTICE.
   - No unexpected binary files. - No unexpected binary files.

-1, Failed due to 0 (binding)
Checked the following:   Checked the following:
   - Signature and Hash. - Signature and Hash.
   - Tags and Links. - Tags and Links.
   - BAD LICENSE and NOTICE.   - LICENSE and NOTICE.
   - No unexpected binary files.  - No unexpected binary files.

Again, those are just samples for guidance, DO NOT copy/paste. However,
your responses should be similar in form.

Please note that it is not a good practice to copy/paste someone else's
response, you may inadvertently misrepresent yourself or your vote.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-12 Thread John Gemignani
This thread has been canceled i.e. closed; please do not reply to it.

Thank you!

John Gemignani

On Tue, Apr 11, 2023 at 9:19 PM Nimra Tahir 
wrote:

> +1  Release this package as Apache age 1.3.0 for Postgresql 13.
> I did the usual checks, all looks good to me!
>
>
>1. Tags and links are checked
>2. License and Notice checked
>3. Checked for unexpected binary files
>
> Regards,
> Nimra Tahir
>
> On Wed, Apr 12, 2023 at 3:39 AM John Gemignani  >
> wrote:
>
> > Dear Apache Community,
> >
> > Due to multiple issues and errors with the voting process for this
> release
> > (AGE 1.3.0 for PG13) -
> >
> > 1) Community members not stating what they checked or not checking
> > everything. This is not optional.
> > 2) Community members who are PMCs, not stating that they are binding.
> > This is not optional.
> > 3) Community members who are NOT PMCs, stating that they are binding.
> > Only PMCs are binding.
> >
> > It is necessary to cancel this vote and resubmit it later. Please
> > understand that your vote is important but Apache needs it to be done
> > correctly. The Apache board reviews these votes and gives us feedback on
> > them. It is important for the community to do its best to look good.
> >
> > Still, I do thank everyone who took part in the vote! We just need to
> > strive to do it better.
> >
> > John Gemignani
> >
> > On Tue, Apr 11, 2023 at 1:31 PM Waleed Ahmed Shahid
> >  wrote:
> >
> > > +1 (Binding)
> > >  Checked the following:
> > >   Signature and hash-checked.
> > > - Tags and links - checked.
> > > - LICENSE and NOTICE - checked.
> > > - No unexpected binary files - checked.
> > >
> > > Good to go
> > >
> > > On Tue, Apr 11, 2023 at 12:41 PM Waleed Ahmed Shahid <
> > > wshahid.bscs19se...@seecs.edu.pk> wrote:
> > >
> > > > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> > > >
> > > > On Tue, 11 Apr 2023, 12:37 Daniel John,  wrote:
> > > >
> > > >> +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> > > >>
> > > >> On Tue, Apr 11, 2023, 8:15 AM Hammad Saleem <
> > hammadsaleem1...@gmail.com
> > > >
> > > >> wrote:
> > > >>
> > > >> > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> > > >> >
> > > >> > On Tue, 11 Apr 2023, 11:39 AM Rahimullah Shaheen, <
> > > >> > rahimullah.shaheen...@gmail.com> wrote:
> > > >> >
> > > >> > > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> > > >> > >
> > > >> > > On Tue, 11 Apr 2023 at 11:21, Steve Shin 
> > > wrote:
> > > >> > >
> > > >> > > > +1
> > > >> > > >
> > > >> > > >
> > > >> > > > 2023년 4월 10일 (월) 오후 8:34, Muhammad Zahid <
> > > >> zahidmuhammad...@gmail.com
> > > >> > >님이
> > > >> > > > 작성:
> > > >> > > >
> > > >> > > > > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL
> > 13.
> > > >> > > > >
> > > >> > > > > On Tue, 11 Apr 2023, 6:43 am fatima raza, <
> > > >> fatimaraza...@gmail.com>
> > > >> > > > wrote:
> > > >> > > > >
> > > >> > > > > > +1, Release this package as Apache AGE 1.3.0 for
> > > PostgreSQL
> > > >> 13.
> > > >> > > > > >
> > > >> > > > >
> > > >> > > >
> > > >> > >
> > > >> >
> > > >>
> > > >
> > >
> >
>


Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-11 Thread John Gemignani
Dear Apache Community,

Due to multiple issues and errors with the voting process for this release
(AGE 1.3.0 for PG13) -

1) Community members not stating what they checked or not checking
everything. This is not optional.
2) Community members who are PMCs, not stating that they are binding.
This is not optional.
3) Community members who are NOT PMCs, stating that they are binding.
Only PMCs are binding.

It is necessary to cancel this vote and resubmit it later. Please
understand that your vote is important but Apache needs it to be done
correctly. The Apache board reviews these votes and gives us feedback on
them. It is important for the community to do its best to look good.

Still, I do thank everyone who took part in the vote! We just need to
strive to do it better.

John Gemignani

On Tue, Apr 11, 2023 at 1:31 PM Waleed Ahmed Shahid
 wrote:

> +1 (Binding)
>  Checked the following:
>   Signature and hash-checked.
> - Tags and links - checked.
> - LICENSE and NOTICE - checked.
> - No unexpected binary files - checked.
>
> Good to go
>
> On Tue, Apr 11, 2023 at 12:41 PM Waleed Ahmed Shahid <
> wshahid.bscs19se...@seecs.edu.pk> wrote:
>
> > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> >
> > On Tue, 11 Apr 2023, 12:37 Daniel John,  wrote:
> >
> >> +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> >>
> >> On Tue, Apr 11, 2023, 8:15 AM Hammad Saleem  >
> >> wrote:
> >>
> >> > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> >> >
> >> > On Tue, 11 Apr 2023, 11:39 AM Rahimullah Shaheen, <
> >> > rahimullah.shaheen...@gmail.com> wrote:
> >> >
> >> > > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> >> > >
> >> > > On Tue, 11 Apr 2023 at 11:21, Steve Shin 
> wrote:
> >> > >
> >> > > > +1
> >> > > >
> >> > > >
> >> > > > 2023년 4월 10일 (월) 오후 8:34, Muhammad Zahid <
> >> zahidmuhammad...@gmail.com
> >> > >님이
> >> > > > 작성:
> >> > > >
> >> > > > > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> >> > > > >
> >> > > > > On Tue, 11 Apr 2023, 6:43 am fatima raza, <
> >> fatimaraza...@gmail.com>
> >> > > > wrote:
> >> > > > >
> >> > > > > > +1, Release this package as Apache AGE 1.3.0 for
> PostgreSQL
> >> 13.
> >> > > > > >
> >> > > > >
> >> > > >
> >> > >
> >> >
> >>
> >
>


[VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread John Gemignani
Dear Apache Community,

This is an official vote for the Apache AGE release 1.3.0 for PostgreSQL 13.

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

Functionalities included and issues addressed in this release:
*
 Apache AGE 1.3.0 for PostgreSQL 13 Release Notes

 NOTE: Due to this being the first release for PostgreSQL 13, there is
no
 upgrade path from other versions.

 Implement CALL ...[YIELD] for cypher functions. (#630)
 Graph names with the empty string '' are disallowed. (#251)
 Fix typos at multiple locations. (#470)
 Fix Bug with CALL... [YIELD], clause ignores WHERE.
 Fix EXPLAIN to allow for nested cypher commands.
 Fix delete_global_graphs and add regression tests. (#336)
 Invalid labels now return NULL.
 Update CONTRIBUTING.md (#348)
 Fix null pointer on name compare. (#376)
 Fix Travis CI warning messages.
 Additional regression tests added for age_global_graph. (#341)
 Readme Added for AGE-JDBC-Driver. (#383)
 Updated volatility categories for many functions.
 Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)
 Create complete graph function. (#342) (#662)
 Fix issue 317: Graph naming convention. (#349)
 Update SET clause to support assigning a map to a variable. (#468)
 Patch to address PR 203 that appears to be inactive. (#671)
 Add additional comments for create_graph function. (#582)
 Optimize age_exists function. (#586)
 Implement plus-equal operator in SET clause. (#638)
 Implement CI test for python driver. (#587)
 Move from travis CI to github actions for build. (#673)
 Update all driver CIs to Github actions.
 Fix build warnings. (#709)
 Updated Readme for drivers folder. (#642)
 Removed async from function definitions. (#680)
 Barbell graph generation (#648) and Barbell regress tests. (#708)
 Updated Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
 Fix WITH ignoring WHERE clause. (#646)
 Implement isEmpty() predicate function. (#710)
 Fix cypher function input argument checks. (#718)
 Fix Issue 693 - server termination from return exists(path). (#721)
 Update regression tests for cypher_with. (#725)
 Fix issue 733 - create_complete_graph() terminates the server. (#734)
 Prevent MATCH from following OPTIONAL MATCH. (#740)
 Fix property constraints against resolved variables. (#724) (#751)
(#701) (#747)
 Include invalid labels in reused variables. (#751) (#762)
 Fix update_entity_tuple to use correct CommandId. (#769)
 Remove check for scalar agtypes in unwind. (#736)
 Update PG13 CI workflows. (#775)
 Update readme and version for python driver. (#780)
 Update README.md
*

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

The git commit hash:
commit 09e8cb4495f19badeb1aa20bf0990a874a120fbe

The release files for 1.3.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG13/1.3.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.3.0-rc0

!!! IMPORTANT !!!
Please note that Apache REQUIRES the following information to be in your
response the the vote -

- If you are a binding vote, a PMC, then you MUST state it in your
response.
- You MUST state what you checked, to support your vote.

Please vote -

+1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

For example -

 +1 (Binding)
 Checked the following:
 - Signature and hash - check.
 - Tags and links - check.
 - LICENSE and NOTICE - check.
 - No unexpected binary files - check.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official vote for Apache AGE 1.3.0 for PostgreSQL 13 shortly.

Thank you all for your time!

John Gemignani

On Fri, Mar 31, 2023 at 2:43 PM John Gemignani 
wrote:

> Dear Apache Community,
>
>
>
> We would like to open a discussion for the Apache AGE release 1.3.0 for
> PostgreSQL 13.
>
>
>
> To learn more about Apache AGE, please see http://age.apache.org/
>
>
>
> Functionalities included and addressed in this release:
>
>
>
> Apache AGE 1.3.0 for PostgreSQL 13 Release Notes
>
> NOTE: Due to this being the first release for PostgreSQL 13, there is no
>
> upgrade path from other versions.
>
> Implement CALL ...[YIELD] for cypher functions. (#630
> <https://github.com/apache/age/pull/630>)
>
> Graph names with the empty string '' are no more allowed. (#251
> <https://github.com/apache/age/pull/251>)
>
> Fix typos at multiple locations. (#470
> <https://github.com/apache/age/pull/470>)
>
> Fix Bug with CALL... [YIELD], clause ignores WHERE.
>
> Fix EXPLAIN to allow for nested cypher commands.
>
> Fix delete_global_graphs and add regression tests. (#336
> <https://github.com/apache/age/pull/336>)
>
> Invalid labels now return NULL.
>
> Update CONTRIBUTING.md (#348 <https://github.com/apache/age/pull/348>)
>
> Fix null pointer on name compare. (#376
> <https://github.com/apache/age/pull/376>)
>
> Fix Travis CI warning messages.
>
> Additional regression tests added for age_global_graph. (#341
> <https://github.com/apache/age/pull/341>)
>
> Readme Added for AGE-JDBC-Driver. (#383
> <https://github.com/apache/age/pull/383>)
>
> Updated volitility categories for many functions.
>
> Fix issue 339 - entities in WHERE clause have wrong Expr. (#391
> <https://github.com/apache/age/pull/391>)
>
> Create complete graph function. (#342
> <https://github.com/apache/age/pull/342>) (#662
> <https://github.com/apache/age/pull/662>)
>
> Fix issue 317: Graph naming convention. (#349
> <https://github.com/apache/age/pull/349>)
>
> Update SET clause to support assigning a map to a variable. (#468
> <https://github.com/apache/age/pull/468>)
>
> Patch to address PR 203 that appears to be inactive. (#671
> <https://github.com/apache/age/pull/671>)
>
> Add additional comments for create_graph function. (#582
> <https://github.com/apache/age/pull/582>)
>
> Optimize age_exists function. (#586
> <https://github.com/apache/age/pull/586>)
>
> Implement plus-equal operator in SET clause. (#638
> <https://github.com/apache/age/pull/638>)
>
> Implement CI test for python driver. (#587
> <https://github.com/apache/age/pull/587>)
>
> Move from travis CI to github actions for build. (#673
> <https://github.com/apache/age/pull/673>)
>
> Update all driver CIs to Github actions.
>
> Fix build warnings. (#709 <https://github.com/apache/age/pull/709>)
>
> Updated Readme for drivers folder. (#642
> <https://github.com/apache/age/pull/642>)
>
> Removed async from function definitions. (#680
> <https://github.com/apache/age/pull/680>)
>
> Barbell graph generation (#648 <https://github.com/apache/age/pull/648>)
> and Barbell regress tests. (#708 <https://github.com/apache/age/pull/708>)
>
> UPDATED Python Driver ANTLR 4.9.3 -> 4.11.1 (#706
> <https://github.com/apache/age/pull/706>)
>
> Fix WITH ignoring WHERE clause. (#646
> <https://github.com/apache/age/pull/646>)
>
> Implement isEmpty() predicate function. (#710
> <https://github.com/apache/age/pull/710>)
>
> Fix cypher function input argument checks. (#718
> <https://github.com/apache/age/issues/718>)
>
> Fix Issue 693 - server termination from return exists(path). (#721
> <https://github.com/apache/age/pull/721>)
>
> Update regression tests for cypher_with. (#725
> <https://github.com/apache/age/pull/725>)
>
> Fix issue 733 - create_complete_graph() terminates the server. (#734
> <https://github.com/apache/age/pull/734>)
>
> Prevent MATCH from following OPTIONAL MATCH. (#740
> <https://github.com/apache/age/pull/740>)
>
> Fix property constraints against resolved variables. (#724
> <https://github.com/apache/age/issues/724>) (#751
> <https://github.com/apache/age/pull/751>) (#701
> <https://github.com/apache/age/issues/701>) (#747
> <https://github.com/apache/age/pull/747>)
>
> Include invalid labels in reused variables. (#751
> <https://github.com/apache/age/pull/751>) (#762
&g

[DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-05 Thread John Gemignani
Dear Apache Community,

We would like to open a discussion for the Apache AGE release 1.3.0 for
PostgreSQL 12.

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

Functionalities included and addressed in this release are:


Apache AGE 1.3.0 for PostgreSQL 12 Release Notes


NOTE: Due to modifications to core tables, there is no upgrade
path from previous versions.

Implement CALL ...[YIELD] for cypher functions. (#630)

Graph names with the empty string '' are no longer allowed. (#251)

Fix typos at multiple locations. (#470)

Fix Bug with CALL... [YIELD], clause ignores WHERE.

Fix EXPLAIN to allow for nested cypher commands.

Fix delete_global_graphs and add regression tests. (#336)

Invalid labels now return NULL.

Update CONTRIBUTING.md (#348)

Fix null pointer on name compare. (#376)

Fix Travis CI warning messages.

Additional regression tests added for age_global_graph. (#341)

Readme Added for AGE-JDBC-Driver. (#383)

Updated volatility categories for many functions.

Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)

Create complete graph function. (#342) (#662)

Fix issue 317: Graph naming convention. (#349)

Update SET clause to support assigning a map to a variable. (#468)

Patch to address PR 203 that appears to be inactive. (#671)

Add additional comments for create_graph function. (#582)

Optimize age_exists function. (#586)

Implement plus-equal operator in SET clause. (#638)

Implement CI test for python driver. (#587)

Move from travis CI to github actions for build. (#673)

Update all driver CIs to Github actions.

Fix build warnings. (#709)

Updated Readme for drivers folder. (#642)

Remove async from function definitions. (#680)

Barbell graph generation (#648) and Barbell regress tests. (#708)

Update Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)

Fix WITH ignoring WHERE clause. (#646)

Implement isEmpty() predicate function. (#710)

Fix cypher function input argument checks. (#718)

Fix Issue 693 - server termination from return exists(path). (#721)

Update regression tests for cypher_with. (#725)

Fix issue 733 - create_complete_graph() terminates the server. (#734)
Prevent MATCH from following OPTIONAL MATCH. (#740)
Fix property constraints against resolved variables. (#724) (#751) (#701)
(#747)
Include invalid labels in reused variables. (#751) (#762)
Fix update_entity_tuple to use correct CommandId. (#769)
Remove check for scalar agtypes in unwind. (#736)
Update PG12 CI workflows. (#776)
Update readme and version for python driver. (#780)
Update README.md

*

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

The git commit hash:
commit 01486efe5b8a2b316ae766299e6ec78b488fcff2

The release files for 1.3.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG12/1.3.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/PG12/v1.3.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


[DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-03-31 Thread John Gemignani
//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.3.0-rc0



Please share your thoughts and feedback and let us know if we can call for
a vote.


Thank you for your time.


John Gemignani


Re: [DISCUSS] Migration strategy for commits to newly supported, unsynchronized, AGE PG version branches.

2023-02-08 Thread John Gemignani
I haven't done anything with cherry picking but I will look into this to
see if it is helpful.

john

On Wed, Feb 8, 2023 at 11:18 AM Nicholas Sorrell  wrote:

> I’m curious if any experimentation has been done with the `git
> cherry-pick` command? This sounds like the ideal use case where it would
> preserve the history and give the PR initiator co-authorship. You might
> have already explored this, but just wanted to mention it. Here’s a small
> article explaining a similar use case:
> http://technosophos.com/2009/12/04/git-cherry-picking-move-small-code-patches-across-branches.html
>
> > On Feb 7, 2023, at 4:32 PM, John Gemignani 
> wrote:
> >
> > Hi All,
> >
> > There is a need to discuss our strategy going forward for migrating
> commits
> > from, as an example, AGE for PG 11 (called PG11 from this point) to AGE
> for
> > PG 12, 13, etc. (called PG, from this point) for newly supported
> > PostgreSQL version branches.
> >
> > First, I'm no Github expert and welcome any viable, potential
> alternatives.
> > So, please do add suggestions or comments.
> >
> > The issues that arise come down to the *author *and *co-author* of the
> work
> > being moved from one version to another. These issues are due to the
> > creation of newly supported PostgreSQL version branches and the adding of
> > commits that were not part of the previous version, at the time of the
> > creation of these new branches.
> >
> > Please note: Once a new branch is synchronized (brought up to current),
> it
> > will be up to the individuals who put forth a PR, to apply it to
> applicable
> > versions. We will only be migrating commits to synchronize newly created
> > branches. This means that, once a branch is synchronized, any new PRs
> > added, are the responsibility of the PR creators. For example, if one
> > creates a PR for PG11, and PG12 and PG13 have been synchronized at the
> > time, it will be up to that person to create a PR for PG12 and PG13.
> >
> > As far as I'm aware, other than modifying patch files directly, there are
> > only 2 ways to migrate a commit from one separate branch to another.
> > Remember, these branches are diverging.
> >
> >   1. Extract a patch manually, apply it to a local feature branch, make
> >   sure that everything works as expected, rebase it to the local PG
> branch,
> >   then push that branch back to the remote.
> >   2. This is similar to #1, except it is done as a PR.
> >
> > Using option #1, the original author of the patch is preserved, but there
> > is no co-author information for the person doing the migration.
> > Additionally, it doesn't use a PR, so isn't as trackable.
> > Using option #2, the original author is changed to the PR creator and the
> > original author is now the co-author.
> >
> > Our preference would be to preserve the original author, as the author,
> and
> > have the person writing the PR become the co-author. However, it doesn't
> > appear as if that is possible. The co-author is important to keep as a
> > record of who did the work migrating the PR and, they potentially did a
> lot
> > of work to migrate that patch.
> >
> > Being faced with these two options, neither of which are ideal, we're
> > leaning towards option #2.
> >
> > This is where anyone who has any comments, experience, or expertise is
> > welcome to speak up. Additionally, if there are any reasonably viable
> > alternatives, we would be interested in hearing them out.
> >
> > Otherwise, provided no input or reasonable alternatives we will be going
> > with option #2.
> >
> > Thank you to everyone in advance,
> >
> > John Gemignani
>
>


[DISCUSS] Migration strategy for commits to newly supported, unsynchronized, AGE PG version branches.

2023-02-07 Thread John Gemignani
Hi All,

There is a need to discuss our strategy going forward for migrating commits
from, as an example, AGE for PG 11 (called PG11 from this point) to AGE for
PG 12, 13, etc. (called PG, from this point) for newly supported
PostgreSQL version branches.

First, I'm no Github expert and welcome any viable, potential alternatives.
So, please do add suggestions or comments.

The issues that arise come down to the *author *and *co-author* of the work
being moved from one version to another. These issues are due to the
creation of newly supported PostgreSQL version branches and the adding of
commits that were not part of the previous version, at the time of the
creation of these new branches.

Please note: Once a new branch is synchronized (brought up to current), it
will be up to the individuals who put forth a PR, to apply it to applicable
versions. We will only be migrating commits to synchronize newly created
branches. This means that, once a branch is synchronized, any new PRs
added, are the responsibility of the PR creators. For example, if one
creates a PR for PG11, and PG12 and PG13 have been synchronized at the
time, it will be up to that person to create a PR for PG12 and PG13.

As far as I'm aware, other than modifying patch files directly, there are
only 2 ways to migrate a commit from one separate branch to another.
Remember, these branches are diverging.

   1. Extract a patch manually, apply it to a local feature branch, make
   sure that everything works as expected, rebase it to the local PG branch,
   then push that branch back to the remote.
   2. This is similar to #1, except it is done as a PR.

Using option #1, the original author of the patch is preserved, but there
is no co-author information for the person doing the migration.
Additionally, it doesn't use a PR, so isn't as trackable.
Using option #2, the original author is changed to the PR creator and the
original author is now the co-author.

Our preference would be to preserve the original author, as the author, and
have the person writing the PR become the co-author. However, it doesn't
appear as if that is possible. The co-author is important to keep as a
record of who did the work migrating the PR and, they potentially did a lot
of work to migrate that patch.

Being faced with these two options, neither of which are ideal, we're
leaning towards option #2.

This is where anyone who has any comments, experience, or expertise is
welcome to speak up. Additionally, if there are any reasonably viable
alternatives, we would be interested in hearing them out.

Otherwise, provided no input or reasonable alternatives we will be going
with option #2.

Thank you to everyone in advance,

John Gemignani


CVE-2022-45786: Apache AGE: Python and Golang drivers allow data manipulation and exposure due to SQL injection

2023-02-03 Thread John Gemignani
Severity: important

Description:

There are issues with the AGE drivers for Golang and Python that enable SQL 
injections to occur. This impacts AGE for PostgreSQL 11 & AGE for PostgreSQL 
12, all versions up-to-and-including 1.1.0, when using those drivers.

The fix is to update to the latest Golang and Python drivers in addition to the 
latest version of AGE that is used for PostgreSQL 11 or  PostgreSQL 12.

The update of AGE will add a new function to enable parameterization of the 
cypher() function, which, in conjunction with the driver updates, will resolve 
this issue.

Background (for those who want more information):

After thoroughly researching this issue, we found that due to the nature of the 
cypher() function, it was not easy to parameterize the values passed into it. 
This enabled SQL injections, if the developer of the driver wasn't careful. The 
developer of the Golang and Pyton drivers didn't fully utilize 
parameterization, likely because of this, thus enabling SQL injections.

The obvious fix to this issue is to use parameterization in the drivers for all 
PG SQL queries. However, parameterizing all PG queries is complicated by the 
fact that the cypher() function call itself cannot be parameterized directly, 
as it isn't a real function. At least, not the parameters that would take the 
graph name and cypher query.

The reason the cypher() function cannot have those values parameterized is 
because the function is a placeholder and never actually runs. The cypher() 
function node, created by PG in the query tree, is transformed and replaced 
with a query tree for the actual cypher query during the analyze phase. The 
problem is that parameters - that would be passed in and that the cypher() 
function transform needs to be resolved - are only resolved in the execution 
phase, which is much later. Since the transform of the cypher() function needs 
to know the graph name and cypher query prior to execution, they can't be 
passed as parameters.

The fix that we are testing right now, and are proposing to use, is to create a 
function that will be called prior to the execution of the cypher() function 
transform. This new function will allow values to be passed as parameters for 
the graph name and cypher query. As this command will be executed prior to the 
cypher() function transform, its values will be resolved. These values can then 
be cached for the immediately following cypher() function transform to use. As 
added features, the cached values will store the calling session's pid, for 
validation. And, the cypher() function transform will clear this cached 
information after function invocation, regardless of whether it was used.

This method will allow the parameterizing of the cypher() function indirectly 
and provide a way to lock out SQL injection attacks.

References:

https://age.apache.org
https://www.cve.org/CVERecord?id=CVE-2022-45786



[RESULT][VOTE] Apache AGE Release 1.1.1 for PostgreSQL 12

2023-02-01 Thread John Gemignani
Dear Apache Community,

The vote successfully passed with 4, +1 (binding) votes and 3, +1
(non-binding votes). There were no -1 or 0 votes.

Following are the detailed results:

Total of 7 (+1) votes. +1 (Binding) Jasper Blues Nicholas Sorrell Dehowe
Feng Eya Badal +1 (Non Binding) Joe Suh Young Seung Andrew Ko Muhammad
Shoaib

VOTE thread:
https://lists.apache.org/thread/prrlmxdq9qghpktghojdz684vspm0hgc

Thank you,

John Gemignani


[RESULT][VOTE] Apache AGE 1.2.0 Release for PostgreSQL 11

2023-02-01 Thread John Gemignani
Dear Apache Community,

The vote successfully passed with 5, +1 (binding) votes and 3, +1
(non-binding votes). There were no -1 or 0 votes.

Following are the detailed results:

*Total of 8 (+1) votes. * *5, +1 (Binding)* Jasper Blues Nicholas Sorrell
Pieterjan De Potter Dehowe Feng Eya Badal *3, +1 (Non Binding)* Joe Suh
Young Seung Andrew Ko Muhammad Shoaib

VOTE thread:
https://lists.apache.org/thread/2f7qpmojq7y7mglxy2trv27pc63kk7gr

Thank you,

John Gemignani


Re: [VOTE] Apache AGE Release 1.1.1 for PostgreSQL 12

2023-02-01 Thread John Gemignani
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 Mon, Jan 30, 2023 at 8:01 AM Eya Badal  wrote:

> +1 (Binding)
>
> Checked the following:
>
> - Signature and hash - check.
> - LICENSE and NOTICE - check.
> - No unexpected binary files - check.
>
> Great Job!!
>
>
>
>
> On 2023/01/26 21:14:24 John Gemignani wrote:
> > Dear Apache Community,
> >
> > This is an official *RE-ISSUED* vote for the Apache AGE Release 1.1.1 for
> > PostgreSQL 12.
> >
> > To learn more about Apache AGE, please see http://age.apache.org/
> >
> > Included and addressed in this release:
> >
> > Upgrade script from AGE for PG12 1.1.0 to 1.1.1
> > Issue (#318): PGXN Support added. (#367)
> > Add the ability to pass parameters to the cypher function.
> > Modify the python driver's parameterization.
> > Modify the go driver's parameterization.
> > Fix compare_agtype_scalar_values returned result.
> > Implement CI testing for Golang Driver (#372).
> > Update to go version 1.19, as 1.16 is EOL (#373).
> > Issue #388 - Fix python driver build from source (#389).
> > Updated README.md
> >
> > *
> >
> > The git tag to be discussed and voted upon:
> > https://github.com/apache/age/releases/tag/PG12/v1.1.1-rc1
> >
> > The git commit hash:
> > commit 2f85a37f781e8f7a1112aa36e0812d9c3a50d971
> >
> > The release files for 1.1.1, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG12/1.1.1.rc1/
> >
> > 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/PG12/v1.1.1-rc1
> >
> > Please vote (if you are a binding vote, please state it):
> >
> > [ ] +1 Release this package as Apache AGE 1.1.1 for PostgreSQL 12
> > [ ] 0 I won't get in the way
> > [ ] -1 Do not release this package because ...
> >
> >
> > This vote will be open for 72 hours.
> >
> > Thank you,
> >
> > John Gemignani
> >
>


Re: [VOTE] Apache AGE 1.2.0 Release for PostgreSQL 11

2023-02-01 Thread John Gemignani
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 Mon, Jan 30, 2023 at 8:03 AM Eya Badal  wrote:

> +1 (Binding)
>
> Checked the following:
>
> - Signature and hash - check.
> - LICENSE and NOTICE - check.
> - No unexpected binary files - check.
>
> Great Job!!
>
>
> On 2023/01/26 21:05:37 John Gemignani wrote:
> > Dear Apache Community,
> >
> > This is an official vote for the Apache AGE 1.2.0 Release for PostgreSQL
> 11.
> >
> > To learn more about Apache AGE, please see http://age.apache.org/
> >
> > Included and addressed in this release:
> >
> > Fix Python driver (#388).
> > Patch to apply PR (#203) - typos and incorrect hash init.
> > Update SET clause to support assigning a map (#468).
> > Fix WHERE clause wrong Expr bug (#339).
> > Fix multiple typos (#470).
> > Updated the volatility category (from STABLE to IMMUTABLE) of
> multiple
> > functions.
> > Graph naming convention now aligns with Cypher spec. (#349).
> > Fixed README typos (#436).
> > Create graph instruction fixed (#414).
> > Readme added for JDBC driver (#383).
> > Regression tests added (#341).
> > Regression tests added (#336).
> > Updated Python driver Readme for clarity.
> > Fixed compare_agtype_scalar to only return 1, 0, or -1.
> > Created complete graph function (#342).
> > Fix Travis CI warning messages.
> > Updated Golang version to 1.19 (#373).
> > Fixed NULL pointer on name compare (#376).
> > Multiple updates to the README.md file.
> > Implemented CI testing for Golang Driver (#372).
> > Modify the Python driver's parameterization.
> > Added license header to new files that it was missing from.
> > Modify the Golang driver's usage of parameterization.
> > Added the ability to pass PostgreSQL parameters to the cypher
> function
> > (specifically for drivers).
> > Use Debian Buster base image (#243).
> > Updated the CONTRIBUTING.md file (#348).
> > Invalid labels now return NULL instead of erroring out.
> > Removed incubating from overlooked files.
> > Fixed Golang driver module.
> > Removed DISCLAIMER file.
> > Fixed bug in delete_global_graphs.
> > Fixed EXPLAIN to allow for nested cypher commands.
> > Fixed bug with Call, YIELD clause ignores WHERE.
> > Graph names with empty string '' are now disallowed (#251).
> > Implement CALL YIELD for cypher functions.
> > Update NOTICE file.
> >
> > *
> >
> > The git tag to be discussed and voted upon:
> > https://github.com/apache/age/releases/tag/PG11%2Fv1.2.0-rc0
> >
> > The git commit hash:
> > commit 67cb875d2326a257ace8f47622988fdae2332eb1
> >
> > The release files for 1.2.0, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG11/1.2.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/PG11%2Fv1.2.0-rc0
> >
> > Please vote (if you are a binding vote, please state it):
> >
> > [ ] +1 Release this package as Apache AGE 1.2.0 for PostgreSQL 11
> >
> > [ ] 0 I won't get in the way
> >
> > [ ] -1 Do not release this package because ...
> >
> >
> > This vote will be open for 72 hours.
> >
> > Thank you,
> >
> > John Gemignani
> >
>


  1   2   >