Re: MERGE bug?

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

the same situation...

"Shan R Shanmuganathan" <shan_at_srinidhi.net> wrote in message news:408f220d.0402262241.493d950d_at_posting.google.com...
> Try this:
>
> create table xyz ( c1 number );
>
> insert into xyz values ( 5 );
>
> 1 row created.
>
> select * from xyz;
> C1
> ----------
> 5
>
> merge into xyz
> using (select * from dual) A
> on ( 1=1 )
> when matched then
> update set c1 = 10
> when not matched then
> insert values ( 20 );
>
> 1 row merged.
>
> select * from xyz;
>
> C1
> ----------
> 10
>
> merge into xyz
> using (select * from dual) A
> on ( 1=2 )
> when matched then
> update set c1 = 10
> when not matched then
> insert values ( 20 );
>
> 0 row merged.
>
> Why is it not inserting in the second merge?
>
> 9.2 SQL reference guide allows me to use any 'condition' inside the on ().
>
> Bug??
>
> BTW, I have 9.2.0.3.0.
>
> Thanks,
> Shan R Shanmuganathan
Received on Fri Feb 27 2004 - 08:54:26 CET