[Bug]: Update transform - Skip lookup option not working

[dave-csc]

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

[hansva]

Skipping the lookup assumes you know the record is available

edit: nm I thought you said when lookup is disabled