Auto increment works with step 2

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Fastex
Posts: 15
Joined: Wed 20 Oct 2010 08:52

Auto increment works with step 2

Post by Fastex » Mon 22 Aug 2016 21:37

Hello!
I use dbFOrge for MySQL 7.1.13. I have some table in my database.
For example:

Code: Select all

CREATE TABLE Certification.Applicant (
  ID int(11) NOT NULL AUTO_INCREMENT,
  ApplicantName varchar(255) NOT NULL COMMENT 'Заявитель',
  CreateUserID int(11) NOT NULL COMMENT 'Пользователь, создавший запись',
  CreateDateTime datetime NOT NULL COMMENT 'Дата создания записи',
  LastEditUserID int(11) DEFAULT NULL COMMENT 'Последний редактировавший пользователь',
  LastEditDateTime datetime DEFAULT NULL COMMENT 'Дата и время последнего редактирования',
  Deleted tinyint(1) NOT NULL COMMENT 'Признак удаления записи',
  PRIMARY KEY (ID),
  UNIQUE INDEX ApplicantName (ApplicantName)
)
ENGINE = MYISAM
AUTO_INCREMENT = 1
CHARACTER SET utf8
COLLATE utf8_general_ci
COMMENT = 'Заявители';
If i try add the first record to this table, field "ID" sets value 1, but if i try add one more record, field "ID" sets value 3 (not 2). And any new records will increment with step 2: 1, 3, 5, 7, 9, 11...

What am i doing wrong?

alexa

Re: Auto increment works with step 2

Post by alexa » Tue 23 Aug 2016 07:13

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

Fastex
Posts: 15
Joined: Wed 20 Oct 2010 08:52

Re: Auto increment works with step 2

Post by Fastex » Tue 23 Aug 2016 07:20

This issue also is in UniDAC

alexa

Re: Auto increment works with step 2

Post by alexa » Tue 23 Aug 2016 09:57

A more detailed investigation of this issue has revealed that this is the behavior of the MySQL server itself.

Post Reply