Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

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

On 01-02-2012 11:00, Alex Peshkoff wrote:
>  On 01/31/12 02:12, Adriano dos Santos Fernandes wrote:
>> All,
>>
>> There is two obscure SQL commands called READ BLOB and WRITE BLOB.
>>
>> The idea behind these commands is to make blob read/write using the
>> cursor (fetch/insert) API. Why they exist is not something I know, maybe
>> it predates blob API functions?
>>
>> Currently there is problems related to some requests receiving some
>> (theoretically invalid) operations that may even crash the server. While
>> working at it, I do think these two commands could and should be removed
>> from v3.
>>
>> Comments?
> 
> I like the suggestion, but one question. How much are we sure that this
> commands are not used in some popular client tool? Do you remember the
> case with ibase.h cleanup which broken kinterbasdb stable build? Fix is
> certainly trivial, done in SVN - but current stable kinterbasdb does not
> build with current stable firebird (2.5.1). We should better avoid such
> things.
> 

In the case of these commands, they will be removed from the parser and
will never be prepared. No API function will be changed.

Sure, some library may broke, but what the heck, a new, better, faster
and simple way to achieve the same result is present since a long time
already!

I doubt there are programs with these commands spread at every place and
them being difficult to change.


Adriano