Unique constraint not working in encrypted database on first command [CORE5673] #5939
Comments
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoffreporter: Alexander Peshkov [ alexpeshkoff ] => Jiri Cincura [ cincura_net ] |
Modified by: Sean Leyne (seanleyne)description: I have a weird behavior here. Database after b&r, no errors. I try to => I have a weird behavior here. Database after b&r, 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 IBSurgeon) and the same statement does not fail. Only the next one will throw unique violation. environment: IBPhoenix AES128 plugin => IBSurgeon AES128 plugin |
Modified by: Sean Leyne (seanleyne)description: I have a weird behavior here. Database after b&r, 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 IBSurgeon) and the same statement does not fail. Only the next one will throw unique violation. => I have a weird behavior here. Database after b&r, 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. environment: IBSurgeon AES128 plugin => IBPhoenix AES128 plugin |
|
Commented by: @AlexPeshkoff Error happened because tdbb_status_vector with constraint violation error was cleared by crypt plugin. That's not a plugin error. Even with newer programming style in plugin which does not assume full vector cleanup on each call code invoking plugin was wrong. In case of 2 errors (both in constraint and in plugin) instead merged status vector with both errors we got only plugin error in it. |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0.3 [ 10810 ] Fix Version: 4.0 Beta 1 [ 10750 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] Test Details: Could not check reproducing of bug on FB 3.0.2 because there is no encryption plugin for this (too old) version. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @cincuranet
I have a weird behavior here. Database after b&r, 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.
Commits: 992554a 8c68ef5
====== Test Details ======
Could not check reproducing of bug on FB 3.0.2 because there is no encryption plugin for this (too old) version.
Decided only to ensure that exception will be catched on recent FB version for each attempt to insert duplicate.
The text was updated successfully, but these errors were encountered: