Constraint violation error may be swallowed in some cases [CORE4670] #4981
Comments
Modified by: Attila Molnár (e_pluribus_unum)Attachment: command.sql [ 12666 ] |
|
Commented by: @dyemanov Confirmed. The issue manifests itself when the following conditions are met: 1) Problematic PK/UK index has rdb$index_id > 1 (let rdb$index_id be X, so X > 1) |
Modified by: @dyemanovVersion: 3.0 Beta 1 [ 10332 ] Version: 2.5.3 [ 10461 ] Version: 3.0 Alpha 2 [ 10560 ] Version: 3.0 Alpha 1 [ 10331 ] assignee: Dmitry Yemanov [ dimitr ] summary: INSERT SELECT bug with 2.5.3 => Constraint violation error may be swallowed in some cases |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5.4 [ 10585 ] Fix Version: 3.0 Beta 2 [ 10586 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Not enough information Test Details: Script contains no DDL. No database in provided link. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Attila Molnár (e_pluribus_unum)
Attachments:
command.sql
Hi!
Running the attached command on 2.5.3 server caused no error, but it should be.
Run statistic shows 1 successful insert, but in reality it does not happend.
test database : ftp://firebirdproject:projectfirebird@ftp.mve.hu
I'll send the zip password in PM.
With Firebird 2.5.2 works as expected, I'll get the following error
violation of FOREIGN KEY constraint "".
violation of FOREIGN KEY constraint "AEFEJ_FK1" on table "AEFEJ".
Foreign key reference target does not exist.
Thank you!
Commits: aaa2936 fbb4edc FirebirdSQL/fbt-repository@0d90434 FirebirdSQL/fbt-repository@ac34497
====== Test Details ======
Script contains no DDL. No database in provided link.
The text was updated successfully, but these errors were encountered: