Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Vlad Khorsun
03.09.2019 4:27, Adriano dos Santos Fernandes wrote: On 02/09/2019 05:17, Vlad Khorsun wrote: 30.08.2019 19:15, Adriano dos Santos Fernandes wrote: On 30/08/2019 08:48, Alex Peshkoff via Firebird-devel wrote: 1. Let's use SQL subtype in order to represent in the message UTC or regional time,

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Vlad Khorsun
03.09.2019 4:32, Adriano dos Santos Fernandes wrote: On 02/09/2019 06:26, Alex Peshkoff via Firebird-devel wrote: If even this causes problems offset may be displayed instead, i.e. GMT+3. That's definitely trivial. Fallback for the crazy situation of wrong client (without ICU) is Not ag

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Vlad Khorsun
03.09.2019 4:20, Adriano dos Santos Fernandes wrote: On 02/09/2019 08:06, Alex Peshkoff via Firebird-devel wrote: ICU library often missing on windows client. No, it's not, the C/C++ runtime causes much more problem in Windows than ICU. It is very far from my own expirience Regards, Vlad

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Adriano dos Santos Fernandes
On 02/09/2019 06:26, Alex Peshkoff via Firebird-devel wrote: > > If even this causes problems offset may be displayed instead, i.e. > GMT+3. That's definitely trivial. > Fallback for the crazy situation of wrong client (without ICU) is already present: display gmt time with region "GMT*". Craz

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Adriano dos Santos Fernandes
On 02/09/2019 05:17, Vlad Khorsun wrote: > 30.08.2019 19:15, Adriano dos Santos Fernandes wrote: >> On 30/08/2019 08:48, Alex Peshkoff via Firebird-devel wrote: >>> >>> >>> 1. Let's use SQL subtype in order to represent in the message UTC or >>> regional time, i.e. for time with time zone 2 subtype

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Adriano dos Santos Fernandes
On 02/09/2019 08:22, Dimitry Sibiryakov wrote: > 02.09.2019 13:16, Alex Peshkoff via Firebird-devel wrote: >> How to make server always use offset (not timezone code) in selected >> TS with TZ using coersion? > >   Usual way for data coercion: application just set desired data type in > metadata d

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Adriano dos Santos Fernandes
On 02/09/2019 08:06, Alex Peshkoff via Firebird-devel wrote: > ICU library often missing on windows client. No, it's not, the C/C++ runtime causes much more problem in Windows than ICU. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird

[Firebird-devel] [FB-Tracker] Created: (CORE-6133) Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field with COLLATION

2019-09-02 Thread Luciano Mendes (JIRA)
Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field with COLLATION - Key: CORE-6133 URL: http://tracker.firebirdsql.org/

[Firebird-devel] ADO.NET provider 7.1.0.0

2019-09-02 Thread Jiří Činčura
More info at this https://www.tabsoverspaces.com/id/233796 link. -- Mgr. Jiří Činčura Independent IT Specialist Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Dimitry Sibiryakov
02.09.2019 14:35, Adriano dos Santos Fernandes wrote: Pools are also used for memory accounting. valgrind and DrMemory are better on this. It's the same. As soon someone does not chain everything being allocated or has non-memory resources, finalizers are needed when delete by pool is used.

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Adriano dos Santos Fernandes
On 02/09/2019 08:22, Alex Peshkoff via Firebird-devel wrote: > On 02.09.2019 13:42, Dimitry Sibiryakov wrote: >> 02.09.2019 12:26, Alex Peshkoff via Firebird-devel wrote: >>> When first pool-enabled classes were added to firebird ~15 years ago >>> allocators were absolutely unable to peresent fireb

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Adriano dos Santos Fernandes
On 02/09/2019 07:21, Dimitry Sibiryakov wrote: > 02.09.2019 12:15, Alex Peshkoff via Firebird-devel wrote: >> Don't gorget - 'classic' smart pointers, containers, etc. do NOT work >> when object is deleted by pool. > >   That's why object in pool must never use non-pooled child object. > Adriano mu

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 14:30, Dimitry Sibiryakov wrote: 02.09.2019 13:27, Alex Peshkoff via Firebird-devel wrote: May be OK for future versions.   ..."but now we are going to make a quick hack". Ok, ok.   Don't forget to make this hack for boolean datatype as well: those applications that not aware o

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Ann Harrison
> On Sep 2, 2019, at 6:26 AM, Alex Peshkoff via Firebird-devel > > When first pool-enabled classes were added to firebird ~15 years ago Double that - of course there weren’t classes thirty years ago. Cheers, Ann Firebird-Devel mailing list, web interface at https://lists.sourceforge.ne

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Mark Rotteveel
On 2-9-2019 13:16, Alex Peshkoff via Firebird-devel wrote: On 02.09.2019 14:12, Dimitry Sibiryakov wrote: 02.09.2019 13:06, Alex Peshkoff via Firebird-devel wrote: Suggested approach makes it possible to tune server to return data in a form required by partcular client.   And (just in case) I

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Dimitry Sibiryakov
02.09.2019 13:27, Alex Peshkoff via Firebird-devel wrote: May be OK for future versions. ..."but now we are going to make a quick hack". Ok, ok. Don't forget to make this hack for boolean datatype as well: those applications that not aware of this new datatype should get it as a string.

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 14:22, Dimitry Sibiryakov wrote: 02.09.2019 13:16, Alex Peshkoff via Firebird-devel wrote: How to make server always use offset (not timezone code) in selected TS with TZ using coersion?   Usual way for data coercion: application just set desired data type in metadata during fet

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Dimitry Sibiryakov
02.09.2019 13:22, Alex Peshkoff via Firebird-devel wrote: Delete by pool is very important performance optimization. Yes, it is nice but has a high price demanding careful design of classes and their interactions which is not currently the case. -- WBR, SD. Firebird-Devel mailing list

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 13:42, Dimitry Sibiryakov wrote: 02.09.2019 12:26, Alex Peshkoff via Firebird-devel wrote: When first pool-enabled classes were added to firebird ~15 years ago allocators were absolutely unable to peresent firebird pools.   Pools were implemented that time because standard memory

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Dimitry Sibiryakov
02.09.2019 13:16, Alex Peshkoff via Firebird-devel wrote: How to make server always use offset (not timezone code) in selected TS with TZ using coersion? Usual way for data coercion: application just set desired data type in metadata during fetch. PS: I understand that it may be convenient

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 14:12, Dimitry Sibiryakov wrote: 02.09.2019 13:06, Alex Peshkoff via Firebird-devel wrote: Suggested approach makes it possible to tune server to return data in a form required by partcular client.   And (just in case) I repeat: suggested approach duplicate data coercion functio

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Dimitry Sibiryakov
02.09.2019 13:06, Alex Peshkoff via Firebird-devel wrote: Suggested approach makes it possible to tune server to return data in a form required by partcular client. And (just in case) I repeat: suggested approach duplicate data coercion functionality and is superfluous. -- WBR, SD. Fi

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 13:53, Mark Rotteveel wrote: On 2-9-2019 11:35, Alex Peshkoff via Firebird-devel wrote: On 02.09.2019 11:25, Vlad Khorsun wrote: 30.08.2019 20:41, Mark Rotteveel wrote:   Hope Alex will answer this, below is my own understanding of propositions. Could you explicitly describe t

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Mark Rotteveel
On 2-9-2019 11:35, Alex Peshkoff via Firebird-devel wrote: On 02.09.2019 11:25, Vlad Khorsun wrote: 30.08.2019 20:41, Mark Rotteveel wrote:   Hope Alex will answer this, below is my own understanding of propositions. Could you explicitly describe the problem you think this solves, and how y

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Dimitry Sibiryakov
02.09.2019 12:26, Alex Peshkoff via Firebird-devel wrote: When first pool-enabled classes were added to firebird ~15 years ago allocators were absolutely unable to peresent firebird pools. Pools were implemented that time because standard memory manager was slower. Had someone compared thei

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 13:21, Dimitry Sibiryakov wrote: 02.09.2019 12:15, Alex Peshkoff via Firebird-devel wrote: Don't gorget - 'classic' smart pointers, containers, etc. do NOT work when object is deleted by pool.   That's why object in pool must never use non-pooled child object. Adriano must use p

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Dimitry Sibiryakov
02.09.2019 12:15, Alex Peshkoff via Firebird-devel wrote: Don't gorget - 'classic' smart pointers, containers, etc. do NOT work when object is deleted by pool. That's why object in pool must never use non-pooled child object. Adriano must use pooled Allocator in his SimilarMatcher for std co

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 13:10, Dimitry Sibiryakov wrote: 02.09.2019 12:06, Alex Peshkoff via Firebird-devel wrote: Certainly it's much, much better to define rules of object deletion at construction time than to delete something explicitly (here and there) when object is going to be destroyed.   That's

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Dimitry Sibiryakov
02.09.2019 12:06, Alex Peshkoff via Firebird-devel wrote: Certainly it's much, much better to define rules of object deletion at construction time than to delete something explicitly (here and there) when object is going to be destroyed. That's the job for smart pointers and containers. --

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 30.08.2019 19:20, Adriano dos Santos Fernandes wrote: On 30/08/2019 08:56, Dmitry Yemanov wrote: 27.08.2019 3:59, Adriano dos Santos Fernandes wrote: Sometimes a object managed by memory-pool may embed non-pooled memory or other resources. If the main object is not explicitly destroyed, i.e

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 11:25, Vlad Khorsun wrote: 30.08.2019 20:41, Mark Rotteveel wrote:   Hope Alex will answer this, below is my own understanding of propositions. Could you explicitly describe the problem you think this solves, and how your proposal solves it?   Hmm... the first paragraph at or

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 02.09.2019 11:17, Vlad Khorsun wrote: 30.08.2019 19:15, Adriano dos Santos Fernandes wrote: On 30/08/2019 08:48, Alex Peshkoff via Firebird-devel wrote: 1. Let's use SQL subtype in order to represent in the message UTC or regional time, i.e. for time with time zone 2 subtypes will make sen

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Vlad Khorsun
30.08.2019 20:41, Mark Rotteveel wrote: Hope Alex will answer this, below is my own understanding of propositions. Could you explicitly describe the problem you think this solves, and how your proposal solves it? Hmm... the first paragraph at original message explains it BTW: This subj

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Vlad Khorsun
30.08.2019 19:15, Adriano dos Santos Fernandes wrote: On 30/08/2019 08:48, Alex Peshkoff via Firebird-devel wrote: 1. Let's use SQL subtype in order to represent in the message UTC or regional time, i.e. for time with time zone 2 subtypes will make sense - UTC format or regional format. When u

Re: [Firebird-devel] TIME WITH TZ

2019-09-02 Thread Alex Peshkoff via Firebird-devel
On 31.08.2019 12:41, liviuslivius wrote: >>About tools: isql supports all newer features Who use isql, really? I do. :) I suppose only to confirm some bug. I cannot imagine that someone use it by typing directly commands inside or looking at textual output if gui tools have grids, filterin