Re: [VOTE] Apache AGE 1.5.0 Release for PostgreSQL 11
+1 binding Checked following and found in proper order - Release notes - Git Tag - Commit hash - Links Kind Regards Shoaib Muhammad *Shoaib, PhD* Data Scientist, Bioinformatician and AI Engineer PhD (Biomedical Engineering) Email: muhemmed.sho...@gmail.com On Fri, 15 Mar 2024 at 23:03, 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) > 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 > > * > > !!! 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
[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 11
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) 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 * !!! 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
[I] Call subquery [age]
rafsun42 opened a new issue, #1690:
URL: https://github.com/apache/age/issues/1690
Should we add [call
subquery](https://neo4j.com/docs/cypher-manual/current/subqueries/call-subquery/?utm_source=Google_medium=PaidSearch_campaign=Evergreenutm_content=AMS-Search-SEMCE-DSA-None-SEM-SEM-NonABM_term=_adgroup=DSA-use-cases_source=1=CjwKCAjw48-vBhBbEiwAzqrZVLKhZ3Swr9FxOtwkjpaA9BWPj8vjzbjxoapsZf0gapp3RPktxKf2BxoCnWwQAvD_BwE)
to AGE? It will allow Neo4j's GraphQL library to be compatible with AGE.
**Data Setup**
```sql
SELECT * FROM cypher('xyz', $$
CREATE (:Actor{name:'Tom Hanks'})-[:ACTED_IN]->(:Movie{title:'Forrest
Gump'})
$$) as (a agtype);
```
**Two uses of call subquery**
1)
```sql
SELECT * FROM ag_catalog.cypher('xyz', $$
MATCH (this:Movie)
CALL {
WITH this
MATCH (this)<-[this0:ACTED_IN]-(this1:Actor)
WITH ag_catalog.agtype_build_map('name', this1.name) AS this1
RETURN collect(this1) AS var2
}
RETURN ag_catalog.agtype_build_map('title', this.title, 'actors', var2)
AS this
$$) as ("?" agtype);
```
2)
```sql
SELECT * FROM ag_catalog.cypher('xyz', $$
UNWIND $create_param0 AS create_var0
CALL {
WITH create_var0
CREATE (create_this1:Movie)
SET
create_this1.title = create_var0.title
WITH create_this1, create_var0
CALL {
WITH create_this1, create_var0
UNWIND create_var0.actors.create AS create_var2
WITH create_var2.node AS create_var3, create_var2.edge AS
create_var4, create_this1
CREATE (create_this5:Actor)
SET
create_this5.name = create_var3.name
MERGE (create_this1)<-[create_this6:ACTED_IN]-(create_this5)
RETURN collect(NULL) AS create_var7
}
RETURN create_this1
}
CALL {
WITH create_this1
MATCH (create_this1)<-[create_this8:ACTED_IN]-(create_this9:Actor)
WITH ag_catalog.agtype_build_map('name', create_this9.name) AS
create_this9
RETURN collect(create_this9) AS create_var10
}
RETURN collect(ag_catalog.agtype_build_map('title', create_this1.title,
'actors', create_var10)) AS data
$$,
'[ { title: 'Forrest Gump', actors: { create: [{ node: { name: "Tom Hanks" }
}] } } ]' -- parameter
) as ("?" agtype);
```
**Expected output**
For both queries:
```
[
{
"title": "Forrest Gump",
"actors": [
{
"name": "Tom Hanks"
}
]
}
]
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Re: [DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 11
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 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
Re: [I] [OSSC] Make Apache AGE compatible with pgcli [age]
markgomer commented on issue #1659: URL: https://github.com/apache/age/issues/1659#issuecomment-1999568137 Hello @nasirbloch323, thanks for your tip. Which tools do you recommend for this? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [I] Periodic regression test "expr" failures [age]
saygoodbyye commented on issue #1439: URL: https://github.com/apache/age/issues/1439#issuecomment-1999041903 @rafsun42 Thank you. I noticed that this is not the only query that can use parallel workers, so I decided to set this option for the entire test. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [I] [OSSC] Make Apache AGE compatible with pgcli [age]
nasirbloch323 commented on issue #1659: URL: https://github.com/apache/age/issues/1659#issuecomment-1999021539 use some advacnce tools to reslove this -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
