1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
# name: test/sql/table_function/duckdb_indexes.test
# description: Test duckdb_indexes function
# group: [table_function]
statement ok
CREATE TABLE integers(i INTEGER, j INTEGER, k INTEGER)
statement ok
CREATE INDEX i_index ON integers((j + 1), k)
statement ok nosort duckdb_col
SELECT * FROM duckdb_indexes();
statement ok nosort duckdb_col
SELECT * FROM duckdb_indexes;
query I
select expressions from duckdb_indexes where table_name = 'integers';
----
['((j + 1))', k]
|
