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