Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Alex Peshkoff via Firebird-devel
On 02/02/18 22:19, Dimitry Sibiryakov wrote: 02.02.2018 20:03, Mark Rotteveel wrote: I have the feeling I'm missing part of the discussion here   Thunderbird used to reply to author of message directly instead of sending reply to list. It can be changed in settings. That's my fault - two

[Firebird-devel] Fwd: Re: DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Alex Peshkoff via Firebird-devel
Mark & others - this is missing email Forwarded Message Subject: Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled? Date: Fri, 2 Feb 2018 21:32:46 +0300 From: Alex Peshkoff To: Dimitry Sibiryakov On 02/02/18 21:15, Dimitry Sibiryakov wrote:

Re: [Firebird-devel] Fwd: Re: DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Mark Rotteveel
On 3-2-2018 09:39, Alex Peshkoff via Firebird-devel wrote: Mark & others - this is missing email   Because SQL_DEC* values according to IEEE are, actually, floating-point values, they must be treated the same way as SQL_FLOAT and SQL_DOUBLE, IMHO. I.e. like numerics based on SQL_DOUBLE in d

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Mark Rotteveel
To summarize the proposed change: The SQL_DEC_FIXED type is dropped in favour of using SQL_DEC34 with subtypes, and I assume this to also mean the blr_dec_fixed is removed, including the need to send the scale separately in the request BLR. As a result, SQL_DEC34 will represent: DECFLOAT wit

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Dmitry Yemanov
03.02.2018 16:05, Mark Rotteveel wrote: I assume this to also mean the blr_dec_fixed is removed From the client-server interaction - yes, but supposedly not in general, as it still can back physical field storage / PSQL variables / etc. Dmitry -

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Dimitry Sibiryakov
03.02.2018 14:05, Mark Rotteveel wrote: 1. When sending values from client to server, will Firebird reject values with the wrong scale for subtypes 1 and 2, or round them to the correct scale? As an example, will sending 12.345 (12345e-3) for a DECIMAL(34,2) be rejected with an incorrect scale

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Dimitry Sibiryakov
03.02.2018 14:19, Dmitry Yemanov wrote: 03.02.2018 16:05, Mark Rotteveel wrote: I assume this to also mean the blr_dec_fixed is removed From the client-server interaction - yes, but supposedly not in general, as it still can back physical field storage / PSQL variables / etc. Variables

Re: [Firebird-devel] DEC_FIXED implementation, Decimal128 is unscaled?

2018-02-03 Thread Mark Rotteveel
On 3-2-2018 14:19, Dmitry Yemanov wrote: 03.02.2018 16:05, Mark Rotteveel wrote: I assume this to also mean the blr_dec_fixed is removed From the client-server interaction - yes, but supposedly not in general, as it still can back physical field storage / PSQL variables / etc. Why that s