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

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 proba

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 - speciall

[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: 2

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 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 and no particular

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 wrote: > On Wed, Jan 18, 2012 at 11:08 PM, Ivan Prenosil > 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

[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

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

2012-02-02 Thread Jiri Cincura
On Thu, Feb 2, 2012 at 4:13 PM, Mark Rotteveel wrote: > That is what is done in Jaybird right now. > > See getDataType(...) and getDataTypeName(...) in > http://firebird.cvs.sourceforge.net/viewvc/firebird/client-java/src/main/org/firebirdsql/jdbc/AbstractDatabaseMetaData.java?view=markup That's

[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 Versi