It definitely is redundant. The code happen to run queries generated
by a script, and the script generated it thay way. I removed the set
part when this problem is found. But still I am not sure why it
resulted in hanging the query.
-Deepesh.
Da Man <jeffc_at_sympatico.ca> wrote in message news:<j53guu88t4aac4dodkf62v1rgam25pbbuc_at_4ax.com>...
> What does look a little strange is your setting the primary_key_field
> = 100 but your where clause is looking for primary_key_field = 100.
> That seems redundent to me.
>
>
> On 27 Nov 2002 17:06:11 -0800, deepesh_garg_at_yahoo.com (Deepesh Garg)
> wrote:
>
> >Hi,
> >I am running a query of this sort (on Oracle 8i) and it seems to hang
> >most of the time. Can anyone tell me why does it hangs.
> >
> >update some_table set some_field = 'some value', primary_key_field =
> >100 where primary_key_field = 100
> >
> >I know its stupid, but I want to know that why this type of query
> >hangs. If I remove the primari_key_field = 100 from set part of the
> >query, it runs fine.
