Subqueries not executing in FROM,WHERE,IN,EXISTS, aliases not being handled, LIKE not handling in WHERE, ORDER BY not supporting

IITDBGroup / gprom

GProM is a middleware that adds support for provenance to database backends.

Apache License 2.0

8 stars 5 forks source link

Open risha2019 opened 3 years ago

risha2019 commented 3 years ago

LIKE is not executing resulting WHERE clause result type should be DT_BOOL, but was DT_STRING
WHERE clauses containing IN, EXISTS have subqueries and are resulting in Segmentation fault(Core dumped)
ORDER BY clauses in queries throwing errors

lordpretzel commented 3 years ago

the problem with LIKE is resolved in the latest master commit
ORDER BY works for me with the postgres backend. Do you have a test case schema and query that fails?
regarding nested subqueries, only the oracle serializer does support it currently in master. I think in some branch that has been fixed for postgres, have to check this out further