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
|
# name: test/sql/function/autocomplete/table_functions.test
# description: Test sql_auto_complete
# group: [autocomplete]
require autocomplete
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('call histo') LIMIT 1;
----
histogram 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('call histogram_') LIMIT 1;
----
histogram_values 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('call duckdb_ty') LIMIT 1;
----
duckdb_types 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('FROM duckdb_c') LIMIT 1;
----
duckdb_columns 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('call read_cs') LIMIT 1;
----
read_csv 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('FROM read_csv_a') LIMIT 1;
----
read_csv_auto 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('call unnes') LIMIT 1;
----
unnest 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('CALL glo') LIMIT 1;
----
"glob" 5
query II
SELECT suggestion, suggestion_start FROM sql_auto_complete('from ran') LIMIT 1;
----
"range" 5
|