Re: [I] OPTIONAL MATCH should act as outer relationship, acts as cross join [age]
MironAtHome commented on issue #1629: URL: https://github.com/apache/age/issues/1629#issuecomment-1970556683 Reproduced on both, Windows and Linux. Workaround, produces left outer join: ``` SELECT * FROM cypher( 'test_graph' , $$ MATCH (a:vertice1) OPTIONAL MATCH (b:vertice2) RETURN a, b $$ ) AS (a agtype, b agtype); ``` -- 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
[DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 12
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
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
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) > > > 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: > > >
Re: [I] Need postgres with graph extensions running on windows OS [age]
uhayat commented on issue #1542: URL: https://github.com/apache/age/issues/1542#issuecomment-1969066053 I started working on this, hopefully I will be done in couple of days with minimal changes in AGE to make it cross platform. -- 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
