[GitHub] [age] cho2hhun opened a new issue, #1234: [Hybrid Query]Cannot use SQL function in Cypher query

2023-09-18 Thread via GitHub
cho2hhun opened a new issue, #1234: URL: https://github.com/apache/age/issues/1234 I've used Agens Graph and AGE many times, and I think there is a point that hope to revise like Agens Graph In AGE, it cannot use **PostgreSQL function in Cypher query** but Agens Graph was possible to

[GitHub] [age] cho2hhun commented on issue #1226: [Creating Table]Creating Table, Temporary Table, View from Graph in AGE

2023-09-18 Thread via GitHub
cho2hhun commented on issue #1226: URL: https://github.com/apache/age/issues/1226#issuecomment-1724698016 Hello @jrgemignani !! For example if i try to make table with `SELECT` query that is including cypher query, then **_table_ and _temporary table_ is not created** below is

[GitHub] [age] cho2hhun commented on issue #1225: [Data Casting] 'agtype' Casting

2023-09-18 Thread via GitHub
cho2hhun commented on issue #1225: URL: https://github.com/apache/age/issues/1225#issuecomment-1724693861 @KamleshKumar427 Thank you for your advice! I'de read many times the document that you linked, But in that Document, I Think There are problems also :( First The Cypher

[GitHub] [age] cho2hhun commented on issue #1225: [Data Casting] 'agtype' Casting

2023-09-18 Thread via GitHub
cho2hhun commented on issue #1225: URL: https://github.com/apache/age/issues/1225#issuecomment-1724628778 Hi @Allison-E I've tried various Code but Problems are like that 1. agtype only possible to cast as 'varchar' for string Data, not 'text' etc 2. actually agtype is normally used

Re: [VOTE] Apache AGE 1.4.0 Release for PostgreSQL 15

2023-09-18 Thread Dehowe Feng
Vote: +1 binding I did the usual checks: - Signature and hash - Links and tags - LICENSE and NOTICE - No unexpected binary files Cheers On Mon, Sep 18, 2023 at 9:11 AM Muhammad Taha Naveed wrote: > +1 > > - Signature and Hash => checked > - Tags and links => checked > - No unexpected binary fi

[GitHub] [age] jimenasansav commented on issue #1217: Java Driver - Gradle/Java error when installing from source

2023-09-18 Thread via GitHub
jimenasansav commented on issue #1217: URL: https://github.com/apache/age/issues/1217#issuecomment-1724558361 Hi @iabmatos, thank you for sharing your issues! Please do not hesitate to share other problems you are facing. Our team is always willing to help! -- This is an automated mes

[GitHub] [age] jrgemignani commented on issue #1219: MERGE does not set properties involving variables

2023-09-18 Thread via GitHub
jrgemignani commented on issue #1219: URL: https://github.com/apache/age/issues/1219#issuecomment-1724484103 The query also succeeds in these cases - ``` psql-15.4-5432-pgsql=# SELECT * FROM cypher('xyz', $$ MATCH (x:Label1{arr:[1,2,3,4]}) MERGE (y:Label2{key1:2, key2:x.arr, key

[GitHub] [age] ksheroz commented on issue #1219: MERGE does not set properties involving variables

2023-09-18 Thread via GitHub
ksheroz commented on issue #1219: URL: https://github.com/apache/age/issues/1219#issuecomment-1724030759 > Some observations: > > * The same query with `CREATE` instead of `MERGE` works just fine > > ``` > SELECT * FROM cypher('xyz', > $$ > MATCH (x:Label1{arr:[1,2,3,4

Re: [VOTE] Apache AGE 1.4.0 Release for PostgreSQL 15

2023-09-18 Thread Muhammad Taha Naveed
+1 - Signature and Hash => checked - Tags and links => checked - No unexpected binary files => checked - Validity of release notes => checked - Regression tests => checked (24 passing) - Driver tests => checked Regards Muhammad Taha Naveed On Thu, Sep 14, 2023 at 5:15 AM John Gemignani wrote:

Re: [VOTE] Apache AGE 1.4.0 Release for PostgreSQL 15

2023-09-18 Thread Rafsun Masud
Dear Apache Community, I am writing to vote for this release. +1 Checked: - Signature, hash - Links, tags - LICENSE and NOTICE - Unexpected binary files (none) Regards, Rafsun Masud On Wed, Sep 13, 2023 at 5:15 PM John Gemignani wrote: > Dear Apache Community, > > Please carefully read all in

Re: [VOTE] Apache AGE 1.4.0 Release for PostgreSQL 15

2023-09-18 Thread Muhammad Shoaib
Dear Apache AGE Community, I hope this message finds you well. I am writing to formally cast my vote for the approval of Apache AGE version 1.4.0 for PG15. My vote is as follows: +1 (Binding) I have conducted a thorough review of the release candidate and have ensured that the following criteria

[GitHub] [age] jrgemignani commented on issue #1000: Index is not used in the WHERE clause

2023-09-18 Thread via GitHub
jrgemignani commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1723634301 @vladiksun Yes, @rafsun42 and @dehowef have both been working on PRs for improving WHERE performance. Hopefully, we'll have them all out by the end of the week. -- This is an auto

[GitHub] [age] vladiksun commented on issue #1000: Index is not used in the WHERE clause

2023-09-18 Thread via GitHub
vladiksun commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1723634217 @jrgemignani, @rafsun42 ok I will create a new issue for the proposed solution for IN operator and link it to the this one. Thank you. -- This is an automated message from the Apach

[GitHub] [age] jrgemignani commented on issue #1000: Index is not used in the WHERE clause

2023-09-18 Thread via GitHub
jrgemignani commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1723626748 @vladiksun We probably should keep the issues separate but link them. Really long threads can lose their readability, especially if they diverge too much. Also, having a long thread

[GitHub] [age] vladiksun commented on issue #1000: Index is not used in the WHERE clause

2023-09-18 Thread via GitHub
vladiksun commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1723616635 @jrgemignani I believe @rafsun42 also suggested the solution for IN operator. I can move the issue with "IN" operator to another ticket. Let me know if it is convenient to do so or lea

[GitHub] [age] jrgemignani commented on issue #1000: Index is not used in the WHERE clause

2023-09-18 Thread via GitHub
jrgemignani commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1723595479 @vladiksun We should probably look into these later queries separately. My tests were only against your query at the top of this thread and only on my server. If the issue with using

[GitHub] [age] vladiksun commented on issue #1000: Index is not used in the WHERE clause

2023-09-18 Thread via GitHub
vladiksun commented on issue #1000: URL: https://github.com/apache/age/issues/1000#issuecomment-1723307224 @jrgemignani Thanks for sharing the PR. I have built that branch to see how it could affect our typical queries. It turns out that for our use cases, we do not see much difference.

[GitHub] [age] CapnSpek commented on issue #1219: MERGE does not set properties involving variables

2023-09-18 Thread via GitHub
CapnSpek commented on issue #1219: URL: https://github.com/apache/age/issues/1219#issuecomment-1723262498 The same query also fails if instead of an array, we have any other datatype. If the setup is changed to ... SELECT * FROM cypher('xyz', $$ CREATE (x:Label1{arr:[1,2,3,

[GitHub] [age] CapnSpek commented on issue #1219: MERGE does not set properties involving variables

2023-09-18 Thread via GitHub
CapnSpek commented on issue #1219: URL: https://github.com/apache/age/issues/1219#issuecomment-1723217422 Some observations: - The same query with `CREATE` instead of `MERGE` works just fine ``` SELECT * FROM cypher('xyz', $$ MATCH (x:Label1{arr:[1,2,3,4]}) CREATE (y:La