Fix issues 39469

[nicelulu]

Changelog category (leave one):

• Bug Fix (user-visible misbehavior in official stable or prestable release)

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

Fix possible "Not found column in block" exception when using projections. This closes #39469

[alexey-milovidov]

I've edited the changelog.

Was:

https://github.com/ClickHouse/ClickHouse/issues/39469

Now:

Fix possible "Not found column in block" exception when using projections. This closes #39469

[alexey-milovidov]

@kssenii a test for PostgreSQL replica has failed: https://s3.amazonaws.com/clickhouse-test-reports/39470/c5d9a6c37c1e6fa5be6bfff332943cabb13242cb/integration_tests__asan__[3/3].html

[alexey-milovidov]

@nicelulu the Flaky check shows that the new test is flaky: https://s3.amazonaws.com/clickhouse-test-reports/39470/c5d9a6c37c1e6fa5be6bfff332943cabb13242cb/stateless_tests_flaky_check__address_.html

PTAL.

[nicelulu]

2022.07.25 11:38:44.753334 [ 892 ] {fe1d8acf-fc7c-4c12-ab27-1897ac551585} <Error> test_2m9u7n.video_log (321809a5-9194-4edf-a12f-04c201753597): Cannot quickly remove directory /var/lib/clickhouse/store/321/321809a5-9194-4edf-a12f-04c201753597/delete_tmp_tmp_mut_20220722_2_2_0_5 by removing files; fallback to recursive removal. Reason: Code: 458. DB::ErrnoException: Cannot unlink file /var/lib/clickhouse/store/321/321809a5-9194-4edf-a12f-04c201753597/delete_tmp_tmp_mut_20220722_2_2_0_5/checksums.txt, errno: 2, strerror: No such file or directory. (CANNOT_UNLINK) (version 22.8.1.1)
2

Strange, doesn't seem to have anything to do with the change.

[alexey-milovidov]

Yes, looks strange. Need help from @tavplubix

[tavplubix]

Cannot quickly remove directory ... delete_tmp_tmp_mut_20220722_2_2_0_5 ... Cannot unlink file ... delete_tmp_tmp_mut_20220722_2_2_0_5/checksums.txt ... No such file or directory

It's because part was not completely mutated and some files are absent (It's OK). Part was not completely mutated because ALTERs in test are asynchronous. So new test it not quite correct.