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

Restriction of {0,0} returns the same as {1,1} #9

Open
Dtenwolde opened this issue May 23, 2023 · 2 comments
Open

Restriction of {0,0} returns the same as {1,1} #9

Dtenwolde opened this issue May 23, 2023 · 2 comments

Comments

@Dtenwolde
Copy link
Contributor

Dtenwolde commented May 23, 2023

What happens?

see title

To Reproduce

create table student(id INT); INSERT INTO student(id) VALUES (10), (20), (30), (40);
create table know(src INT, dst INT); INSERT INTO know(src, dst) VALUES (40, 20), (10,30), (10,10), (20,10), (30,10);

-create property graph g vertex tables (student) edge tables (know source key (src) references student (id) destination key (dst) references student (id)); 

-FROM GRAPH_TABLE (g
    MATCH
    ANY SHORTEST (a:student)-[k:know]->{0,0}(b:student)
    WHERE a.id = 10
    COLUMNS (a.id as a_id, b.id as b_id)
    );

Actual result:

┌───────┬───────┐
│ a_id  │ b_id  │
│ int32 │ int32 │
├───────┼───────┤
│    10 │    10 │
│    10 │    30 │
└───────┴───────┘

Expected result:

┌───────┬───────┐
│ a_id  │ b_id  │
│ int32 │ int32 │
├───────┼───────┤
│    10 │    10 │
└───────┴───────┘

### OS:

macOs 13 - Apple M1 Pro

### DuckDB Version:

dev

### DuckDB Client:

CLI

### Full Name:

Daniel ten Wolde

### Affiliation:

CWI

### Have you tried this on the latest `master` branch?

- [X] I agree

### Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

- [X] I agree
@Dtenwolde Dtenwolde transferred this issue from cwida/duckdb-pgq Jun 26, 2023
Dtenwolde pushed a commit that referenced this issue Dec 5, 2023
duckdb version bump, small fixes
@github-actions github-actions bot added the stale label Sep 5, 2024
@github-actions github-actions bot added the stale label Dec 5, 2024
@Dtenwolde Dtenwolde removed the stale label Dec 5, 2024
@cwida cwida deleted a comment from github-actions bot Dec 5, 2024
@cwida cwida deleted a comment from github-actions bot Dec 5, 2024
@Dtenwolde
Copy link
Contributor Author

I've started looking into this issue, but I don't know what the PGQ document uses for path semantics. If it is strict, then no edge traversals occur and the expected result would be the empty set. If it is relaxed semantics, then the result could be only the source node. I will ask next week at the TUC meeting.

@Dtenwolde
Copy link
Contributor Author

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