Bad arrayJoin result with optimize_read_in_order and query_plan_execute_functions_after_sorting disabled

[PedroTadim]

Describe the bug

Happens since v25.12 Time to bisect

How to reproduce

Run Fiddle: https://fiddle.clickhouse.com/c9807b35-d78c-470b-972b-0b2d7329b215

Error message and/or stacktrace

No response

Version info

• Resolved by: Do not apply lazy materialization for plans with array join #101644
• Merged into: 26.5.1.710
• Backported to: 26.4.5.20, 26.3.14.16

[PedroTadim]

Claude code is having a bad time bisecting this. cc @vdimir, maybe someone on your team can look into it? 😄