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
|
# name: test/sql/function/autocomplete/show.test
# description: Test sql_auto_complete
# group: [autocomplete]
require autocomplete
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('DESCR') LIMIT 1;
----
DESCRIBE 0
statement ok
CREATE TABLE my_table(my_column INTEGER);
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SHOW my_') LIMIT 1;
----
my_table 5
statement ok
CREATE SCHEMA my_schema;
statement ok
CREATE TABLE my_schema.table_in_schema(my_column INTEGER)
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('SHOW my_s') LIMIT 1;
----
my_schema. 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('DESCRIBE my_schema.t') LIMIT 1;
----
table_in_schema 19
|
