Changeset: f7f0fe7c3e8a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f7f0fe7c3e8a
Modified Files:
        sql/test/BugTracker-2024/Tests/All
Branch: Aug2024
Log Message:

merge with Dec2023


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
@@ -70,3 +70,4 @@ 7536-mclient-forgets-to-flush
 7541-levenshtein
 7542-column-name-resolution
 7545-groupby_on_index_col
+7547-drop-login-trigger-crash
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to