Re: [I] [Hybrid Query]Cannot use SQL function in Cypher query [age]

2023-10-04 Thread via GitHub


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

   @cho2hhun 
   
   Have you tried using the full qualified name of the function and casting 
agtype to float8? 
   ```
   select * from cypher ('car', $$
   match (a : vt_car) -[r : eg_eng_use2]->(b : vt_engine)
   return (pg_catalog.corr((r.fe)::pg_float8, (r.co2)::pg_float8)) as corr 
$$) as (corr 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



Re: [I] Renaming a Label [age]

2023-10-04 Thread via GitHub


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

   Hi @MatheusFarias03. We are planning to add support for label rename as a 
part of the label redesign project.  


-- 
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.4.0 Release for PostgreSQL 13

2023-10-04 Thread Rafsun Masud
+1

Checked:
- Signature and hash
- LICENSE and notice
- Links and Tags
- Unexpected binary files (none)

Regards,
Rafsun Masud

On Tue, Oct 3, 2023 at 10:32 PM Muhammad Shoaib 
wrote:

> +1(Binding)
>
> I checked the following:
>
>- Signature and hash
>- Links and tags
>- LICENSE and NOTICE
>- No unexpected binary files
>
> Kind Regards
> Shoaib
>
> On Wed, Oct 4, 2023 at 2:47 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.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/tag/PG13/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 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 

Re: [I] Unexpected termination on looping cypher query - could not find rte [age]

2023-10-04 Thread via GitHub


I33Buckler commented on issue #1260:
URL: https://github.com/apache/age/issues/1260#issuecomment-1746362184

   Further investigation has determined that the process continues until row 
123,486 of the 231,131 rows in the table. 
   Would be interested to know what could be the cause of this hard limit on 
processing the table as there is no obvious reason for it.


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