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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
|
# name: test/sql/storage_version/storage_version.test_slow
# description: Storage version test checks whether or not the storage version needs to be incremented.
# group: [storage_version]
# If this test fails, re-generate the database file by following the steps listed below:
# 1) Increment the version number in src/storage/storage_info.cpp and recompile (make release)
# 2) Run the script in scripts/generate_storage_version.py
# 3) Commit the newly generated database file in test/sql/storage_version/storage_version.db
# The database was written with a vector size of 2048.
require exact_vector_size 2048
load test/sql/storage_version/storage_version.db readonly
statement ok
BEGIN TRANSACTION;
query IIIII
SELECT * FROM integral_values ORDER BY 1
----
1 2 3 4 5
NULL NULL NULL NULL NULL
query II
SELECT * FROM numeric_values ORDER BY 1
----
1.0 3.0
NULL NULL
query IIII
SELECT * FROM decimal_values ORDER BY 1
----
1.0 3.22 10420942.4567 12908124908190481290481.11
NULL NULL NULL NULL
query II
SELECT * FROM string_values ORDER BY 1
----
hello world \xAA\xFF\xAA
NULL NULL
query III
SELECT * FROM date_values ORDER BY 1
----
1992-01-01 12:00:03 1992-09-20 10:00:03
NULL NULL NULL
query IIIII
SELECT * FROM v1 ORDER BY 1
----
1 2 3 4 5
NULL NULL NULL NULL NULL
query I
SELECT * FROM test3.v2 ORDER BY 1
----
9
NULL
query II
SELECT COUNT(*), SUM(i) FROM big_integers ORDER BY 1
----
100000 4999950000
query II
SELECT LENGTH(a), SUBSTR(a, 5000, 3) FROM big_string ORDER BY 1
----
100000 aaa
query I
SELECT * FROM uuid_values
----
a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11
NULL
47183823-2574-4bfd-b411-99ed177d3e43
10203040-5060-7080-0102-030405060708
# all types function
query I nosort alltypes
SELECT * FROM test_all_types();
query I nosort alltypes
SELECT * FROM all_types
# complex views
query IIIIIIIIIIIIIIIII
SELECT * FROM cv1 ORDER BY 1
----
0 1 NULL 0 0 0 1 0 42 0 0 NULL 0 hello world [1, 2, 3] {'x': [42, 88]} 0
1 3 2 1 1 0 1 1 42 1 1 1 1 hello world [1, 2, 3] {'x': [42, 88]} 1
2 5 3 1 2 1 1 2 42 2 2 1 0 hello world [1, 2, 3] {'x': [42, 88]} 2
3 7 4 0 3 1 0 3 42 3 3 NULL 0 hello world [1, 2, 3] {'x': [42, 88]} 3
query IIIIII
SELECT * FROM cv2
----
0 2 1 2 2,0 1
query IIIII
SELECT * FROM cv3
----
0 1 0 2 0
2 3 2 2 3
3 4 4 3 5
query I
SELECT * FROM cv4
----
1
2
3
query I
SELECT * FROM cv5
----
1
2
3
query I
SELECT * FROM cv6
----
0
2
4
query II
SELECT * FROM cv7
----
0 2
1 4
query I
SELECT * FROM cv8
----
1
2
3
NULL
query I
SELECT * FROM cv9
----
3
4
query I
SELECT * FROM cv10
----
0
1
2
3
query IIII
SELECT * FROM cv11
----
0 0 0 0
0 0 2 2
0 1 1 1
0 1 3 3
1 0 NULL 2
1 1 NULL 4
3 NULL NULL 6
query II
SELECT * FROM cv12
----
0 0
1 1
2 2
3 4
query I
SELECT * FROM cv13
----
2
1
# Version 29: IGNORE NULLS
query II
SELECT i, V29(i) FROM integral_values ORDER BY 1 NULLS LAST
----
1 1
NULL 1
statement error
SELECT nextval('test3.bla')
----
read-only mode
|
