append_after_replace.sql 426 B

123456
  1. /* postgres can not */
  2. /* multirun can not */
  3. -- kikimr only: pragma kikimr.UnwrapReadTableValues = "false"; create table plato.Output (key varchar null, subkey varchar null, value varchar null, primary key (key)); commit;
  4. insert into plato.Output with truncate (key, subkey, value) select key, subkey, value from plato.Input;
  5. commit;
  6. insert into plato.Output (key, subkey, value) select key, subkey, value from plato.Output;