summaryrefslogtreecommitdiff
path: root/mysql-test/t/trigger.test
diff options
context:
space:
mode:
authordlenev@brandersnatch.localdomain <>2004-09-09 00:46:01 +0400
committerdlenev@brandersnatch.localdomain <>2004-09-09 00:46:01 +0400
commit6dc933b7303baea0398761a608d7dfa7dfee1239 (patch)
tree585d1e39d3250f0afea1d761e09394b1142c917f /mysql-test/t/trigger.test
parent9b1bc6a4d59267becd668e13e94985bb551119b0 (diff)
downloadmariadb-git-6dc933b7303baea0398761a608d7dfa7dfee1239.tar.gz
WL#1218 "Triggers"
After review and after merge fixes.
Diffstat (limited to 'mysql-test/t/trigger.test')
-rw-r--r--mysql-test/t/trigger.test20
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test
index f7b9ebc8d2c..edbd2a92c3c 100644
--- a/mysql-test/t/trigger.test
+++ b/mysql-test/t/trigger.test
@@ -151,15 +151,15 @@ drop table t1;
#
create table t1 (i int);
---error 1358
+--error 1362
create trigger trg before insert on t1 for each row set @a:= old.i;
---error 1358
+--error 1362
create trigger trg before delete on t1 for each row set @a:= new.i;
---error 1357
+--error 1361
create trigger trg before update on t1 for each row set old.i:=1;
---error 1358
+--error 1362
create trigger trg before delete on t1 for each row set new.i:=1;
---error 1357
+--error 1361
create trigger trg after update on t1 for each row set new.i:=1;
# TODO: We should also test wrong field names here, we don't do it now
# because proper error handling is not in place yet.
@@ -173,23 +173,23 @@ create trigger trg after update on t1 for each row set new.i:=1;
create trigger trg before insert on t2 for each row set @a:=1;
create trigger trg before insert on t1 for each row set @a:=1;
---error 1354
+--error 1358
create trigger trg after insert on t1 for each row set @a:=1;
---error 1354
+--error 1358
create trigger trg2 before insert on t1 for each row set @a:=1;
drop trigger t1.trg;
---error 1355
+--error 1359
drop trigger t1.trg;
create view v1 as select * from t1;
---error 1356
+--error 1360
create trigger trg before insert on v1 for each row set @a:=1;
drop view v1;
drop table t1;
create temporary table t1 (i int);
---error 1356
+--error 1360
create trigger trg before insert on t1 for each row set @a:=1;
drop table t1;