diff options
Diffstat (limited to 'mysql-test/r/trigger.result')
| -rw-r--r-- | mysql-test/r/trigger.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result index 5d643057666..52123885772 100644 --- a/mysql-test/r/trigger.result +++ b/mysql-test/r/trigger.result @@ -619,7 +619,7 @@ set sql_mode=default; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` date default NULL + `a` date DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 show triggers; Trigger Event Table Statement Timing Created sql_mode Definer @@ -947,7 +947,7 @@ mysqltest t1_bi mysqltest t1 set @a:=new.id show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `id` int(11) default NULL + `id` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop trigger test.t1_bi; ERROR HY000: Trigger does not exist @@ -1008,9 +1008,9 @@ insert into t1 values create function f2() returns int return (select max(b) from t2); insert into t2 select a, f2() from t1; load data infile '../std_data_ln/words.dat' into table t1 (a) set b:= f1(); -drop table t1, t2; drop function f1; drop function f2; +drop table t1, t2; create table t1(i int not null, j int not null, n numeric(15,2), primary key(i,j)); create table t2(i int not null, n numeric(15,2), primary key(i)); create trigger t1_ai after insert on t1 for each row |