yql/essentials/tests/sql/suites/weak_field/weak_field_join.sql


1
2
3
4
5
6
7
8
9
10

/* postgres can not */
use plato;

SELECT
  i1.subkey as sk,
  WeakField(i1.value1, "String", "funny") as i1v1,
  WeakField(i1.value2, "String", "bunny") as i1v2,
  WeakField(i2.value1, "String", "short") as i2v1,
  WeakField(i2.value2, "String", "circuit") as i2v2
FROM Input1 as i1 join Input2 as i2 USING(subkey) ORDER BY sk