You have a great example in your issue, let's try to add it as test.

Also there's some commits Merge pull request #1 from ClickHouse/master in this PR, do you mind to rebase it and have just one or two commits with just your work?

You have a great example in your issue, let's try to add it as test.

Also there's some commits Merge pull request #1 from ClickHouse/master in this PR, do you mind to rebase it and have just one or two commits with just your work?

@vdimir Thanks for your reviewing ! I will try to add some tests and rebase the unnecessary commits.

@lingtaolf I guess you can / should use "force..." for tests:

set force_index_by_date=1, force_primary_key=1　;

--force_index_by_date arg Throw an exception if there is a partition key in a table, and it is not used.
--force_primary_key arg Throw an exception if there is primary key in a table, and it is not used.

@lingtaolf I guess you can / should use "force..." for tests:

set force_index_by_date=1, force_primary_key=1　;

--force_index_by_date arg Throw an exception if there is a partition key in a table, and it is not used.
--force_primary_key arg Throw an exception if there is primary key in a table, and it is not used.

@den-crane Done ! Thanks for you advices .

All committers have signed the CLA.

I fixed fuzzer error and added support both type of expressions (id, value) = (1, 'A') and (1, 'A') = (id, value)

Analyzing of expression like (1, value) = (id, 'A') not implemented yet, we can add it this PR or in other one.

Thank you for your changes!

Let's wait for CI and merge if it'll be ok.

@vdimir Thanks for your help !

CI stuck for some reason, I'm going to rebase branch

Added a couple of testcases with tuple in tuple and rebase on master, hope final change, will wait CI and merge.

AST fuzzer (UBSan) — ../contrib/libcxx/include/vector:677:16: runtime error: reference binding to

Known solved issue
#29687

Integration tests (asan) fail: 2, passed: 1559, flaky: 21
Integration tests (release) fail: 1, passed: 1574, flaky: 8
Integration tests (thread) fail: 4, passed: 1566, flaky: 14

@vdimir @lingtaolf test_cluster_copier/test_three_nodes.py::test failed for a reason, should be fixed in #29956