Error:
Logical error: 'Unexpected return type from acos. Expected Nullable(Float64). Got Float64. Action:
FUNCTION acos(id : 0) -> acos(__table1.id) Nullable(Float64) : 2,
input block structure:id UInt32 UInt32(size = 0)'.
---

Failed query:
EXPLAIN ESTIMATE SELECT t2.id, t1.id FROM test_table_1 AS t1 GLOBAL ANY INNER JOIN test_table_2 AS t2 ON t1.id = t2.id WHERE (acos(t2.id) != atan(t1.id)) AND (NOT (acos(t2.id) >= atan(t1.id)))
---

Reproduce commands (auto-generated; may require manual adjustment):
CREATE TABLE test_table_2 (`id` UInt32) ENGINE = MergeTree ORDER BY id
CREATE TABLE test_table_1 (`id` UInt32) ENGINE = MergeTree ORDER BY id
EXPLAIN ESTIMATE SELECT t2.id, t1.id FROM test_table_1 AS t1 GLOBAL ANY INNER JOIN test_table_2 AS t2 ON t1.id = t2.id WHERE (acos(t2.id) != atan(t1.id)) AND (NOT (acos(t2.id) >= atan(t1.id)))
DROP TABLE IF EXISTS test_table_2
DROP TABLE IF EXISTS test_table_1
---

Stack trace:
__GI___pthread_kill @ 0x00000000000969fd
raise @ 0x0000000000042476
__lgamma_r_finite@GLIBC_2.15 @ 0x00000000000287f3
src/Common/Exception.cpp:57: DB::abortOnFailedAssertion(String const&, std::basic_string_view<char, std::char_traits<char>>, void* const*, unsigned long, unsigned long) @ 0x00000000162a023c
src/Common/Exception.cpp:90: DB::handle_error_code(String const&, std::basic_string_view<char, std::char_traits<char>>, int, bool, std::vector<void*, std::allocator<void*>> const&) @ 0x00000000162a164d
src/Common/Exception.cpp:143: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000162a1939
src/Common/Exception.h:172: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000d874c54
src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000d874751
src/Common/Exception.h:190: DB::Exception::Exception<String, String, String, String, String>(int, FormatStringHelperImpl<std::type_identity<String>::type, std::type_identity<String>::type, std::type_identity<String>::type, std::type_identity<String>::type, std::type_identity<String>::type>, String&&, String&&, String&&, String&&, String&&) @ 0x000000001042889a
src/Interpreters/ExpressionActions.cpp:696: DB::executeAction(DB::ExpressionActions::Action const&, DB::(anonymous namespace)::ExecutionContext&, bool, bool, bool)
src/Interpreters/ExpressionActions.cpp:836: DB::ExpressionActions::execute(DB::Block&, unsigned long&, bool, bool) const @ 0x000000001c539c13
src/Interpreters/ExpressionActions.cpp:882: DB::ExpressionActions::execute(DB::Block&, bool, bool) const @ 0x000000001c53a1c7
src/Processors/Transforms/FilterTransform.cpp:88: DB::FilterTransform::FilterTransform(std::shared_ptr<DB::Block const>, std::shared_ptr<DB::ExpressionActions>, String, bool, bool, std::shared_ptr<std::atomic<unsigned long>>, std::optional<std::pair<unsigned long, String>>) @ 0x000000002062d87e
contrib/llvm-project/libcxx/include/__memory/construct_at.h:38: DB::FilterTransform* std::construct_at[abi:se210105]<DB::FilterTransform, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool, bool&, DB::FilterTransform*>(DB::FilterTransform*, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool&&, bool&) @ 0x0000000020885342
contrib/llvm-project/libcxx/include/__memory/construct_at.h:46: DB::FilterTransform* std::__construct_at[abi:se210105]<DB::FilterTransform, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool, bool&, DB::FilterTransform*>(DB::FilterTransform*, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool&&, bool&)
contrib/llvm-project/libcxx/include/__memory/allocator_traits.h:302: void std::allocator_traits<std::allocator<DB::FilterTransform>>::construct[abi:se210105]<DB::FilterTransform, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool, bool&, 0>(std::allocator<DB::FilterTransform>&, DB::FilterTransform*, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool&&, bool&)
contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:162: __shared_ptr_emplace<const std::shared_ptr<const DB::Block> &, std::shared_ptr<DB::ExpressionActions> &, std::basic_string<char, std::char_traits<char>, std::allocator<char> > &, bool, bool &, std::allocator<DB::FilterTransform>, 0>
contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:736: std::shared_ptr<DB::FilterTransform> std::allocate_shared[abi:se210105]<DB::FilterTransform, std::allocator<DB::FilterTransform>, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool, bool&, 0>(std::allocator<DB::FilterTransform> const&, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool&&, bool&)
contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:744: std::shared_ptr<DB::FilterTransform> std::make_shared[abi:se210105]<DB::FilterTransform, std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool, bool&, 0>(std::shared_ptr<DB::Block const> const&, std::shared_ptr<DB::ExpressionActions>&, String&, bool&&, bool&)
src/Processors/QueryPlan/FilterStep.cpp:161: operator()
contrib/llvm-project/libcxx/include/__type_traits/invoke.h:87: std::__invoke_result_impl<void, DB::FilterStep::transformPipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&)::$_0&, std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType>::type std::__invoke[abi:se210105]<DB::FilterStep::transformPipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&)::$_0&, std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType>(DB::FilterStep::transformPipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&)::$_0&, std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType&&)
contrib/llvm-project/libcxx/include/__type_traits/invoke.h:334: std::shared_ptr<DB::IProcessor> std::__invoke_void_return_wrapper<std::shared_ptr<DB::IProcessor>, false>::__call[abi:se210105]<DB::FilterStep::transformPipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&)::$_0&, std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType>(DB::FilterStep::transformPipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&)::$_0&, std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType&&)
contrib/llvm-project/libcxx/include/__type_traits/invoke.h:348: std::shared_ptr<DB::IProcessor> std::__invoke_r[abi:se210105]<std::shared_ptr<DB::IProcessor>, DB::FilterStep::transformPipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&)::$_0&, std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType>(DB::FilterStep::transformPipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&)::$_0&, std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType&&)
contrib/llvm-project/libcxx/include/__functional/function.h:450: ? @ 0x0000000020884039
contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
src/QueryPipeline/Pipe.cpp:592: DB::Pipe::addSimpleTransform(std::function<std::shared_ptr<DB::IProcessor> (std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType)> const&)::$_0::operator()(DB::OutputPort*&, DB::Pipe::StreamType) const @ 0x000000001b50bfbe
src/QueryPipeline/Pipe.cpp:631: DB::Pipe::addSimpleTransform(std::function<std::shared_ptr<DB::IProcessor> (std::shared_ptr<DB::Block const> const&, DB::Pipe::StreamType)> const&) @ 0x000000001b50be1d
src/Processors/QueryPlan/FilterStep.cpp:158: DB::FilterStep::transformPipeline(DB::QueryPipelineBuilder&, DB::BuildQueryPipelineSettings const&) @ 0x0000000020881372
src/Processors/QueryPlan/ITransformingStep.cpp:21: DB::ITransformingStep::updatePipeline(std::vector<std::unique_ptr<DB::QueryPipelineBuilder, std::default_delete<DB::QueryPipelineBuilder>>, std::allocator<std::unique_ptr<DB::QueryPipelineBuilder, std::default_delete<DB::QueryPipelineBuilder>>>>, DB::BuildQueryPipelineSettings const&) @ 0x0000000020892feb
src/Processors/QueryPlan/QueryPlan.cpp:209: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&, bool) @ 0x00000000208d3c2f
src/Interpreters/InterpreterExplainQuery.cpp:704: DB::InterpreterExplainQuery::executeImpl() @ 0x000000001c671901
src/Interpreters/InterpreterExplainQuery.cpp:144: DB::InterpreterExplainQuery::execute() @ 0x000000001c66f003
src/Interpreters/executeQuery.cpp:1731: 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 ()>, DB::QueryResultDetails&) @ 0x000000001ca254a8
src/Interpreters/executeQuery.cpp:1955: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001ca1ee94
src/Server/TCPHandler.cpp:774: DB::TCPHandler::runImpl() @ 0x000000002025d849
src/Server/TCPHandler.cpp:2867: DB::TCPHandler::run() @ 0x00000000202788a4
base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x000000002670b24e
base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x000000002670b8bb
base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x00000000266abdbf
base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000266a944f
start_thread @ 0x0000000000094ac3
__GI___clone3 @ 0x00000000001268c0