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
|
# name: test/sql/function/autocomplete/create_function.test
# description: Test sql_auto_complete
# group: [autocomplete]
require autocomplete
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('CREATE MA') LIMIT 1;
----
MACRO 7
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('CREATE F') LIMIT 1;
----
FUNCTION 7
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('CREATE MACRO name(a) A') LIMIT 1;
----
AS 21
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('CREATE MACRO name(a) AS a+1, (b) A') LIMIT 1;
----
AS 33
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('CREATE MACRO name (a) AS TA') LIMIT 1;
----
TABLE 25
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('CREATE MACRO name (a) AS TABLE SEL') LIMIT 1;
----
SELECT 31
|
