Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
11.8.3
-
None
-
Not for Release Notes
Description
Ich habe in einer Datenbank exakt eine Tabelle mit einem Eintrag. Dieser Eintrag wurde einmalig erzeugt und nie verändert, so dass AUTO_INCREMENT auf 2 steht. Die Abfrage
mysql -e 'select TABLE_SCHEMA, TABLE_NAME, TABLE_ROWS, AUTO_INCREMENT from information_schema.TABLES where TABLE_SCHEMA="admin"'
|
liefert das Ergebnis
+--------------+------------+------------+----------------+
|
| TABLE_SCHEMA | TABLE_NAME | TABLE_ROWS | AUTO_INCREMENT |
|
+--------------+------------+------------+----------------+
|
| admin | pure_ftpd | 0 | 2 |
|
+--------------+------------+------------+----------------+
|
wobei TABLE_ROWS = 1 sein müsste.
Die Definition der Tabelle:
CREATE TABLE `pure_ftpd` (
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'internal id',
|
`account` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'account and login name',
|
`password` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'password encoded by crypt()',
|
`disabled` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '>0: account disable',
|
`uid` smallint(5) unsigned NOT NULL DEFAULT 472 COMMENT 'user id, default is 470=''wwwrun''',
|
`gid` smallint(5) unsigned NOT NULL DEFAULT 474 COMMENT 'group id, default is 471=''www''',
|
`basedir` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'FTP base path',
|
`info` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'any additionally info',
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `account` (`account`)
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
|