Re: strange update

On Mon, 31 Mar 2003 16:03:29 +0200, "Marcin Buchwald" <velvet_at_agora.pl> wrote:

>select id from (select mak_xx,adno,czas_obow,min(xx) id,count(1) from
>spacer_pub where adno is not null group by mak_xx,adno,czas_obow having
>count(1)>1);
>
>...
>
>1413 rows selected
>
>All the rows are different!
>
>Next I wrote:
>
>update spacer_pub set adno=null where xx in (select id from (select
>mak_xx,adno,czas_obow,min(xx) id,count(1) from spacer_pub where adno is not
>null group by mak_xx,adno,czas_obow having count(1)>1));
>
>72 rows updated
>
>(!!!) I expected 1413 rows to be updated
>
>What about the other rows??
>
>I am using ora817eent
>
>Thanks in advance,
>
> Marcin
>

This looks like a NULL value related issue: my guess would be that there are records for which xx is NULL. Those do not satisfy the WHERE clause of the UPDATE.

Jaap. Received on Mon Mar 31 2003 - 15:52:41 CST