1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
# name: test/sql/function/autocomplete/alter_table.test
# description: Test sql_auto_complete
# group: [autocomplete]
require autocomplete
statement ok
CREATE TABLE my_table(first_column bigint);
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('ALTER TABLE my_table DROP COLUMN fi') LIMIT 1;
----
first_column 33
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('ALTER TABLE my_table ALTER COLUMN fi') LIMIT 1;
----
first_column 34
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('ALTER TABLE my_table RENAME COLUMN fi') LIMIT 1;
----
first_column 35
|
