Replace function "" is needed while using hybrid queries

[dianaoa22]

Describe the bug For a hybrid query

SELECT p.name,p.x,p.state FROM public.Rtable AS p WHERE REPLACE(p.name, '"', '') IN ( SELECT REPLACE(test_name, '"', '') FROM cypher('test_graph', $$ MATCH (v:test) RETURN v.test_name $$) AS (test_name varchar(4096)) );

demomodel=# SELECT * FROM cypher('bs_graph', $$ MATCH (v:test) RETURN v.test_name $$) as (test_name agtype); test_name

"test_1" "test_2"

Here the data is returned in double_quotes hence the outer call if has to work these "" needs to be trimmed because in relational data the data is stored without double quotes.

How are you accessing AGE (Command line, driver, etc.)?

• JDBC

What data setup do we need to do?

...

...

What is the necessary configuration info needed?

• [e.g. Installed PostGIS]

What is the command that caused the error?

ERROR:  something failed to execute

Expected behavior A clear and concise description of what you expected to happen.

Environment (please complete the following information):

• Version: [e.g. 0.4.0]

Additional context Add any other context about the problem here.

[github-actions[bot]]

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.

[github-actions[bot]]

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