join_nosimple.sql 375 B

123456789101112
  1. /* postgres can not */
  2. /* syntax version 1 */
  3. use plato;
  4. pragma OrderedColumns;
  5. pragma DisableSimpleColumns;
  6. $foo = select 1 as sk, "150" as key, 2 as v;
  7. select * from $foo as b join Input as a using(key);
  8. select a.* from $foo as b join Input as a using(key);
  9. select b.* from $foo as b join Input as a using(key);
  10. select a.*, b.* from $foo as b join Input as a using(key);