1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
-- test-run result file version 2
--
-- Make sure that when inserting, values are inserted in the given
-- order when ephemeral space is used.
--
CREATE TABLE t (i INT PRIMARY KEY AUTOINCREMENT);
| ---
| - row_count: 1
| ...
--
-- In order for this INSERT to use the ephemeral space, we created
-- this trigger.
--
CREATE TRIGGER r AFTER INSERT ON t FOR EACH ROW BEGIN SELECT 1; END
| ---
| - row_count: 1
| ...
INSERT INTO t VALUES (1), (NULL), (10), (NULL), (NULL), (3), (NULL);
| ---
| - autoincrement_ids:
| - 2
| - 11
| - 12
| - 13
| row_count: 7
| ...
SELECT * FROM t;
| ---
| - metadata:
| - name: I
| type: integer
| rows:
| - [1]
| - [2]
| - [3]
| - [10]
| - [11]
| - [12]
| - [13]
| ...
DROP TABLE t;
| ---
| - row_count: 1
| ...
|
