It can be reproduced with ``` :) CREATE TABLE t1 (x UInt32, y UInt64) engine = MergeTree ORDER BY (x,y); :) CREATE TABLE t2 (x UInt32, y UInt64) engine = MergeTree ORDER BY (x,y); :) SET join_algorithm = 'prefer_partial_merge'; :) SET any_join_distinct_right_table_keys = 1; :) SET join_use_nulls = 1; :) SELECT intDiv(t2.y, 65535), 1 FROM t1 FULL OUTER JOIN t2 ON (and(toUInt32(intDiv(t1.y, 1025)) = t2.x) AND and(t1.x = t2.x)) AND and(toUInt32(intDiv(t1.y, 65535)) = t2.x) ORDER BY toUInt32(intDiv(t1.y, 9223372036854775807)) DESC NULLS LAST 2021.02.10 13:57:02.255967 [ 38062 ] {47ce7103-9491-4c19-acc6-0986c30e9000} executeQuery: (from [::1]:60830, using production parser) SELECT intDiv(t2.y, 65535), 1 FROM t1 FULL OUTER JOIN t2 ON (and(toUInt32(intDiv(t1.y, 1025)) = t2.x) AND and(t1.x = t2.x)) AND and(toUInt32(intDiv(t1.y, 65535)) = t2.x) ORDER BY toUInt32(intDiv(t1.y, 9223372036854775807)) DESC NULLS LAST 2021.02.10 13:57:02.267394 [ 38062 ] {47ce7103-9491-4c19-acc6-0986c30e9000} ContextAccess (default): Access granted: SELECT(x, y) ON default.t2 2021.02.10 13:57:02.268223 [ 38062 ] {47ce7103-9491-4c19-acc6-0986c30e9000} default.t2 (80d71dc7-facf-45aa-a63e-80eda7a2a07e) (SelectExecutor): Key condition: unknown 2021.02.10 13:57:02.268380 [ 38062 ] {47ce7103-9491-4c19-acc6-0986c30e9000} default.t2 (80d71dc7-facf-45aa-a63e-80eda7a2a07e) (SelectExecutor): Selected 0 parts by partition key, 0 parts by primary key, 0 marks by primary key, 0 marks to read from 0 ranges 2021.02.10 13:57:02.268931 [ 38062 ] {47ce7103-9491-4c19-acc6-0986c30e9000} InterpreterSelectQuery: FetchColumns -> Complete 2021.02.10 13:57:02.271352 [ 38057 ] {} BaseDaemon: Received signal 11 2021.02.10 13:57:02.271983 [ 38736 ] {} BaseDaemon: ######################################## 2021.02.10 13:57:02.272243 [ 38736 ] {} BaseDaemon: (version 21.3.1.1, build id: 9F7E6921C214205D4C0398D669E7E85FE9C4DD05) (from thread 38062) (no query) Received signal Segmentation fault (11) 2021.02.10 13:57:02.272495 [ 38736 ] {} BaseDaemon: Address: 0x10 Access: read. Address not mapped to object. 2021.02.10 13:57:02.272716 [ 38736 ] {} BaseDaemon: Stack trace: 0x87dab88 0x87db013 0x117b1cd0 0x117afc5f 0x10c3d624 0x10c3b4e9 0xb8e3706 0xb8e397a 0xb8e4c12 0xaacdc8f 0xad8c58d 0x1229795f 0x1229764a 0x1290e6a3 0x129151d0 0x12911a11 0x1290ea07 0x12912329 0x1290ea73 0x125244f9 0x12517cf3 0x1251dd42 0x12521259 0x1157688f 0x11572f50 0x1156fa81 0x1156e83c 0x115e588c 0x115e3386 0x115e2c91 0x11528127 2021.02.10 13:57:02.277039 [ 38736 ] {} BaseDaemon: 4. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/boost/boost/smart_ptr/intrusive_ptr.hpp:91: boost::intrusive_ptr::intrusive_ptr(boost::intrusive_ptr const&) @ 0x87dab88 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.281051 [ 38736 ] {} BaseDaemon: 5. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Common/COW.h:128: COW::immutable_ptr::immutable_ptr(COW::immutable_ptr const&) @ 0x87db013 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.328514 [ 38736 ] {} BaseDaemon: 6. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Common/COW.h:203: COW::chameleon_ptr::chameleon_ptr::immutable_ptr const&>(COW::immutable_ptr const&) @ 0x117b1cd0 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.375878 [ 38736 ] {} BaseDaemon: 7. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Columns/ColumnConst.cpp:26: DB::ColumnConst::ColumnConst(COW::immutable_ptr const&, unsigned long) @ 0x117afc5f in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.416426 [ 38736 ] {} BaseDaemon: 8. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Common/COW.h:285: COW::mutable_ptr COWHelper::create::immutable_ptr const&, unsigned long>(COW::immutable_ptr const&, unsigned long&&) @ 0x10c3d624 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.456913 [ 38736 ] {} BaseDaemon: 9. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Functions/FunctionHelpers.cpp:74: DB::createBlockWithNestedColumns(std::__1::vector > const&) @ 0x10c3b4e9 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.471230 [ 38736 ] {} BaseDaemon: 10. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Functions/IFunction.cpp:480: DB::FunctionOverloadResolverAdaptor::getReturnTypeDefaultImplementationForNulls(std::__1::vector > const&, std::__1::function (std::__1::vector > const&)> const&) @ 0xb8e3706 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.485362 [ 38736 ] {} BaseDaemon: 11. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Functions/IFunction.cpp:493: DB::FunctionOverloadResolverAdaptor::getReturnTypeWithoutLowCardinality(std::__1::vector > const&) const @ 0xb8e397a in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.499696 [ 38736 ] {} BaseDaemon: 12. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Functions/IFunction.cpp:598: DB::FunctionOverloadResolverAdaptor::getReturnType(std::__1::vector > const&) const @ 0xb8e4c12 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.508474 [ 38736 ] {} BaseDaemon: 13. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Functions/IFunctionAdaptors.h:111: DB::FunctionOverloadResolverAdaptor::buildImpl(std::__1::vector > const&) const @ 0xaacdc8f in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.535646 [ 38736 ] {} BaseDaemon: 14. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Functions/IFunctionAdaptors.h:116: DB::FunctionOverloadResolverAdaptor::build(std::__1::vector > const&) const @ 0xad8c58d in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.594312 [ 38736 ] {} BaseDaemon: 15. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ActionsDAG.cpp:200: DB::ActionsDAG::addFunction(std::__1::shared_ptr const&, std::__1::vector >, std::__1::basic_string, std::__1::allocator >, bool) @ 0x1229795f in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.655857 [ 38736 ] {} BaseDaemon: 16. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ActionsDAG.cpp:165: DB::ActionsDAG::addFunction(std::__1::shared_ptr const&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&, std::__1::basic_string, std::__1::allocator >, DB::Context const&) @ 0x1229764a in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.724372 [ 38736 ] {} BaseDaemon: 17. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ActionsVisitor.cpp:501: DB::ScopeStack::addFunction(std::__1::shared_ptr const&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&, std::__1::basic_string, std::__1::allocator >) @ 0x1290e6a3 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.795026 [ 38736 ] {} BaseDaemon: 18. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ActionsVisitor.h:155: DB::ActionsMatcher::Data::addFunction(std::__1::shared_ptr const&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&, std::__1::basic_string, std::__1::allocator >) @ 0x129151d0 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.863904 [ 38736 ] {} BaseDaemon: 19. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ActionsVisitor.cpp:971: DB::ActionsMatcher::visit(DB::ASTFunction const&, std::__1::shared_ptr const&, DB::ActionsMatcher::Data&) @ 0x12911a11 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:02.933264 [ 38736 ] {} BaseDaemon: 20. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ActionsVisitor.cpp:546: DB::ActionsMatcher::visit(std::__1::shared_ptr const&, DB::ActionsMatcher::Data&) @ 0x1290ea07 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse DB::ActionsMatcher::visit(DB::ASTExpressionList&, std::__1::shared_ptr const&, DB::ActionsMatcher::Data&) @ 0x12912329 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.073653 [ 38736 ] {} BaseDaemon: 22. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ActionsVisitor.cpp:550: DB::ActionsMatcher::visit(std::__1::shared_ptr const&, DB::ActionsMatcher::Data&) @ 0x1290ea73 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.142767 [ 38736 ] {} BaseDaemon: 23. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InDepthNodeVisitor.h:34: DB::InDepthNodeVisitor const>::visit(std::__1::shared_ptr const&) @ 0x125244f9 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.210505 [ 38736 ] {} BaseDaemon: 24. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ExpressionAnalyzer.cpp:410: DB::ExpressionAnalyzer::getRootActions(std::__1::shared_ptr const&, bool, std::__1::shared_ptr&, bool) @ 0x12517cf3 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.278566 [ 38736 ] {} BaseDaemon: 25. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ExpressionAnalyzer.cpp:1108: DB::SelectQueryExpressionAnalyzer::appendSelect(DB::ExpressionActionsChain&, bool) @ 0x1251dd42 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.344735 [ 38736 ] {} BaseDaemon: 26. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/ExpressionAnalyzer.cpp:1492: DB::ExpressionAnalysisResult::ExpressionAnalysisResult(DB::SelectQueryExpressionAnalyzer&, std::__1::shared_ptr const&, bool, bool, bool, std::__1::shared_ptr const&, DB::Block const&) @ 0x12521259 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.394484 [ 38736 ] {} BaseDaemon: 27. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InterpreterSelectQuery.cpp:571: DB::InterpreterSelectQuery::getSampleBlockImpl() @ 0x1157688f in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.444652 [ 38736 ] {} BaseDaemon: 28. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InterpreterSelectQuery.cpp:465: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr const&, DB::Context const&, std::__1::shared_ptr const&, std::__1::optional, std::__1::shared_ptr const&, DB::SelectQueryOptions const&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&, std::__1::shared_ptr const&)::$_2::operator()(bool) const @ 0x11572f50 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.492599 [ 38736 ] {} BaseDaemon: 29. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InterpreterSelectQuery.cpp:468: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr const&, DB::Context const&, std::__1::shared_ptr const&, std::__1::optional, std::__1::shared_ptr const&, DB::SelectQueryOptions const&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&, std::__1::shared_ptr const&) @ 0x1156fa81 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.540417 [ 38736 ] {} BaseDaemon: 30. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InterpreterSelectQuery.cpp:153: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr const&, DB::Context const&, DB::SelectQueryOptions const&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&) @ 0x1156e83c in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.589679 [ 38736 ] {} BaseDaemon: 31. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/libcxx/include/memory:2068: std::__1::__unique_if::__unique_single std::__1::make_unique const&, DB::Context&, DB::SelectQueryOptions&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&>(std::__1::shared_ptr const&, DB::Context&, DB::SelectQueryOptions&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&) @ 0x115e588c in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.638108 [ 38736 ] {} BaseDaemon: 32. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InterpreterSelectWithUnionQuery.cpp:327: DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::__1::shared_ptr const&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&) @ 0x115e3386 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.686779 [ 38736 ] {} BaseDaemon: 33. /home/avtokmakov/ch/ClickHouse/build_debug/../src/Interpreters/InterpreterSelectWithUnionQuery.cpp:249: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr const&, DB::Context const&, DB::SelectQueryOptions const&, std::__1::vector, std::__1::allocator >, std::__1::allocator, std::__1::allocator > > > const&) @ 0x115e2c91 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:03.734022 [ 38736 ] {} BaseDaemon: 34. /home/avtokmakov/ch/ClickHouse/build_debug/../contrib/libcxx/include/memory:2068: std::__1::__unique_if::__unique_single std::__1::make_unique&, DB::Context&, DB::SelectQueryOptions const&>(std::__1::shared_ptr&, DB::Context&, DB::SelectQueryOptions const&) @ 0x11528127 in /home/avtokmakov/ch/ClickHouse/build_debug/programs/clickhouse 2021.02.10 13:57:06.160329 [ 38736 ] {} BaseDaemon: Calculated checksum of the binary: D1C6ACF89C18F43414CFB4B8C89FAA04. There is no information about the reference checksum. ```

Segfault in RIGHT and FULL JOIN #20046

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions