Rewrite only if data exists in the row

[shyim]

Currently, the rewrite feature replaces all rows with the value. I guess that hurts the reproducibility of bugs as the data is not the same.

My idea would be to change the SELECT to IF(colum IS NULL, NULL, REPLACEMNET) as X. With a new option.

What do you think about that? I could provide a PR

[bolovsky]

That actually should pretty good as a feature to ensure issues are correctly reproducible.

you can also use COALESCE (same same, just syntactic sugar) as COALESCE(column, REPLACEMENT) ;)

[shyim]

Do we want it on table/column level or just global as option 🤔

[bolovsky]

I would say global as option would probably be more consistent. Also, having it per table could rapidly become a configuration issue :)