Bug #77590 auto_increment
Submitted: 1 Jul 2015 22:39 Modified: 6 Jul 2015 16:36
Reporter: Lieven Roegiers Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:any availeble OS:Any
Assigned to: CPU Architecture:Any
Tags: count error cant read

[1 Jul 2015 22:39] Lieven Roegiers 
Description:
so you wil not have a 0 or 1 number and you wil not to mutch 000000000 at id's
so i extra check for my accounds zo i use preset 
afer can i check if my id is under preset it wil be not corrects.

How to repeat:
CREATE TABLE `email`(
       `id`      INT(20)ZEROFILL NOT NULL AUTO_INCREMENT,
       `email`  VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
       `emailchecked` ENUM('TRUE','FALSE')NOT NULL DEFAULT 'FALSE',
       `emailsubscribed` ENUM('TRUE','FALSE')NOT NULL DEFAULT 'FALSE',
       `ENABLED` ENUM('TRUE','FALSE')NOT NULL DEFAULT 'TRUE',
       PRIMARY KEY (`id`,`email`)
       )ENGINE = InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;alter table `email` AUTO_INCREMENT=250011001;

Suggested fix:
so it wil not work 
i dont now
it wil works if i use 2 query commits
(alter table `email` AUTO_INCREMENT=250011001;)wil make the fail if it is use at one query
[2 Jul 2015 12:54] MySQL Verification Team 
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.
[6 Jul 2015 16:36] Lieven Roegiers 
alter table accound AUTO_INCREMENT=165400100001;
wil not works with error

exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine' in x:\importantcodefile.php:173 

alter table accound AUTO_INCREMENT=1654001001;
and this wil works gread so it can maybe 
*mysql
*PDO
I think that pdo can not count more than "10 000 000 000"

keywords: 
database failed , 
not working after gread working, 
fail after years working
ERROR after years working

general cote:
IT are one's and zero's.be the one and your not the only one.IF you understand it.