JOIN: crash on count(*) w/o group by

[sanikolaev]

Bug Description:

MRE:

drop table if exists j2; create table j2; insert into j2 values(1); 
select id, count(*) from j1 left join j2 on j1.id=j2.id;

 0# sphBacktrace(int, bool) in /usr/bin/searchd
 1# CrashLogger::HandleCrash(int) in /usr/bin/searchd
 2# 0x00007F8B7FC30520 in /lib/x86_64-linux-gnu/libc.so.6
 3# JoinSorter_c::FinalizeJoin(CSphString&, CSphString&) in /usr/bin/searchd
 4# FinalExpressionCalculation(CSphQueryContext&, VecTraits_T<CSphRefcountedPtr<RtSegment_t> > const&, VecTraits_T<ISphMatchSorter*>&, bool, CSphQueryResultMeta&) in /usr/bin/searchd
 5# RtIndex_c::MultiQuery(CSphQueryResult&, CSphQuery const&, VecTraits_T<ISphMatchSorter*> const&, CSphMultiQueryArgs const&) const in /usr/bin/searchd
 6# CSphIndexStub::MultiQueryEx(int, CSphQuery const*, CSphQueryResult*, ISphMatchSorter**, CSphMultiQueryArgs const&) const in /usr/bin/searchd
 7# 0x0000557360316E76 in /usr/bin/searchd
 8# 0x0000557360660A3D in /usr/bin/searchd
 9# Threads::Coro::ExecuteN(int, std::function<void ()>&&) in /usr/bin/searchd
10# SearchHandler_c::RunLocalSearches() in /usr/bin/searchd
11# SearchHandler_c::RunSubset(int, int) in /usr/bin/searchd
12# SearchHandler_c::RunQueries() in /usr/bin/searchd
13# HandleMysqlSelect(RowBuffer_i&, SearchHandler_c&) in /usr/bin/searchd
14# ClientSession_c::Execute(std::pair<char const*, int>, RowBuffer_i&) in /usr/bin/searchd
15# SqlServe(std::unique_ptr<AsyncNetBuffer_c, std::default_delete<AsyncNetBuffer_c> >) in /usr/bin/searchd
16# MultiServe(std::unique_ptr<AsyncNetBuffer_c, std::default_delete<AsyncNetBuffer_c> >, std::pair<int, unsigned short>, Proto_e) in /usr/bin/searchd
17# 0x0000557360215BAF in /usr/bin/searchd
18# Threads::CoRoutine_c::CreateContext(std::function<void ()>, std::pair<boost::context::stack_context, Threads::StackFlavour_E>)::{lambda(boost::context::detail::transfer_t)#1}::__invoke(boost::context::detail::transfer_t) in /usr/bin/searchd
19# make_fcontext in /usr/bin/searchd

Manticore Search Version:

Manticore 6.2.13 cc9294cd6@24051604 dev (columnar 2.2.5 0c18998@240424) (secondary 2.2.5 0c18998@240424) (knn 2.2.5 0c18998@240424)

Operating System Version:

Ubuntu Jammy (dev2)

Have you tried the latest development version?

• Yes

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

• Task estimated
• Specification created, reviewed, and approved
• Implementation completed
• Tests developed
• Documentation updated
• Documentation proofread
• Changelog updated

[glookka]

Fixed in 997bab9