Re: [I] How to handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040975917 > I had the same error showing up, but I worked around it by creating labels separately: > > ```sql > SELECT create_vlabel('graph_store', 'TEST'); > SELECT create_elabel('graph_store', 'ABC_IS\'a'); > ``` > > Please check if this works for you unfortunately, it doesn't work on my side. ![CleanShot 2024-04-06 at 13 32 26@2x](https://github.com/apache/age/assets/8643866/0765b9c0-0526-47be-ac2e-91b5d90c6528) -- 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: [PR] Update faqs, meta description, title and images [age-website]
dpdjvhxm commented on PR #297: URL: https://github.com/apache/age-website/pull/297#issuecomment-2040843125 @MuhammadTahaNaveed Thanks for your feedback and kind help. now I understand how it works but still need to learn about it. I will keep that in my mind. 👍 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 For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] Update New-web [age-website]
MuhammadTahaNaveed merged PR #297: URL: https://github.com/apache/age-website/pull/297 -- 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: [PR] Update New-web [age-website]
MuhammadTahaNaveed commented on PR #297: URL: https://github.com/apache/age-website/pull/297#issuecomment-2040838472 > @MuhammadTahaNaveed > > I check the link and try it. Is that right way to fix it? ![image](https://private-user-images.githubusercontent.com/137974842/320167316-c645c64f-542f-4fcc-a642-ba4d464e536c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTIzNjU3NDYsIm5iZiI6MTcxMjM2NTQ0NiwicGF0aCI6Ii8xMzc5NzQ4NDIvMzIwMTY3MzE2LWM2NDVjNjRmLTU0MmYtNGZjYy1hNjQyLWJhNGQ0NjRlNTM2Yy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNDA2JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDQwNlQwMTA0MDZaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1kNWQ0OTE4ZmIyODdkM2ExZTdlYzU0YzRiNDYzOTVkNTc0OWJkNzQ1YTQ2YTUyNjZiYzFmN2ZiNmRhNDliMTNmJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.1pbp6oSpCqaxCuKlk8sm28kzo4Ai9lMexDR_qJ1zwoU) You made a new commit with the same changes rather than amending the previous commit. But it will work for now 👍🏻 . Just remember to write **good commit messages with extended description** in your **future PRs** as well. Thank you. -- 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: [PR] Update New-web [age-website]
dpdjvhxm commented on PR #297: URL: https://github.com/apache/age-website/pull/297#issuecomment-2040836285 @MuhammadTahaNaveed I check the link and try it. Is that right way to fix it? ![image](https://github.com/apache/age-website/assets/137974842/c645c64f-542f-4fcc-a642-ba4d464e536c) -- 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: [PR] Update New-web [age-website]
MuhammadTahaNaveed commented on PR #297: URL: https://github.com/apache/age-website/pull/297#issuecomment-2040804163 @dpdjvhxm Thank you for explaining the changes. However, my request was to change the commit message. If you are not familiar about how to change the commit message, please see [here](https://docs.github.com/en/pull-requests/committing-changes-to-your-project/creating-and-editing-commits/changing-a-commit-message). As a sample for writing meaningful commit message, you can refer to the screenshot below: ![image](https://github.com/apache/age-website/assets/85064039/bb5aacfd-9886-4fb2-8d0c-fce139279dde) -- 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: [PR] Update New-web [age-website]
dpdjvhxm commented on PR #297: URL: https://github.com/apache/age-website/pull/297#issuecomment-2040797756 @MuhammadTahaNaveed Thanks for the review Update meta description : gatsby-config.js - description: "Since May 2022, Apache AGE® is a Top-Level Project at the Apache Software Foundation, born from AgensGraph and developed by Bitnine Global Inc. since 2019. Donated to Apache in April 2020, it enhances graph database capabilities under the Apache License 2.0.", Update title name in index-page: src/pages/index.md - Apache AGE | Graph Database Extension for PostgreSQL Update Image resource(Landing page banner, Article images) - replace image for size reduce Update FAQ Page: Add Q14 ~ Q17 - Updated questions in FAQ page (https://github.com/apache/age-website/pull/297/files#diff-6f03dca09f952eeb1c02b70721c79a9e4060de1618404a5511d6f56a1ee8d7b8) -- 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] Drop extension doesn't drop the ag_catalog schema [age]
jrgemignani commented on issue #1626: URL: https://github.com/apache/age/issues/1626#issuecomment-2040789194 @jriouovh I will try to look into why this is happening. -- 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] Several server crashes when running tests in parallel [age]
diangamichael commented on issue #1512: URL: https://github.com/apache/age/issues/1512#issuecomment-2040763620 It seems that the server crashes occur when running tests using a specific Makefile setup and iterating through the tests multiple times. Here's a summary of the issue and the steps leading to the server crashes: Bug Description: Several server crashes occur when running tests in a loop with the specified Makefile setup. Steps to Reproduce: Modify the Makefile to run tests in a loop multiple times. Start tests using the modified Makefile. Iterate through the tests multiple times, possibly hundreds of iterations. Observe server crashes occurring during the test iterations. Expected Behavior: Tests should execute successfully without causing server crashes even when run multiple times in a loop. Environment: Apache AGE (PG16 branch) with PostgreSQL (REL_16_STABLE). Makefile Modification: REGRESS=--schedule=schedule Modified Test Execution: for i in `seq 10`; do echo "ITER $i" make -s installcheck if coredumpctl; then break fi done Actual Outcome: Server crashes occur during the test iterations, leading to failed tests and potential instability. Workaround: Since the issue seems related to running tests repeatedly in a loop, you might consider running the tests individually or in smaller batches to mitigate the likelihood of server crashes until the root cause of the crashes can be identified and resolved. Additionally, analyzing the server logs and core dumps generated during the crashes could provide insights into the underlying cause. -- 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] List comprehension as property constraint of MERGE clause errors out [age]
diangamichael commented on issue #1611: URL: https://github.com/apache/age/issues/1611#issuecomment-2040762064 To apply a workaround to the query and avoid using list comprehensions in the MERGE clause, you can modify the query to precompute the list before using it in the MERGE clause. Here's how you can rewrite the query: WITH input_list AS ( SELECT [1,2,3] AS list ) SELECT * FROM cypher('graph_name', $$ MERGE ({list: u.list}) ON CREATE SET ... ON MATCH SET ... $$) AS (a agtype); In this modified query: We first create a Common Table Expression (CTE) named input_list to compute the list [1,2,3]. Then, we reference this computed list u.list within the MERGE clause. You need to replace ON CREATE SET ... and ON MATCH SET ... with the appropriate actions you want to perform when the MERGE clause creates or matches a node. By precomputing the list outside the MERGE clause, we avoid using list comprehensions directly within it, potentially bypassing the error you encountered. To apply a workaround to the query and avoid using list comprehensions in the MERGE clause, you can modify the query to precompute the list before using it in the MERGE clause. Here's how you can rewrite the query: sql Copy code WITH input_list AS ( SELECT [1,2,3] AS list ) SELECT * FROM cypher('graph_name', $$ MERGE ({list: u.list}) ON CREATE SET ... ON MATCH SET ... $$) AS (a agtype); In this modified query: We first create a Common Table Expression (CTE) named input_list to compute the list [1,2,3]. Then, we reference this computed list u.list within the MERGE clause. You need to replace ON CREATE SET ... and ON MATCH SET ... with the appropriate actions you want to perform when the MERGE clause creates or matches a node. By precomputing the list outside the MERGE clause, we avoid using list comprehensions directly within it, potentially bypassing the error you encountered. -- 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] Drop extension doesn't drop the ag_catalog schema [age]
diangamichael commented on issue #1626: URL: https://github.com/apache/age/issues/1626#issuecomment-2040760198 Manually drop the "ag_catalog" schema using the drop schema ag_catalog; command after uninstalling the extension. This bug disrupts the expected behavior of the extension uninstallation process and requires extra steps for cleanup. It would be ideal to have the extension removal process also remove any associated schemas automatically to streamline the uninstallation process. -- 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 handle the param if there're single quotes in it? [age]
markgomer commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040426033 I had the same error showing up, but I worked around it by creating labels separately: ```sql SELECT create_vlabel('graph_store', 'TEST'); SELECT create_elabel('graph_store', 'ABC_IS\'a'); ``` Please check if this works for you -- 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 handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040386293 > > I mean, that query works in Neo4j, but I tried it in pg, it doesn't work. Can a label include quotes? > > ``` > > SELECT * from cypher('graph_store', $$ > > MERGE (n1:`TEST`{id: 'a\'bb'}) > > MERGE (n2:`TEST`{id: 'bb \'s abc'}) > > MERGE (n1)-[:`ABC_IS\'_a`]->(n2) > > $$) as (a agtype); > > ``` > > I tested this on AGE-viewer and it seems to be working... what is the error message you're getting? @markgomer Thank you for your reply it shows label name is invalid ![CleanShot 2024-04-06 at 02 22 14@2x](https://github.com/apache/age/assets/8643866/0998a7e0-a08c-4110-85ba-92e7d2090b8f) -- 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 handle the param if there're single quotes in it? [age]
markgomer commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040367613 > I mean, that query works in Neo4j, but I tried it in pg, it doesn't work. Can a label include quotes? > > ``` > SELECT * from cypher('graph_store', $$ >MERGE (n1:`TEST`{id: 'a\'bb'}) >MERGE (n2:`TEST`{id: 'bb \'s abc'}) >MERGE (n1)-[:`ABC_IS\'_a`]->(n2) > $$) as (a agtype); > ``` I tested this on AGE-viewer and it seems to be working... what is the error message you're getting? -- 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 handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040348479 The behavior in the python driver NOT WORK ``` prepared_statement = """ MERGE (n1:`TEST` {id: 'a\'bb'}) MERGE (n2:`TEST` {id: 'bb\'s abc'}) MERGE (n1)-[:`ABC_IS_a`]->(n2) """ ag.execCypher( prepared_statement, ) ``` WORK ``` prepared_statement = """ MERGE (n1:`TEST` {id: "a'bb"}) MERGE (n2:`TEST` {id: "bb's abc"}) MERGE (n1)-[:`ABC_IS_a`]->(n2) """ ag.execCypher( prepared_statement, ) ``` NOT WORK ``` prepared_statement = """ MERGE (n1:`TEST` {id: 'a"bb'}) MERGE (n2:`TEST` {id: 'bb"s abc'}) MERGE (n1)-[:`ABC_IS_a`]->(n2) """ ag.execCypher( prepared_statement, ) ``` NOT WORK ``` prepared_statement = """ MERGE (n1:`TEST` {id: 'a\"bb'}) MERGE (n2:`TEST` {id: 'bb\"s abc'}) MERGE (n1)-[:`ABC_IS_a`]->(n2) """ ag.execCypher( prepared_statement, ) ``` -- 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 handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040327490 > > Another question, should this work as it in Neo4j? > > ``` > > SELECT * from ag_catalog.cypher('graph_store', $$ > > MERGE (n1:`TEST`{id: 'a\'bb'}) > > MERGE (n2:`TEST`{id: 'bb \'s abc'}) > > MERGE (n1)-[:`ABC_I'S_a`]->(n2) > > $$) as (a ag_catalog.agtype); > > ``` > > I'm not sure I understand what you are asking. Also, keep in mind that you will likely need to backslash all non wrapping quote characters. I mean, that query works in Neo4j, but I tried it in pg, it doesn't work. Can a label include quotes? ``` SELECT * from cypher('graph_store', $$ MERGE (n1:`TEST`{id: 'a\'bb'}) MERGE (n2:`TEST`{id: 'bb \'s abc'}) MERGE (n1)-[:`ABC_IS\'_a`]->(n2) $$) as (a 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] How to handle the param if there're single quotes in it? [age]
jrgemignani commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040211383 > Another question, should this work as it in Neo4j? > > ``` > SELECT * from ag_catalog.cypher('graph_store', $$ >MERGE (n1:`TEST`{id: 'a\'bb'}) >MERGE (n2:`TEST`{id: 'bb \'s abc'}) >MERGE (n1)-[:`ABC_I'S_a`]->(n2) > $$) as (a ag_catalog.agtype); > ``` I'm not sure I understand what you are asking. Also, keep in mind that you will likely need to backslash all non wrapping quote characters. -- 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 handle the param if there're single quotes in it? [age]
jrgemignani commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040206690 @noahxzhu > After setting the search_path, now it's working, but why? The search path is needed to see Cypher -- 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 handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040201016 I still have the problem with the python driver, how to handle it with a param which contains single quotes, I digged into the python code, it do set the search_path, but not works ![CleanShot 2024-04-06 at 00 16 39@2x](https://github.com/apache/age/assets/8643866/2cee9924-e3df-432b-b796-8bb2d71f8dbd) -- 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 handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040185888 Another question, should this work as it in Neo4j? ``` SELECT * from ag_catalog.cypher('graph_store', $$ MERGE (n1:`TEST`{id: 'a\'bb'}) MERGE (n2:`TEST`{id: 'bb \'s abc'}) MERGE (n1)-[:`ABC_I'S_a`]->(n2) $$) as (a ag_catalog.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] How to handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040174819 > > > Can you put double quotes around the string? > > > ```cypher > > > SELECT * from ag_catalog.cypher('graph_store', $$ > > > MERGE (n1:`Entity` {id: 'I'}) > > > MERGE (n2:`Entity` {id: "It's better for technology companies to be run by product people"}) > > > MERGE (n1)-[:`Learned`]->(n2) > > > $$) as (a ag_catalog.agtype); > > > ``` > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > This worked for me alright > > > > > > @markgomer I just copy and paste yours, it seems not work > > ![CleanShot 2024-04-05 at 23 46 19@2x](https://private-user-images.githubusercontent.com/8643866/320061243-cb16b2aa-09b2-4a94-94bc-6e752b04c3b2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTIzMzI1MDgsIm5iZiI6MTcxMjMzMjIwOCwicGF0aCI6Ii84NjQzODY2LzMyMDA2MTI0My1jYjE2YjJhYS0wOWIyLTRhOTQtOTRiYy02ZTc1MmIwNGMzYjIucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDQwNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA0MDVUMTU1MDA4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MDE1Yzc4OGJmMTA3MDEwMWExYWM5MGUxYjU3MmRmMTdhYjg1N2IyNzBjM2ZlNDQ1Y2M0YzMxYjVjZjlmMDI0MCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.I_akTn9vwmn3CJ8uR-0tgiglnF06j2w1u2rO0p_QMHU) > > Try setting the search_path: > > ```cypher > SET search_path TO ag_catalog; > ``` > > I'm not sure why it is not working without this, though. After setting the search_path, now it's working, but why? -- 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 handle the param if there're single quotes in it? [age]
markgomer commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040166146 > > Can you put double quotes around the string? > > ```cypher > > SELECT * from ag_catalog.cypher('graph_store', $$ > > MERGE (n1:`Entity` {id: 'I'}) > > MERGE (n2:`Entity` {id: "It's better for technology companies to be run by product people"}) > > MERGE (n1)-[:`Learned`]->(n2) > > $$) as (a ag_catalog.agtype); > > ``` > > > > > > > > > > > > > > > > > > > > > > > > This worked for me alright > > @markgomer I just copy and paste yours, it seems not work > > ![CleanShot 2024-04-05 at 23 46 19@2x](https://private-user-images.githubusercontent.com/8643866/320061243-cb16b2aa-09b2-4a94-94bc-6e752b04c3b2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTIzMzI1MDgsIm5iZiI6MTcxMjMzMjIwOCwicGF0aCI6Ii84NjQzODY2LzMyMDA2MTI0My1jYjE2YjJhYS0wOWIyLTRhOTQtOTRiYy02ZTc1MmIwNGMzYjIucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDQwNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA0MDVUMTU1MDA4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MDE1Yzc4OGJmMTA3MDEwMWExYWM5MGUxYjU3MmRmMTdhYjg1N2IyNzBjM2ZlNDQ1Y2M0YzMxYjVjZjlmMDI0MCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.I_akTn9vwmn3CJ8uR-0tgiglnF06j2w1u2rO0p_QMHU) Try setting the search_path: ```cypher SET search_path TO ag_catalog; ``` I'm not sure why it is not working without this, though. -- 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] `MERGE` creates incomplete vertices after the first one [age]
mingfang commented on issue #1709: URL: https://github.com/apache/age/issues/1709#issuecomment-2040147467 @jrgemignani Confirm fixed. 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 For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [I] `MERGE` creates incomplete vertices after the first one [age]
mingfang closed issue #1709: `MERGE` creates incomplete vertices after the first one URL: https://github.com/apache/age/issues/1709 -- 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 handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040141008 > @noahxzhu Did you try using the backslash for the cypher query? Your example above doesn't show it. > > ``` > psql-16.1-5432-pgsql=# SELECT * from ag_catalog.cypher('test', $$ > MERGE (n1:`Entity` {id: 'I'}) > MERGE (n2:`Entity` {id: 'It\'s better for technology companies to be run by product people'}) > MERGE (n1)-[:`Learned`]->(n2) > $$) as (a ag_catalog.agtype); > a > --- > (0 rows) > > psql-16.1-5432-pgsql=# SELECT * FROM cypher('test', $$ MATCH (v) RETURN v $$) AS (v agtype); > v > > > -- > {"id": 844424930131969, "label": "Entity", "properties": {"id": "I"}}::vertex > {"id": 844424930131970, "label": "Entity", "properties": {"id": "It's better for technology companies to be run by product people"} > }::vertex > (2 rows) > > psql-16.1-5432-pgsql=# > ``` not work on my side, I need to investigate the reason -- 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 handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040137056 > Can you put double quotes around the string? > > ```cypher > SELECT * from ag_catalog.cypher('graph_store', $$ > MERGE (n1:`Entity` {id: 'I'}) > MERGE (n2:`Entity` {id: "It's better for technology companies to be run by product people"}) > MERGE (n1)-[:`Learned`]->(n2) > $$) as (a ag_catalog.agtype); > ``` > > This worked for me alright @markgomer I just copy and paste yours, it seems not work ![CleanShot 2024-04-05 at 23 46 19@2x](https://github.com/apache/age/assets/8643866/cb16b2aa-09b2-4a94-94bc-6e752b04c3b2) -- 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 handle the param if there're single quotes in it? [age]
markgomer commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040124740 Can you put double quotes around the string? ```cypher SELECT * from ag_catalog.cypher('graph_store', $$ MERGE (n1:`Entity` {id: 'I'}) MERGE (n2:`Entity` {id: "It's better for technology companies to be run by product people"}) MERGE (n1)-[:`Learned`]->(n2) $$) as (a ag_catalog.agtype); ``` This worked for me alright -- 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 handle the param if there're single quotes in it? [age]
jrgemignani commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040095077 @noahxzhu Additionally, this sounds more like a question than a bug. -- 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 handle the param if there're single quotes in it? [age]
jrgemignani commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2040092230 @noahxzhu Did you try using the backslash for the cypher query? Your example above doesn't show 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
Re: Change default branch for age-website repo?
Hi Sebb, Just letting you know that I have brought this email to the attention of those responsible for the website repo. john On Thu, Apr 4, 2024 at 4:32 PM sebb wrote: > Another reason for changing the default branch is that GH search only > applies to the default branch. > > On Thu, 4 Apr 2024 at 17:19, sebb wrote: > > > > The AGE website is currently built from the new-web branch rather than > > the default master branch. > > This is confusing for outsiders who may wish generate PRs or issues > > relating to the site. > > > > It might be time to ask raise an INFRA Jira to ask for the default to > > be changed. > > > > Or at least the README in the master branch should be edited make it > > clear that the source for the site is located elsewhere. > > > > Note: you may need to copy some settings from .asf.yaml in the master > branch. > > > > Sebb >
Re: [I] `MERGE` creates incomplete vertices after the first one [age]
jrgemignani commented on issue #1709: URL: https://github.com/apache/age/issues/1709#issuecomment-2040011319 @diangamichael Thank you for your input. However, this issue is a bug and the suggestion is a temporary workaround. This issue cannot be closed until the issue is resolved and @mingfang, who opened the issue, is satisfied with the solution. -- 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 handle the param if there're single quotes in it? [age]
noahxzhu commented on issue #1722: URL: https://github.com/apache/age/issues/1722#issuecomment-2039886389 When I use Neo4j, I can create like this, the edge label can also include single quote ![CleanShot 2024-04-05 at 21 59 12@2x](https://github.com/apache/age/assets/8643866/03d3a264-c5c7-4e36-851c-ea49cac7557b) -- 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 handle the param if there're single quotes in it? [age]
noahxzhu opened a new issue, #1722: URL: https://github.com/apache/age/issues/1722 **Describe the bug** An error is observed when a property parameter includes a single quote. **How are you accessing AGE (Command line, driver, etc.)?** - I'm using the apache-age-python package in a python project. **What data setup do we need to do?** ```python def upsert_triplet_test(subj: str, rel: str, obj: str) -> None: prepared_statement = f""" MERGE (n1:`Entity` {{id: %s}}) MERGE (n2:`Entity` {{id: %s}}) MERGE (n1)-[:`{rel.replace(" ", "_").upper()}`]->(n2) """ ag.execCypher( prepared_statement, params=( subj, obj, ), ) ag.commit() upsert_triplet_test( "I", "Learned", "It's better for technology companies to be run by product people" ) ``` This is the error ``` cursor.execute(stmt) psycopg2.errors.SyntaxError: syntax error at or near "'s better for technology companies to be run by product people'" ``` **What is the necessary configuration info needed?** - nothing **What is the command that caused the error?** ```pgsql SELECT * from ag_catalog.cypher('graph_store', $$ MERGE (n1:`Entity` {id: 'I'}) MERGE (n2:`Entity` {id: 'It's better for technology companies to be run by product people'}) MERGE (n1)-[:`Learned`]->(n2) $$) as (a ag_catalog.agtype); ``` Not sure how to handle this case ``` ERROR: syntax error at or near "s" LINE 3: MERGE (n2:`Entity` {id: 'It's better for technology com... ``` **Expected behavior** This merge operation should be succeed. **Environment (please complete the following information):** - Version: package version 0.0.7 - AGE Version: 1.5.0 **Additional context** no -- 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
[PR] Update New-web [age-website]
dpdjvhxm opened a new pull request, #297: URL: https://github.com/apache/age-website/pull/297 Update meta description Update title name in index-page Update Image resource(Landing page banner, Article images) Update FAQ Page: Add Q14 ~ Q17 -- 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