binstr merge issue with non-unique first column

K2InformaticsGmbH / imem

Clustered in-memory database based on MNESIA with simple SQL layer

http://www.k2informatics.ch/

Apache License 2.0

21 stars 4 forks source link

Open stoch opened 3 years ago

stoch commented 3 years ago

grafik

stoch commented 3 years ago

OK, if all duplicates are removed:

grafik

stoch commented 3 years ago

It seems that as long as sort order is ok in left and right table (for both colums at least) the result is ok:

grafik

stoch commented 3 years ago

Sort error is appearing in result, sort is wrong on second column (which is OK):

grafik