diff options
author | dlenev@brandersnatch.localdomain <> | 2004-09-09 00:46:01 +0400 |
---|---|---|
committer | dlenev@brandersnatch.localdomain <> | 2004-09-09 00:46:01 +0400 |
commit | 6dc933b7303baea0398761a608d7dfa7dfee1239 (patch) | |
tree | 585d1e39d3250f0afea1d761e09394b1142c917f /mysql-test/t/trigger.test | |
parent | 9b1bc6a4d59267becd668e13e94985bb551119b0 (diff) | |
download | mariadb-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.test | 20 |
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; |