Log files: clickhouse-server.err.log, stderr.log
Error:
Logical error: 'No available columns'.
---
Failed query:
SELECT DISTINCT toTypeName(if(1, CAST((1, 2), 'Tuple(UInt8, UInt8)'), CAST((3, 4), 'Tuple(UInt8, UInt8)'))), count(_CAST([toLowCardinality(toNullable(('name', NULL))), ('', NULL)], 'Map(String, Nullable(Nothing))'), tup.s) FROM t_nullable_tuple SETTINGS optimize_functions_to_subcolumns = 1. (ILLEGAL_TYPE_OF_ARGUMENT) (version 26.4.1.409) (from [::1]:50562) (comment: 04039_count_nullable_tuple_subcolumn.sql-test_7) (query 18, line 37) (in query: SELECT DISTINCT toTypeName(if(1, CAST((1, 2), 'Tuple(UInt8, UInt8)'), CAST((3, 4), 'Tuple(UInt8, UInt8)'))), count(_CAST([toLowCardinality(toNullable(('name', NULL))), ('', NULL)], 'Map(String, Nullable(Nothing))'), tup.s) FROM t_nullable_tuple SETTINGS optimize_functions_to_subcolumns = 1), Stack trace (when copying this message, always include the lines below):
---
Stack trace:
__pthread_kill_implementation @ 0x0000000000082009
gsignal @ 0x000000000003a83c
__GI_abort @ 0x0000000000027134
src/Common/Exception.cpp:60:5: DB::abortOnFailedAssertion(String const&, std::basic_string_view<char, std::char_traits<char>>, void* const*, unsigned long, unsigned long) @ 0x0000000029bf5040
src/Common/Exception.cpp:93:13: DB::handle_error_code(String const&, std::basic_string_view<char, std::char_traits<char>>, int, bool, std::vector<void*, std::allocator<void*>> const&) @ 0x0000000029bf7310
src/Common/Exception.cpp:146:19: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000029bf787c
./src/Common/Exception.h:171:100: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000001a7641a8
./src/Common/Exception.h:57:54: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000001a762e88
./src/Common/Exception.h:189:77: DB::Exception::Exception<>(int, FormatStringHelperImpl<>) @ 0x0000000029c013a4
src/Interpreters/ExpressionActions.cpp:929:15: DB::ExpressionActions::getSmallestColumn(DB::NamesAndTypesList const&) @ 0x0000000038425f58
src/Planner/PlannerJoinTree.cpp:471:41: DB::(anonymous namespace)::prepareBuildQueryPlanForTableExpression(std::shared_ptr<DB::IQueryTreeNode> const&, DB::SelectQueryOptions const&, std::shared_ptr<DB::PlannerContext>&) @ 0x0000000037269d94
src/Planner/PlannerJoinTree.cpp:2748:9: DB::buildJoinTreeQueryPlan(std::shared_ptr<DB::IQueryTreeNode> const&, DB::SelectQueryInfo const&, DB::SelectQueryOptions&, std::unordered_set<String, std::hash<String>, std::equal_to<String>, std::allocator<String>> const&, std::shared_ptr<DB::PlannerContext>&) @ 0x000000003725d42c
src/Planner/Planner.cpp:2022:32: DB::Planner::buildPlanForQueryNode() @ 0x0000000037214fa0
src/Planner/Planner.cpp:1778:9: DB::Planner::buildQueryPlanIfNeeded() @ 0x000000003720f420
src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:359:13: DB::InterpreterSelectQueryAnalyzer::getQueryPlan() @ 0x0000000038777b64
src/Interpreters/executeQuery.cpp:1752:48: 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>>&, boost::intrusive_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>, std::function<void ()>, DB::QueryResultDetails&) @ 0x0000000038e21724
src/Interpreters/executeQuery.cpp:2199:11: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000038e19290
src/Interpreters/executeQuery.cpp:2146:27: DB::executeASTFuzzerQueries(boost::intrusive_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, double, bool) @ 0x0000000038e35870
src/Interpreters/executeQuery.cpp:2256: operator()
inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:87: std::__invoke_result_impl<void, DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum)::$_0&, DB::QueryPipelineFinalizedInfo const&, std::chrono::time_point<std::chrono::system_clock, std::chrono::duration<long long, std::ratio<1l, 1000000l>>>>::type std::__invoke[abi:fe210105]<DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum)::$_0&, DB::QueryPipelineFinalizedInfo const&, std::chrono::time_point<std::chrono::system_clock, std::chrono::duration<long long, std::ratio<1l, 1000000l>>>>(DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum)::$_0&, DB::QueryPipelineFinalizedInfo const&, std::chrono::time_point<std::chrono::system_clock, std::chrono::duration<long long, std::ratio<1l, 1000000l>>>&&)
inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:342: void std::__invoke_void_return_wrapper<void, true>::__call[abi:fe210105]<DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum)::$_0&, DB::QueryPipelineFinalizedInfo const&, std::chrono::time_point<std::chrono::system_clock, std::chrono::duration<long long, std::ratio<1l, 1000000l>>>>(DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum)::$_0&, DB::QueryPipelineFinalizedInfo const&, std::chrono::time_point<std::chrono::system_clock, std::chrono::duration<long long, std::ratio<1l, 1000000l>>>&&)
inlined from ./contrib/llvm-project/libcxx/include/__type_traits/invoke.h:348: void std::__invoke_r[abi:fe210105]<void, DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum)::$_0&, DB::QueryPipelineFinalizedInfo const&, std::chrono::time_point<std::chrono::system_clock, std::chrono::duration<long long, std::ratio<1l, 1000000l>>>>(DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum)::$_0&, DB::QueryPipelineFinalizedInfo const&, std::chrono::time_point<std::chrono::system_clock, std::chrono::duration<long long, std::ratio<1l, 1000000l>>>&&)
./contrib/llvm-project/libcxx/include/__functional/function.h:450:25: ? @ 0x0000000038e39998
inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
inlined from ./contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
src/QueryPipeline/BlockIO.cpp:70:12: DB::BlockIO::onFinish(std::chrono::time_point<std::chrono::system_clock, std::chrono::duration<long long, std::ratio<1l, 1000000l>>>) @ 0x0000000035d2b8f0
src/Server/TCPHandler.cpp:0: DB::TCPHandler::runImpl() @ 0x000000004147e068
src/Server/TCPHandler.cpp:2963:9: DB::TCPHandler::run() @ 0x00000000414b9028
base/poco/Net/src/TCPServerConnection.cpp:40:3: Poco::Net::TCPServerConnection::start() @ 0x000000004e307438
base/poco/Net/src/TCPServerDispatcher.cpp:115:42: Poco::Net::TCPServerDispatcher::run() @ 0x000000004e30810c
base/poco/Foundation/src/ThreadPool.cpp:205:14: Poco::PooledThread::run() @ 0x000000004e2240f8
./base/poco/Foundation/src/Thread_POSIX.cpp:341:27: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000004e21d820
contrib/llvm-project/compiler-rt/lib/asan/asan_interceptors.cpp:239:28: asan_thread_start(void*) @ 0x000000001a707e88
start_thread @ 0x0000000000080398
thread_start @ 0x00000000000e9e9c
Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.
Test name: Logical error: No available columns (STID: 3938-33a6)
CI report: Stress test (arm_asan_ubsan, s3)
Failing test history: cidb
Test output: