laravel-oci8
laravel-oci8 copied to clipboard
Fixing problem with limit and offset in oracle 11g
This PR fix the problem with limit and offset in oracle 11g using between in comparer rn. Changing the calculus in compileRowConstraint, the change try create pagination in query, eg:
limit = 30offset (page) = 1
The calculus create the sequence:
t2.rn between 1 and 30
And, if used offset (page) = 2 will have
t2.rn between 31 and 60
The math formula is:
start = offset * limit;
finish = start + limit;
Can you please provide some snippets to reproduce the issue that this PR fixes? Or some tests would be better if possible. Thanks!