Oracle serializer runs into infinite loop for LIMIT

IITDBGroup / gprom

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

http://www.cs.iit.edu/%7edbgroup/research/gprom.php

Apache License 2.0

8 stars 5 forks source link

Oracle serializer runs into infinite loop for LIMIT #76

Closed lordpretzel closed 11 months ago

lordpretzel commented 3 years ago

This is because the matching of operators to query blocks does not check for limit operator

lordpretzel commented 3 years ago

Oracle serialization of limit requires adding an outer query block SELECT * FROM Q WHERE ROWNUM <= limit. Currently, this only works when LIMIT is the last operator in the query.