Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Replace function "" is needed while using hybrid queries #1932

Open
dianaoa22 opened this issue Jun 22, 2024 · 1 comment
Open

Replace function "" is needed while using hybrid queries #1932

dianaoa22 opened this issue Jun 22, 2024 · 1 comment
Labels
bug Something isn't working Stale Stale issues/PRs

Comments

@dianaoa22
Copy link

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.

@dianaoa22 dianaoa22 added the bug Something isn't working label Jun 22, 2024
Copy link

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 github-actions bot added the Stale Stale issues/PRs label Aug 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Stale Stale issues/PRs
Projects
None yet
Development

No branches or pull requests

1 participant