- It uses the aggregate function LAST_VALUE to determine where to start a scan when a table is scanned using multiple (fast) queries rather than one slow query.
- It uses the aggregate functions UNORDERED_CHECKSUM and ORDERED_CHECKSUM to compute checksums.
ZFS would detect this error as it stores a page checksum separate from the disk page. RAID 10 might help. If writes for one of the copies was lost, then as long as your are lucky enough to read the page from the good side of the mirror, you will get the good data. But that might not be comforting. What else would help to detect and or correct this?