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