List:General Discussion« Previous MessageNext Message »
From:Jay Miller Date:July 1 1999 6:39pm
Subject:RE: bug!!!!
View as plain text  
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.

Thread
bug!!!!mslade1 Jul
  • RE: bug!!!!Jay Miller1 Jul
  • Re: bug!!!!Paul DuBois1 Jul
  • Re: bug!!!!Andrew Moody1 Jul
RE: bug!!!!Darren L Sweeney1 Jul
  • Re: bug!!!!Micksa) Slade1 Jul
RE: bug!!!!Darren L Sweeney1 Jul