Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21181

Automatic invisible primary key

    XMLWordPrintable

Details

    Description

      Feature request - new option innodb_automatic_pk (default off, global/session)

      During CREATE TABLE for InnoDB, automatically translate

      -- FROM:

      CREATE TABLE t1 (c2 INT) ENGINE=InnoDB;

      -- TO:

      CREATE TABLE t1 (_inv_PK SERIAL INVISIBLE PRIMARY KEY, c2 INT) ENGINE=InnoDB;

      -- FROM:

      ALTER TABLE t1 ADD PRIMARY KEY (`c2`);

      -- TO:

      ALTER TABLE t1 DROP COLUMN IF EXISTS _inv_PK, ADD PRIMARY KEY (`c2`);

      It might be a good idea to modify or suppress warning "Can't DROP COLUMN `_inv_PK`" and to issue a warning that _inv_PK was created.

      Here's a question, should the user be able to do

      select _inv_PK from t1;

      or should the column be completely internal and "not exist" from the user point of view?
      If one can select it, it's be kind of like ROWID in Oracle.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-28412 Introduce sql_require_primary_key

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-10177 Invisible columns

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-19506 Remove the global sequence DICT_HDR_ROW_ID for DB_ROW_ID

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-24001 Implement hidden PK for RBR of no-unique key table

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-24830 Write a warning to error log if Galera replicates InnoDB table with no primary key

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25551 Assertion `mode_ == m_local || transaction_.is_streaming()` failed in BF abort

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30430 Enabling system versioning on tables without primary key breaks replication

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-38011 Forbid RBR Replication and Galera for tables without at least one key (not necessarily unique) OR implement hidden row-key for replication.

          • Major - Major loss of function.
          • Open

          Activity

            People

              gkodinov Georgi Kodinov
              mg MG
              Votes:
              4 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.