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

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

2012-01-19 Thread Mark Rotteveel
On Wed, 18 Jan 2012 23:08:36 +0100, Ivan Prenosil ivan.preno...@seznam.cz wrote: I have a table: recreate table test ( base numeric(15,4), test1 computed by (base+base), test2 computed by (cast(base+base as numeric(15,4))), foo bigint, bar numeric(15,4) ); If I run the query:

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

2012-01-18 Thread Mark Rotteveel
On Wed, 18 Jan 2012 08:58:09 +0100, Jiri Cincura disk...@cincura.net wrote: Hi *, I have a table: recreate table test ( base numeric(15,4), test1 computed by (base+base), test2 computed by (cast(base+base as numeric(15,4))), foo bigint, bar numeric(15,4) ); If I run the