ClickHouse / ClickHouse/ClickHouse

ClickHouse ignores settings from subquery

Open
#63,078 4 comments 0 reactions 0 assignees View on GitHub
comp-query-analyzer external unexpected behaviour
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

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.