Skip to content

Logical error: No available columns (STID: 3938-33a6) #101324

@SmitaRKulkarni

Description

@SmitaRKulkarni

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:

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    fuzzProblem found by one of the fuzzerstestingSpecial issue with list of bugs found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions