Changeset: 995872b4375d for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=995872b4375d
Added Files:
        sql/test/BugTracker-2015/Tests/schema-trigger.Bug-3710.sql
Modified Files:
        sql/test/BugTracker-2015/Tests/All
Branch: default
Log Message:

Add test for bug 3710


diffs (24 lines):

diff --git a/sql/test/BugTracker-2015/Tests/All 
b/sql/test/BugTracker-2015/Tests/All
--- a/sql/test/BugTracker-2015/Tests/All
+++ b/sql/test/BugTracker-2015/Tests/All
@@ -98,3 +98,4 @@ mserver-creates-but-not-accept-column-ty
 NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871
 foreignkey_over_schemas.Bug-3855
 
mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872
+schema-trigger.Bug-3710
diff --git a/sql/test/BugTracker-2015/Tests/schema-trigger.Bug-3710.sql 
b/sql/test/BugTracker-2015/Tests/schema-trigger.Bug-3710.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/schema-trigger.Bug-3710.sql
@@ -0,0 +1,11 @@
+create schema marketdata;
+create table marketdata.quotes (i integer);
+CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON marketdata.quotes
+FOR EACH ROW 
+BEGIN ATOMIC
+-- select * from marketdata.quotes limit 1;
+END;
+--syntax error, unexpected '.', expecting WHILE in: "create trigger 
marketdata.calc_sdate before insert on marketdata."
+drop table marketdata.quotes;
+drop schema marketdata;
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to