Bug #71114 | I got issue for multiple insert in mysql for AutoIncrement number for table. | ||
---|---|---|---|
Submitted: | 9 Dec 2013 6:45 | Modified: | 9 Dec 2013 10:16 |
Reporter: | Nishit Modi | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 5.6.15, 5.7.3-m13 | OS: | Windows |
Assigned to: | CPU Architecture: | Any | |
Tags: | AutoIncrement Sequence Issue |
[9 Dec 2013 6:45]
Nishit Modi
[9 Dec 2013 9:57]
Hartmut Holzgraefe
Looks as if auto_increment IDs were prefetched for all SELECT results without taking LIMIT into account ... Not a bug as there is no guarantee on auto_increment being without gaps, just that the ID sequence will be monotonous, so "only" a feature request IMHO to handle INSERT INTO...SELECT with LIMIT in a more clever, less surprising way ...
[9 Dec 2013 10:13]
MySQL Verification Team
Hello Nishit, Thank you for the bug report, duplicate of http://bugs.mysql.com/bug.php?id=61058 See, http://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html Thanks, Umesh
[9 Dec 2013 10:19]
Peter Laursen
@Nishit .. You are reproting this as an issue with "SQLYog Ultimate - Mysql GUI v9.50". SQLyog is not a program from Oracle (it is a 3rd party client distributed by Webyog). However sinde this is reproducible in *pure SQL* it is not licent specific. Version should be changed to the MySQL server version in case - or "any". Client-specific issues with SQLyog )what this reprot is not) are irrelevant for this bugs systems. You should report those to http://forums.webyog.com or send a mail to support@webyog.com. Peter (not a MySQL/Oracle person - but working for Webyog)
[9 Dec 2013 10:24]
Peter Laursen
@Nishit .. one more point. What is your setting of 'innodb_autoinc_lock_mode' variable? If it is "1" you will most likely achieve the behavior you expect by changing this server variable to "0" (and as far as I can understand it does not really matter as long as you don't use replication)