aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/weak_field/weak_field_strict.sql
blob: e156940290381c9e57d48b53b8c8d940f864eb6e (plain) (blame)
1
2
3
4
5
6
7
8
9
10
/* postgres can not */
use plato;
SELECT
  WeakField(first_num, "uint32") as num_nodef,
  WeakField(first_num, "uint32", 11) as num_def,
  WeakField(first_null, "uint32") as null_nodef,
  WeakField(first_null, "uint32", 42) as null_def,
  WeakField(val, "string") as missed_nodef,
  WeakField(val, "string", "no value") as missed_def
FROM Input