In our program we discovered that a column should have been mandatory but was not selected to be in the SF. This has been fixed in a later version by simply making the column mandatory, and we wanted to try to use the Data conversion functionality to fill in the missing data.
The following expression has to be used for filling the column, and this has been selected in the SF as well;
isnull(t1.calculatie_soort,(select ws.standaard_calculatie_soort_id from waarde_standaard ws))
However, when generating the code for this upgrade, we found out that the SF generates a faulty statement when inserting the data from the renamed table;
t1."product_type" as "product_type",
t1."calculatie_soort"(isnull(t1.calculatie_soort,(select ws.standaard_calculatie_soort_id from waarde_standaard ws))) as "calculatie_soort",
t1."per_1_of_100" as "per_1_of_100",
As you see, unchanged columns are fine, but our change column "calculatie_soort” now causes an error, as bot the "normal” code (t1.”calculatie_soort”) and our expression are present.
Are we making an error when using the expression or is this a bug in the SF?
Best answer by Jeroen van den BeltView original