[Firebird-devel] [FB-Tracker] Created: (CORE-5924) Automatic name of the field for RDB$GET_CONTEXT is not generated in the union

2018-09-25 Thread Karol Bieniaszewski (JIRA)
Automatic name of the field for RDB$GET_CONTEXT is not generated in the union - Key: CORE-5924 URL: http://tracker.firebirdsql.org/browse/CORE-5924 Project: Firebird Core

Re: [Firebird-devel] ODP: ODP: CORE-5921

2018-09-25 Thread Vlad Khorsun
25.09.2018 22:37, Karol Bieniaszewski wrote: Hi Vlad, Maybe you should go first to the end of may email (quite long – sorry please be patient) Not so long ;) I suppose that i misunderstand names and meaining. This is the commit number of currently used snapshot, if present. Non-RC

Re: [Firebird-devel] CORE-5921

2018-09-25 Thread Vlad Khorsun
24.09.2018 10:19, liviuslivius wrote: Hi, can you point me about usage cases about http://tracker.firebirdsql.org/browse/CORE-5921? The main goal is to provide ability to investigate new engine characteristics and behaviour for end users, testers, etc (i.e. not only for the core

[Firebird-devel] [FB-Tracker] Created: (CORE-5925) bad parameters on attach or create database CHARACTER SET WIN1250 is not defined

2018-09-25 Thread Pawel Kubiczek (JIRA)
bad parameters on attach or create database CHARACTER SET WIN1250 is not defined Key: CORE-5925 URL: http://tracker.firebirdsql.org/browse/CORE-5925 Project: Firebird

Re: [Firebird-devel] CORE-5921

2018-09-25 Thread Vlad Khorsun
25.09.2018 17:25, liviuslivius wrote: Ok, i supposed that this go further. I need global CN from transaction start POV. For snapshot\concurrency transaction you could obtain it using SNAPSHOT_CN context variable. For read-comitted transaction it doesn't exists. I do not know if i can

Re: [Firebird-devel] ODP: CORE-5921

2018-09-25 Thread Vlad Khorsun
25.09.2018 19:02, Karol Bieniaszewski wrote: What is then SNAPSHOT_CN? This is the commit number of currently used snapshot, if present. Non-RC transactions create snapshot at own start and SNAPSHOT_CN is the CN of that snapshot. RCRC transactions create snapshot when user query execution

Re: [Firebird-devel] CORE-5921

2018-09-25 Thread liviuslivius
Ok, i supposed that this go further. I need global CN from transaction start POV. I do not know if i can retrive it in On Transaction Start Trigger? Is that trigger serialized? If i start transaction no other transaction can be commited until this trigger is finished? You know myTrStartCN:=

[Firebird-devel] ODP: CORE-5921

2018-09-25 Thread Karol Bieniaszewski
What is then SNAPSHOT_CN? Is this last snapshot commited before my transaction start? Consider sample – what i try to accomplish (get deltas) CREATE TABLE NAMES ( ID integer NOT NULL, NAME varchar(100), TR_ID bigint, CONSTRAINT INTEG_2 PRIMARY KEY (ID) ); CREATE TABLE NAMES__DEL ( ID