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

2024-01-10 Thread Dehowe Feng
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 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

Re: [I] Cypher query to exlude subpaths (or return only full paths) [age]

2024-01-10 Thread via GitHub


rafsun42 commented on issue #1464:
URL: https://github.com/apache/age/issues/1464#issuecomment-1885365477

   @FrancescoSillani 
   
   Given you scenario, does this path `A -> B -> C` exists?


-- 
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] Cypher query to exlude subpaths (or return only full paths) [age]

2024-01-10 Thread via GitHub


rafsun42 commented on issue #1464:
URL: https://github.com/apache/age/issues/1464#issuecomment-1885373522

   @FrancescoSillani 
   
   Assuming, your scenario is- `A -> [R] -> B -> [R] -> C`, please refer to the 
documentation on [variable length 
edges](https://age.apache.org/age-manual/master/clauses/match.html#variable-length-edges).
 You can MATCH paths with exactly 2 edges using `(t1)-[:R*2]->(t2)`.


-- 
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] Study the make_directed_edge_join_conditions function [age]

2024-01-10 Thread via GitHub


rafsun42 closed issue #1007: Study the make_directed_edge_join_conditions 
function
URL: https://github.com/apache/age/issues/1007


-- 
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



[I] How to specify property types when loading vertices from files with "load_labels_from_file“ [age]

2024-01-10 Thread via GitHub


jhan129 opened a new issue, #1502:
URL: https://github.com/apache/age/issues/1502

   hi, i wonder if there is any way I can specify property types when loading 
vertices from CSV? it seems all the properties will be loaded as String, though 
some of them are numeric values in my csv. 
   
   Thanks!


-- 
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