Why would you want to manually set an AUTO_INCREMENT column?? You might
as well use an integer column if you want to be able to change its
values...
- TIM
> >Description:
>
> On some releases of mysql, after you manually set an AUTO_INCREMENT
> column to a negative value, the AUTO_INCREMENT fails.
>
> On mysql 3.23.32
> mysql> DROP TABLE IF EXISTS temp;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> CREATE TABLE temp(
> -> id INT NOT NULL AUTO_INCREMENT,
> -> foo VARCHAR(255),
> -> PRIMARY KEY(id));
> Query OK, 0 rows affected (0.02 sec)
>
> mysql> INSERT INTO temp (id,foo) VALUES (-1, "works");
> Query OK, 1 row affected (0.00 sec)
>
> mysql> INSERT INTO temp (foo) VALUES ("works");
> Query OK, 1 row affected (0.00 sec)
>
> mysql> INSERT INTO temp (foo) VALUES ("doesn't");
> Query OK, 1 row affected (0.00 sec)
>
> mysql> select * from temp;
> +----+---------+
> | id | foo |
> +----+---------+
> | -1 | works |
> | 0 | works |
> | 1 | doesn't |
> +----+---------+
> 3 rows in set (0.00 sec)
>
> mysql>
>
> On mysql 3.23.37:
>
> mysql> DROP TABLE IF EXISTS temp;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> CREATE TABLE temp(
> -> id INT NOT NULL AUTO_INCREMENT,
> -> foo VARCHAR(255),
> -> PRIMARY KEY(id));
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> INSERT INTO temp (id,foo) VALUES (-1, "works");
> Query OK, 1 row affected (0.00 sec)
>
> mysql> INSERT INTO temp (foo) VALUES ("works");
> Query OK, 1 row affected (0.00 sec)
>
> mysql> INSERT INTO temp (foo) VALUES ("doesn't");
> ERROR 1062: Duplicate entry '2147483647' for key 1
>
> mysql> SELECT * FROM temp;
> +------------+-------+
> | id | foo |
> +------------+-------+
> | -1 | works |
> | 2147483647 | works |
> +------------+-------+
> 2 rows in set (0.03 sec)
>
>
> >How-To-Repeat:
>
> DROP TABLE IF EXISTS temp;
> CREATE TABLE temp(
> id INT NOT NULL AUTO_INCREMENT,
> foo VARCHAR(255),
> PRIMARY KEY(id));
> INSERT INTO temp (id,foo) VALUES (-1, "works");
> INSERT INTO temp (foo) VALUES ("works");
> INSERT INTO temp (foo) VALUES ("doesn't");
>
> >Fix:
>
> None knwn.
>
> >Submitter-Id: <submitter ID>
> >Originator: Andrew Barros
> >Organization:
> Andrew Barros <[EMAIL PROTECTED]>
> GPG Key Fingerprint:
> EC9C DFC5 C565 E90C 0FFA C4E7 539F DE81 2A92 E07D
> <http://andy.netherweb.com/>
> _ _ _
> _ _ ___| |_| |_ ___ _ _ _ _ ___| |_
> | ' \/ -_) _| ' \/ -_) '_| ' \/ -_) _|
> |_||_\___|\__|_||_\___|_| |_||_\___|\__|
> >
> >MySQL support: [none | licence | email support | extended email support ]
> none
> >Synopsis: Problem involving negative values and AUTO_INCREMENT
> >Severity: non-critical
> >Priority: medium
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.37 (Source distribution)
>
> >Environment:
>
> System: Linux discovery 2.4.1 #1 Tue Jan 30 23:44:03 EST 2001 i686 unknown
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
> gcc version 2.95.4 20010506 (Debian prerelease)
> Compilation info: CC='gcc' CFLAGS='-O2 -g' CXX='g++' CXXFLAGS='-O2 -g
>-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 13 May 7 19:43 /lib/libc.so.6 ->
>libc-2.2.3.so
> -rwxr-xr-x 1 root root 1105224 May 6 16:19 /lib/libc-2.2.3.so
> -rw-r--r-- 1 root root 2529096 May 6 16:21 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 May 6 16:21 /usr/lib/libc.so
> -rw-r--r-- 1 root root 712844 Mar 31 00:23 /usr/lib/libc-client.so.2000
> Configure command: ./configure --prefix=/usr --exec-prefix=/usr
>--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
>--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
>--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
>--with-berkeley-db --with-innodb --with-gemini --enable-static --enable-shared
>--with-raid --enable-thread-safe-client --without-readline
>--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql
>--without-bench --with-extra-charsets=all
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php