Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

LogicalIntersect Not implemented #5

Open
nmiletic opened this issue Dec 15, 2023 · 0 comments
Open

LogicalIntersect Not implemented #5

nmiletic opened this issue Dec 15, 2023 · 0 comments

Comments

@nmiletic
Copy link

Thank you for this great tool.

Reading readme of prover it states that INTERSECT is supported. But I am getting LogicalIntersect Not implemented from parser.

I am trying to parse following file:

-- Declare table schemas
create table db(
  platform varchar,
  version varchar,
  traffic_type varchar,
  dbno     integer,
  constraint pk_db primary key (dbno)
);

-- Define queries (There should only be two!)
SELECT version
FROM db
WHERE platform IN ('ZA-1000', 'SM-100')
AND traffic_type = 'Sport'
GROUP BY version
HAVING COUNT(DISTINCT platform) = 2;
SELECT version
FROM db
WHERE (platform = 'ZA-1000' AND traffic_type = 'Sport')
INTERSECT
SELECT version
FROM db
WHERE (platform = 'SM-100' AND traffic_type = 'Sport');

but I am getting following error

qed-parser test.sql
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
In file:
test.sql
java.lang.UnsupportedOperationException: Not implemented: LogicalIntersect

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

No branches or pull requests

1 participant