Re: [Firebird-devel] Profiler plugin is not found. Windows snapshot Firebird-5.0.0.684-0-x64

23.08.2022 13:38, Norbert Saint Georges пишет: Simonov Denis via Firebird-devel a écrit : SQL> connect inet://localhost:3055/employee user SYSDBA password 'masterkey'; Database: inet://localhost:3055/employee, User: SYSDBA SQL> select rdb$profiler.start_session('Profile Session 1') fro

[Firebird-devel] Profiler plugin is not found. Windows snapshot Firebird-5.0.0.684-0-x64

SQL> connect inet://localhost:3055/employee user SYSDBA password 'masterkey'; Database: inet://localhost:3055/employee, User: SYSDBA SQL> select rdb$profiler.start_session('Profile Session 1') from rdb$database; START_SESSION = Statement failed, SQLSTATE = HY000

[Firebird-devel] Windows snapshor for Firebird 5.0

No snapshots for windows in http://web.firebirdsql.org/download/snapshot_builds/win/5.0/ And the second problem. If you download the artifact https://github.com/FirebirdSQL/firebird/suites/7826192155/artifacts/330779110 and others under Windows, it does not contain default_profiler.dll

Re: [Firebird-devel] New statement: EXECUTE SQL

15.08.2022 13:24, Adriano dos Santos Fernandes пишет: On 15/08/2022 04:16, Simonov Denis via Firebird-devel wrote: Very good feature, reminds me of the functionality from Oracle WITH Procedure p1 ...  AS ... FUNCTION f1 ... AS ... SELECT... Firebird does not have any support for client

Re: [Firebird-devel] New statement: EXECUTE SQL

14.08.2022 2:28, Adriano dos Santos Fernandes пишет: Hi! When one starts with a DSQL command and need to adapt it to EXECUTE BLOCK (for example to use sub routines or use a single parameter in many places), work is difficult when there are many parameters and output fields. Everything must

Re: [Firebird-devel] New statement: EXECUTE SQL

14.08.2022 2:28, Adriano dos Santos Fernandes пишет: Hi! When one starts with a DSQL command and need to adapt it to EXECUTE BLOCK (for example to use sub routines or use a single parameter in many places), work is difficult when there are many parameters and output fields. Everything must

Re: [Firebird-devel] Tablespaces proposal

Omacht András писал(а) в своём письме Thu, 07 Oct 2021 09:18:26 +0300: Hi Roman! First of all, thanks for the development and offering it to Firebird. Do you plan to partition the data depending on field value? Oracle range partitioning example: It seems to me that PARTITION support

Re: [Firebird-devel] ODP: SQL profiler

Adriano dos Santos Fernandes wrote Fri, 13 Nov 2020 01:33:52 +0300: On 08/11/2020 17:58, Karol Bieniaszewski wrote: Really great feature but i am worried about the title „package (FB 5.0)”. Is it for FB4 or for the future version FB5? I labeled it (and RDB$BLOB_UTIL) for FB 5 (or next

Re: [Firebird-devel] PSQL profiler

Adriano dos Santos Fernandes писал(а) в своём письме Mon, 28 Sep 2020 03:11:05 +0300: Hi! Here is link to pull request, starting with the README describing the feature: https://github.com/FirebirdSQL/firebird/pull/285/files I have a few questions. 1. Why is statistics limited to

[Firebird-devel] Firebird PDO preprocessing sql

Hello. I wrote a patch for the PHP PDO Firebird driver. https://github.com/php/php-src/pull/4920 The essence of the patch is to correctly process the EXECUTE BLOCK statement, as well as comments and lines. For the patch, some pieces of code from Firebird were involved and quite heavily

Re: [Firebird-devel] OO API examples for Object Pascal

Paul Reeves wrote Mon, 17 Aug 2020 19:24:44 +0300: On Mon, 17 Aug 2020 18:42:59 +0300 Vlad Khorsun wrote: VCL is overkill of course. We should avoid such dependencies in general samples. Some thin wrappers\helper classes could be very good to have as part of Pascal API.

Re: [Firebird-devel] No Firebird 4.0 snapshots

Mark Rotteveel wrote Mon, 20 Jan 2020 09:57:34 +0300: Both http://web.firebirdsql.org/download/snapshot_builds/win/4.0/ and http://web.firebirdsql.org/download/snapshot_builds/linux/fbtrunk/ currently contain no snapshots. Mark Apparently the Linux snapshots were repaired, but there

Re: [Firebird-devel] SET BIND OF

Alex Peshkoff via Firebird-devel писал(а) в своём письме Sun, 08 Dec 2019 18:59:12 +0300: On 2019-12-08 16:39, Simonov Denis via Firebird-devel wrote: Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed

Re: [Firebird-devel] SET BIND OF

Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed, but not completely. SET BIND OF DECFLOAT(16) NATIVE; -- work OK But SET BIND OF DECFLOAT(16) TO CHAR; select NORMALIZE_DECFLOAT(4300) as n1, QUANTIZE(2, 9.9) as n2,

[Firebird-devel] SET BIND OF

I try snapshot 4.0.0.1683. Basically, the new SET BIND OF statement works as expected. But using a form to return a native type does not work. SET BIND OF DECFLOAT (34) TO CHAR (46); - OK SET BIND OF DECFLOAT (34) NATIVE; Can not convert decfloat (34) to unknown. In addition, I did not see

Re: [Firebird-devel] Underlying format of high precision numerics

Vlad Khorsun wrote Tue, 17 Sep 2019 17:22:10 +0300: 17.09.2019 16:42, Simonov Denis via Firebird-devel wrote: Simonov Denis via Firebird-devel wrote Tue, 17 Sep 2019 15:47:14 +0300: FIELD_TYPE = 26 - this is bigint I'm sorry, it seems like I'm wrong. It would be nice to add a new

Re: [Firebird-devel] Underlying format of high precision numerics

Simonov Denis via Firebird-devel wrote Tue, 17 Sep 2019 15:47:14 +0300: FIELD_TYPE = 26 - this is bigint I'm sorry, it seems like I'm wrong. It would be nice to add a new type to RDB$TYPES. However, the examples above do not work. -- Simonov Denis Firebird-Devel mailing list, web

Re: [Firebird-devel] Underlying format of high precision numerics

Alex Peshkoff via Firebird-devel wrote Tue, 17 Sep 2019 13:42:17 +0300: SQL> select cast(12345678901234567890 as numeric(25, 0)) as n from rdb$database; Statement failed, SQLSTATE = 22003 arithmetic exception, numeric overflow, or string truncation -numeric value is out of range

Re: [Firebird-devel] Underlying format of high precision numerics

Alex Peshkoff via Firebird-devel wrote Fri, 21 Jun 2019 16:53:26 +0300: I've compared various possible implementations of high precision numeric. Except existing in fb4 (decfloat based) were checked native gcc's __int128 and ttmath (fixed high precision library with pure .h

Re: [Firebird-devel] TIME WITH TZ

Alex Peshkoff via Firebird-devel wrote Fri, 30 Aug 2019 16:10:12 +0300: I see only one problem with SQL-style management - if old application can't issue arbitrary SQL how to tune it to use legacy/char format? On the other hand: how at all will such application use new DB format? SQL

Re: [Firebird-devel] Underlying format of high precision numerics

Dimitry Sibiryakov писал(а) в своём письме Tue, 25 Jun 2019 22:54:57 +0300: 21.06.2019 15:53, Alex Peshkoff via Firebird-devel wrote: I.e. I suggest to replace high precision numeric's implementation using decfloat with native 128-bit integer when possible and ttmath in other cases. That

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

Windows Server 2012 x64. After installation Firebird 4.0.0.1436 x64 we have the following. Connect from IBExpert use c:\Program Files\Firebird\Firebird_4_0\WOW64\fbclient.dll When trying to execute a query, we get the error "Could not find acceptable ICU library" select current_timestamp

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

06.03.2019 18:26, Adriano dos Santos Fernandes пишет: On 04/03/2019 11:08, Adriano dos Santos Fernandes wrote: On 04/03/2019 10:57, Alex Peshkoff via Firebird-devel wrote: On 3/4/19 3:15 PM, Vlad Khorsun wrote: 04.03.2019 14:01, Alex Peshkoff via Firebird-devel wrote: On 3/4/19 2:57 PM, Vlad

[Firebird-devel] Firebird 4: Could not find acceptable ICU library

Faced the following problem when working with Firebird 4.0 via IBExpert. Trying to execute the following SQL query. SELECT current_time FROM $RDB$DATABASE SQLCODE: -902 GDSCODE: 335545167 Unsuccessful execution caused by a system error that precludes successful execution of subsequent

Re: [Firebird-devel] NULL and/or true/false

Kovalenko Dmitry wrote Mon, 01 Oct 2018 19:18:23 +0300: Hello, Firebird 3.0.4 Could anybody (Adriano?) confirm, that next result is corrected: select null or trueas c4__null_or_true, /* TRUE */ null or false as c5__null_or_false, /* NULL */ null and true as

Re: [Firebird-devel] User-defined aggregate functions

Dimitry Sibiryakov wrote Mon, 01 Oct 2018 13:28:44 +0300: 01.10.2018 12:22, Simonov Denis via Firebird-devel wrote: Current SPs do not know how to aggregate data by an external cursor. To do this, you need to write queries inside the SP. How is this related to (in)ability to return

Re: [Firebird-devel] User-defined aggregate functions

Dimitry Sibiryakov wrote Mon, 01 Oct 2018 13:12:36 +0300: 01.10.2018 12:07, Simonov Denis via Firebird-devel wrote: To return more than one value you need support for ROW types. Otherwise, the function still does not extract more than one value. Current SP can return several values

Re: [Firebird-devel] User-defined aggregate functions

Adriano dos Santos Fernandes wrote Sat, 29 Sep 2018 22:55:52 +0300: So SUSPEND in this context is very like JS YIELD with caller doing a reduce. I have even thought in use YIELD keyword in this context. Adriano The keyword YEILD is more preferable for aggregate functions. At the

Re: [Firebird-devel] User-defined aggregate functions

Dimitry Sibiryakov wrote Mon, 01 Oct 2018 12:44:58 +0300: 01.10.2018 11:24, Pavel Cisar wrote: Aggregates could produce various single-value outputs Why to limit them to single value? Some aggregates could profit if they are able to return more values at once. For example, avg +

Re: [Firebird-devel] Broken read committed consistency (was Changes in JRD_start/JRD_start_and_send in "read consistency" patch)

Adriano dos Santos Fernandes wrote Tue, 28 Aug 2018 13:39:26 +0300: Adriano, Oracle does not implement statement consistency only delimited to an SQL (instead of PL / SQL) because of its loose integration, but because it's completely nonsense to do the contrary. And that's bad. That's

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

Adriano dos Santos Fernandes wrote Mon, 27 Aug 2018 20:10:49 +0300: And when the user executes that EXECUTE BLOCK, all the whole thing may execute repeated times. So we cannot use any external routines with side effects anymore in Firebird. Not even internal functions with side effects.

Re: [Firebird-devel] Smart end of statement detection in ISQL

Adriano dos Santos Fernandes wrote Sun, 24 Jun 2018 21:09:21 +0300: Not touching the algorithm AUTOTERM. This functionality would be useful. Moreover, some IDEs for Firebird successfully solve this problem, for example IB Expert. Although perhaps this is not cheap. -- Simonov Denis

Re: [Firebird-devel] Virtual table for time zones

Adriano dos Santos Fernandes wrote Thu, 10 May 2018 18:21:49 +0300: Hi! I want to create a virtual table that lists available time zones. For now there is RDB$ (non-virtual), MON$ (virtual, but all about monitoring), SEC$ (security plugin). What prefix should

Re: [Firebird-devel] Lateral derived tables (was: Plans to support cross and outer apply)

Dmitry Yemanov wrote Fri, 08 Sep 2017 11:03:02 +0300: 1) d 2) c 3) b 4) b -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

Re: [Firebird-devel] Lateral derived tables (was: Plans to support cross and outer apply)

Dmitry Yemanov wrote Fri, 08 Sep 2017 11:03:02 +0300: 1) d 2) c 3) b 4) b -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

Re: [Firebird-devel] Lateral derived tables (was: Plans to support cross and outer apply)

Dmitry Yemanov wrote Fri, 08 Sep 2017 11:03:02 +0300: 1) d 2) c 3) b 4) b -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!