case_opt_cond.sql 204 B

12345
  1. select case when cast('true' as Bool) then 'FOO1' else 'BAR1' end
  2. union all
  3. select case when cast('false' as Bool) then 'FOO2' else 'BAR2' end
  4. union all
  5. select case when NULL then 'FOO3' else 'BAR3' end;