nested subqueries reference correlated attribute by alias - segfault

[lordpretzel]

This works R(A,B), S(C,D):

SELECT * FROM R WHERE EXISTS (SELECT * FROM S WHERE B = d);
SELECT * FROM R WHERE EXISTS (SELECT * FROM S WHERE B = S.d);
SELECT * FROM R WHERE EXISTS (SELECT * FROM S x WHERE B = x.d);

However, reference correlated attribute alias results in segfault

SELECT * FROM R y  WHERE EXISTS (SELECT * FROM S x WHERE y.B = x.d);

[nebula0717]

I will fix this one.

On Jul 10, 2018, at 1:59 PM, Boris Glavic notifications@github.com wrote:

Assigned #51 https://github.com/IITDBGroup/gprom/issues/51 to @nebula0717 https://github.com/nebula0717.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com/IITDBGroup/gprom/issues/51#event-1726304708, or mute the thread https://github.com/notifications/unsubscribe-auth/AIMlrLvjDZH9YlYH-YV-TUg186_dSFFgks5uFPmZgaJpZM4VJ8mC.

[nebula0717]

thanks, I'll just keep on creating issues so we have the problems documented.

On 7/10/18 15:05, Xing Niu wrote:

I will fix this one.

On Jul 10, 2018, at 1:59 PM, Boris Glavic <notifications@github.com mailto:notifications@github.com> wrote:

Assigned #51 https://github.com/IITDBGroup/gprom/issues/51 to @nebula0717 https://github.com/nebula0717.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com/IITDBGroup/gprom/issues/51#event-1726304708, or mute the thread https://github.com/notifications/unsubscribe-auth/AIMlrLvjDZH9YlYH-YV-TUg186_dSFFgks5uFPmZgaJpZM4VJ8mC.

--

Boris Glavic Associate Professor Computer Science Illinois Institute of Technology

Stuart Building, Room 206 B 10 W 31st Street Chicago, IL 60616

Email: bglavic@iit.edu Phone: +1 312 567 5205 Web: http://www.cs.iit.edu/~glavic DBGroup: http://www.cs.iit.edu/~dbgroup