Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-29 Thread Alex Peshkoff via Firebird-devel
On 11/29/17 10:57, Jiří Činčura wrote: OK, the Firebird-4.0.0.816-0_Win32 behaves correctly. Will this go into 3.0.3 as well? As you can already see it's fixed in FB3 branch too. -- Check out the vibrant tech

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Jiří Činčura
OK, the Firebird-4.0.0.816-0_Win32 behaves correctly. Will this go into 3.0.3 as well? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Jiří Činčura
> Committed to master. Great. I'll check the snapshot build tomorrow and I'll let you know. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Alex Peshkoff via Firebird-devel
On 11/28/17 17:03, Jiří Činčura wrote: Jiří, can you try with this patch? I'm 99% sure it will help you to but if you can check it will be great. Can you maybe commit it to some branch/master and I'll get the fresh build from CI/nightly when it's done? I'm currently not in front of a computer

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Jiří Činčura
> Jiří, can you try with this patch? I'm 99% sure it will help you to but > if you can check it will be great. Can you maybe commit it to some branch/master and I'll get the fresh build from CI/nightly when it's done? I'm currently not in front of a computer with toolset to build Firebird

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-28 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 20:39, Jiří Činčura wrote: I've reproduced an issue. Somewhere between catching error in looper and rethrowing it again when leaving looper tdbb_status_vector is cleaned Great to know, you found it. Jiří, can you try with this patch? I'm 99% sure it will help you to but if you

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
> I've reproduced an issue. Somewhere between catching error in looper and > rethrowing it again when leaving looper tdbb_status_vector is cleaned Great to know, you found it. > up. BTW, for me it's reproduced each time I logoff/logon from/to isql. Yes. For me as well. -- Mgr. Jiří

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Any ideas what could be wrong and where to look at? I've reproduced an issue. Somewhere between catching error in looper and rethrowing it again when leaving looper tdbb_status_vector is cleaned up. BTW, for me it's reproduced each time I logoff/logon

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
>gfix -v -f ? $ .\gfix.exe -v -fu -user sysdba -password masterkey C:\Users\Jiri\Downloads\aaa\aaa\aaa.FDB $ Nothing. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Vlad Khorsun via Firebird-devel
27.11.2017 16:50, Jiří Činčura wrote: But mostly wierd is that even in theory crypt plugin can not affect integrity constraints - encryption works a few logical levels deeper than constraints violation, that's absolutely different parts of code. Yeah. I though the database was somewhat

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 18:08, Jiří Činčura wrote: What is the size of compressed database backup? 52 264 210 bytes, why? Will not fit into email (32M limit on mail.ru), please put it to some reasonable share. -- Check out

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
> AES128 plugin also works fine for me: Yeah, as I said. On a new database it works fine. It's something with this database that triggers some undefined behavior. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Any ideas what could be wrong and where to look at? AES128 plugin also works fine for me: localhost bin # localhost bin # ./isql e1.fdb Database: e1.fdb, User: SYSDBA SQL> alter database encrypt with AES128; SQL> insert into country values('Russia',

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
> What is the size of compressed database backup? 52 264 210 bytes, why? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites,

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:55, Jiří Činčura wrote: To be precise - it's IBSurgeon plugin. Hmm. Of course, could be. Wondering why it fails only on this database? Even more. Test table on this database works fine. What is the size of compressed database backup?

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:43, Alex Peshkoff via Firebird-devel wrote: Wierd - I could not reproduce it with . plugin. To be precise - it's IBSurgeon plugin. -- Check out the vibrant tech community on one of the

[Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
Hi, I have a weird behavior here. Database after b, no errors. I try to insert non-unique value into table with unique constraint and it fails as it should. I encrypt it (AES128 from IBPhoenix) and the same statement does not fail. Only the next one will throw unique violation. Here's a snap