Skip to content

Logical error: Block structure mismatch in A stream: different number of columns: (STID: 0993-21b2) #92533

@Avogar

Description

@Avogar

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: Block structure mismatch in A stream: different number of columns: (STID: 0993-21b2)
CI report: AST fuzzer (amd_ubsan)
CIDB statistics: cidb

Test output:

Error:
Logical error: 'Block structure mismatch in after optimization convertAnyJoinToSemiOrAntiJoin stream: different number of columns:
__table1.b UInt8 Const(size = 0, UInt8(size = 1)), __table1.a UInt8 Const(size = 0, UInt8(size = 1)), __table1.b UInt8 Const(size = 0, UInt8(size = 1)), __table1.a UInt8 Const(size = 0, UInt8(size = 1))
__table1.b UInt8 Const(size = 0, UInt8(size = 1)), __table1.a UInt8 Const(size = 0, UInt8(size = 1))'.
---

Failed query:
SELECT DISTINCT 2 FROM (SELECT 2 AS b, 1 AS a GROUP BY 1, toUInt256(1), 1, and(and(2, rand(materialize(toLowCardinality(2))), assumeNotNull(isNull(isNullable(2))) AND (and(rand(isZeroOrNull(2)), 2, *) AND 1) AND (assumeNotNull(2) AND rand(2)) AND (* AND isNotNull(toLowCardinality(2))), (* AND rand(isNullable(2))) AND isNotNull(2), isNullable(materialize(1)), *), 2, rand(toLowCardinality(2))) WITH CUBE WITH TOTALS) AS foo ANY LEFT JOIN (SELECT * AND ((isNullable(isZeroOrNull(toNullable(1))) AND *) AND rand(2)), 2 AS b, 1 AS a) AS bar ON and(foo.b = bar.b, foo.a = bar.b) WHERE (and(*, toNullable(2), * AND * AND isNotNull(2) AND * AND and(*) AND isNotNull(1), rand(2)) AND *) AND (1 AND assumeNotNull(2)) AND assumeNotNull(isNull(2)) AND (* AND (* AND isZeroOrNull(2)) AND isNull(toNullable(2))) ORDER BY ALL ASC NULLS FIRST
---

Reproduce commands (auto-generated; may require manual adjustment):
SELECT DISTINCT 2 FROM (SELECT 2 AS b, 1 AS a GROUP BY 1, toUInt256(1), 1, and(and(2, rand(materialize(toLowCardinality(2))), assumeNotNull(isNull(isNullable(2))) AND (and(rand(isZeroOrNull(2)), 2, *) AND 1) AND (assumeNotNull(2) AND rand(2)) AND (* AND isNotNull(toLowCardinality(2))), (* AND rand(isNullable(2))) AND isNotNull(2), isNullable(materialize(1)), *), 2, rand(toLowCardinality(2))) WITH CUBE WITH TOTALS) AS foo ANY LEFT JOIN (SELECT * AND ((isNullable(isZeroOrNull(toNullable(1))) AND *) AND rand(2)), 2 AS b, 1 AS a) AS bar ON and(foo.b = bar.b, foo.a = bar.b) WHERE (and(*, toNullable(2), * AND * AND isNotNull(2) AND * AND and(*) AND isNotNull(1), rand(2)) AND *) AND (1 AND assumeNotNull(2)) AND assumeNotNull(isNull(2)) AND (* AND (* AND isZeroOrNull(2)) AND isNull(toNullable(2))) ORDER BY ALL ASC NULLS FIRST
---

Stack trace:
__GI___pthread_kill @ 0x00000000000969fd
raise @ 0x0000000000042476
__lgamma_r_finite @ 0x00000000000287f3
src/Common/Exception.cpp:54: DB::abortOnFailedAssertion(String const&, std::basic_string_view<char, std::char_traits<char>>, void* const*, unsigned long, unsigned long) @ 0x000000001fd0e39d
src/Common/Exception.cpp:87: DB::handle_error_code(String const&, std::basic_string_view<char, std::char_traits<char>>, int, bool, std::vector<void*, std::allocator<void*>> const&) @ 0x000000001fd0f1ff
src/Common/Exception.cpp:138: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001fd0f572
DB::Exception::Exception(String&&, int, String, bool) @ 0x0000000013c10ee3
DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000013c10481
inlined from ./src/Common/Exception.h:141: Exception<std::basic_string_view<char, std::char_traits<char> > &, std::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::basic_string<char, std::char_traits<char>, std::allocator<char> > >
src/Core/Block.cpp:44: void DB::onError<void, std::basic_string_view<char, std::char_traits<char>>&, String, String>(int, FormatStringHelperImpl<std::type_identity<std::basic_string_view<char, std::char_traits<char>>&>::type, std::type_identity<String>::type, std::type_identity<String>::type>, std::basic_string_view<char, std::char_traits<char>>&, String&&, String&&)
src/Core/Block.cpp:141: void DB::checkBlockStructure<void>(DB::Block const&, DB::Block const&, std::basic_string_view<char, std::char_traits<char>>, bool) @ 0x0000000026fbf82f
src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:36: DB::(anonymous namespace)::checkHeaders(DB::QueryPlan::Node const&, std::basic_string_view<char, std::char_traits<char>>, unsigned long) @ 0x000000002f4e4f9e
src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:37: DB::(anonymous namespace)::checkHeaders(DB::QueryPlan::Node const&, std::basic_string_view<char, std::char_traits<char>>, unsigned long) @ 0x000000002f4e4fb0
src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:141: DB::QueryPlanOptimizations::optimizeTreeFirstPass(DB::QueryPlanOptimizationSettings const&, DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&) @ 0x000000002f4e3bca
src/Processors/QueryPlan/QueryPlan.cpp:582: DB::QueryPlan::optimize(DB::QueryPlanOptimizationSettings const&) @ 0x000000002f38df98
src/Processors/QueryPlan/QueryPlan.cpp:182: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&, bool) @ 0x000000002f38d53c
src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:375: DB::InterpreterSelectQueryAnalyzer::buildQueryPipeline() @ 0x0000000028cdcd19
src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:340: DB::InterpreterSelectQueryAnalyzer::execute() @ 0x0000000028cdc8e4
src/Interpreters/executeQuery.cpp:1738: 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&) @ 0x00000000290fdd15
src/Interpreters/executeQuery.cpp:1959: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x00000000290f8707
src/Server/TCPHandler.cpp:776: DB::TCPHandler::runImpl() @ 0x000000002ea26c02
src/Server/TCPHandler.cpp:2866: DB::TCPHandler::run() @ 0x000000002ea49edc
base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x00000000346fbe0c
base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x00000000346fc71c
base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x0000000034685534
./base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000034681c13
start_thread @ 0x0000000000094ac3
__GI___clone3 @ 0x00000000001268c0

Metadata

Metadata

Assignees

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