Changeset: c37c571d4830 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c37c571d4830
Modified Files:
sql/test/scoping/Tests/scoping03.sql
sql/test/scoping/Tests/scoping03.stable.err
Branch: scoping
Log Message:
Added error case
diffs (30 lines):
diff --git a/sql/test/scoping/Tests/scoping03.sql
b/sql/test/scoping/Tests/scoping03.sql
--- a/sql/test/scoping/Tests/scoping03.sql
+++ b/sql/test/scoping/Tests/scoping03.sql
@@ -22,6 +22,10 @@ create or replace trigger mytrigger2
for each statement insert into fun2 values( a, 'value' ); --error,
identifier "a" is ambiguous, it could be either for old row or new row
create or replace trigger mytrigger2
+ after delete on fun referencing old row as "fun3"
+ for each statement update fun2 fun3 set b = (select a from fun3);
--error, identifier "a" is ambiguous, it could be either for old row or table
to update
+
+create or replace trigger mytrigger2
after delete on fun referencing old row as "del"
delete from fun2 where fun2.c = a; --possible, "a" refers to the old row
diff --git a/sql/test/scoping/Tests/scoping03.stable.err
b/sql/test/scoping/Tests/scoping03.stable.err
--- a/sql/test/scoping/Tests/scoping03.stable.err
+++ b/sql/test/scoping/Tests/scoping03.stable.err
@@ -29,6 +29,12 @@ QUERY = create or replace trigger mytrig
for each statement insert into fun2 values( a, 'value' );
--error, identifier "a" is ambiguous, it could be either for old row or new row
ERROR = !SELECT: identifier 'a' ambiguous
CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-689045/.s.monetdb.32789
+QUERY = create or replace trigger mytrigger2
+ after delete on fun referencing old row as "fun3"
+ for each statement update fun2 fun3 set b = (select a from
fun3); --error, identifier "a" is ambiguous, it could be either for old row or
table to update
+ERROR = !SELECT: identifier 'a' ambiguous
+CODE = 42000
# 18:15:52 >
# 18:15:52 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
