Purpose
The oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO view provides information about column checksum inconsistencies between the index table (including global and local indexes) and the primary table.
Note
This view is introduced since OceanBase Database V4.0.0.
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 a 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. |