The following query corrects the problem in Example: CASE Expression Fails by shortening the scale of the multiplier in the THEN expression:
SELECT SUM (CASE WHEN column_2=1 THEN column_3 * 6.1122334455667788 ELSE column_3 END ) FROM dec22;
The following query corrects the problem in Example: CASE Expression Fails by shortening the scale of the multiplier in the THEN expression:
SELECT SUM (CASE WHEN column_2=1 THEN column_3 * 6.1122334455667788 ELSE column_3 END ) FROM dec22;