Yup. I use credit a lot but also pay off my cards every pay period. I get that it sucks for merchants, but you know what sucks worse: getting cheated like this on a debit/cash transaction, or worse having your debit card skimmed.
A relative of mine had the latter and the bank froze her account for weeks while investigating. If it was a credit card they’d just freeze the transaction and maybe send you a replacement card with different #