When running compare on a table, it shows out of sync.
When running repair on the same table, it says it is in sync and does not repair the table.
Product Defect, issue is caused by looking up the out of sync row using key value in repair phase when the key value contain null or space in the middle
For example,
Key column value looks like this 'IOW 77'.
STATUS:
This issue is fixed in future release of 7.6.2.x where we will look up out of sync row in second repair phase with rowid instead.
WORK AROUND:
Use repair1 instead of repair on such tables
This should not be an issue on 7.6.2.x
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center