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

Multiple INNER JOIN clauses: runs into out of time #84

Open
matthiastz opened this issue Jan 2, 2020 · 0 comments
Open

Multiple INNER JOIN clauses: runs into out of time #84

matthiastz opened this issue Jan 2, 2020 · 0 comments

Comments

@matthiastz
Copy link

setup:

schema TrackSchema(TrackId: int, Name: varchar, AlbumId: int,
                MediaTypeId: int, GenreId: int, Composer: varchar,
                Milliseconds: int, Bytes: int, UnitPrice: numeric);
table Track(TrackSchema);
schema PlaylistTrackSchema(PlaylistId: int, TrackId: int);
table PlaylistTrack(PlaylistTrackSchema);
schema GenreSchema(GenreId: int, Name: varchar);
table Genre(GenreSchema);

query q1
`SELECT PT.PlaylistId, TR.TrackId, TR.Name, G.Name FROM
PlaylistTrack AS PT INNER JOIN Track AS TR ON TR.TrackId = PT.TrackId
  INNER JOIN
  Genre AS G ON G.GenreId = TR.GenreId`;

query q2
`SELECT PT.PlaylistId, TR.TrackId, TR.Name, G.Name FROM
PlaylistTrack AS PT JOIN Track AS TR ON PT.TrackId = TR.TrackId
  INNER JOIN
  Genre AS G ON TR.GenreId = G.GenreId`;

verify q1 q2;

result:
Two queries' equivalence is unknown. Solver runs out of time.

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

No branches or pull requests

1 participant