Logical error 'Unexpected return type' in query with tuple with assumeNotNull and tuple

[vdimir]

SELECT 1 WHERE (assumeNotNull(materialize(NULL)), 1) = (1, 1)

Repro:

https://fiddle.clickhouse.com/68ff83a2-a8a4-4919-ad21-8bc6de26d458

Ref #81969 (comment)

[PedroTadim]

Related to any of these: #86031, #87016?

[vdimir]

Related to any of these: #86031, #87016?

I don't think so, that ones have JOIN in query, it can make a difference and require different fixes

[PedroTadim]

This one is also similar: #85354

[vdimir]

This one is also similar: #85354

Good, thanks, and this one can be same, so worth checking once we fix one.

[raimannma]

@PedroTadim that PR is not solving it, but this commit might solve it: raimannma@1ab0b4e
the commit might cause other issues, i don't know, tests seem to pass though