Changeset: 5bdc740343eb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5bdc740343eb
Added Files:
        sql/test/Triggers/Tests/auth-triggers.test
Modified Files:
        sql/test/Triggers/Tests/All
Branch: triggers
Log Message:

add test


diffs (27 lines):

diff --git a/sql/test/Triggers/Tests/All b/sql/test/Triggers/Tests/All
--- a/sql/test/Triggers/Tests/All
+++ b/sql/test/Triggers/Tests/All
@@ -12,3 +12,4 @@ trigger_insert
 trigger_projection
 trigger_schema
 trigger-restart
+auth-triggers
diff --git a/sql/test/Triggers/Tests/auth-triggers.test 
b/sql/test/Triggers/Tests/auth-triggers.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Triggers/Tests/auth-triggers.test
@@ -0,0 +1,14 @@
+statement ok
+create role bar
+
+statement ok
+create user foo with password 'foo' name 'foo'
+
+statement ok
+create trigger foo after login set role bar
+
+@connection(id=1, username=foo, password=foo)
+query T rowsort
+select current_role
+----
+bar
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to