discard.sql 458 B

123456789
  1. /* postgres can not */
  2. use plato;
  3. pragma DisableSimpleColumns;
  4. discard select 1;
  5. discard select * from Input;
  6. discard select * from Input where key<"foo";
  7. discard select * from Input as a join Input as b using(key);
  8. discard select sum(length(value)), key, subkey from Input group by rollup(key,subkey) order by key, subkey;
  9. discard select * from (select key || "a" || "b" as key from Input) as a join (select key || "ab" as key from Input) as b using(key);