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

Query star expression on property graph should only return specified columns #192

Open
2 tasks done
dentiny opened this issue Dec 25, 2024 · 0 comments
Open
2 tasks done

Comments

@dentiny
Copy link
Contributor

dentiny commented Dec 25, 2024

What happens?

As of now, querying star expression (namely, *) from graph returns not only columns contained in the graph, but also the ones from vertex / edge tables.

For more details, see reproduction code below and comments in thread #26 (comment)

To Reproduce

D CREATE TABLE Person(
	id BIGINT PRIMARY KEY, 
    name VARCHAR
);

D INSERT INTO Person VALUES (0, 'Foo'), (1, 'Bar');

D -CREATE PROPERTY GRAPH g VERTEX TABLES (Person PROPERTIES (id));

D -SELECT * FROM GRAPH_TABLE (g MATCH (p:Person));

┌───────┬─────────┐
│  id   │  name   │
│ int64 │ varchar │
├───────┼─────────┤
│     0 │ Foo     │
│     1 │ Bar     │
└───────┴─────────┘

The expected result should only contain id column, but not name column.

OS:

ubuntu 22.04, x86_64

DuckDB Version:

c380346433

DuckDB Client:

C++

Full Name:

Hao

Affiliation:

N/A

How did you load the extension?

Built from source

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

  • Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

  • Yes, I have
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant