[Bug]: nested case...when... constructs,Causing desensitization to fail

[Jane201510]

ODC version

4.2.x

OB version

all

What happened?

nested case...when... constructs,Causing desensitization to fail

What did you expect to happen?

Normal desensitization

How can we reproduce it (as minimally and precisely as possible)?

Query sensitive columns in the following manner： SELECT column_name, CASE WHEN condition1 THEN result1 WHEN condition2 THEN CASE WHEN condition2_1 THEN result2_1 WHEN condition2_2 THEN result2_2 END WHEN condition3 THEN result3 ELSE default_result END AS alias_name FROM table_name;

Anything else we need to know?

No response

Cloud

No response

[sl01388797]

pass

[tonghan-gsh]

case when contains is null desensitization failure