unexpected character at or near "$" when using query arguments about age HOT 6 CLOSED

The format $1 is the Postgres format for parameters and cannot be used in the cypher query. Parameters in the cypher query must take the format $parameter_name. When you want to pass parameters to a cypher query, you must add a third argument to the cypher query. This argument must be a Postgres parameter. So your query must look like:

SELECT * FROM cypher('testgraph', $$CREATE (v:Person {name: $var_name})$$, $1) as (a agtype);

When executing the query the value passed to $1 must be an agtype map, where the key is the variable name. NOTE: All parameters in the cypher query are passed in the map.

Also, both AGE parameters and Postgres parameters can only be used in prepared statements. So the above query will not currently work as it is related to the github issues: #39 & #28. We are currently working on a fix for these issues.

from age.

Some general questions/troubleshooting thoughts:

• Is that error coming from your SET command or the SELECT * from cypher query?
• Does the code work if you hardcode a name instead of $1?
• If not, maybe a library parsing issue? Try spaces after/before the $$ : `$$ CREATE (v:Person {name: $1}) $$ )``

from age.

• The error originates from the SELECT * from cypher query.
• In both cases, the hardcoded query SELECT * FROM cypher('testgraph', $$CREATE (v:Person {name: 'Tom'})$$) as (a agtype); does work.
• Spaces after/before the $$ don't change the outcome.

Both asyncpg and node-postgres appear to rely on libpq.

from age.

I am able to reproduce the error, and have a little more detail below regarding where the error occurs in AGE (ag_scanner.l).

error: unexpected character at or near "$"
    at Parser.parseErrorMessage (/home/nicho/bitnine/testjs/node_modules/pg-protocol/dist/parser.js:278:15)
    at Parser.handlePacket (/home/nicho/bitnine/testjs/node_modules/pg-protocol/dist/parser.js:126:29)
    at Parser.parse (/home/nicho/bitnine/testjs/node_modules/pg-protocol/dist/parser.js:39:38)
    at Socket.<anonymous> (/home/nicho/bitnine/testjs/node_modules/pg-protocol/dist/index.js:10:42)
    at Socket.emit (node:events:378:20)
    at addChunk (node:internal/streams/readable:313:12)
    at readableAddChunk (node:internal/streams/readable:288:9)
    at Socket.Readable.push (node:internal/streams/readable:227:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
  length: 109,
  severity: 'ERROR',
  code: '42601',
  detail: undefined,
  hint: undefined,
  position: '75',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'ag_scanner.l',
  line: '711',
  routine: 'ag_scanner_next_token'

from age.

@pdpotter The python and NodeJs drivers are now compatible with the CREATE, SET, REMOVE and DELETE clauses. Btw, I never had the opportunity to play around with this particular python driver. Seems like a very interesting library.

from age.

It is now indeed possible to use prepared statements to create nodes. Thank you!

from age.