aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/strict_keys.sql
blob: e9382fa7fa5471bf87913ec6fce3c0b703168bad (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
/* syntax version 1 */
/* postgres can not */
use plato;

define subquery $strict() as
  pragma StrictJoinKeyTypes;
  select count(*) from Input1 as a join Input2 as b using(k1)
end define;

select count(*) from Input1 as a join Input2 as b using(k1);
select * from $strict();