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
|
# name: test/sql/table_function/duckdb_sequences.test
# description: Test duckdb_sequences function
# group: [table_function]
query I
SELECT COUNT(*) FROM duckdb_sequences();
----
0
statement ok
CREATE SEQUENCE seq
statement ok
CREATE TEMPORARY SEQUENCE seq2 MINVALUE 3 MAXVALUE 5 START WITH 4 CYCLE;
query IIIIIIII
SELECT schema_name, sequence_name, temporary, start_value, min_value, max_value, increment_by, cycle
FROM duckdb_sequences() ORDER BY sequence_name;
----
main seq False 1 1 9223372036854775807 1 False
main seq2 True 4 3 5 1 True
query I
SELECT database_name = current_database() OR database_name = 'temp'
FROM duckdb_sequences();
----
True
True
|
