Issue Details (XML | Word | Printable)

Key: CORE-3691
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: michalk1
Votes: 0
Watchers: 0
Operations

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

Missing constraint name in foreign key error message in FB 2.1.4

Created: 05/Dec/11 02:10 PM   Updated: 27/Mar/14 12:19 PM
Component/s: Engine
Affects Version/s: 2.1.4
Fix Version/s: 2.1.5

Time Tracking:
Not Specified

Environment: FB 2.1.4 SS, Windows XP
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
Missing constraint name is specific to FB 2.1.4, which is probably side effect of CORE-2289 fix.

ALTER TABLE DETAIL ADD CONSTRAINT DETAIL_FK FOREIGN KEY (ID) REFERENCES MASTER (ID);
COMMIT;

FB 2.1.3, FB 2.5.1 (correct):
violation of FOREIGN KEY constraint "".
violation of FOREIGN KEY constraint "DETAIL_FK" on table "DETAIL".
Foreign key reference target does not exist.

FB 2.1.4 (constraint name missing):
violation of FOREIGN KEY constraint "".
violation of FOREIGN KEY constraint "***unknown***" on table "DETAIL".
Foreign key reference target does not exist.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 05/Dec/11 02:42 PM
Fix for CORE-2289 was not fully backported into v2.1.4.