Backport #47495 to 23.2: Parameterized view bug fix 47287 47247

[robot-clickhouse-ci-1]

Original pull-request #47495
Cherry-pick pull-request #47678

This pull-request is a last step of an automated backporting.
Treat it as a standard pull-request: look at the checks and resolve conflicts.
Merge it only if you intend to backport changes to the target branch, otherwise just close it.

[SmitaRKulkarni]

Reopened to merge it to [23.2]

[SmitaRKulkarni]

Unrelated failures :
test_backup_restore_new/test.py , test_async_backups_to_same_destination - #44901
Stress test (tsan) - Backward compatibility check
2023.03.23 13:26:42.443604 [ 246852 ] {} <Error> test_13.mutations_and_quorum2 (ReplicatedMergeTreeAttachThread): Initialization failed, table will remain readonly. Error: Code: 231. DB::Exception: The local set of parts of table test_13.mutations_and_quorum2 (8337852c-f2a8-4394-bf4b-03961ebfb54e) doesn't look like the set of parts in ZooKeeper: 10.00 rows of 10.00 total rows in filesystem are suspicious. There are 13 uncovered unexpected parts with 10 rows (0 of them is not just-written with 0 rows), 0 missing parts (with 0 blocks), 0 covered unexpected parts (with 0 rows). (TOO_MANY_UNEXPECTED_DATA_PARTS), Stack trace (when copying this message, always include the lines below): 2023.03.23 13:26:42.443921 [ 246890 ] {} <Error> test_13.mutations_and_quorum1 (ReplicatedMergeTreeAttachThread): Initialization failed, table will remain readonly. Error: Code: 231. DB::Exception: The local set of parts of table test_13.mutations_and_quorum1 (45fb661f-eccf-4530-9f30-45068921fbc0) doesn't look like the set of parts in ZooKeeper: 9.00 rows of 10.00 total rows in filesystem are suspicious. There are 12 uncovered unexpected parts with 9 rows (0 of them is not just-written with 0 rows), 0 missing parts (with 0 blocks), 0 covered unexpected parts (with 0 rows). (TOO_MANY_UNEXPECTED_DATA_PARTS), Stack trace (when copying this message, always include the lines below):