align_publish.sql 218 B

12345678910
  1. PRAGMA OrderedColumns;
  2. USE plato;
  3. INSERT INTO @table1 WITH TRUNCATE (a, c, b) VALUES ('1', '2', '3');
  4. COMMIT;
  5. INSERT INTO Output WITH TRUNCATE
  6. SELECT x.c AS d, x.b AS b, json('{}') AS a
  7. FROM @table1 AS x
  8. ORDER BY d