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.

Sign up for GitHub

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

Jump to bottom

Temporal Nested Subqueries - serialization #98

Open

lordpretzel opened this issue Nov 26, 2022 · 0 comments

Collaborator

lordpretzel commented Nov 26, 2022

This one fails to serialize because the possible locations for serializing the nested subquery are not determined correctly.

sequenced temporal (select * from op with time (p_start, p_end) o where exists (select * from ma with time (p_start, p_end) m
where m.mach = o.mach));

CREATE TABLE op (
    staff TEXT,
    mach TEXT,
    p_start INT,
    p_end INT
);

CREATE TABLE ma (
    mach TEXT,
    comp TEXT,
    p_start INT,
    p_end INT
);

INSERT INTO op VALUES
   ('Ann', 'M1', 1, 9),
   ('Joe', 'M1', 9, 15),
   ('Tom', 'M2', 3, 6),
   ('Tom', 'M3', 6, 12),
   ('Ann', 'M1', 15, 17);

INSERT INTO ma VALUES
   ('M1','C1',7,10),
   ('M1','C2',8,11),
   ('M2','C3',3,8);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment