[DocDB] GetLockStatus returns the wrong value for table_id when querying a colocated table

[tvesely]

Jira Link: DB-7226

Description

GetLockStatus returns the wrong table_id when operating on a colocated table.

testdb=# select * from yb_lock_status(null,null);
ERROR:  Not a YSQL ID string: 00004000000030008000000000004004.colocation.parent.uuid

The PgGetLockStatusResponse:

node_locks {
  permanent_uuid: "a18b02419a354998b5bfbc499ccffe7b"
  tablet_lock_infos {
    table_id: "00004000000030008000000000004004.colocation.parent.uuid"
    tablet_id: "19a5fef75f664cc98cc5e68cbd472083"
  }
  tablet_lock_infos {
    table_id: "00004000000030008000000000004004.colocation.parent.uuid"
    tablet_id: "dc6d40f15f1e48b4b7d273c57d791f52"
    transaction_locks {
      key: "ad545d25-d35b-418c-8969-cb3c46672b1a"
      value {
<snip>
        locks {
          range_cols: "1"
          attnum: 7
          column_id: 16
          multiple_rows_locked: false
          wait_end_ht: 6918625730931699712
          subtransaction_id: 1
          is_explicit: false
          modes: STRONG_READ
          modes: STRONG_WRITE
        }
      }
    }
  }

When decoding intents we should obtain the ColocationId from the DocKey, and use that to look up the correct table_id from the tablet schema.

SubDocKey(DocKey(ColocationId=706431629, [], []), []) [kWeakRead, kWeakWrite] HT{ days: 19550 time: 16:58:54.320346 w: 3 } => TransactionId(7916e577-8f9f-4805-8cbb-8d6d47d83b2c) SubTransactionId(2) none

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.