Re: [Firebird-devel] SET BIND OF NUMERIC TO LEGACY does not work with subtype 0

2020-08-05 Thread Ivan Přenosil
On 05.08.2020 v 11:19 Mark Rotteveel wrote: If you want to map that one as well, you will have to execute SET BIND OF INT128 TO LEGACY (which will also cover NUMERIC and DECIMAL) Thanks, now it works as I want. I have to say, I am a bit surprised that 5.5 * 6.6 leads to an INT128 with scale 2

Re: [Firebird-devel] SET BIND OF NUMERIC TO LEGACY does not work with subtype 0

2020-08-05 Thread peshkoff--- via Firebird-devel
Ivan please use for snapshot docs in ~/doc, not b2 RN. Sent from MailDroidFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] SET BIND OF NUMERIC TO LEGACY does not work with subtype 0

2020-08-05 Thread Mark Rotteveel
On 05-08-2020 10:09, Ivan Přenosil wrote: I want numeric values returned as LEGACY, i.e. BIGINT instead of INT128. However SET BIND converts only NUMERIC or DECIMAL, not NUMERIC with subtype 0. (I tried with FB4 Beta 2 and snapshot Firebird-4.0.0.2126) I am not sure whether this is a bug or I a

[Firebird-devel] SET BIND OF NUMERIC TO LEGACY does not work with subtype 0

2020-08-05 Thread Ivan Přenosil
I want numeric values returned as LEGACY, i.e. BIGINT instead of INT128. However SET BIND converts only NUMERIC or DECIMAL, not NUMERIC with subtype 0. (I tried with FB4 Beta 2 and snapshot Firebird-4.0.0.2126) I am not sure whether this is a bug or I am just using SET BIND incorrectly? Here is