Re: [I] I have a question about the function of the agtype json operator in version 1.5.0 [age]
jrgemignani commented on issue #1521: URL: https://github.com/apache/age/issues/1521#issuecomment-1909213255 ``` psql-16.1-5432-pgsql=# select agtype_object_field(properties, 'name') from xyz._ag_label_vertex; agtype_object_field - "John" (1 row) psql-16.1-5432-pgsql=# select agtype_object_field_agtype(properties, 'name') from xyz._ag_label_vertex; ERROR: invalid input syntax for type agtype LINE 1: select agtype_object_field_agtype(properties, 'name') from x... ^ DETAIL: Expected agtype value, but found "name". CONTEXT: agtype data, line 1: name psql-16.1-5432-pgsql=# psql-16.1-5432-pgsql=# select properties->'name' from xyz._ag_label_vertex; ERROR: invalid input syntax for type agtype LINE 1: select properties->'name' from xyz._ag_label_vertex; ^ DETAIL: Expected agtype value, but found "name". CONTEXT: agtype data, line 1: name psql-16.1-5432-pgsql=# ``` -- 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] I have a question about the function of the agtype json operator in version 1.5.0 [age]
jrgemignani commented on issue #1521: URL: https://github.com/apache/age/issues/1521#issuecomment-1909181061 @shinhanbyeol There appears to be something weird with the definition of `->` @Zainab-Saad Could you take a look? -- 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] How to specify property types when loading vertices from files with "load_labels_from_file“ [age]
jrgemignani commented on issue #1502: URL: https://github.com/apache/age/issues/1502#issuecomment-1909121309 @jhan129 If this resolves your question satisfactorily, please consider closing this ticket :) -- 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] I have a question about the function of the agtype json operator in version 1.5.0 [age]
shinhanbyeol commented on issue #1521: URL: https://github.com/apache/age/issues/1521#issuecomment-1909106717 @jrgemignani 1.5 ,1.4 Both were done in pg 14 version -- 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] How to specify property types when loading vertices from files with "load_labels_from_file“ [age]
rafsun42 commented on issue #1502: URL: https://github.com/apache/age/issues/1502#issuecomment-1909009522 The requested behavior is added to the latest master branch by in PR #1519. -- 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: [VOTE] Apache AGE 1.5.0 Release for PostgreSQL 16
+1 (binding) I’ve checked: - tag - commit hash - links and signatures Muhammad *Shoaib, PhD* Data Scientist, Bioinformatician and AI Engineer PhD (Biomedical Engineering) Email: muhemmed.sho...@gmail.com On Wed, 24 Jan 2024 at 18:16, Zainab Saad wrote: > +1 > > Checked the following: > - Release notes > - Tag > - Commit hash > - Links and signatures > > Best regards, > Zainab Saad > > On Wed, Jan 24, 2024 at 1:30 PM Dehowe Feng > wrote: > > > +1 (binding) > > > > I’ve checked: > > > > - Signature and hash > > - License and notice > > - Links and tags > > - No unexpected binary files > > > > Cheers. > > > > On Tue, Jan 23, 2024 at 4:45 AM Muhammad Shoaib < > muhemmed.sho...@gmail.com > > > > > wrote: > > > > > +1 > > > Checked the following: > > > - Tag > > > - Hash > > > - Signature > > > - Link > > > > > > On Mon, Jan 22, 2024 at 9:15 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, Jan 18, 2024, 03:13 John Gemignani < > john.gemign...@bitnine.net > > > > > > > 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) > > > > >
Re: [I] I have a question about the function of the agtype json operator in version 1.5.0 [age]
jrgemignani commented on issue #1521: URL: https://github.com/apache/age/issues/1521#issuecomment-1908668094 @shinhanbyeol What version of PG is this on, what version of PG did it previously work on? -- 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: [VOTE] Apache AGE 1.5.0 Release for PostgreSQL 16
+1 Checked the following: - Release notes - Tag - Commit hash - Links and signatures Best regards, Zainab Saad On Wed, Jan 24, 2024 at 1:30 PM Dehowe Feng wrote: > +1 (binding) > > I’ve checked: > > - Signature and hash > - License and notice > - Links and tags > - No unexpected binary files > > Cheers. > > On Tue, Jan 23, 2024 at 4:45 AM Muhammad Shoaib > > wrote: > > > +1 > > Checked the following: > > - Tag > > - Hash > > - Signature > > - Link > > > > On Mon, Jan 22, 2024 at 9:15 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, Jan 18, 2024, 03:13 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
Re: [I] Invalid reuse of previous clause variable in succeeding CREATE clause [age]
MuhammadTahaNaveed closed issue #1513: Invalid reuse of previous clause variable in succeeding CREATE clause URL: https://github.com/apache/age/issues/1513 -- 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: [VOTE] Apache AGE 1.5.0 Release for PostgreSQL 16
+1 (binding) I’ve checked: - Signature and hash - License and notice - Links and tags - No unexpected binary files Cheers. On Tue, Jan 23, 2024 at 4:45 AM Muhammad Shoaib wrote: > +1 > Checked the following: > - Tag > - Hash > - Signature > - Link > > On Mon, Jan 22, 2024 at 9:15 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, Jan 18, 2024, 03:13 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 > > > !!! > > > > > > 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