RE: Introducing hidden row having duplicated primary key

2001-11-13 Thread Quentin Bennett
-Original Message- From: Martin MOKREJŠ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 14 November 2001 10:04 a.m. To: Gerald Clark Cc: [EMAIL PROTECTED] Subject: Re: Introducing hidden row having duplicated primary key On Tue, 13 Nov 2001, Gerald Clark wrote: > Looks correct to me. >

Re: Introducing hidden row having duplicated primary key

2001-11-13 Thread Jeremy Zawodny
On Tue, Nov 13, 2001 at 10:04:22PM +0100, Martin MOKREJS wrote: > On Tue, 13 Nov 2001, Gerald Clark wrote: > > > Looks correct to me. > > What do you think is the problem? > > > > 2 rows were affected by the replace. > > One row was deleted, and one was inserted, > > Both rows had a value of 'tes

Re: Introducing hidden row having duplicated primary key

2001-11-13 Thread Jeremy Zawodny
On Tue, Nov 13, 2001 at 12:45:17PM -0800, Jeremy Zawodny wrote: > On Tue, Nov 13, 2001 at 08:53:09PM +0100, Martin MOKREJS wrote: > > Hello, > > > > I think I've found a bug. Just by playing with REPLACE and INSERT, > > the following happened. I'm including full log, demonstrating that I > > don

Re: Introducing hidden row having duplicated primary key

2001-11-13 Thread Martin MOKREJŠ
On Tue, 13 Nov 2001, Gerald Clark wrote: > Looks correct to me. > What do you think is the problem? > > 2 rows were affected by the replace. > One row was deleted, and one was inserted, > Both rows had a value of 'test' for column 'Tab'. Cool, thanks to Jeremy Zawodny and you, now I know even mo

Re: Introducing hidden row having duplicated primary key

2001-11-13 Thread Gerald Clark
Looks correct to me. What do you think is the problem? 2 rows were affected by the replace. One row was deleted, and one was inserted, Both rows had a value of 'test' for column 'Tab'. Martin MOKREJŠ wrote: > Hello, > I think I've found a bug. Just by playing with REPLACE and INSERT, the > fo

Re: Introducing hidden row having duplicated primary key

2001-11-13 Thread Jeremy Zawodny
On Tue, Nov 13, 2001 at 08:53:09PM +0100, Martin MOKREJS wrote: > Hello, > > I think I've found a bug. Just by playing with REPLACE and INSERT, > the following happened. I'm including full log, demonstrating that I > don't understand sql at all. ;-) Can someone explain me what "2 rows > affected

Introducing hidden row having duplicated primary key

2001-11-13 Thread Martin MOKREJŠ
Hello, I think I've found a bug. Just by playing with REPLACE and INSERT, the following happened. I'm including full log, demonstrating that I don't understand sql at all. ;-) Can someone explain me what "2 rows affected" means? How can I select the second row from the table? How can I delete it