[memo] merge joins must use globally sorted indexes

[memo] merge joins must use globally sorted indexes #8007