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

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

              Dates

              Created:
              Updated:
              Resolved: