Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-3416

Record Number in Row Store

    • Type: Icon: Improvement Improvement
    • Resolution: Won't Fix
    • Priority: Icon: Minor - P4 Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: Btree
    • None

      WT creates a row store if the key format is not 'r'. If the key format is 'r', then WT creates a column store.

      For a column store, WT generates the unique record number as the key in the table.

      It would be useful to have similar functionality in a row store as well.

      In many application contexts, the application generates a unique primary key, usually a numeric type. 'Sequences' are typically used for this task.

      Since WT already has the functionality in place to generate a unique record number for column stores, it would be useful if this was also available in a row store.

      Without this capability, when an application needs to generate a unique numeric identifier, it would have to create a separate table for this and implement serialisable isolation at the application layer for this capability.

      This thread on google groups has a little more contextual information
      https://groups.google.com/forum/#!topic/wiredtiger-users/r1K5AchwE3E

            Assignee:
            backlog-server-storage-engines [DO NOT USE] Backlog - Storage Engines Team
            Reporter:
            Kimman Kimman Balakrishnan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: