Purpose
The oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO view displays the information about column checksum inconsistencies between the index table (including global and local indexes) and the primary table.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| FROZEN_SCN | bigint(20) unsigned | NO | The SCN of the current compaction. |
| INDEX_TYPE | varchar(12) | NO | The type of the index table.Valid values:0: indicates a local index table.1: indicates a global index table. |
| DATA_TABLE_ID | bigint(20) | NO | The ID of the primary table. |
| INDEX_TABLE_ID | bigint(20) | NO | The ID of the global or local index table. |
| DATA_TABLET_ID | bigint(20) | NO | The ID of the tablet with inconsistent checksums on the primary table (only for verification between the local index table and the primary table) |
| INDEX_TABLET_ID | bigint(20) | NO | The ID of the tablet with inconsistent checksums on the index table (only for verification between the local index table and the primary table). |
| COLUMN_ID | bigint(20) | NO | The ID of the column with the checksum error. |
| DATA_COLUMN_CHECKSUM | bigint(20) | NO | The checksum of this column in the primary table. |
| INDEX_COLUMN_CHECKSUM | bigint(20) | NO | The checksum of this column in the index table. |