fix(txn): for lossy indexes, change comparison function to first check the txn cache

fix(txn): for lossy indexes, change comparison function to first check the txn cache #9658