Bug Report: Dual left join query returns more results than it should

[GuptaManan100]

Overview of the Issue

Running a query like -

select t.title, user.col from (select 'hello' as title) as t left join user on user.id=1

sometimes results in more than 1 row returned in a sharded keyspace.

This is incorrect since the query is a left join query should return only 1 row.

Reproduction Steps

Run the given query in a sharded keyspace

Binary Version

main

Operating System and Environment details

-

Log Fragments

No response