aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/strict_keys.sql
blob: b9ca0641f82960b9c69723c0eb41d18b8d07220f (plain) (blame)
1
2
3
4
5
6
7
8
9
10
/* custom error:Strict key type match requested, but keys have different types*/
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();