Changeset: 374254fa5b0b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/374254fa5b0b Added Files: sql/test/BugTracker-2024/Tests/7547-drop-login-trigger-crash.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for #7547 diffs (57 lines): diff --git a/sql/test/BugTracker-2024/Tests/7547-drop-login-trigger-crash.test b/sql/test/BugTracker-2024/Tests/7547-drop-login-trigger-crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/7547-drop-login-trigger-crash.test @@ -0,0 +1,44 @@ +query T nosort +select name from sys.triggers +---- +system_update_schemas + +statement ok +CREATE OR REPLACE TRIGGER lt1 BEFORE LOGIN SET SCHEMA tmp + +query T nosort +select name from sys.triggers +---- +system_update_schemas +lt1 + +statement ok +CREATE OR REPLACE TRIGGER lt2 AFTER LOGIN SET SCHEMA profiler + +query T nosort +select name from sys.triggers +---- +system_update_schemas +lt1 +lt2 + +skipif knownfail +statement ok +drop trigger lt2 + +skipif knownfail +statement ok +drop trigger "lt1" + +-- after drop we should be able to recreate trigger again +skipif knownfail +statement ok +CREATE OR REPLACE TRIGGER lt1 BEFORE LOGIN SET SCHEMA tmp + +skipif knownfail +statement ok +drop trigger "lt1" + +-- Program terminated with signal SIGSEGV, Segmentation fault. +-- #0 0x00007faa024fa2ca in drop_trigger () from lib64/libmonetdbsql.so.14 + diff --git a/sql/test/BugTracker-2024/Tests/All b/sql/test/BugTracker-2024/Tests/All --- a/sql/test/BugTracker-2024/Tests/All +++ b/sql/test/BugTracker-2024/Tests/All @@ -60,3 +60,4 @@ 7537-prepare_stmt_with_dropped_table 7536-mclient-forgets-to-flush 7541-levenshtein 7542-column-name-resolution +7547-drop-login-trigger-crash _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
