Denny [DBA at Innervate]

funny, one more issue, which also not related, and also not related to the analyzer https://fiddle.clickhouse.com/ed061dba-fc13-45e8-8066-4061f7501c02 ILLEGAL_TYPE_OF_COLUMN_FOR_FILTER ```sql create table orders (a DateTime, b DateTime) Engine=MergeTree PARTITION BY toYYYYMM(a) ORDER...

@neel-bp > no we are not using default database, we have a cluster of 5 shards with 2 replicas each, okay we will try with allow_experimental_analyzer disabled `CREATE TABLE distributeddb.orders`...

@neel-bp ` ourdb_replica` -- YES What is `ourdb_replica` ? How it's related to `localdb` or `distributeddb` ?

yes, it's allow_experimental_analyzer. repro ```xml cat /etc/clickhouse-server/config.d/cl.xml 127.0.0.1 9000 default ``` ```sql create table orders (a Int64) Engine = Memory as select 1; create table orders_d (a Int64) Engine =...

There are also discrepancy now 23.3 https://fiddle.clickhouse.com/e6fe9155-41ab-4ca7-9be9-9d9217493e06 ``` +---------------------+ | DATE | +---------------------+ | 2000-01-01 00:00:00 | +---------------------+ +---------------------+ | DATE | +---------------------+ | 2000-01-01 00:00:00 | +---------------------+ ``` 23.8...

* https://github.com/ClickHouse/ClickHouse/pull/54881

allow_experimental_analyzer ```sql SELECT * FROM ( WITH dense_rank() OVER (ORDER BY number DESC) AS row SELECT row FROM numbers(10) ) WHERE row < 3 SETTINGS allow_experimental_analyzer = 1 Query id:...

client keepalive should substantially **bigger** than server keepalive https://github.com/ClickHouse/ClickHouse/issues/52571#issuecomment-1650266265 https://github.com/ClickHouse/ClickHouse/pull/53068 -- update: bigger not smaller

Hooray. Dreams come true.

new functions multiplyDecimal / divideDecimal (from version 22.12)