Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Adriano dos Santos Fernandes
On 28/05/2018 09:13, Vlad Khorsun via Firebird-devel wrote: >   There is still no agreement. Current offers: > - single ON SESSION RESET trigger > - pair of new triggers: BEFORE SESSION RESET and AFTER SESSION RESET > - use existing ON CONNECT and ON DISCONNECT triggers and introduce a way > to dis

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Vlad Khorsun via Firebird-devel
28.05.2018 18:03, Dimitry Sibiryakov wrote: 28.05.2018 16:45, Vlad Khorsun via Firebird-devel wrote:    On one hand third option would be consistent with behavior of isc_detach_database() on client. On the other hand server cannot handle such error and it will result in endless transaction with

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Dimitry Sibiryakov
28.05.2018 16:45, Vlad Khorsun via Firebird-devel wrote:    On one hand third option would be consistent with behavior of isc_detach_database() on client. On the other hand server cannot handle such error and it will result in endless transaction with all consequences.   Not sure i understand

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Vlad Khorsun via Firebird-devel
28.05.2018 15:57, Dimitry Sibiryakov wrote: 28.05.2018 14:13, Vlad Khorsun via Firebird-devel wrote: - forcebly rollback active transactions and reset connection    same as if connection was broken - raise error and don't reset connection.    Obviously, first case is not an option and we must c

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Dimitry Sibiryakov
28.05.2018 14:13, Vlad Khorsun via Firebird-devel wrote: - forcebly rollback active transactions and reset connection   same as if connection was broken - raise error and don't reset connection.   Obviously, first case is not an option and we must choose between second and third. So far i pre

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Vlad Khorsun via Firebird-devel
All, Some update on this topic 18.05.2018 19:44, Vlad Khorsun via Firebird-devel wrote:    All,    I going to merge into master implementation of pool of external connections. The feature was initially developed more than a year ago, and works at production with good feedback.   Accor

[Firebird-devel] [FB-Tracker] Created: (CORE-5835) Provide place where "Invalid usage of boolean expression"

2018-05-28 Thread Karol Bieniaszewski (JIRA)
Provide place where "Invalid usage of boolean expression" - Key: CORE-5835 URL: http://tracker.firebirdsql.org/browse/CORE-5835 Project: Firebird Core Issue Type: Improvement

Re: [Firebird-devel] System procedures

2018-05-28 Thread Dimitry Sibiryakov
28.05.2018 12:32, Adriano dos Santos Fernandes wrote: On 28/05/2018 07:30, Dimitry Sibiryakov wrote:   I mean: during creation of database already created many definitions for tables, generators and so on. It is easy to add definition for couple of UDRs the same way. Where did you read I'm do

Re: [Firebird-devel] System procedures

2018-05-28 Thread Adriano dos Santos Fernandes
On 28/05/2018 07:30, Dimitry Sibiryakov wrote: > >   I mean: during creation of database already created many definitions > for tables, generators and so on. It is easy to add definition for > couple of UDRs the same way. > > Where did you read I'm doing anything different? Adriano

Re: [Firebird-devel] System procedures

2018-05-28 Thread Dimitry Sibiryakov
28.05.2018 12:27, Dimitry Sibiryakov wrote: 28.05.2018 12:21, Adriano dos Santos Fernandes wrote:    What's the difference between built-in UDR and "system procedure coded in C++"? *U*  stands for User. Need to have metadata manually created. Cannot access engine internals if needed.   In S

Re: [Firebird-devel] System procedures

2018-05-28 Thread Dimitry Sibiryakov
28.05.2018 12:21, Adriano dos Santos Fernandes wrote:   What's the difference between built-in UDR and "system procedure coded in C++"? *U* stands for User. Need to have metadata manually created. Cannot access engine internals if needed. In SysFunction.cpp there is a lot of system functi

Re: [Firebird-devel] System procedures

2018-05-28 Thread Adriano dos Santos Fernandes
On 28/05/2018 07:19, Dimitry Sibiryakov wrote: > 28.05.2018 12:16, Adriano dos Santos Fernandes wrote: >> On 28/05/2018 06:16, Dimitry Sibiryakov wrote: >>> 28.05.2018 3:04, Adriano dos Santos Fernandes wrote: I'm adding system procedure support, coded in C++, initially for list time zone

Re: [Firebird-devel] System procedures

2018-05-28 Thread Adriano dos Santos Fernandes
On 28/05/2018 02:02, Dmitry Yemanov wrote: > 28.05.2018 04:04, Adriano dos Santos Fernandes wrote: >> >> I'm adding system procedure support, coded in C++, initially for list >> time zone rule transition, as it can't be done with virtual table (needs >> parameters). >> >> I see others great potenti

Re: [Firebird-devel] System procedures

2018-05-28 Thread Dimitry Sibiryakov
28.05.2018 12:16, Adriano dos Santos Fernandes wrote: On 28/05/2018 06:16, Dimitry Sibiryakov wrote: 28.05.2018 3:04, Adriano dos Santos Fernandes wrote: I'm adding system procedure support, coded in C++, initially for list time zone rule transition, as it can't be done with virtual table (need

Re: [Firebird-devel] System procedures

2018-05-28 Thread Adriano dos Santos Fernandes
On 28/05/2018 06:16, Dimitry Sibiryakov wrote: > 28.05.2018 3:04, Adriano dos Santos Fernandes wrote: >> I'm adding system procedure support, coded in C++, initially for list >> time zone rule transition, as it can't be done with virtual table (needs >> parameters). > >   Aren't UDRs already implem

Re: [Firebird-devel] System procedures

2018-05-28 Thread Dimitry Sibiryakov
28.05.2018 3:04, Adriano dos Santos Fernandes wrote: I'm adding system procedure support, coded in C++, initially for list time zone rule transition, as it can't be done with virtual table (needs parameters). Aren't UDRs already implemented? -- WBR, SD. --