coalesce_bools.sql 236 B

12345678910111213141516
  1. USE plato;
  2. select
  3. key,
  4. ob1 ?? b1,
  5. ob1 ?? false,
  6. ob1 ?? (1/0 > 0),
  7. (1/2 > 0) ?? ob1,
  8. (1/2 == 0) ?? b1,
  9. (key/0 >= 0) ?? true,
  10. (key/0 >= 0) ?? b1,
  11. (key/2 >= 0) ?? false,
  12. from Input
  13. order by key;