ClickHouse / ClickHouse/ClickHouse
ClickHouse ignores settings from subquery
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
**Describe what's wrong**
SETTINGS clause from a subquery does not apply to the query.
**How to reproduce**
No subquery
```sql
SELECT *
FROM numbers(10)
SETTINGS optimize_read_in_order = 0
-- Query id: d8f9702d-2f45-4976-a1c0-f0401bcf9593
SELECT Settings
FROM system.query_log
WHERE query_id = 'd8f9702d-2f45-4976-a1c0-f0401bcf9593'
LIMIT 1
-- ┌─Settings───────────────────────┐
-- 1. │ {'optimize_read_in_order':'0'} │
-- └────────────────────────────────┘
```
With subquery
```sql
SELECT *
FROM
(
SELECT *
FROM numbers(10)
SETTINGS optimize_read_in_order = 0
)
-- Query id: 98714456-aa89-48b9-a5e0-1ebadc866aaa
;
SELECT Settings
FROM system.query_log
WHERE query_id = '98714456-aa89-48b9-a5e0-1ebadc866aaa'
LIMIT 1
-- ┌─Settings─┐
-- 1. │ {} │
-- └──────────┘
```
**Expected behavior**
Settings are applied to the subquery.
Contributor guide
Assessment
This issue has not been assessed yet.