table-persistence-before-multitable.td.disabled 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. # Copyright Materialize, Inc. and contributors. All rights reserved.
  2. #
  3. # Use of this software is governed by the Business Source License
  4. # included in the LICENSE file at the root of this repository.
  5. #
  6. # As of the Change Date specified in that file, in accordance with
  7. # the Business Source License, use of this software will be governed
  8. # by the Apache License, Version 2.0.
  9. #
  10. # Multi-table insert transactions
  11. > CREATE TABLE multi_table1 (f1 INTEGER);
  12. > CREATE TABLE multi_table2 (f1 INTEGER);
  13. > BEGIN
  14. > INSERT INTO multi_table1 VALUES (1);
  15. > INSERT INTO multi_table2 VALUES (11);
  16. > INSERT INTO multi_table1 VALUES (2);
  17. > INSERT INTO multi_table2 VALUES (12);
  18. > INSERT INTO multi_table1 VALUES (3);
  19. > INSERT INTO multi_table2 VALUES (13);
  20. > INSERT INTO multi_table1 VALUES (4);
  21. > INSERT INTO multi_table2 VALUES (14);
  22. > INSERT INTO multi_table1 VALUES (5);
  23. > INSERT INTO multi_table2 VALUES (15);
  24. > INSERT INTO multi_table1 VALUES (6);
  25. > INSERT INTO multi_table2 VALUES (16);
  26. > INSERT INTO multi_table1 VALUES (7);
  27. > INSERT INTO multi_table2 VALUES (17);
  28. > INSERT INTO multi_table1 VALUES (8);
  29. > INSERT INTO multi_table2 VALUES (18);
  30. > INSERT INTO multi_table1 VALUES (9);
  31. > INSERT INTO multi_table2 VALUES (19);
  32. > INSERT INTO multi_table1 VALUES (10);
  33. > INSERT INTO multi_table2 VALUES (20);
  34. > COMMIT;