From: Eric D. Patterson
Date: March 15 1999 7:36pm
Subject: replace problems...
List-Archive: http://lists.mysql.com/mysql/277
Message-Id: <36ED6122.4DB82B96@halfast.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Here's an interesting one:

I have a table defined with a composite key declared thusly:
alter table big_table add primary key (a,b,c)

I then use:
replace into big_table values(1,2,3,4,5,6,7,8,9)

This should insert the row if there that key has not been used, if it
has, it should update the datain that row.

The end result is that this allows me to violate the key constraints
without erroring on me, it goes ahead and inserts a new row with the
same key values as an existing one.

--If it helps any, i recently upgraded from 3.22.12 (wherein his command
worked properly), to 3.22.19.

Please email slacker@stripped if you have any ideas what might be
causing this, it is quite important that it be resolved!!

--
"Works well when under constant supervision and cornered like a rat in a
trap."