Exposed: Paging on Oracle 12 still generates invalid query

[Petitt88]

I've just tested the paging on Oracle in the current (0.9.2) snapshot release but it is still not good.

If the limit function has both the offset and n values set the query is still invalid.

Currenty it looks like this:

SELECT ...
FROM table
OFFSET 20 FETCH FIRST 20 ROWS ONLY

However, it should be like this:

SELECT ...
FROM table
OFFSET 20 ROWS FETCH FIRST 20 ROWS ONLY;

So the ROWS keyword is missing before FETCH.

[Tapac]

Thank you for the report, I think that {ROW | ROWS} part of OFFSET.. FETCH syntax is optional

Caused by: #210

[lukaseder]

For the record:

https://docs.oracle.com/database/121/SQLRF/statements_10002.htm#SQLRF01702

Back to lurking :-)