[Bug]: Stream Lookup throws ConversionNotImplemented for a Timestamp default value

[fskorgen]

Apache Hop version?

2.19

Java version?

21

Operating system

Windows

What happened?

Affected: 2.19.0 and earlier.

StreamLookup.handleNullIf() converts each configured default from text according to
ReturnValue.valueDefaultType. The switch handles IValueMeta.TYPE_DATE, but not the first-class
IValueMeta.TYPE_TIMESTAMP type. A non-empty default for a Timestamp return field therefore reaches
the default branch and throws StreamLookup.Exception.ConversionNotImplemented during transform
initialization.

Steps to reproduce

1. Configure a Stream Lookup with a return field of type Timestamp.
2. Enable the default used when the lookup misses, and enter a non-empty timestamp value.
3. Start the pipeline.

Expected: the default is parsed and used for rows that miss the lookup, as it is for a Date
return field.
Actual: the pipeline fails before the first row is processed, with
StreamLookup.Exception.ConversionNotImplemented. The same configuration with return type Date
enters the parsing branch and works.

Suggested fix

Handle TYPE_TIMESTAMP alongside TYPE_DATE. The existing branch already parses to a
java.util.Date, which Hop's Timestamp value metadata accepts.

Issue Priority

Priority: 2

Issue Component

Component: Transforms