Logical Error: Input nodes size mismatch in dag

[PedroTadim]

Describe the bug

Easy to reproduce. Happens since v25.9

How to reproduce

Run Fiddle: https://fiddle.clickhouse.com/accc6269-efaa-4a59-8c47-cca301af6cbe

Error message and/or stacktrace

Stack trace:

<Fatal> : Logical error: 'Input nodes size mismatch in dag: 0 : INPUT () (no column) UInt8 __table1.c0
1 : FUNCTION (0) (no column) UInt8 abs(__table1.c0) [abs]
2 : INPUT () (no column) UInt8 __table7.c0
3 : COLUMN () Const(UInt8) UInt8 __join_result_dummy
Output nodes: 1 0 2 3
, expected: [__table3.c0, __table1.c0], [__table7.c0]'.
<Fatal> : Stack trace (when copying this message, always include the lines below):

0. contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x00000000247d85b2
1. src/Common/Exception.cpp:129: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000014ff0069
2. src/Common/Exception.h:123: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000d50e30e
3. src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000d50dd11
4. src/Common/Exception.h:141: DB::Exception::Exception<String, String, String>(int, FormatStringHelperImpl<std::type_identity<String>::type, std::type_identity<String>::type, std::type_identity<String>::type>, String&&, String&&, String&&) @ 0x000000000d5e30b6
5. src/Interpreters/JoinExpressionActions.cpp:124: DB::JoinExpressionActions::JoinExpressionActions(DB::Block const&, DB::Block const&, DB::ActionsDAG&&) @ 0x000000001adaf9cf
6. src/Processors/QueryPlan/Optimizations/optimizeJoin.cpp:939: DB::QueryPlanOptimizations::chooseJoinOrder(DB::QueryPlanOptimizations::QueryGraphBuilder, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&, DB::JoinStrictness) @ 0x000000001f136d9c
7. src/Processors/QueryPlan/Optimizations/optimizeJoin.cpp:1103: DB::QueryPlanOptimizations::optimizeJoinLogicalImpl(DB::JoinStepLogical*, DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&, DB::QueryPlanOptimizationSettings const&) @ 0x000000001f1340d9
8. src/Processors/QueryPlan/Optimizations/optimizeJoin.cpp:1068: DB::QueryPlanOptimizations::optimizeJoinLogical(DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&, DB::QueryPlanOptimizationSettings const&) @ 0x000000001f13a991
9. src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:224: DB::QueryPlanOptimizations::optimizeTreeSecondPass(DB::QueryPlanOptimizationSettings const&, DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&, DB::QueryPlan&) @ 0x000000001f123ec9
10. src/Processors/QueryPlan/QueryPlan.cpp:506: DB::QueryPlan::optimize(DB::QueryPlanOptimizationSettings const&) @ 0x000000001f03529f
11. src/Processors/QueryPlan/QueryPlan.cpp:180: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&, bool) @ 0x000000001f034b40
12. src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:289: DB::InterpreterSelectQueryAnalyzer::buildQueryPipeline() @ 0x000000001ada14a5
13. src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:256: DB::InterpreterSelectQueryAnalyzer::execute() @ 0x000000001ada11dc
14. src/Interpreters/executeQuery.cpp:1603: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, std::unique_ptr<DB::ReadBuffer, std::default_delete<DB::ReadBuffer>>&, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>, std::function<void ()>) @ 0x000000001b0c1642
15. src/Interpreters/executeQuery.cpp:1812: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001b0bb2b2
16. src/Server/TCPHandler.cpp:744: DB::TCPHandler::runImpl() @ 0x000000001e9fa1ee
17. src/Server/TCPHandler.cpp:2818: DB::TCPHandler::run() @ 0x000000001ea13f64
18. base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x000000002488efc7
19. base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x000000002488f5a5
20. base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x000000002482e73f
21. base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000002482be11
22. start_thread @ 0x00000000000a27f1
23. __GI___clone3 @ 0x0000000000133b5c