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