Left join returns not-matching entries with match() over right table

[glookka]

Bug Description:

Left join returns not matching entries with nulled out data when match() is specified for the right table:

drop table if exists join1;
drop table if exists join2;

create table join1 ( id bigint, title text, string_id integer, tmp string attribute, j json ) engine='columnar';
create table join2 ( id bigint, title text, string_id integer, name string attribute engine='columnar', j json );

insert into join1 values (1, 'title1', 1, 'tmp1', '{"sort":5,"a":1,"table":"join1"}');
insert into join1 values (2, 'title2', 2, 'tmp2', '{"sort":6,"b":2,"table":"join1"}');
insert into join1 values (3, 'title3', 3, 'tmp3', '{"sort":7,"c":3,"table":"join1"}');
insert into join1 values (4, 'title4', 4, 'tmp4', '{"sort":8,"d":4,"table":"join1"}');

insert into join2 values (1, 'title1', 1, 'name1', '{"sort":10,"a":1,"table":"join2"}');
insert into join2 values (2, 'title2', 2, 'name2', '{"sort":5,"b":2,"table":"join2"}');

Query:

select title, join2.title, uint(join2.j.sort) as table2, weight() * (j.sort + table2) as test2 from join1 left join join2 on join1.string_id = join2.string_id where match('title2', join2) order by test2 desc;

Result:

+--------+-------------+--------+-------+
| title  | join2.title | table2 | test2 |
+--------+-------------+--------+-------+
| title2 | title2      |      5 |    11 |
| title4 | NULL        |   NULL |     8 |
| title3 | NULL        |   NULL |     7 |
| title1 | NULL        |   NULL |     5 |
+--------+-------------+--------+-------+
4 rows in set (0.00 sec)

Manticore Search Version:

6.3.1

Operating System Version:

Any

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.}

• Implementation completed
• Tests developed
• Documentation updated
• Documentation reviewed
• Changelog updated

[glookka]

Fixed in 5b77336