diff options
Diffstat (limited to 'mysql-test/t/trigger_no_defaults-11698.test')
-rw-r--r-- | mysql-test/t/trigger_no_defaults-11698.test | 42 |
1 files changed, 0 insertions, 42 deletions
diff --git a/mysql-test/t/trigger_no_defaults-11698.test b/mysql-test/t/trigger_no_defaults-11698.test deleted file mode 100644 index c10bec68314..00000000000 --- a/mysql-test/t/trigger_no_defaults-11698.test +++ /dev/null @@ -1,42 +0,0 @@ -# -# MDEV-11698 Old Bug possibly not fixed; BEFORE INSERT Trigger on NOT NULL -# -set sql_mode='strict_all_tables'; -create table t1 (a int not null, b int); ---error ER_NO_DEFAULT_FOR_FIELD -insert t1 (b) values (1); -delimiter |; -create trigger trgi before insert on t1 for each row - case new.b - when 10 then - set new.a = new.b; - when 30 then - set new.a = new.a; - else - do 1; - end case| -delimiter ;| -insert t1 (b) values (10); ---error ER_NO_DEFAULT_FOR_FIELD -insert t1 (b) values (20); -# arguably the statement below should fail too -insert t1 (b) values (30); -select * from t1; -drop table t1; -set sql_mode=default; - -# -# MDEV-11842 Fail to insert on a table where a field has no default -# -set sql_mode=''; -create table t1 ( - id int(11) not null auto_increment primary key, - data1 varchar(10) not null, - data2 varchar(10) not null -); -insert into t1 (data2) values ('x'); -create trigger test_trigger before insert on t1 for each row begin end; -insert into t1 (data2) values ('y'); -select * from t1; -drop table t1; -set sql_mode=default; |