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
|
# name: test/sql/storage/test_empty_table.test
# description: Test empty table storage.
# group: [storage]
load __TEST_DIR__/test_empty_table.db
statement ok
CREATE TABLE test (a INTEGER, b VARCHAR)
query I
SELECT COUNT(*) FROM test
----
0
# Verify that the table exists after restarting the database.
restart
query I
SELECT COUNT(*) FROM test
----
0
statement ok
INSERT INTO test VALUES (1, 2)
query I
SELECT COUNT(*) FROM test
----
1
restart
query I
SELECT COUNT(*) FROM test
----
1
|
