dave-csc opened a new issue, #4772: URL: https://github.com/apache/hop/issues/4772
### Apache Hop version? 2.11.0 ### Java version? 17.0.2 ### Operating system Linux ### What happened? In the **Update** transform the **Skip lookup** option is not correctly working: when enabled, if there are no entries in the lookup fields table, the transform fails because it tries to execute an SQL statement with an incomplete WHERE clause (e.g. `UPDATE "db_name"."table_name" SET "field_name" = :1 WHERE`). Need to check if, with the option enabled and the lookup field table populated, transform completes with the specified filter ignoring the Skip lookup option. ### Issue Priority Priority: 2 ### Issue Component Component: Transforms -- 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]
