SqlWindowingPagingQueryProvider does not generate correct SQL for Oracle [BATCH-2166]

[spring-projects-issues]

Philippe BAYE opened BATCH-2166 and commented

The generated SQL requests look like this (for both first page & remaining pages) :
SELECT * from (....) AS TMP_SUB WHERE ...

But for Oracle, the correct SQL requests look like this :
SELECT * from (....) TMP_SUB WHERE ...

The problem is located in the getSubQueryAlias() method.

In previous version (2.0.4) the SQL requests are corrected.

---

Affects: 2.1.9

[spring-projects-issues]

Michael Minella commented

Does this occur on the 2.2.x branch as well?

[spring-projects-issues]

Philippe BAYE commented

I think so.

I did not test it, but only read the source code of the same class (for 2.2.3 version)
It appears that the SQL request builder uses the same syntax (through getSubQueryAlias method)

[cppwfs]

Thank you for opening the issue. Can you retry with the latest release of Spring Batch(5.0.2) and report back the results?
If the issue is reproducible, can you provide a sample project that uses the latest release of Spring Batch and that exhibits the behavior? To help you in reporting your issue, we have prepared a project template that you can use as a starting point. Please check the Issue Reporting Guidelines for more details about this.