-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.
>
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
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
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
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
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
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