nadment opened a new issue, #7726: URL: https://github.com/apache/hop/issues/7726
### Apache Hop version? 2.19.0-SNAPSHOT ### Java version? 21 ### Operating system Windows ### What happened? # Symptom The `CachingDatabaseExecutionInfoLocation` class generates an incorrect SQL query when retrieving executions from Oracle. In the `retrieveIds()` method, the limit handling adds a second `WHERE` clause. SQL generated ``` SELECT id, execution_start_date FROM TEST.HOP_EXECUTIONS WHERE (parent_id IS NULL OR parent_id = '') ORDER BY execution_start_date DESC WHERE ROWNUM <= 50 ``` # Solution It’s time to review the code generation in the Oracle connector: Replace the generated SQL : `WHERE ROWNUM <= 50` with a more modern version that has been available since Oracle 12c Release 1 (released in 2013) `FETCH FIRST 10 ROWS ONLY` ### Issue Priority Priority: 3 ### Issue Component Component: Database -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
