ClickHouse / ClickHouse/ClickHouse
If I remove a setting from users XML to reset a setting it requires restart ?
- 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
Assessment
This issue has not been assessed yet.