Re: [Firebird-devel] Strange CAST result

2022-05-25 Thread Mark Rotteveel
On 25-05-2022 10:08, artyom.abakumov wrote: The CAST function returns a strange result in the following case: SQL> SELECT CAST(345.12e-2 as VARCHAR(10)) from RDB$DATABASE; CAST == 3.45 Is it a correct behavior? LI-V4.0.2.2770 Firebird 4.0 It does seem off, I would expect it to output

[Firebird-devel] Strange CAST result

2022-05-25 Thread artyom.abakumov
Hi! The CAST function returns a strange result in the following case: SQL> SELECT CAST(345.12e-2 as VARCHAR(10)) from RDB$DATABASE; CAST == 3.45 Is it a correct behavior? LI-V4.0.2.2770 Firebird 4.0 Artyom Firebird-Devel mailing list, web interface at https://lists.sourceforge.net