ROWID

Owned by Mike Donovan (Deactivated)
Aug 31, 2017
1 min read

In the context of usage with Dbvisit Replicate it’s important to distinguish two meanings of ROWID:

  1. ROWID as a datatype of a table column. This is what is generally meant by the mention of “ROWID datatype support”. You have to create such a column explicitly in a table, and populate it with whatever values you want. In this sense it is just a simple column, and the contents must be format-valid ROWID, but it does not need to point to any existing row anywhere. The PLOG will then contain such column data as for any other column, only that the datatype will be ROWID.

  2. ROWID as pointer to the row being replicated. It is possible for MINE to add this information to the PLOG, although by default, this is disabled. To enable it, set _MINE_ADD_ROWID_TO_PLOG=YES. When enabled, the PLOG entry will contain tag TAG_ROWID (0x00020033), with 4 (uint32_t) values: data_object_id, file number, block, slot (so it’s a ROWID deconstructed to its components).