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
|
# name: test/sql/logging/logging_file_persistence.test
# description: Test file backed log storage persistence
# group: [logging]
# Due to different file locking behaviour, this currently fails on windows
require notwindows
# load the DB from disk
load {TEMP_DIR}/logging_file_persistence.test
# Enable FileSystem logging to single csv file
statement ok
CALL enable_logging('FileSystem', storage='file', storage_config={'path': '{TEMP_DIR}/logging_file_persistence.csv'});
# Read some data to trigger FileSystem log
statement ok
FROM "{DATA_DIR}/csv/big_number.csv"
statement ok
CALL disable_logging();
query IIIIIIIII nosort log_output
FROM duckdb_logs;
----
restart
# TODO: configuring log storage config is clunky now
statement ok
CALL enable_logging('FileSystem', storage='file', storage_config={'path': '{TEMP_DIR}/logging_file_persistence.csv'});
statement ok
CALL disable_logging();
query IIIIIIIII nosort log_output
FROM duckdb_logs;
----
|
