summaryrefslogtreecommitdiff
path: root/mysql-test/main/trigger.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/trigger.test')
-rw-r--r--mysql-test/main/trigger.test6
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/main/trigger.test b/mysql-test/main/trigger.test
index 16d117e7342..f2f2001eb37 100644
--- a/mysql-test/main/trigger.test
+++ b/mysql-test/main/trigger.test
@@ -2628,6 +2628,7 @@ DROP TABLE t1, t2;
set time_zone="+00:00";
SET TIMESTAMP=UNIX_TIMESTAMP('2001-01-01 10:20:30');
SET @@session.sql_mode = 'STRICT_ALL_TABLES,STRICT_TRANS_TABLES';
+set @rpt=1;
CREATE TABLE t1 (c CHAR(1) NOT NULL);
DELIMITER |;
CREATE TRIGGER t1_bi
@@ -2635,13 +2636,14 @@ CREATE TRIGGER t1_bi
ON t1
FOR EACH ROW
BEGIN
- SET NEW.c = 'www';
+ SET NEW.c = repeat(@rpt,@rpt);
+ set @rpt=@rpt+1;
END;
|
DELIMITER ;|
SET @@session.sql_mode = default;
--error ER_DATA_TOO_LONG
-INSERT INTO t1 VALUES ('a');
+INSERT INTO t1 VALUES ('a'),('b'); # this is a BUG, must be "at row 2"
show create trigger t1_bi;
DROP TRIGGER t1_bi;
DROP TABLE t1;