Re: Bug or syntax error in my update query with a FROM statement ?

Thanks for your reply.
I would tend to agree with you but why doesn't it update ANY row when count() equals zero then, and ALL rows only when
thecount is not zero ? I would agree with you if ALL rows were updated in any case or did I miss something ? 
Arnaud

>The first query SHOULD update all rows, because there is NO restriction
>on the utilisateur table - a.login <> '*' is NOT the same as
>utilisateur.login <> '*' - the former qualifies the FROM clause, and the
>latter applies to the UPDATE itself.



>"Dima Tkach" <dmitry@openratings.com> a écrit dans le message de news: 3CC6A7AF.3070801@openratings.com...

>> Here's the "wrong" query :
>> update utilisateur set login='*', password='*' from utilisateur a, ancien b where a.util_id=b.util_id and
b.anc_decesis not null and >(a.login<>'*' or a.password<>'*'); 
>>
>> Here's the "correct" one :
>> update utilisateur set login='*', password='*' from ancien b where utilisateur.util_id=b.util_id and b.anc_deces is
notnull and >(utilisateur.login<>'*' or utilisateur.password<>'*'); 
>>
>> Both queries work the same when there's nothing to update, (i.e. select count(*) from utilisateur a, ancien b where
>a.util_id=b.util_idand b.anc_deces is not null and (a.login<>'*' or a.password<>'*') returns 0). 
>> But the first one ("wrong") updates ALL rows of table 'utilisateur' when the above count() is not 0, where the
secondone >("correct") updates only the rows needed. 
>>
>> What's wrong with the first query : me or the parser ? I guess the problem comes from the fact that table
'utilisateur'appears twice and is aliased which may confuse the parser in the "wrong" query... 
>>