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

--=-cENMcCMSmeMmp+YOrDim
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Tue, 2004-08-03 at 22:52, philo vivero wrote:
> > update foobar set id =3D id+10000;
> > -- red is 10001, blue is 10002, green is 10003, the next auto_increment
> > entry SHOULD BE 10004
> >=20
> > insert into foobar (name) values ("white");
> > -- white's id is 4 instead of 10004
> >=20
> > Version:
> > mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
>=20
> Must be an introduced bug. My 4.0.12 doesn't have this problem:

Did you make the table type=3DInnoDB? It's not clear from your example.

-Fred

> 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)
>=20
> mysql> update autoinc set a=3Da+10000 ;
> Query OK, 6 rows affected (0.00 sec)
> Rows matched: 6 Changed: 6 Warnings: 0
>=20
> mysql> insert into autoinc (name) values
> ('genevieve'),('trai-nelle'),('rachellette') ;
> Query OK, 3 rows affected (0.00 sec)
> Records: 3 Duplicates: 0 Warnings: 0
>=20
> 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)
>=20
> mysql> select version() ;
> +------------+
> | version() |
> +------------+
> | 4.0.12-log |
> +------------+
>=20
> --=20
> pv
--=20
Fred Mitchell, HydraNuke.com
E-Commerce and Hosting Solutions=20
Whatever you want, we'll make it happen
(603)557-5986


--=-cENMcCMSmeMmp+YOrDim
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQBBEeGFVZ97vCsahg4RAq/uAJ9/CTEZovQ/rm5y57QGdHjcy6Ts5ACd Fljh
eaho029roEgXta1mhA30xNQ=
=hqtl
-----END PGP SIGNATURE-----

--=-cENMcCMSmeMmp+YOrDim--