Hi everyone, I am investigating a strange looking entry in our SYSTEM.CATALOG table. The row is an index table (TABLE_TYPE = i) but it does not contain any other index information (no DATA_TABLE_NAME and INDEX_TYPE, etc.).
Has anyone encountered similar situation, or is there any other way to investigate how the entry was created? By the way, is there any documentation available on the SYSTEM.CATALOG, that I can check to make I am understanding the information in this table correctly? Thanks! We are running Phoenix 4.10 (upgraded previous from 4.8 and from 4.6) Here is a few more details on this strange "index": SELECT * from system.catalog where table_schem = 'prod' and data_table_name is null and TABLE_TYPE = 'i'; TENANT_ID TABLE_SCHEM prod TABLE_NAME RULES COLUMN_NAME COLUMN_FAMILY IDX_ID_RULES TABLE_SEQ_NUM 0 TABLE_TYPE i PK_NAME COLUMN_COUNT null SALT_BUCKETS null DATA_TABLE_NAME INDEX_STATE IMMUTABLE_ROWS VIEW_STATEMENT DEFAULT_COLUMN_FAMILY DISABLE_WAL MULTI_TENANT VIEW_TYPE null VIEW_INDEX_ID null DATA_TYPE null COLUMN_SIZE null DECIMAL_DIGITS null NULLABLE null ORDINAL_POSITION null SORT_ORDER null ARRAY_SIZE null VIEW_CONSTANT IS_VIEW_REFERENCED KEY_SEQ null LINK_TYPE 1 TYPE_NAME REMARKS SELF_REFERENCING_COL_NAME REF_GENERATION BUFFER_LENGTH null NUM_PREC_RADIX null COLUMN_DEF SQL_DATA_TYPE null SQL_DATETIME_SUB null CHAR_OCTET_LENGTH null IS_NULLABLE SCOPE_CATALOG SCOPE_SCHEMA SCOPE_TABLE SOURCE_DATA_TYPE null IS_AUTOINCREMENT INDEX_TYPE null INDEX_DISABLE_TIMESTAMP null STORE_NULLS BASE_COLUMN_COUNT null IS_ROW_TIMESTAMP TRANSACTIONAL UPDATE_CACHE_FREQUENCY null IS_NAMESPACE_MAPPED AUTO_PARTITION_SEQ APPEND_ONLY_SCHEMA GUIDE_POSTS_WIDTH null COLUMN_QUALIFIER IMMUTABLE_STORAGE_SCHEME null ENCODING_SCHEME null QUALIFIER_COUNTER null We actually have the normal-looking index IDX_ID_RULES created for the RULES table, here: SELECT * from system.catalog where table_schem = 'prod' and data_table_name = 'RULES' and TABLE_TYPE = 'i'; TENANT_ID TABLE_SCHEM prod TABLE_NAME IDX_ID_RULES COLUMN_NAME COLUMN_FAMILY TABLE_SEQ_NUM 0 TABLE_TYPE i PK_NAME COLUMN_COUNT 4 SALT_BUCKETS 255 DATA_TABLE_NAME RULES INDEX_STATE a IMMUTABLE_ROWS false VIEW_STATEMENT DEFAULT_COLUMN_FAMILY DISABLE_WAL false MULTI_TENANT false VIEW_TYPE null VIEW_INDEX_ID null DATA_TYPE null COLUMN_SIZE null DECIMAL_DIGITS null NULLABLE null ORDINAL_POSITION null SORT_ORDER null ARRAY_SIZE null VIEW_CONSTANT IS_VIEW_REFERENCED KEY_SEQ null LINK_TYPE null TYPE_NAME REMARKS SELF_REFERENCING_COL_NAME REF_GENERATION BUFFER_LENGTH null NUM_PREC_RADIX null COLUMN_DEF SQL_DATA_TYPE null SQL_DATETIME_SUB null CHAR_OCTET_LENGTH null IS_NULLABLE SCOPE_CATALOG SCOPE_SCHEMA SCOPE_TABLE SOURCE_DATA_TYPE null IS_AUTOINCREMENT INDEX_TYPE 1 INDEX_DISABLE_TIMESTAMP 0 STORE_NULLS false BASE_COLUMN_COUNT -1 IS_ROW_TIMESTAMP TRANSACTIONAL false UPDATE_CACHE_FREQUENCY 0 IS_NAMESPACE_MAPPED false AUTO_PARTITION_SEQ APPEND_ONLY_SCHEMA false GUIDE_POSTS_WIDTH null COLUMN_QUALIFIER IMMUTABLE_STORAGE_SCHEME 1 ENCODING_SCHEME 2 QUALIFIER_COUNTER null