Re: [Firebird-devel] Updatable cursors are in need of some touchup

[Adriano d. S. F. <adr...@uo...>]

Dmitry Yemanov escreveu:
>> Now, for the first problem.  I cannot use the sh.QTY in the FOR UPDATE list.
>> I can’t even use the fully qualified name of the table as a prefix.
>> I have to actually use the field name without any relation name or alias 
>> at all.
>>     
>
> Right, this is accordingly to the SQL specification. What you need could 
> be done in ten minutes, but we already have a few places in the parser 
> marked with "IBO hack" (table aliases in INSERT and UPDATE, for example) 
> :-) And the intention was to restore the standard syntax as soon as IBO 
> is fixed. So, I really doubt that we need more such "hacks" now.
>   
What you mean in "this is accordingly to the SQL specification"?
AFAIR, the spec allows table aliases in UPDATE and DELETE.

And I see in UPDATE syntax:
/* CVC: This option should be deprecated! The only allowed syntax should be
Update...set column = expr, without qualifier for the column. */

I think this comment is wrong.


Adriano