[Firebird-devel] [FB4.0] Statement failed when COALESCE(TIMESTAMPCOLUMN, CURRENT_TIMESTAMP)

2020-08-31 Thread Eliezer Riani
Hi, Take a look at these steps (https://snipboard.io/Tzkq47.jpg) that produces an error like that: "Statement failed, SQLSTATE = HY000 message length error (encountered 12, expected 16)" Here are the steps to reproduce: isql -USER SYSDBA -pass masterkey CRE

Re: [Firebird-devel] The datatype of CURRENT_TIME and CURRENT_TIMESTAMP on FB 4.0

2020-08-31 Thread Eliezer Riani
Hi, I apologize for not located and for not knowing the SET BIND statement or DataTypeCompatibility configuration. However, I've read the Firebird 4.0 Beta2 Release Notes focusing specifically on my problem. I suggest to include mentions to the SET BIND and DataTypeCompatibility at these segments o

Re: [Firebird-devel] Set bind for numeric(38) for sum function

2020-08-31 Thread Jiří Činčura
>Windows snapshot build seems to be broken for now, use artefacts from CI: SQL> select sum(cast(1 as bigint)) from rdb$database; INPUT message field count: 0 OUTPUT message field count: 1 01: sqltype: 32752 INT128 Nullable scale: 0 subtype: 0 len: 16 : name: SUM alias: SUM : table: o

Re: [Firebird-devel] Set bind for numeric(38) for sum function

2020-08-31 Thread Dimitry Sibiryakov
31.08.2020 14:28, Jiří Činčura wrote: The firebirdsql.org show Beta 2:https://snipboard.io/Rbgm7L.jpg . Windows snapshot build seems to be broken for now, use artefacts from CI: https://github.com/FirebirdSQL/firebird/actions/runs/231772533 -- WBR, SD. Firebird-Devel mailing list, web

Re: [Firebird-devel] Set bind for numeric(38) for sum function

2020-08-31 Thread Jiří Činčura
>Current version is RC1. The firebirdsql.org show Beta 2: https://snipboard.io/Rbgm7L.jpg . -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Set bind for numeric(38) for sum function

2020-08-31 Thread Dimitry Sibiryakov
31.08.2020 14:14, Jiří Činčura wrote: SQL> show version; ISQL Version: WI-T4.0.0.1963 Firebird 4.0 Beta 2 Current version is RC1. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Set bind for numeric(38) for sum function

2020-08-31 Thread Jiří Činčura
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 l

Re: [Firebird-devel] The datatype of CURRENT_TIME and CURRENT_TIMESTAMP on FB 4.0

2020-08-31 Thread Mark Rotteveel
On 2020-08-31 00:09, Eliezer Riani wrote: Hi, I have some systems developed in Delphi, PHP, and Java. I used Firebird 2.5.9 until I've updated to the Firebird 3.0.6 without any change in my SQL's. I am now testing Firebird 4.0 from your daily builds and have a problem. The feature implemented i

Re: [Firebird-devel] The datatype of CURRENT_TIME and CURRENT_TIMESTAMP on FB 4.0

2020-08-31 Thread peshkoff--- via Firebird-devel
See DataTypeCompatibility in release notes Sent from MailDroidFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel