[Firebird-devel] [FB-Tracker] Created: (CORE-6481) Dialect 1. Not consistent result of two expressions with divide of NUMERIC with scale
Dialect 1. Not consistent result of two expressions with divide of NUMERIC with scale - Key: CORE-6481 URL: http://tracker.firebirdsql.org/browse/CORE-6481 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.8 Environment: Database with first dialect Reporter: Kovalenko Dmitry Priority: Minor Not consistent result of two expressions with divide: 1. cast(2 as NUMERIC(2, 1)) / cast(3 as NUMERIC(2,0)) returns DOUBLE value: 0.6(6) without any information about scale 2. cast(cast(2 as NUMERIC(2, 1)) / cast(3 as NUMERIC(2,0)) AS VARCHAR(32)) returns VARCHAR value: 0.7 --- d:\Program_Files\Firebird_3_0_x64>isql Use CONNECT or CREATE DATABASE to specify a database SQL> CONNECT "inet4://localhost/d:\database\RAM\IBP_TEST_FB30_D1.GDB"; Database: "inet4://localhost/d:\database\RAM\IBP_TEST_FB30_D1.GDB", User: HOME4\DIMA SQL> SET SQLDA_DISPLAY ON; SQL> select cast(2 as NUMERIC(2, 1)) / cast(3 as NUMERIC(2,0)) from dual; INPUT message field count: 0 OUTPUT message field count: 1 01: sqltype: 480 DOUBLE scale: 0 subtype: 0 len: 8 : name: DIVIDE alias: DIVIDE : table: owner: DIVIDE === 0. SQL> select cast(cast(2 as NUMERIC(2, 1)) / cast(3 as NUMERIC(2,0)) AS VARCHAR(32)) from dual; INPUT message field count: 0 OUTPUT message field count: 1 01: sqltype: 448 VARYING scale: 0 subtype: 0 len: 32 charset: 0 NONE : name: CAST alias: CAST : table: owner: CAST 0.7 - -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-6480) Multiple sum query cause ad incorrect SQLDA structure error
Multiple sum query cause ad incorrect SQLDA structure error --- Key: CORE-6480 URL: http://tracker.firebirdsql.org/browse/CORE-6480 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Beta 2 Environment: WINDOWS 10, INTEL CORE I9 9900, 64GB RAM Client sofdtware : DLEPHI, IBEXPERT (same error) Reporter: William Pristia This query SELECT SUM(QUANTITA_NETTA) QUANTITA_MATURATA_COMPENSATA, SUM(QUANTITA_SOTTO_MINIMO) QUANTITA_SOTTO_MINIMO, SUM(QUANTITA_SOPRA_MASSIMO) QUANTITA_SOPRA_MASSIMO, SUM(QUANTITA_VALUTATA) QUANTITA_VALUTATA, SUM(QUANTITA_SVOLTA) QUANTITA_SVOLTA, SUM(QUANTITA_SVOLTA_FESTIVO) QUANTITA_SVOLTA_FESTIVO, SUM(QUANTITA_SVOLTA_NOTTURNO) QUANTITA_SVOLTA_NOTTURNO FROM APP_SORVEGLIANTI_DATI_S SDG INNER JOIN APP_CONTRATTI_DATI CD ON (CD.ID_CONTRATTO_DATO=SDG.ID_CONTRATTO_DATO) INNER JOIN APP_SYS_TP_CONTRATTO_DATO TCD ON (TCD.ID_TP_CONTRATTO_DATO=SDG.ID_TP_CONTRATTO_DATO_MISURA) WHERE SDG.ID_PAGA=53 AND SDG.ID_SORVEGLIANTE=260 AND SDG.ID_ASSUNZIONE=501 AND CD.ID_CONTRATTO_DATO=1566 AND ((SDG.DATA_INIZIO BETWEEN '01.01.2021' AND '31.01.2021') OR (SDG.DATA_FINE BETWEEN '01.01.2021' AND '31.01.2021')) and all queries of this kind generate this error : An error was found in the application program input parameters for the SQL statement. Incorrect values within SQLDA structure. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
I am a simple user, so I must accommodate their policies. But I embrace this idea. Congratulations to all for your work -- Ismael - Original Message - From: "Dmitry Yemanov" To: "For discussion among Firebird Developers" Sent: Tuesday, February 02, 2021 9:07 AM Subject: Re: [Firebird-devel] Usage of 32b version of Firebird 02.02.2021 16:47, Mark Rotteveel wrote: A policy that says for example that Firebird 4.0 is the last to provide x86-32 builds might be good enough. I'd suggest to keep x86 builds for the v4.x series and remove them from v5 onwards (but keep the codebase compilable on 32-bits). Whether v5 x86 packages will be snapshot-only or built by 3rd parties or completely absent -- to be decided later. +1 Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
02.02.2021 16:47, Mark Rotteveel wrote: A policy that says for example that Firebird 4.0 is the last to provide x86-32 builds might be good enough. I'd suggest to keep x86 builds for the v4.x series and remove them from v5 onwards (but keep the codebase compilable on 32-bits). Whether v5 x86 packages will be snapshot-only or built by 3rd parties or completely absent -- to be decided later. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
02.02.2021 15:47, Mark Rotteveel wrote: For Embedded, I think that people still needing 32-bit and Embedded, are likely not using the latest and greatest version of Firebird. A policy that says for example that Firebird 4.0 is the last to provide x86-32 builds might be good enough. +1 Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
On 2021-02-02 11:14, Tony Whyman wrote: There is an important point sitting here for support of legacy applications. While a standalone x86 Firebird Server is likely to be of increasingly little interest, an x86 client library may need to be supported for much longer. This then gives rise to the question: what about the embedded server. Does that have to be available for x86? The question is, do those use case even update/upgrade their Firebird installs? I'm continuing to be amazed by people steadfastly continuing to use - for example - Firebird 1.5, 12 years after its last release (and even then, they are sometimes not even using the last 1.5 release). That said, continuing to provide a 32 bit client library is probably warranted, if only to prevent issues with client applications and tools (for example, FlameRobin 64-bit was broken, not sure if it still is, while 32-bit worked OK). For Embedded, I think that people still needing 32-bit and Embedded, are likely not using the latest and greatest version of Firebird. A policy that says for example that Firebird 4.0 is the last to provide x86-32 builds might be good enough. Mark Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] SIO_LOOPBACK_FAST_PATH deprecated
On 2021-02-02 00:35, Leyne, Sean wrote: Vlad, https://www.gitmemory.com/issue/grpc/grpc/18057/486312183 There is no mention of SIO_LOOPBACK_FAST_PATH in this link https://support.microsoft.com/en-us/topic/stop-error-0xd1-when-you-set- the-sio-loopback-fast-path-flag-in-windows-8-or-windows-server-2012- 14399334-f3a8-b731-3799-12899a79bf35 The HotFix is from 2012, with the last update in 2015. I think that the underlying issue has been resolved/mitigated. Given Microsoft documents this feature with: """ *Important* The SIO_LOOPBACK_FAST_PATH is deprecated and is not recommended to be used in your code. """ I think it is safe to assume they couldn't fix certain important issues with this feature. Given its usage is actively discouraged by Microsoft, we should either remove it entirely, or disable it by default. Mark Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
On 2/2/21 3:33 PM, Jiří Činčura wrote: Yes, good point :) Onli some new feature need new client. But It is rather rare, but happen as e.g compression as i remember. Basically whenever a new protocol version is created. Not all features make sense for old apps. What sense in having statement timeouts or SQL batches in client library if app is not aware about them? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
> Yes, good point :) > Onli some new feature need new client. But It is rather rare, but > happen as e.g compression as i remember. Basically whenever a new protocol version is created. -- 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] Usage of 32b version of Firebird
02.02.2021, 08:52, "Jiří Činčura" : Yes, client library must be 32 bit too for the long time. Many existig applications are 32bit and cannot be "migrated" to 64 bit in the near futureOn the other hand, these applications can still use older fbclient.dll. --Mgr. Jiří Činčurahttps://www.tabsoverspaces.com/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel Are there usage metrics for 32-bit versions? Here in Brazil about 30% of my company's customers still use 32-bit OS, while some of these machines can support 64-bit OS there are other issues that block the update, such as legacy 16-bit applications, older hardware with drivers available only for 32-bit etc ... Due to the financial crisis caused by the pandemic, we cannot discard or force our customers to upgrade, so we will probably be stuck with Firebird 3.x. Anyway, although I really hate supporting old hardware and systems, if there are no technical blocks I think 32bit versions should be supported by at least one more major version (up to 4.1 maybe 5.0) as deprecated. Luis H.Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
Yes, good point :)Onli some new feature need new client. But It is rather rare, but happen as e.g compression as i remember.Regards,Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
> Yes, client library must be 32 bit too for the long time. > Many existig applications are 32bit and cannot be "migrated" to 64 bit > in the near future On the other hand, these applications can still use older fbclient.dll. -- 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] Usage of 32b version of Firebird
Yes, client library must be 32 bit too for the long time.Many existig applications are 32bit and cannot be "migrated" to 64 bit in the near futureRegards,Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
On Tue, 2 Feb 2021 13:31:10 +0300 Alex Peshkoff via Firebird-devel wrote: > On 2/2/21 12:16 PM, Paul Reeves wrote: > > I doubt that our user base for 32-bit ARM is really very significant but > > 32-bit ARM chips probably have a good future ahead of them. > > Not sure. I visited eShop - only 46 cheap-most phones of 616 have 32-bit > CPUs. And they use chips developed in 2014. All the rest are at least > Cortex-A53. Actually, I wasn't thinking about phones. I was thinking more on the lines of the early Raspberries. And there are many more similar products such as Arduino. These 32-bit processor designs can have h/w costs that are almost in pennies, not dollars. That market is only going to get bigger. But as I said, we don't really have much of a user base there. At least at the moment. tl;dr - 32-bit x86 is more or less dead but 32-bit processors will be around for some time to come. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Producing isc_arg_warning
On 2/2/21 1:59 PM, Jiří Činčura wrote: Hi *, what action should I do to get isc_arg_warning? Revoke non-existing grant. In employee: SQL> revoke EXECUTE ON PROCEDURE ADD_EMP_PROJ from john; Warning: EXECUTE on ADD_EMP_PROJ is not granted to JOHN. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Producing isc_arg_warning
Hi *, what action should I do to get isc_arg_warning? -- 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] Usage of 32b version of Firebird
02.02.2021 11:31, Alex Peshkoff via Firebird-devel wrote: I'm unsure what to do with FB4. We used to publish 32-bit binaries for beta & rc - i.e. looks like they should be in release too but I see no other reason why should they be in release... In contrast to 32->64 porting, maintaining of 32 build for generally 64 bits sources requires next to no effort. The only issue is int128 which in Firebird is done by external library anyway. We can provide only x86_64 official release package but snapshots/CI artefact can be freely available for 32 bits as well. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
On 2/2/21 12:16 PM, Paul Reeves wrote: On Tue, 2 Feb 2021 11:32:42 +0300 Alex Peshkoff via Firebird-devel wrote: On 2/1/21 10:24 PM, marius adrian popa wrote: My guess old cpus or installs Example got laptop with Windows 10 32 that is still supported by > Microsoft also have an old laptop with Ubuntu 32bit also another old > raspberry pi that is 32 bit only I doubt all that list is worth having _new_ versions 32 bit. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel Presumably the original question implied x86 rather than 32-bit in general. I doubt that our user base for 32-bit ARM is really very significant but 32-bit ARM chips probably have a good future ahead of them. Not sure. I visited eShop - only 46 cheap-most phones of 616 have 32-bit CPUs. And they use chips developed in 2014. All the rest are at least Cortex-A53. 32-bit x86 chips seem to largely have gone the way of 16-bit x86. Exactly. I certainly ask myself the question about x86 quite frequently. I can see a reason for maintaining support in the code base but I find it hard to justify producing official x86 binaries for new versions of Firebird. Yes. I just want to make clean what do we mean under 'new versions'. On my mind version 3 that already had 32-bit binaries for a long time should continue providing them in maintaness releases. Post-4 version (still not sure 4.1, 5.0 - but it does not matter now) has absolutely no reasons to support 32-bit HW (at least x86, but sooner of all no armv7a too). I'm unsure what to do with FB4. We used to publish 32-bit binaries for beta & rc - i.e. looks like they should be in release too but I see no other reason why should they be in release... Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
There is an important point sitting here for support of legacy applications. While a standalone x86 Firebird Server is likely to be of increasingly little interest, an x86 client library may need to be supported for much longer. This then gives rise to the question: what about the embedded server. Does that have to be available for x86? On 02/02/2021 09:25, marius adrian popa wrote: Current Ubuntu LTS is 64 bit , only with selected packages for 32 bit apps (Thanks to Steam and Wine apps) https://www.omgubuntu.co.uk/2019/06/ubuntu-is-dropping-all-32-bit-support-going-forward Even FreeBSD moved i386 to Tier 2 for FreeBSD 13.x https://lists.freebsd.org/pipermail/freebsd-announce/2021-January/002006.html So in the end my guess 32 bit is only for legacy apps (Think Delphi apps without source code ... ) Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
> I doubt that our user base for 32-bit ARM is really very significant but > 32-bit ARM chips probably have a good future ahead of them. 32-bit x86 chips > seem to largely have gone the way of 16-bit x86. What 32-bit ARM you have in mind? I wouldn't put my bet on ARMv6, ARMv5, etc. ;) Not sure about the Cortex either. Also, you're right. I was more about x86 vs AMD64, but I used to 32-bit as a simplification. -- 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] Usage of 32b version of Firebird
Current Ubuntu LTS is 64 bit , only with selected packages for 32 bit apps (Thanks to Steam and Wine apps) https://www.omgubuntu.co.uk/2019/06/ubuntu-is-dropping-all-32-bit-support-going-forward Even FreeBSD moved i386 to Tier 2 for FreeBSD 13.x https://lists.freebsd.org/pipermail/freebsd-announce/2021-January/002006.html So in the end my guess 32 bit is only for legacy apps (Think Delphi apps without source code ... ) On Tue, Feb 2, 2021 at 11:17 AM Paul Reeves wrote: > On Tue, 2 Feb 2021 11:32:42 +0300 > Alex Peshkoff via Firebird-devel > wrote: > > > On 2/1/21 10:24 PM, marius adrian popa wrote: > > > My guess old cpus or installs > > > > > > Example got laptop with Windows 10 32 that is still supported by > > > > Microsoft also have an old laptop with Ubuntu 32bit also another old > > > > raspberry pi that is 32 bit only > > > > I doubt all that list is worth having _new_ versions 32 bit. > > > > > > > > Firebird-Devel mailing list, web interface at > > https://lists.sourceforge.net/lists/listinfo/firebird-devel > > > > Presumably the original question implied x86 rather than 32-bit in general. > > I doubt that our user base for 32-bit ARM is really very significant but > 32-bit ARM chips probably have a good future ahead of them. 32-bit x86 > chips > seem to largely have gone the way of 16-bit x86. > > I certainly ask myself the question about x86 quite frequently. I can see a > reason for maintaining support in the code base but I find it hard to > justify > producing official x86 binaries for new versions of Firebird. > > > Paul > -- > > Paul Reeves > http://www.ibphoenix.com > Supporting users of Firebird > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
On Tue, 2 Feb 2021 11:32:42 +0300 Alex Peshkoff via Firebird-devel wrote: > On 2/1/21 10:24 PM, marius adrian popa wrote: > > My guess old cpus or installs > > > > Example got laptop with Windows 10 32 that is still supported by > > > Microsoft also have an old laptop with Ubuntu 32bit also another old > > > raspberry pi that is 32 bit only > > I doubt all that list is worth having _new_ versions 32 bit. > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Presumably the original question implied x86 rather than 32-bit in general. I doubt that our user base for 32-bit ARM is really very significant but 32-bit ARM chips probably have a good future ahead of them. 32-bit x86 chips seem to largely have gone the way of 16-bit x86. I certainly ask myself the question about x86 quite frequently. I can see a reason for maintaining support in the code base but I find it hard to justify producing official x86 binaries for new versions of Firebird. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
https://www.backblaze.com/blog/64-bit-os-vs-32-bit-os/ I like this quote : "You might be asking -> why do I care? Why does Brian want Microsoft to stop shipping an Operating System that is likely only chosen by mistake? My problem is this: Backblaze, like any good technology vendor, wants to be easy to use and friendly. In this case, that means we need to quietly, invisibly, continue to support BOTH the 32-bit and the 64-bit versions of every Microsoft OS they release. And we’ll probably need to do this for at least 5 years AFTER Microsoft officially retires the 32-bit only version of their operating system." Also Microsoft stopped shipping windows 32 bit to OEM but you can still install on your own workstations https://www.engadget.com/windows-10-32-bit-oem-173055990.html On Tue, Feb 2, 2021 at 10:33 AM Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > On 2/1/21 10:24 PM, marius adrian popa wrote: > > My guess old cpus or installs > > > > Example got laptop with Windows 10 32 that is still supported by > > Microsoft also have an old laptop with Ubuntu 32bit also another old > > raspberry pi that is 32 bit only > > > > I doubt all that list is worth having _new_ versions 32 bit. > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Usage of 32b version of Firebird
> I doubt all that list is worth having _new_ versions 32 bit. I agree. My original motivation to ask was to estimate whether I should keep providing 32bit builds of FbNetExternalEngine. Not that it is a huge amount of work, but still. -- 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] Usage of 32b version of Firebird
On 2/1/21 10:24 PM, marius adrian popa wrote: My guess old cpus or installs Example got laptop with Windows 10 32 that is still supported by Microsoft also have an old laptop with Ubuntu 32bit also another old raspberry pi that is 32 bit only I doubt all that list is worth having _new_ versions 32 bit. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel