I don't see this bug:
-----
mysql> INSERT INTO test VALUES(1,1);
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO test VALUES(1,2);
ERROR 1062: Duplicate entry '1' for key 1
-----
Which is, in fact, the correct response, since id1 is PRIMARY KEY.
> -----Original Message-----
> From: mslade@stripped [mailto:mslade@stripped]
> Sent: Thursday, July 01, 1999 1:28 PM
> To: mysql@stripped
> Subject: bug!!!!
>
>
> >Description:
> replace can remove a row
> >How-To-Repeat:
> do this:
> CREATE TABLE test (
> id1 int(11) DEFAULT '0' NOT NULL,
> id2 int(11) DEFAULT '0' NOT NULL,
> PRIMARY KEY (id1),
> UNIQUE id2 (id2)
> );
> INSERT INTO test VALUES(1,1);
> INSERT INTO test VALUES(1,2);
>
> "select * from test;" for visual aid, then:
> REPLACE INTO test VALUES(1,2);
> "select * from test;" again.
> );
> >Fix:
> dunno.
>
> >Submitter-Id: don't have one
> >Originator: Michael Slade
> >Organization: Micksoft, Inc.
> >MySQL support: [none | licence | email support | extended email support ]
> >Synopsis: REPLACE can remove rows
> >Severity: non-critical
> >Priority: low
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.22.23b (Source distribution)
> >Server: /usr/bin/mysqladmin Ver 7.11 Distrib 3.22.23b, for
> pc-linux-gnu on i586
> TCX Datakonsult AB, by Monty
>
> Server version 3.22.23b
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 1 day 4 hours 53 min 12 sec
> (oh, must you know THAT?...)
>
> Threads: 1 Questions: 779 Slow queries: 0 Opens: 33 Flush
> tables: 1 Open tables: 9
> >Environment:
> linux x86, glib 2.1
> System: Linux mickpc 2.2.5 #7 SMP Sat Apr 10 02:52:27 EST 1999
> i586 unknown
> Architecture: i586
>
> Some paths: /usr/local/bin/perl /usr/bin/make
> /home/mslade/progs/gcc /home/mslade/progs/cc
> GCC: Reading specs from
> /usr/lib/gcc-lib/i586-pc-linux-gnu/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release)
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> Configure command: ./configure --prefix=/usr
> Perl: This is perl, version 5.005_03 built for i586-linux-thread
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread6392@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
