Nikita Mikhaylov

Test?

I see that `01700_deltasum` is broken in master along with `test_memory_limit/test.py::test_multiple_queries`. The [TSAN failure](https://s3.amazonaws.com/clickhouse-test-reports/48902/4da68a344b9c3b32803c5ac28b8fa7a82edaf875/stateless_tests__tsan__s3_storage__[1_3]/stderr.log) looks related. Looking.

Stateless tests (asan) - https://github.com/ClickHouse/ClickHouse/issues/74287

So, another iteration: - `test_async_insert_adaptive_busy_timeout/test.py::test_compare_parallel_inserts_durations_for_adaptive_and_fixed_async_timeouts`[ is super flaky](https://play.clickhouse.com/play?user=play#U0VMRUNUIGNoZWNrX25hbWUsIHRlc3RfbmFtZSwgcmVwb3J0X3VybApGUk9NIGNoZWNrcwpXSEVSRSAxCiAgICBBTkQgY2hlY2tfc3RhcnRfdGltZSA+PSBub3coKSAtIElOVEVSVkFMIDE0NCBIT1VSCiAgICBBTkQgdGVzdF9zdGF0dXMgIT0gJ1NLSVBQRUQnCiAgICBBTkQgKHRlc3Rfc3RhdHVzIExJS0UgJ0YlJyBPUiB0ZXN0X3N0YXR1cyBMSUtFICdFJScpIAogICAgQU5EIGNoZWNrX3N0YXR1cyAhPSAnc3VjY2VzcycKICAgIEFORCB0ZXN0X25hbWUgSUxJS0UgJyV0ZXN0X2FzeW5jX2luc2VydF9hZGFwdGl2ZV9idXN5X3RpbWVvdXQvdGVzdC5weTo6dGVzdF9jb21wYXJlX3BhcmFsbGVsX2luc2VydHNfZHVyYXRpb25zX2Zvcl9hZGFwdGl2ZV9hbmRfZml4ZWRfYXN5bmNfdGltZW91dHMlJwpPUkRFUiBCWSBjaGVja19uYW1lLCB0ZXN0X25hbWUsIGNoZWNrX3N0YXJ0X3RpbWU=) in recent days. - `02871_peak_threads_usage` [failed in another PR](https://play.clickhouse.com/play?user=play#U0VMRUNUIGNoZWNrX25hbWUsIHRlc3RfbmFtZSwgcmVwb3J0X3VybApGUk9NIGNoZWNrcwpXSEVSRSAxCiAgICBBTkQgY2hlY2tfc3RhcnRfdGltZSA+PSBub3coKSAtIElOVEVSVkFMIDE0NCBIT1VSCiAgICBBTkQgdGVzdF9zdGF0dXMgIT0gJ1NLSVBQRUQnCiAgICBBTkQgKHRlc3Rfc3RhdHVzIExJS0UgJ0YlJyBPUiB0ZXN0X3N0YXR1cyBMSUtFICdFJScpIAogICAgQU5EIGNoZWNrX3N0YXR1cyAhPSAnc3VjY2VzcycKICAgIEFORCB0ZXN0X25hbWUgSUxJS0UgJyUwMjg3MV9wZWFrX3RocmVhZHNfdXNhZ2UlJwpPUkRFUiBCWSBjaGVja19uYW1lLCB0ZXN0X25hbWUsIGNoZWNrX3N0YXJ0X3RpbWU=) in a recent week. Given that these changes tend to conflict much, I...

@fzyzcjy Stay tuned 😌

@pufit Let's continue.

- `Stateless tests (tsan, s3 storage) [4/5]` https://github.com/ClickHouse/ClickHouse/pull/66111 - `Stateless tests (aarch64)` https://github.com/ClickHouse/ClickHouse/issues/65589 - `AST fuzzer (debug)` https://github.com/ClickHouse/ClickHouse/issues/61611

I think it should also throw an exception when we are trying to shift for more than type width. While this behaviour seems different from the MySQL for example, I'd...

Previous attempt to fix this bug was here: https://github.com/ClickHouse/ClickHouse/pull/52944 The first failure from the past month was noticied in this PR: https://github.com/ClickHouse/ClickHouse/pull/61601#issuecomment-2208796921

Let's check, it might break the compatibility with old versions of ClickHouse, because `allow_experimental_analyzer` is IMPORTANT.