refaktor/rye

BUG: left-join should return all matching combinations of rows

refaktor opened this issue · 0 comments

left join now returns only the number of rows of the left table, but if there are two join matches in the right table it should return 2 rows for one row of the left table to have identical behavior as the SQL databases. If it's not identical you can get unexpected different behaviour when doint something you used to do with sql tables and it's then not obvious why, so I think it's best we do the same.

Screenshot_2024-11-04_09-16-46

Screenshot_2024-11-04_09-22-40