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

2012-02-02 Thread Alex Peshkoff
On 02/01/12 21:57, Adriano dos Santos Fernandes wrote: On 01-02-2012 12:46, Dmitry Yemanov wrote: 31.01.2012 2:12, Adriano dos Santos Fernandes wrote: 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

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

2012-02-02 Thread Adriano dos Santos Fernandes
On 02-02-2012 08:34, Alex Peshkoff wrote: Looks like that when introducing cursors people wanted to follow some standard that existed that time. But from today POV this commands look useless and should better be removed - specially if they cause problems with engine stability. But probably

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

2012-02-02 Thread Alex Peshkoff
On 02/02/12 16:39, Adriano dos Santos Fernandes wrote: On 02-02-2012 08:34, Alex Peshkoff wrote: Looks like that when introducing cursors people wanted to follow some standard that existed that time. But from today POV this commands look useless and should better be removed - specially if

[Firebird-devel] [FB-Tracker] Created: (CORE-3750) Error increasing limits on posix

2012-02-02 Thread Alexander Peshkov (JIRA)
Error increasing limits on posix Key: CORE-3750 URL: http://tracker.firebirdsql.org/browse/CORE-3750 Project: Firebird Core Issue Type: Bug Components: Build Issues / Porting Affects Versions:

Re: [Firebird-devel] Wrong rdb$field_sub_type for numeric computed column

2012-02-02 Thread Jiri Cincura
On Wed, Jan 18, 2012 at 11:08 PM, Ivan Prenosil ivan.preno...@seznam.cz wrote:  NumericField(9, 2) + 1 - result is .. ehm ... Num/Dec(18, 2)  (API will return zero as subtype) That's the point. What is/should be the real result in this case? I'm happy with conclusion that if field_scale is 0

Re: [Firebird-devel] Wrong rdb$field_sub_type for numeric computed column

2012-02-02 Thread Mark Rotteveel
On Thu, 2 Feb 2012 16:05:02 +0100, Jiri Cincura disk...@cincura.net wrote: On Wed, Jan 18, 2012 at 11:08 PM, Ivan Prenosil ivan.preno...@seznam.cz wrote:  NumericField(9, 2) + 1 - result is .. ehm ... Num/Dec(18, 2)  (API will return zero as subtype) That's the point. What is/should be the

[Firebird-devel] [FB-Tracker] Created: (CORE-3751) stored proc not null return param reports null error on empty resultset

2012-02-02 Thread JIRA
stored proc not null return param reports null error on empty resultset --- Key: CORE-3751 URL: http://tracker.firebirdsql.org/browse/CORE-3751 Project: Firebird Core Issue

[Firebird-devel] [FB-Tracker] Created: (CORE-3752) Extend the TracePlugin Interface

2012-02-02 Thread Oleg Matveyev (JIRA)
Extend the TracePlugin Interface Key: CORE-3752 URL: http://tracker.firebirdsql.org/browse/CORE-3752 Project: Firebird Core Issue Type: New Feature Components: API / Client Library Affects