strict_keys.sql 312 B

12345678910
  1. /* custom error:Strict key type match requested, but keys have different types*/
  2. use plato;
  3. define subquery $strict() as
  4. pragma StrictJoinKeyTypes;
  5. select count(*) from Input1 as a join Input2 as b using(k1)
  6. end define;
  7. select count(*) from Input1 as a join Input2 as b using(k1);
  8. select * from $strict();