Affects Version/s: None
Fix Version/s: 4.9.0
This bug can be re-pro against two conditions:
1. select must hit index table and have to query back to data table
2. at least one of the data table's PK column is in DESC order
see the following SQLs:
if we declare ether p1/p2 as DESC, then the same SELECT will return nothing.
if p1 is not DESC, but p2 is, SELECT will fail too.