You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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
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: