ClickHouse / ClickHouse/ClickHouse

If I remove a setting from users XML to reset a setting it requires restart ?

Open
#46,418 1 comment 0 reactions 0 assignees View on GitHub
comp-settings external unexpected behaviour
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

I removed a setting from default profile `1`
it does not have any impact on settings.

```sql
22.8.13.20 (official build) / 23.1.2.9

cat /etc/clickhouse-server/users.d/st.xml



1
15

select name,value from system.settings where name like '%empty_result_for_aggregation_by_empty_set%';
┌─name──────────────────────────────────────┬─value─┐
│ empty_result_for_aggregation_by_empty_set │ 1 │
└───────────────────────────────────────────┴───────┘

select count() from system.one where 0;
0 rows in set. Elapsed: 0.003 sec.

cat /etc/clickhouse-server/users.d/st.xml



15

select name,value from system.settings where name like '%empty_result_for_aggregation_by_empty_set%';
┌─name──────────────────────────────────────┬─value─┐
│ empty_result_for_aggregation_by_empty_set │ 1 │
└───────────────────────────────────────────┴───────┘

systemctl restart clickhouse-server

┌─name──────────────────────────────────────┬─value─┐
│ empty_result_for_aggregation_by_empty_set │ 0 │
└───────────────────────────────────────────┴───────┘
```

So if I change `empty_result_for_aggregation_by_empty_set` to 1 or to 0 it impacts on settings.
If I remove a line from XML it does not impact.

It seems it happens with all settings not only `empty_result_for_aggregation_by_empty_set`

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.