>Description:
On a table with a auto_increment/primary constraint is it not possible to
insert an id with value 0 but it is possible to insert it with another
id and use update to set it to 0, thereby making the backup import later
fail due to the use of "insert" statements.
>How-To-Repeat:
mysql> DROP TABLE test;
Query OK, 0 rows affected (0.07 sec)
mysql> CREATE TABLE `test` (
-> `id` int(10) unsigned NOT NULL auto_increment,
-> PRIMARY KEY (`id`)
-> ) TYPE=InnoDB PACK_KEYS=1 ;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values(0);
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.00 sec)
mysql> update test set id = 0;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
mysql> select * from test;
+----+
| id |
+----+
| 0 |
+----+
1 row in set (0.00 sec)
>Fix:
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: none
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.18-standard (Official MySQL RPM)
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux 2.4.20-8bigmem #1 SMP Thu Mar 13 17:32:29 EST 2003 i686 i686 i386
GNU/Linux
Architecture: i686
Some paths: /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking
--with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux
Thread model: posix
gcc version 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=i486 -fno-strength-reduce' CXX='gcc'
CXXFLAGS='-O2 -mcpu=i486 -fno-strength-reduce -felide-constructors
-fno-exceptions -fno-rtti ' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Oct 3 2003 /lib/libc.so.6 -> libc-2.3.2.so
-rwxr-xr-x 1 root root 1549556 Mar 14 2003 /lib/libc-2.3.2.so
-rw-r--r-- 1 root root 2321376 Mar 14 2003 /usr/lib/libc.a
-rw-r--r-- 1 root root 204 Mar 13 2003 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Oct 3 2003 /usr/lib/libc-client.a ->
c-client.a
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static'
'--with-client-ldflags=-all-static' '--with-server-suffix=-standard'
'--without-embedded-server' '--without-berkeley-db' '--with-innodb' '--without-vio'
'--without-openssl' '--enable-assembler' '--enable-local-infile'
'--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc'
'--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man' '--enable-thread-safe-client'
'--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O2 -mcpu=i486
-fno-strength-reduce' 'CXXFLAGS=-O2 -mcpu=i486 -fno-strength-reduce
-felide-constructors -fno-exceptions -fno-rtti ' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
