Hi,
why is the result still numeric(38) and not numeric(18) (the "legacy" type)?
SQL> set bind of numeric(38) to legacy;
SQL> select sum(cast(1 as bigint)) from rdb$database;
INPUT message field count: 0
OUTPUT message field count: 1
01: sqltype: 32752 NUMERIC(38) Nullable scale: 0 subtype: 0 len: 16
: name: SUM alias: SUM
: table: owner:
SUM
=============================================
1
SQL> show version;
ISQL Version: WI-T4.0.0.1963 Firebird 4.0 Beta 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.1963
Firebird 4.0 Beta 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.1963
Firebird 4.0 Beta 2/tcp (x2pc)/P16:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.1963
Firebird 4.0 Beta 2/tcp (x2pc)/P16:C"
on disk structure version 13.0
SQL>
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
