Re: [Firebird-devel] Reported datatype
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=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Reported datatype
On Wed, Nov 25, 2015, at 07:39, Jiří Činčura wrote: > Not sure if it's correct (or where I found that information ;)). Ha, looks like I was already there: http://markmail.org/message/skkpcjl3wnnjzqfl. -- 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=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Reported datatype
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=/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=/4140Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Reported datatype
Hi *, I have a query where (only) one field (expression) is this: OUTPUT SQLDA version: 1 sqln: 20 sqld: 1 01: sqltype: 581 INT64 Nullable sqlscale: -9 sqlsubtype: 0 sqllen: 8 When I do "show view ..." the datatype is reported as BIGINT. Is that correct? Looks like it should be NUMERIC/DECIMAL based on `scale`, but the `subtype` has confusing value. All fields in the query's expression are DECIMAL(18,4). Thanks JC. -- 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=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Reported datatype
What is the query you use? 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. Mark - Reply message - Van: "Jiří Činčura" <j...@cincura.net> Aan: "For discussion among Firebird Developers" <firebird-devel@lists.sourceforge.net> Onderwerp: [Firebird-devel] Reported datatype Datum: di, nov. 24, 2015 19:15 Hi *, I have a query where (only) one field (expression) is this: OUTPUT SQLDA version: 1 sqln: 20 sqld: 1 01: sqltype: 581 INT64 Nullable sqlscale: -9 sqlsubtype: 0 sqllen: 8 When I do "show view ..." the datatype is reported as BIGINT. Is that correct? Looks like it should be NUMERIC/DECIMAL based on `scale`, but the `subtype` has confusing value. All fields in the query's expression are DECIMAL(18,4). Thanks JC. -- 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=/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=/4140Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel