Don't push down constraints into LATERAL with LIMIT/FETCH/OFFSET

oracle / pgql-lang

PGQL is an SQL-based query language for property graphs

https://pgql-lang.org/

Other

182 stars 44 forks source link

Closed oskar-van-rest closed 1 year ago

oskar-van-rest commented 1 year ago

For example:

SELECT *
FROM LATERAL ( SELECT n.prop FROM MATCH (n) ORDER BY n.prop LIMIT 5 )
WHERE prop < 10

Was getting translated into:

SELECT *
FROM LATERAL ( SELECT n.prop FROM MATCH (n) WHERE prop < 10 ORDER BY n.prop LIMIT 5 )

Which is incorrect and may give wrong results.