Re: bugs Digest 4 Aug 2004 01:10:15 -0000 Issue 618

> update foobar set id = id+10000;
> -- red is 10001, blue is 10002, green is 10003, the next auto_increment
> entry SHOULD BE 10004
>
> insert into foobar (name) values ("white");
> -- white's id is 4 instead of 10004
>
> Version:
> mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)

Must be an introduced bug. My 4.0.12 doesn't have this problem:

mysql> select * from autoinc ;
+---+--------------+
| a | name |
+---+--------------+
| 4 | fred |
| 5 | jeff |
| 6 | mark |
| 7 | lisa |
| 8 | mary |
| 9 | verchantelle |
+---+--------------+
6 rows in set (0.00 sec)

mysql> update autoinc set a=a+10000 ;
Query OK, 6 rows affected (0.00 sec)
Rows matched: 6 Changed: 6 Warnings: 0

mysql> insert into autoinc (name) values
('genevieve'),('trai-nelle'),('rachellette') ;
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select * from autoinc ;
+-------+--------------+
| a | name |
+-------+--------------+
| 10004 | fred |
| 10005 | jeff |
| 10006 | mark |
| 10007 | lisa |
| 10008 | mary |
| 10009 | verchantelle |
| 10010 | genevieve |
| 10011 | trai-nelle |
| 10012 | rachellette |
+-------+--------------+
9 rows in set (0.00 sec)

mysql> select version() ;
+------------+
| version() |
+------------+
| 4.0.12-log |
+------------+

--
pv


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org