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/[email protected]