LEFT JOIN on collections returns wrong results

DROP INDEX ix20 ON default.s1.c1;

DROP INDEX ix21 ON default.s1.c2;

UPSERT INTO default.s1.c1 VALUES("c1k01",{"_scope":"test", "_type":"achievement", "id":"k01", "hash":10});

UPSERT INTO default.s1.c1 VALUES("c1k02",{"_scope":"test", "_type":"achievement", "id":"k02", "hash":20});

UPSERT INTO default.s1.c1 VALUES("c1k03",{"_scope":"test", "_type":"achievement_order", "id":"k03", "hash":30});

CREATE INDEX ix20 ON default.s1.c1(`_type`,`_scope`);

CREATE INDEX ix21 ON default.s1.c2(`status`,`_type`,`hash`,`_scope`,`id`);

SELECT col_data.id AS _k, dex as c

FROM default.s1.c1 col_data

LEFT JOIN  default.s1.c2 as  dex

ON dex.id = col_data.id

   AND dex.status = 'progress'

   AND dex.`hash` != col_data.`hash`

   AND dex._scope=col_data._scope

   AND dex._type= col_data._type

WHERE col_data._scope='test' AND col_data._type IN ['achievement', 'achievement_order'];

DROP INDEX ix20 ON default;

DROP INDEX ix21 ON default;

UPSERT INTO default VALUES("c1k01",{"_scope":"test", "_type":"achievement", "id":"k01", "hash":10});

UPSERT INTO default VALUES("c1k02",{"_scope":"test", "_type":"achievement", "id":"k02", "hash":20});

UPSERT INTO default VALUES("c1k03",{"_scope":"test", "_type":"achievement_order", "id":"k03", "hash":30});

CREATE INDEX ix20 ON default(`_type`,`_scope`);

CREATE INDEX ix21 ON default(`status`,`_type`,`hash`,`_scope`,`id`);

SELECT col_data.id AS _k, dex as c

FROM default col_data

LEFT JOIN  default as  dex

ON dex.id = col_data.id

   AND dex.status = 'progress'

   AND dex.`hash` != col_data.`hash`

   AND dex._scope=col_data._scope

   AND dex._type= col_data._type

WHERE col_data._scope='test' AND col_data._type IN ['achievement', 'achievement_order'];

	                    {

	                        "#operator": "NestedLoopJoin",

	                        "#stats": {

	                            "#itemsIn": 3,

	                            "#phaseSwitches": 25,

	                            "execTime": "33.854µs",

	                            "kernTime": "1.700277ms"

	                        },

	                        "alias": "dex",

	                        "filter": "(not ((`dex`.`hash`) = (`col_data`.`hash`)))",

	                        "on_clause": "((((((`dex`.`id`) = (`col_data`.`id`)) and ((`dex`.`status`) = \"progress\")) and (not ((`dex`.`hash`) = (`col_data`.`hash`)))) and ((`dex`.`_scope`) = (`col_data`.`_scope`))) and ((`dex`.`_type`) = (`col_data`.`_type`)))",

	                        "outer": true,

{

	                        "#operator": "NestedLoopJoin",

	                        "#stats": {

	                            "#itemsIn": 3,

	                            "#itemsOut": 3,

	                            "#phaseSwitches": 31,

	                            "execTime": "11.183µs",

	                            "kernTime": "1.647968ms"

	                        },

	                        "alias": "dex",

	                        "on_clause": "((((((`dex`.`id`) = (`col_data`.`id`)) and ((`dex`.`status`) = \"progress\")) and (not ((`dex`.`hash`) = (`col_data`.`hash`)))) and ((`dex`.`_scope`) = (`col_data`.`_scope`))) and ((`dex`.`_type`) = (`col_data`.`_type`)))",

	                        "optimizer_estimates": {

	                            "cardinality": 0.00005925925925925928,

	                            "cost": 24.034868485281375,

	                            "fr_cost": 24.034868485281375,

	                            "size": 2

	                        },

	                        "outer": true,