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

run "create table t {...} auto_increment=1000" success, but didn't take affect actually

    XMLWordPrintable

Details

    Description

      >>>CREATE TABLE t (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4

      >>>show create table t;
      --------------------------------------------------------------------+

      CREATE TABLE `t` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
      --------------------------------------------------------------------+

      the "AUTO_INCREMENT=1000" didn't take affect.

      Attachments

        Activity

          People

            Unassigned Unassigned
            hzw hzw
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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