You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@age.apache.org by "wen-bing (via GitHub)" <gi...@apache.org> on 2024/10/31 01:27:15 UTC

[I] cannot use $$ inside a string [age]

wen-bing opened a new issue, #2127:
URL: https://github.com/apache/age/issues/2127

   **Describe the bug**
   in cypher query , I cannot use $$ inside a string. my query like this:
   
   select * from cypher('graph1', $$
   Match(v:Persion{p_id:'safd$$bbb'}
   return v
   $$) as (v agtype);
   
   **How are you accessing AGE (Command line, driver, etc.)?**
   - psql
   
   **What data setup do we need to do?**
   ```pgsql
   ...
   SELECT * from cypher('graph1', $$
     CREATE (a:Persion {p_id: '123'}), 
            (b:Persion{p_id: '345'}), 
   $$) as (a agtype);
   ...
   ```
   
   **What is the command that caused the error?**
   ```pgsql
   SELECT * from cypher('graph1', $$
     MATCH  (b:Person{p_id: '345$$wwee'})
   $$) as (b agtype);
   ```
   ```
   ERROR: execution not completed.
   ```
   
   **Expected behavior**
   A clear and concise description of what you expected to happen.
   
   **Environment (please complete the following information):**
   - Version: 1.5.0, PG 15
   
   


-- 
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-unsubscribe@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] cannot use $$ inside a string [age]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.

github-actions[bot] commented on issue #2127:
URL: https://github.com/apache/age/issues/2127#issuecomment-2623213792

   This issue was closed because it has been stalled for further 14 days with no activity.


-- 
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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] cannot use $$ inside a string [age]

Posted by "funny-falcon (via GitHub)" <gi...@apache.org>.

funny-falcon commented on issue #2127:
URL: https://github.com/apache/age/issues/2127#issuecomment-2452901578

   [RTFM](https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING), please:
   ```sql
   select * from cypher('graph1', $AnythingInsideDollars$
   Match(v:Persion{p_id:'safd$$bbb'}
   return v
   $AnythingInsideDollars$) as (v 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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] cannot use $$ inside a string [age]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.

github-actions[bot] commented on issue #2127:
URL: https://github.com/apache/age/issues/2127#issuecomment-2591353754

   This issue is stale because it has been open 60 days with no activity. Remove "Abondoned" label or comment or this will be closed in 14 days.


-- 
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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] cannot use $$ inside a string [age]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.

github-actions[bot] closed issue #2127: cannot use $$ inside a string
URL: https://github.com/apache/age/issues/2127


-- 
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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] cannot use $$ inside a string [age]

Posted by "wen-bing (via GitHub)" <gi...@apache.org>.

wen-bing commented on issue #2127:
URL: https://github.com/apache/age/issues/2127#issuecomment-2477898228

   this works!
   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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org