Logical error: Unexpected number of columns in result sample block: A expected B ([C] = [D] + [E] + [F]) (STID: 2980-385f)

_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: Unexpected number of columns in result sample block: A expected B ([C] = [D] + [E] + [F]) (STID: 2980-385f)
CI report: [AST fuzzer (amd_debug)](https://s3.amazonaws.com/clickhouse-test-reports/json.html?REF=master&sha=21e34d9562ba858cda50a641e67ffc749a268d6a&name_0=MasterCI&name_1=AST%20fuzzer%20%28amd_debug%29)
Failing test history: [cidb](https://play.clickhouse.com/play?user=play&run=1#V0lUSAogICAgOTAgQVMgaW50ZXJ2YWxfZGF5cwpTRUxFQ1QKICAgIHRvU3RhcnRPZkRheShjaGVja19zdGFydF90aW1lKSBBUyBkYXksCiAgICBjb3VudCgpIEFTIGZhaWx1cmVzLAogICAgZ3JvdXBVbmlxQXJyYXkocHVsbF9yZXF1ZXN0X251bWJlcikgQVMgcHJzLAogICAgYW55KHJlcG9ydF91cmwpIEFTIHJlcG9ydF91cmwKRlJPTSBjaGVja3MKV0hFUkUgKG5vdygpIC0gdG9JbnRlcnZhbERheShpbnRlcnZhbF9kYXlzKSkgPD0gY2hlY2tfc3RhcnRfdGltZQogICAgQU5EIHRlc3RfbmFtZSA9ICdMb2dpY2FsIGVycm9yOiBVbmV4cGVjdGVkIG51bWJlciBvZiBjb2x1bW5zIGluIHJlc3VsdCBzYW1wbGUgYmxvY2s6IEEgZXhwZWN0ZWQgQiAoW0NdID0gW0RdICsgW0VdICsgW0ZdKSAoU1RJRDogMjk4MC0zODVmKScKICAgIC0tIEFORCBjaGVja19uYW1lID0gJ0FTVCBmdXp6ZXIgKGFtZF9kZWJ1ZyknCiAgICBBTkQgdGVzdF9zdGF0dXMgSU4gKCdGQUlMJywgJ0VSUk9SJykKICAgIEFORCAocHVsbF9yZXF1ZXN0X251bWJlciA9IDAgT1IgYmFzZV9yZWYgSU4gKCcnLCAnbWFzdGVyJykpCiAgICBBTkQgdGVzdF9jb250ZXh0X3JhdyBMSUtFICclRXhjZXB0aW9uOiUnCkdST1VQIEJZIGRheQpPUkRFUiBCWSBkYXkgREVTQwo=)

Test output:
```
Error:
Logical error: 'Unexpected number of columns in result sample block: 3 expected 5 ([__table2, __table1.x, __table1.y] = [__table2, __table2] + [__table1.y] + [__table2, __table1.x])'.
---

Failed query:
SELECT *, '2149-06-062149-06-062149-06-062149-06-062149-06-062149-06-062149-06-062149-06-06' FROM temp WHERE toUInt8(multiIf(toInt32(256, concat((SELECT *, plus(NULL, 2147483647))), NULL), toInt32(moduloOrZero(-2147483647, (SELECT if(and(globalIn(y, tuple(intDiv(-9223372036854775808, toInt32(moduloOrZero(toInt256(toLowCardinality(1023)), (SELECT toLowCardinality(-9223372036854775808))))), globalIn(toNullable(257), 65537))), equals(minus(toUInt32(toNullable(9223372036854775807), intDivOrZero(NULL, toInt8(toLowCardinality(toNullable(1024))))), NULL), y AS alias3719)), -9223372036854775808, concat(toUInt16(256)))))), concat(multiply(NULL, toInt128(1024)), toInt16((SELECT NULL)), toUInt32(9223372036854775807, NULL, toInt128(1024), 7), '', 257))) IN (1025, toInt128(materialize(9223372036854775806)))
---

Reproduce commands (auto-generated; may require manual adjustment):
CREATE TABLE temp (`x` Decimal(38, 2), `y` Nullable(Decimal(38, 2))) ENGINE = Memory;
INSERT INTO temp FORMAT Values(32, 32), (64, 64), (128, 128), (256, 256);                     ;
SELECT *, '2149-06-062149-06-062149-06-062149-06-062149-06-062149-06-062149-06-062149-06-06' FROM temp WHERE toUInt8(multiIf(toInt32(256, concat((SELECT *, plus(NULL, 2147483647))), NULL), toInt32(moduloOrZero(-2147483647, (SELECT if(and(globalIn(y, tuple(intDiv(-9223372036854775808, toInt32(moduloOrZero(toInt256(toLowCardinality(1023)), (SELECT toLowCardinality(-9223372036854775808))))), globalIn(toNullable(257), 65537))), equals(minus(toUInt32(toNullable(9223372036854775807), intDivOrZero(NULL, toInt8(toLowCardinality(toNullable(1024))))), NULL), y AS alias3719)), -9223372036854775808, concat(toUInt16(256)))))), concat(multiply(NULL, toInt128(1024)), toInt16((SELECT NULL)), toUInt32(9223372036854775807, NULL, toInt128(1024), 7), '', 257))) IN (1025, toInt128(materialize(9223372036854775806)));
DROP TABLE IF EXISTS temp;
---

Stack trace:
pthread_kill@@GLIBC_2.34 @ 0x00000000000969fd
gsignal @ 0x0000000000042476
__lgamma_r_finite@GLIBC_2.15 @ 0x00000000000287f3
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) @ 0x00000000165aa95d
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&) @ 0x00000000165abd4d
src/Common/Exception.cpp:146:19: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000165ac039
src/Common/Exception.h:171:100: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000e5eeb94
src/Common/Exception.h:57:54: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000e5ee691
src/Common/Exception.h:189:77: DB::Exception::Exception<unsigned long, unsigned long&, String, fmt::v12::join_view<std::__wrap_iter<String*>, std::__wrap_iter<String*>, char>, String, String>(int, FormatStringHelperImpl<std::type_identity<unsigned long>::type, std::type_identity<unsigned long&>::type, std::type_identity<String>::type, std::type_identity<fmt::v12::join_view<std::__wrap_iter<String*>, std::__wrap_iter<String*>, char>>::type, std::type_identity<String>::type, std::type_identity<String>::type>, unsigned long&&, unsigned long&, String&&, fmt::v12::join_view<std::__wrap_iter<String*>, std::__wrap_iter<String*>, char>&&, String&&, String&&) @ 0x000000001cea9220
src/Interpreters/HashJoin/HashJoin.cpp:1722:19: DB::HashJoin::getNonJoinedBlocks(DB::Block const&, DB::Block const&, unsigned long, unsigned long, unsigned long) const @ 0x000000001ce97304
src/Interpreters/ConcurrentHashJoin.cpp:480:37: DB::ConcurrentHashJoin::getNonJoinedBlocks(DB::Block const&, DB::Block const&, unsigned long, unsigned long, unsigned long) const @ 0x000000001c688b8e
src/Processors/Transforms/JoiningTransform.cpp:598:35: DB::NonJoinedBlocksTransform::generate() @ 0x00000000208fbd5f
src/Processors/ISource.cpp:144:18: DB::ISource::tryGenerate() @ 0x00000000205f876a
src/Processors/ISource.cpp:110:26: DB::ISource::work() @ 0x00000000205f8441
src/Processors/Executors/ExecutionThreadContext.cpp:53: DB::executeJob(DB::ExecutingGraph::Node*, DB::ReadProgressCallback*)
src/Processors/Executors/ExecutionThreadContext.cpp:102:26: DB::ExecutionThreadContext::executeTask() @ 0x0000000020614b30
src/Processors/Executors/PipelineExecutor.cpp:351:26: DB::PipelineExecutor::executeStepImpl(unsigned long, DB::IAcquiredSlot*, std::atomic<bool>*) @ 0x0000000020606cb2
src/Processors/Executors/PipelineExecutor.cpp:279:5: DB::PipelineExecutor::executeSingleThread(unsigned long, DB::IAcquiredSlot*) @ 0x00000000206072ec
src/Processors/Executors/PipelineExecutor.cpp:565: operator()
contrib/llvm-project/libcxx/include/__type_traits/invoke.h:87: std::__invoke_result_impl<void, DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&>::type std::__invoke[abi:se210105]<DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&>(DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&)
contrib/llvm-project/libcxx/include/__type_traits/invoke.h:342: void std::__invoke_void_return_wrapper<void, true>::__call[abi:se210105]<DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&>(DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&)
contrib/llvm-project/libcxx/include/__type_traits/invoke.h:348: void std::__invoke_r[abi:se210105]<void, DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&>(DB::PipelineExecutor::spawnThreads(std::shared_ptr<DB::IAcquiredSlot>)::$_0&)
contrib/llvm-project/libcxx/include/__functional/function.h:450:17: ? @ 0x000000002060850e
contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
src/Common/ThreadPool.cpp:799:12: ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::worker() @ 0x000000001674a3f9
contrib/llvm-project/libcxx/include/__type_traits/invoke.h:0: std::__invoke_result_impl<void, void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&>::type std::__invoke[abi:se210105]<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&)
contrib/llvm-project/libcxx/include/tuple:1380: decltype(auto) std::__apply_tuple_impl[abi:se210105]<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), std::tuple<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>&, 0ul>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), std::tuple<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>&, std::__tuple_indices<0ul>)
contrib/llvm-project/libcxx/include/tuple:1384: decltype(auto) std::apply[abi:se210105]<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), std::tuple<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>&>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&)(), std::tuple<ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>&)
src/Common/ThreadPool.h:312: ThreadFromGlobalPoolImpl<false, true>::ThreadFromGlobalPoolImpl<void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*>(void (ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::ThreadFromThreadPool*&&)::'lambda'()::operator()() @ 0x0000000016750a1f
contrib/llvm-project/libcxx/include/__functional/function.h:508: ?
contrib/llvm-project/libcxx/include/__functional/function.h:772: ?
src/Common/ThreadPool.cpp:809:12: ThreadPoolImpl<std::thread>::ThreadFromThreadPool::worker() @ 0x0000000016747803
contrib/llvm-project/libcxx/include/__type_traits/invoke.h:0: std::__invoke_result_impl<void, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>::type std::__invoke[abi:se210105]<void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>(void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*&&)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*&&)
contrib/llvm-project/libcxx/include/__thread/thread.h:159: void std::__thread_execute[abi:se210105]<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*, 2ul>(std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>&, std::__tuple_indices<2ul>)
contrib/llvm-project/libcxx/include/__thread/thread.h:168: void* std::__thread_proxy[abi:se210105]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>>(void*) @ 0x000000001674e6ce
start_thread @ 0x0000000000094ac3
clone3 @ 0x00000000001268d0
```


Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Logical error: Unexpected number of columns in result sample block: A expected B ([C] = [D] + [E] + [F]) (STID: 2980-385f) #100422

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Logical error: Unexpected number of columns in result sample block: A expected B ([C] = [D] + [E] + [F]) (STID: 2980-385f) #100422

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions