PROBE side Should consider index order for pagaination

create index ix10 ON default (lc1,lc2 DESC, lc3);

create index ix12 ON default (rc1,rc2 DESC, rc3);

 EXPLAIN SELECT l.lc1, r.rc2 FROM default AS l JOIN default r USE HASH (PROBE) ON l.lc3 = r.rc3 WHERE l.lc1 = 10 AND r.rc1 = 30 ORDER BY r.rc2 DESC;