leehaut opened a new pull request, #8064: URL: https://github.com/apache/hop/pull/8064
Fix https://github.com/apache/hop/issues/8033 ## Summary Adds **Load SQL from file** to the Database Join transform, matching Table Input. A Database Join can now point at an external `.sql` file (VFS path, variables such as `${PROJECT_HOME}/sql/lookup_records.sql`). The query is read once at transform init. `?` placeholders still bind to the Parameters table, so the same lookup SQL can be reused across pipelines without copy-paste. Leaving the path empty keeps the previous inline SQL editor (backward compatible). ## Changed - **Runtime:** `sql_from_file` on `DatabaseJoinMeta`; `getEffectiveSql()` loads the file via VFS (UTF-8). `DatabaseJoin.init()` prepares that SQL, then applies Replace variables when enabled. - **UI:** path + Browse above the SQL editor. When a file is set, the editor is a read-only preview; clearing the path makes it editable again. - **Docs / i18n:** user manual (`databasejoin.adoc`) and `en_US` / `zh_CN` messages. - Add integration test `0009-database-join-sql-file.hpl` -- 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]
