BUG: left-join should return all matching combinations of rows
refaktor opened this issue · 0 comments
refaktor commented
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.