use of case - when statement (sequential evaluation) for dealing with no-data in log() expressions

[olcl@…]

As discussed in the meeting in Vienna, the need fro sequential evaluation has become a priority for users with no-data values they wish to exclude from the built-in log() function.

The currently proposed way (below) fails due to the log expression being evaluated before the masking of the scalar expression

for c in (myocean_test)
return
encode (

(c[t(4)] = -999)* (-999)

+ (c[t(4)] != -999)*log(c[t(4)]),
"png" )

The future proposed method includes the use of the proposed case-when statement, which has been proposed for the WCPS 2.0 standard

for c in (myocean_test)
return
encode (

case
when (c[t(4)] != -999 then log(c[t(4)])

else -999

end,

"png" )

[abeccati]

It seems we have case available in rasql since changeset 170df10605a20dce69d71e8fc0c61d8457b47aa0.

Can we include this at WCPS level in the tech preview for 9.0 alpha?
Tentatively scheduling accordingly meanwhile.

[Dimitar Misev]

When you say include at WCPS level, do you mean in the current implementation or in the upcoming WCPS 2.0 standard?

[abeccati]

For a tech preview that would be a preliminary implementation on a draft or proposed standard, if available.