Re: [Firebird-devel] Inserts and FKs

2019-09-05 Thread liviuslivius
Hi"tx2 inserts a detail record in TableB    Trigger on TableB tries to update master record,    since the record is still not visible for this snapshot,    update has null effect"I do not understand this point. If table B i detail it can only insert record for visible to it record in master. Or

[Firebird-devel] Inserts and FKs

2019-09-05 Thread Carlos H. Cantu
Recently I had a real situation that drove me crazy for several days while trying to find what actually happened. After lots of thinking, checking the auditing logs and chatting with Vlad, the only scenario that could explain what happened is: TableA (master) TableB (detail) There is FK between Ta

Re: [Firebird-devel] lck_length

2019-09-05 Thread Vlad Khorsun
05.09.2019 18:27, Adriano dos Santos Fernandes wrote: Hi! Lock manager has dev. build checkLength that asserts for lck_length <= MAX_UCHAR. Max identifier length is 63 characters, which may be multiplied by 4 in utf8 bytes. get_dsql_cache_item may create keys with 506 bytes. lck_length is USH

[Firebird-devel] lck_length

2019-09-05 Thread Adriano dos Santos Fernandes
Hi! Lock manager has dev. build checkLength that asserts for lck_length <= MAX_UCHAR. Max identifier length is 63 characters, which may be multiplied by 4 in utf8 bytes. get_dsql_cache_item may create keys with 506 bytes. lck_length is USHORT. Is the assertion wrong or do we have bigger proble

Re: [Firebird-devel] op_crypt case sensitivity on Linux

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 18:11, Mark Rotteveel wrote: On 5-9-2019 13:53, Alex Peshkoff via Firebird-devel wrote: On 05.09.2019 14:33, Jiří Činčura wrote: Hi, it turns out when sending "Arc4" and/or "Symmetric" in op_crypt the Linux builds are case sensitive, while Windows builds are not. Is this expect

Re: [Firebird-devel] op_crypt case sensitivity on Linux

2019-09-05 Thread Mark Rotteveel
On 5-9-2019 13:53, Alex Peshkoff via Firebird-devel wrote: On 05.09.2019 14:33, Jiří Činčura wrote: Hi, it turns out when sending "Arc4" and/or "Symmetric" in op_crypt the Linux builds are case sensitive, while Windows builds are not. Is this expected behavior? Yes for Arc4 (plugins' name

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 17:25, Adriano dos Santos Fernandes wrote: On 05/09/2019 10:59, Alex Peshkoff via Firebird-devel wrote: On 05.09.2019 16:52, Adriano dos Santos Fernandes wrote: Looks like finally you agreed that return a different tz value is like dropping a different database because engine cou

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Adriano dos Santos Fernandes
On 05/09/2019 10:59, Alex Peshkoff via Firebird-devel wrote: > On 05.09.2019 16:52, Adriano dos Santos Fernandes wrote: > >> Looks like finally you agreed that return a different tz value is >> like >> dropping a different database because engine could not drop the >> asked >> o

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 16:52, Adriano dos Santos Fernandes wrote: Looks like finally you agreed that return a different tz value is like dropping a different database because engine could not drop the asked one, and no workaround should be inserted replacing region codes by wrong offsets. Why are you so

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Adriano dos Santos Fernandes
On 05/09/2019 10:52, Adriano dos Santos Fernandes wrote: > > Map (per user request, in API) ... or set binding statement. > type to string. > > Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Adriano dos Santos Fernandes
On 05/09/2019 07:36, Alex Peshkoff via Firebird-devel wrote: > On 05.09.2019 12:04, Lester Caine wrote: >> On 05/09/2019 08:52, Alex Peshkoff via Firebird-devel wrote: >    Error is error, doesn't matter where it happens. Or you could > offer > "fallback" for > wrong database handle

[Firebird-devel] ADO.NET provider 7.1.1.0

2019-09-05 Thread Jiří Činčura
More info at this https://www.tabsoverspaces.com/id/233798 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] op_crypt case sensitivity on Linux

2019-09-05 Thread Jiří Činčura
> Yes for Arc4 (plugins' names are derived from filenames), no for > Symmetric (may be side effect of plugins' case sensitivity). OK. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-deve

Re: [Firebird-devel] op_crypt case sensitivity on Linux

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 14:33, Jiří Činčura wrote: Hi, it turns out when sending "Arc4" and/or "Symmetric" in op_crypt the Linux builds are case sensitive, while Windows builds are not. Is this expected behavior? Yes for Arc4 (plugins' names are derived from filenames), no for Symmetric (may be side

[Firebird-devel] op_crypt case sensitivity on Linux

2019-09-05 Thread Jiří Činčura
Hi, it turns out when sending "Arc4" and/or "Symmetric" in op_crypt the Linux builds are case sensitive, while Windows builds are not. Is this expected behavior? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 12:04, Lester Caine wrote: On 05/09/2019 08:52, Alex Peshkoff via Firebird-devel wrote:    Error is error, doesn't matter where it happens. Or you could offer "fallback" for wrong database handle\wrong server name in isc_attach_database\not working client DNS\etc cases ? Looks li

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Lester Caine
On 05/09/2019 08:52, Alex Peshkoff via Firebird-devel wrote:    Error is error, doesn't matter where it happens. Or you could offer "fallback" for wrong database handle\wrong server name in isc_attach_database\not working client DNS\etc cases ? Looks like finally you agreed that return a differ

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Vlad Khorsun
05.09.2019 5:28, Adriano dos Santos Fernandes wrote: On 04/09/2019 06:39, Vlad Khorsun wrote:   Error is error, doesn't matter where it happens. Or you could offer "fallback" for wrong database handle\wrong server name in isc_attach_database\not working client DNS\etc cases ? Looks like fi

Re: [Firebird-devel] TIME WITH TZ

2019-09-05 Thread Alex Peshkoff via Firebird-devel
On 05.09.2019 5:28, Adriano dos Santos Fernandes wrote: On 04/09/2019 06:39, Vlad Khorsun wrote:   Error is error, doesn't matter where it happens. Or you could offer "fallback" for wrong database handle\wrong server name in isc_attach_database\not working client DNS\etc cases ? Looks like f