Issue Details (XML | Word | Printable)

Key: CORE-4670
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Attila Molnár
Votes: 0
Watchers: 4
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Constraint violation error may be swallowed in some cases

Created: 22/Jan/15 12:51 PM   Updated: 23/Sep/15 11:33 AM
Component/s: None
Affects Version/s: 3.0 Alpha 1, 3.0 Alpha 2, 2.5.3, 3.0 Beta 1, 2.5.3 Update 1
Fix Version/s: 2.5.4, 3.0 Beta 2

File Attachments: 1. File command.sql (2 kB)


QA Status: Not enough information
Test Details: Script contains no DDL. No database in provided link.


 Description  « Hide
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!

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 26/Jan/15 10:21 AM
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)
2) There are expression indices before X (rdb$index_id < X)
3) At least one of those expression indices invoke some UDF