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-automations opened this issue May 17, 2017 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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