Error:
Logical error: 'Bad cast from type DB::ColumnFixedString to DB::ColumnLowCardinality'.
---

Failed query:
SELECT id FROM test_table__fuzz_34 WHERE (value, id) GLOBAL IN (SELECT toFixedString(toLowCardinality('not a number'), 12), * UNION ALL SELECT DISTINCT toLowCardinality(5), toString(number) FROM numbers(5))
---

Reproduce commands (auto-generated; may require manual adjustment):
CREATE TABLE test_table__fuzz_34 (`id` Decimal(76, 70), `value` Int128) ENGINE = MergeTree ORDER BY (id, value) SETTINGS index_granularity = 8192, index_granularity_bytes = '1Mi', add_minmax_index_for_numeric_columns = 0;
CREATE TABLE test_table__fuzz_34 (`id` Decimal(76, 70), `value` Int128) ENGINE = MergeTree ORDER BY (id, value) SETTINGS index_granularity = 8192, index_granularity_bytes = '1Mi', add_minmax_index_for_numeric_columns = 0;
INSERT INTO test_table__fuzz_34 SELECT number, number FROM numbers(10);
SELECT id FROM test_table__fuzz_34 WHERE (value, id) GLOBAL IN (SELECT toFixedString(toLowCardinality('not a number'), 12), * UNION ALL SELECT DISTINCT toLowCardinality(5), toString(number) FROM numbers(5));
DROP TABLE IF EXISTS test_table__fuzz_34;
---

Stack trace:
pthread_kill @ 0x00000000000969fd
raise @ 0x0000000000042476
__lgamma_r_finite @ 0x00000000000287f3
/ClickHouse/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) @ 0x00000000162ee81d
/ClickHouse/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&) @ 0x00000000162efc0d
/ClickHouse/src/Common/Exception.cpp:146:19: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000162efef9
/ClickHouse/src/Common/Exception.h:171:100: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000dc969d4
/ClickHouse/src/Common/Exception.h:57:54: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000dc964d1
/ClickHouse/src/Common/Exception.h:189:77: DB::Exception::Exception<String, String>(int, FormatStringHelperImpl<std::type_identity<String>::type, std::type_identity<String>::type>, String&&, String&&) @ 0x000000000dc93dc6
/ClickHouse/src/Common/typeid_cast.cpp:15:11: throwBadTypeidCast(std::type_info const&, std::type_info const&) @ 0x00000000163fb327
inlined from /ClickHouse/src/Common/typeid_cast.h:22: T typeid_cast<DB::ColumnLowCardinality const&, DB::IColumn const>(DB::IColumn const&)
/ClickHouse/src/Functions/FunctionsConversion.h:6152:5: DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda0'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)::operator()(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long) const @ 0x000000001a52180e
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__type_traits/invoke.h:87: std::__invoke_result_impl<void, DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda0'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long>::type std::__invoke[abi:se210105]<DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda0'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long>(DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda0'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*&&, unsigned long&&)
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__type_traits/invoke.h:334: COW<DB::IColumn>::immutable_ptr<DB::IColumn> std::__invoke_void_return_wrapper<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, false>::__call[abi:se210105]<DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda0'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long>(DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda0'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*&&, unsigned long&&)
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__type_traits/invoke.h:348: COW<DB::IColumn>::immutable_ptr<DB::IColumn> std::__invoke_r[abi:se210105]<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda0'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long>(DB::detail::FunctionCast::prepareUnpackDictionaries(std::shared_ptr<DB::IDataType const> const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda0'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*&&, unsigned long&&)
/ClickHouse/contrib/llvm-project/libcxx/include/__functional/function.h:450:27: ? @ 0x000000001a52108f
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
/ClickHouse/src/Functions/FunctionsConversion.h:5389:12: DB::detail::FunctionCast::createVariantToColumnWrapper(DB::DataTypeVariant const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)::operator()(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long) const @ 0x000000001a2bd997
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__type_traits/invoke.h:87: std::__invoke_result_impl<void, DB::detail::FunctionCast::createVariantToColumnWrapper(DB::DataTypeVariant const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long>::type std::__invoke[abi:se210105]<DB::detail::FunctionCast::createVariantToColumnWrapper(DB::DataTypeVariant const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long>(DB::detail::FunctionCast::createVariantToColumnWrapper(DB::DataTypeVariant const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*&&, unsigned long&&)
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__type_traits/invoke.h:334: COW<DB::IColumn>::immutable_ptr<DB::IColumn> std::__invoke_void_return_wrapper<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, false>::__call[abi:se210105]<DB::detail::FunctionCast::createVariantToColumnWrapper(DB::DataTypeVariant const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long>(DB::detail::FunctionCast::createVariantToColumnWrapper(DB::DataTypeVariant const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*&&, unsigned long&&)
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__type_traits/invoke.h:348: COW<DB::IColumn>::immutable_ptr<DB::IColumn> std::__invoke_r[abi:se210105]<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, DB::detail::FunctionCast::createVariantToColumnWrapper(DB::DataTypeVariant const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long>(DB::detail::FunctionCast::createVariantToColumnWrapper(DB::DataTypeVariant const&, std::shared_ptr<DB::IDataType const> const&) const::'lambda'(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*, unsigned long)&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>>&, std::shared_ptr<DB::IDataType const> const&, DB::ColumnNullable const*&&, unsigned long&&)
/ClickHouse/contrib/llvm-project/libcxx/include/__functional/function.h:450:27: ? @ 0x000000001a2bd6cf
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
/ClickHouse/src/Functions/FunctionsConversion.h:4202:12: DB::detail::ExecutableFunctionCast::executeImpl(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long) const @ 0x000000001a2adfbb
/ClickHouse/src/Functions/IFunction.cpp:365:15: DB::IExecutableFunction::executeWithoutLowCardinalityColumns(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long, bool) const @ 0x000000001a192181
/ClickHouse/src/Functions/IFunction.cpp:442:18: DB::IExecutableFunction::executeWithoutSparseColumns(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long, bool) const @ 0x000000001a1938a2
/ClickHouse/src/Functions/IFunction.cpp:577:16: DB::IExecutableFunction::executeWithoutReplicatedColumns(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long, bool) const @ 0x000000001a194dea
/ClickHouse/src/Functions/IFunction.cpp:486:20: DB::IExecutableFunction::execute(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long, bool) const @ 0x000000001a1947a1
/ClickHouse/src/Functions/IFunction.cpp:592:32: DB::IFunctionBase::execute(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long, bool) const @ 0x000000001a19529c
/ClickHouse/src/Interpreters/castColumn.cpp:38:27: DB::castColumn(DB::CastType, DB::ColumnWithTypeAndName const&, std::shared_ptr<DB::IDataType const> const&, DB::InternalCastFunctionCache*) @ 0x000000001c9bb1a3
/ClickHouse/src/Interpreters/castColumn.cpp:54:12: DB::castColumnAccurateOrNull(DB::ColumnWithTypeAndName const&, std::shared_ptr<DB::IDataType const> const&, DB::InternalCastFunctionCache*) @ 0x000000001c9bb6d7
/ClickHouse/src/Storages/MergeTree/KeyCondition.cpp:1801:41: DB::tryPrepareSetColumnsForIndex(std::vector<COW<DB::IColumn>::immutable_ptr<DB::IColumn>, std::allocator<COW<DB::IColumn>::immutable_ptr<DB::IColumn>>>&, std::vector<std::shared_ptr<DB::IDataType const>, std::allocator<std::shared_ptr<DB::IDataType const>>>&, std::vector<std::optional<DB::DeterministicKeyTransformDag>, std::allocator<std::optional<DB::DeterministicKeyTransformDag>>> const&, std::vector<std::shared_ptr<DB::IDataType const>, std::allocator<std::shared_ptr<DB::IDataType const>>> const&, std::vector<DB::MergeTreeSetIndex::KeyTuplePositionMapping, std::allocator<DB::MergeTreeSetIndex::KeyTuplePositionMapping>> const&, unsigned long) @ 0x000000001f8e979b
/ClickHouse/src/Storages/MergeTree/KeyCondition.cpp:1911:10: DB::KeyCondition::tryPrepareSetIndexForIn(DB::RPNBuilderFunctionTreeNode const&, DB::KeyCondition::BuildInfo const&, DB::KeyCondition::RPNElement&) @ 0x000000001f8ea9f4
/ClickHouse/src/Storages/MergeTree/KeyCondition.cpp:2654:21: DB::KeyCondition::extractAtomFromTree(DB::RPNBuilderTreeNode const&, DB::KeyCondition::BuildInfo const&, DB::KeyCondition::RPNElement&) @ 0x000000001f8edae0
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
inlined from /ClickHouse/contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
/ClickHouse/src/Storages/MergeTree/RPNBuilder.cpp:554:12: DB::RPNBuilder<DB::KeyCondition::RPNElement>::traverseTree(DB::RPNBuilderTreeNode const&) @ 0x000000001fcbcdd5
/ClickHouse/src/Storages/MergeTree/RPNBuilder.cpp:503:5: DB::RPNBuilder<DB::KeyCondition::RPNElement>::RPNBuilder(DB::ActionsDAG::Node const*, std::shared_ptr<DB::Context const>, std::function<bool (DB::RPNBuilderTreeNode const&, DB::KeyCondition::RPNElement&)> const&) @ 0x000000001fcbcb2b
/ClickHouse/src/Storages/MergeTree/KeyCondition.cpp:922:28: DB::KeyCondition::KeyCondition(DB::ActionsDAGWithInversionPushDown const&, std::shared_ptr<DB::Context const>, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::ExpressionActions> const&, bool, bool) @ 0x000000001f8e302f
/ClickHouse/src/Processors/QueryPlan/ReadFromMergeTree.cpp:1910:36: DB::ReadFromMergeTree::buildIndexes(std::optional<DB::ReadFromMergeTree::Indexes>&, DB::ActionsDAG const*, DB::MergeTreeData const&, DB::RangesInDataParts const&, std::optional<DB::VectorSearchParameters> const&, std::optional<DB::TopKFilterInfo>, std::shared_ptr<DB::Context const> const&, DB::SelectQueryInfo const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&) @ 0x000000002081d8c0
/ClickHouse/src/Processors/QueryPlan/ReadFromMergeTree.cpp:2170:9: DB::ReadFromMergeTree::applyFilters(DB::ActionDAGNodes) @ 0x00000000208218b6
/ClickHouse/src/Processors/QueryPlan/SourceStepWithFilter.h:60:9: DB::SourceStepWithFilterBase::applyFilters() @ 0x00000000208f89e8
/ClickHouse/src/Processors/QueryPlan/Optimizations/optimizePrimaryKeyConditionAndLimit.cpp:49:30: DB::QueryPlanOptimizations::optimizePrimaryKeyConditionAndLimit(std::vector<DB::QueryPlanOptimizations::Frame, std::allocator<DB::QueryPlanOptimizations::Frame>> const&) @ 0x00000000208f87d5
/ClickHouse/src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:586:13: DB::QueryPlanOptimizations::optimizeTreeSecondPass(DB::QueryPlanOptimizationSettings const&, DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&, DB::QueryPlan&) @ 0x00000000208ee027
/ClickHouse/src/Processors/QueryPlan/QueryPlan.cpp:580:5: DB::QueryPlan::optimize(DB::QueryPlanOptimizationSettings const&) @ 0x00000000207e9362
/ClickHouse/src/Processors/QueryPlan/QueryPlan.cpp:182:9: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&, bool) @ 0x00000000207e8c11
/ClickHouse/src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:340:34: DB::InterpreterSelectQueryAnalyzer::buildQueryPipeline() @ 0x000000001c6912b1
/ClickHouse/src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:305:29: DB::InterpreterSelectQueryAnalyzer::execute() @ 0x000000001c690e9e
/ClickHouse/src/Interpreters/executeQuery.cpp:1749:40: 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&) @ 0x000000001c9f4dfb
/ClickHouse/src/Interpreters/executeQuery.cpp:2070:11: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001c9ef463
/ClickHouse/src/Server/TCPHandler.cpp:788:68: DB::TCPHandler::runImpl() @ 0x000000002013a258
/ClickHouse/src/Server/TCPHandler.cpp:2899:9: DB::TCPHandler::run() @ 0x0000000020155e24
/ClickHouse/base/poco/Net/src/TCPServerConnection.cpp:40:3: Poco::Net::TCPServerConnection::start() @ 0x0000000026852f0e