Igor Nikonov

https://s3.amazonaws.com/clickhouse-test-reports/64448/75f7816c46da69b4b92b902a2ef4c33112c99ebb/ast_fuzzer__ubsan_.html ``` build/src/Processors/QueryPlan/ReadFromMergeTree.cpp:551:79: runtime error: 1.84467e+19 is outside the range of representable values of type 'unsigned long' ``` https://pastila.nl/?0008b286/3d60464501e9d093c92aaf0a80bf5a9f#6u9SKtLkKv1jmRM8aG4ckw== Fix: [fa0f454](https://github.com/ClickHouse/ClickHouse/pull/64448/commits/fa0f4543b688861a97843a8767d895f52b6dee9d)

https://s3.amazonaws.com/clickhouse-test-reports/64448/4753f4cb334f7a2ab9dba2f1e69b9b38d596b5d8/ast_fuzzer__debug_.html ``` /build/contrib/llvm-project/libcxx/include/vector:1500: assertion __n < size() failed: vector[] index out of bounds ``` https://pastila.nl/?000e180a/a2a8555458ee72488c2e5e89218a6660#4q9IGCOpEX4xKqAWLomzPw== New occurrences: https://s3.amazonaws.com/clickhouse-test-reports/64448/36036c3da9bb3c91284f157b9d579b5d0087b6e4/ast_fuzzer__debug_.html Fix commit [1a8f454](https://github.com/ClickHouse/ClickHouse/pull/64448/commits/1a8f45464c1ef81dc8c2c16c8fbba2e696762962) Separated fix https://github.com/ClickHouse/ClickHouse/pull/68309

https://s3.amazonaws.com/clickhouse-test-reports/64448/4753f4cb334f7a2ab9dba2f1e69b9b38d596b5d8/ast_fuzzer__asan_.html ``` SUMMARY: AddressSanitizer: heap-buffer-overflow build_docker/./src/Storages/MergeTree/MergeTreeIndexGranularity.cpp:75:12 in DB::MergeTreeIndexGranularity::getRowsCountInRange(unsigned long, unsigned long) const ``` https://pastila.nl/?000c1e18/8ab368055eae9aacd495efbfe1032ee4#KPXYFM7z/UoBEN6u3IBN9Q== Upd: reproduced again [here](https://s3.amazonaws.com/clickhouse-test-reports/64448/f49412e967ec549d8a49e53ce3bfba27e13994fc/ast_fuzzer__asan_.html). Need to investigate Added test `03222_pr_asan_index_granularity.sql`

https://s3.amazonaws.com/clickhouse-test-reports/64448/f49412e967ec549d8a49e53ce3bfba27e13994fc/stress_test__debug_.html Somehow, `is_parallel_reading_from_replicas` flag was set with `select ... final` ``` 2024.07.24 04:58:19.998634 [ 6010 ] {d28aa30d-41b5-448b-a8e6-89d5bb6d23a1} : Logical error: '!is_parallel_reading_from_replicas'. ``` https://pastila.nl/?000b09b7/08a0651b91abb49dff73b0a5ec8cd9db#2PptACV7S1Hz5S64eV9TMw== Added test `03222_parallel_replicas_final_in_subquery.sql` Fix commit [a3978b2](https://github.com/ClickHouse/ClickHouse/pull/64448/commits/a3978b24d0ee8847e5b332a08014ced896edae2c)

Stress test [failure](https://s3.amazonaws.com/clickhouse-test-reports/64448/0705bbb42b1c5e19024faadcefbc3e1b236d0b1a/stress_test__debug_.html) ``` [ 6751 ] {1f5c1bca-0798-4fb9-bfcd-92594d47fefc} : Logical error: \'Expected the argument №2 (\'_CAST(NULL_Nullable(String), \'Nullable(String)\'_String)\' of type Nullable(String)) to have 2 rows, but it has 0\'. [ 6751...

> https://s3.amazonaws.com/clickhouse-test-reports/64448/75f7816c46da69b4b92b902a2ef4c33112c99ebb/stress_test__msan_.html For a reason, replicas choose different modes to read table `ReverseOrder` on the initiator and `Default` on some other replica > > ``` > 55371:2024.07.19 16:14:38.236759 [ 4019...

`Stateless test (asan)` [failure](https://s3.amazonaws.com/clickhouse-test-reports/64448/db8ce31bb785ae6a843089a02396abc2f986003e/stateless_tests__asan__[1_2].html) - `DB::Exception: Unexpected error for async deduplicated insert`, see https://pastila.nl/?00315c22/4cc66983d8947ee2d18f040eef94e5b0#J4jgSkA5kvOW5EXbVLwU9A==

AST Fuzzer [failure](https://s3.amazonaws.com/clickhouse-test-reports/64448/fc1228e3a40509c0566c89c5348c94664e3ce219/ast_fuzzer__debug_.html) - `Logical error: 'Not-ready Set is passed as the second argument for function 'in''.` UPD: fixed by https://github.com/ClickHouse/ClickHouse/pull/69264 Performance comparison [errors](https://s3.amazonaws.com/clickhouse-test-reports/64448/fc1228e3a40509c0566c89c5348c94664e3ce219/performance_comparison__release__[4_4]/report.html) - afais, they are caused by...

Waiting for https://github.com/ClickHouse/ClickHouse/pull/69264

> @devcrafter any idea on this PR? Currently, I'm discussing it with some colleagues in the team.