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.
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 TABLET ID with inconsistent checksum on the primary table (only for the check between the local index table and the primary table) |
| INDEX_TABLET_ID | bigint(20) | NO | The TABLET ID 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. |