[Bug]: action PIPELINE parameter doubles variable replacing

[fila73]

Apache Hop version?

seen on 2.12 and 2.14

Java version?

openjdk-jre-17

Operating system

Windows

What happened?

experiencing on windows and docker variable substitution when passing parameters from workflow to pipeline seems to execute twice,

scenario:

1. there is a variable TableName set to 'ACCOUNT'
2. in a workflow use action PIPELINE to call pipeline
3. parameter TableName and value set to PREFIX_${TableName}_SUFFIX
4. in target pipeline use Get variables to add parameters to stream fields
5. log stream field

expected output: field's value is set to PREFIX_ACCOUNT_SUFFIX real output: field's value is set to PREFIX_PREFIX_ACCOUNT_SUFFIX_SUFFIX

note: we are porting our project from pentaho kettle, where we got the expected output.

Issue Priority

Priority: 3

Issue Component

Component: Actions

[dave-csc]

Queuing here... I experienced a similar issue with the Simple mapping transform, when trying to redefine a variable for the mapped (sub-)pipeline using a variable with the same name in the parent project.

But in that case, the outcome was the pipeline failure due to an "infinite loop detected" in variable substitution...

[mattcasters]

Can you please add a reproduction path or sample? The thing is, parameters and variables replacement were not always correct in Kettle while in Hop we have added integration tests to make sure these things happen one way and stay like that.

[hansva]

.take-issue

I was able to reproduce this. Though I find it a confusing use case to overwrite the value of that parameter it should work.