Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined) [CORE5542] #5810

Closed
firebird-issue-importer opened this issue May 17, 2017 · 4 comments

Comments

@firebird-issue-importer

Submitted by: @pavel-zotov

Attachments:
db-level-triggers-for-Tx-events-ignore-position-index-from-their-ddl.7z

Run scripts from attached .7z (or just see their logs - also in this attach).
You will see that only triggers for CONNECT / DISCONNECT event honour the index that was specified in POSITION clause.
"

Commits: 67222d7 8263711

====== Test Details ======

Test was splitted on following separate .fbt (one per each event):

core_5542-db_attach.fbt
core_5542-db_detach.fbt
core_5542-tx_commit.fbt
core_5542-tx_rollback.fbt
core_5542-tx_start.fbt

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 17, 2017

Modified by: @pavel-zotov

Attachment: db-level-triggers-for-Tx-events-ignore-position-index-from-their-ddl.7z [ 13116 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 17, 2017

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 19, 2017

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

Fix Version: 3.0.3 [ 10810 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 22, 2017

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

Test Details: Test was splitted on following separate .fbt (one per each event):

core_5542-db_attach.fbt
core_5542-db_detach.fbt
core_5542-tx_commit.fbt
core_5542-tx_rollback.fbt
core_5542-tx_start.fbt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment