-- GUC configuration test
CREATE EXTENSION pg_stat_ch;
SELECT name FROM pg_settings WHERE name LIKE 'pg_stat_ch.%' ORDER BY name COLLATE "C";
                  name                  
----------------------------------------
 pg_stat_ch.batch_max
 pg_stat_ch.clickhouse_database
 pg_stat_ch.clickhouse_host
 pg_stat_ch.clickhouse_password
 pg_stat_ch.clickhouse_port
 pg_stat_ch.clickhouse_skip_tls_verify
 pg_stat_ch.clickhouse_use_tls
 pg_stat_ch.clickhouse_user
 pg_stat_ch.debug_force_locked_overflow
 pg_stat_ch.enabled
 pg_stat_ch.flush_interval_ms
 pg_stat_ch.hostname
 pg_stat_ch.log_min_elevel
 pg_stat_ch.otel_endpoint
 pg_stat_ch.otel_log_batch_size
 pg_stat_ch.otel_log_delay_ms
 pg_stat_ch.otel_log_max_bytes
 pg_stat_ch.otel_log_queue_size
 pg_stat_ch.otel_metric_interval_ms
 pg_stat_ch.queue_capacity
 pg_stat_ch.use_otel
(21 rows)

SHOW pg_stat_ch.enabled;
 pg_stat_ch.enabled 
--------------------
 on
(1 row)

-- Test log_min_elevel GUC
SHOW pg_stat_ch.log_min_elevel;
 pg_stat_ch.log_min_elevel 
---------------------------
 warning
(1 row)

SET pg_stat_ch.log_min_elevel = 'error';
SHOW pg_stat_ch.log_min_elevel;
 pg_stat_ch.log_min_elevel 
---------------------------
 error
(1 row)

SET pg_stat_ch.log_min_elevel = 'notice';
SHOW pg_stat_ch.log_min_elevel;
 pg_stat_ch.log_min_elevel 
---------------------------
 notice
(1 row)

RESET pg_stat_ch.log_min_elevel;
SHOW pg_stat_ch.log_min_elevel;
 pg_stat_ch.log_min_elevel 
---------------------------
 warning
(1 row)

-- Test that clickhouse_password is hidden from non-superusers (issue #3)
CREATE ROLE psch_test_user LOGIN;
SET ROLE psch_test_user;
-- Should error: must be superuser
SHOW pg_stat_ch.clickhouse_password;
ERROR:  permission denied to examine "pg_stat_ch.clickhouse_password"
DETAIL:  Only roles with privileges of the "pg_read_all_settings" role may examine this parameter.
-- Should return no rows (GUC_SUPERUSER_ONLY hides from pg_settings)
SELECT name, setting FROM pg_settings WHERE name = 'pg_stat_ch.clickhouse_password';
 name | setting 
------+---------
(0 rows)

RESET ROLE;
DROP ROLE psch_test_user;
DROP EXTENSION pg_stat_ch;