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
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
|
# name: test/sql/function/autocomplete/select.test
# description: Test sql_auto_complete
# group: [autocomplete]
require autocomplete
# main keywords
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SEL') LIMIT 1;
----
SELECT 0
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('WI') LIMIT 1;
----
WITH 0
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FR') LIMIT 1;
----
FROM 9
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl WH') LIMIT 1;
----
WHERE 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl AN') LIMIT 1;
----
ANTI 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl OR') LIMIT 1;
----
ORDER 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl ORDER B') LIMIT 1;
----
BY 24
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl ORDER BY AL') LIMIT 1;
----
ALL 27
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl GR') LIMIT 1;
----
GROUP 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl GROUP B') LIMIT 1;
----
BY 24
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl GROUP BY AL') LIMIT 1;
----
ALL 27
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl GROUP BY ALL HAV') LIMIT 1;
----
HAVING 31
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl LIM') LIMIT 1;
----
LIMIT 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl LIMIT 5 OF') LIMIT 1;
----
OFFSET 26
# joins
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl INN') LIMIT 1;
----
INNER 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl INNER JO') LIMIT 1;
----
JOIN 24
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl JOIN tbl2 USING (i) WH') LIMIT 1;
----
WHERE 38
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl LEF') LIMIT 1;
----
LEFT 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl LEFT OUT') LIMIT 1;
----
OUTER 23
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl NAT') LIMIT 1;
----
NATURAL 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl NATURAL FU') LIMIT 1;
----
FULL 26
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl NATURAL FULL OUT') LIMIT 1;
----
OUTER 31
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl POS') LIMIT 1;
----
POSITIONAL 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl NATURAL JOIN tbl2 WH') LIMIT 1;
----
WHERE 36
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl NATURAL JOIN tbl2 NAT') LIMIT 1;
----
NATURAL 36
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl JOIN tbl2 US') LIMIT 1;
----
USING 28
# cross product
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl, tbl2 WH') LIMIT 1;
----
WHERE 24
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl, tbl2 LEFT OUT') LIMIT 1;
----
OUTER 29
# from first
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('FR') LIMIT 1;
----
FROM 0
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('FROM tbl SEL') LIMIT 1;
----
SELECT 9
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('FROM tbl OR') LIMIT 1;
----
ORDER 9
# set ops
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl UN') LIMIT 1;
----
UNION 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl UNION AL') LIMIT 1;
----
ALL 24
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl EX') LIMIT 1;
----
EXCEPT 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl INT') LIMIT 1;
----
INTERSECT 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl UNION ALL SEL') LIMIT 1;
----
SELECT 28
# qualify
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl QUAL') LIMIT 1;
----
QUALIFY 18
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT * FROM tbl QUALIFY row_number() OVER () ORD') LIMIT 1;
----
ORDER 47
# operators with quotes
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT col=''world'' FR') LIMIT 1;
----
FROM 19
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT col="quoted col2" FR') LIMIT 1;
----
FROM 25
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT "quoted col1"="quoted col2" + "quoted col3" FR') LIMIT 1;
----
FROM 51
# quoted identifiers
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT ''ORDER'' "WHERE" FR') LIMIT 1;
----
FROM 23
# escaped quoted identifiers
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT ''OR''''DER'' "WHE""RE" FR') LIMIT 1;
----
FROM 27
statement ok
CREATE TABLE my_table(my_column INTEGER);
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT my_') LIMIT 1;
----
my_column 7
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('UP') LIMIT 1;
----
UPDATE 0
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('UPDATE my_table SET m') LIMIT 1;
----
my_column 20
statement ok
CREATE TABLE MyTable(MyColumn Varchar);
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SELECT My') LIMIT 1;
----
MyColumn 7
|
