LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-179] LURQL projection should leave out anything inside of exists #693

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="jvs", created="Fri, 4 Aug 2006 16:17:20 -0500 (GMT-05:00)"] select * from StoredColumn as c where exists(
follow destination class TagAnnotation where name='DIM_COLUMN' and value='OPTY_STAGE_NAME'
)

returns too much; select c gives the correct results.

dynamobi-build commented 12 years ago

[author="jvs", created="Mon, 28 May 2007 10:22:05 -0500 (GMT-05:00)"] Fixed in eigenchange 9349.

Also added a check for this case (exists list should only reference variables from inside the in clause, not from outside):

Should fail: reference to alias from outside in exists.

EXPLAIN
select c
from class "Class" as c
where exists c in (
follow association Generalizes forward then (
follow composite forward
destination class Attribute as a
where name='annotation'
)
);