Ah, that simple :). I do think it is a bug though.
Mark
----- Reply message -----
Van: "Jiří Činčura" <j...@cincura.net>
Aan: <firebird-devel@lists.sourceforge.net>
Onderwerp: [Firebird-devel] Reported datatype
Datum: wo, nov. 25, 2015 07:39
On Tue, Nov 24, 2015, at 19:30, Mark Rotteveel wrote:
> What is the query you use?
select sum(field1 * (field2 + field3)) from ...
But basically any operation with these fields gives me subtype 0.
> I know that Firebird sometimes doesn't reports the subtype for
> decimal/numeric, and then you only have the scale to go on. Or at least,
> Jaybird has code to handle cases like this (subtype 0, negative scale) so
> I assume Firebird does or has done this, I have never actually seen a
> case myself.
I have similar code in FirebirdClient as well. It defaults to DECIMAL.
Not sure if it's correct (or where I found that information ;)).
--
Mgr. Jiří Činčura
Independent IT Specialist
------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
