diff options
author | Rucha Deodhar <rucha.deodhar@mariadb.com> | 2022-03-28 15:45:29 +0530 |
---|---|---|
committer | Rucha Deodhar <rucha.deodhar@mariadb.com> | 2022-03-30 15:13:01 +0530 |
commit | 2eaaa8874fbc5212a3813e150d437b36ec34f22e (patch) | |
tree | 7c073b54519e8ca5d2704e3fbcad6589752f39ad /mysql-test/main/trigger.result | |
parent | a8e7e7c0b4a66a9e92c03b0fe084e98393bafdce (diff) | |
download | mariadb-git-2eaaa8874fbc5212a3813e150d437b36ec34f22e.tar.gz |
MDEV-13005: Fixing bugs in SEQUENCE, part 3, 5/5
Task 6:
We can find the .frm type of file. If it is sequence then is_sequence
passed to dd_frm_type() will be true. Since there is already a check
to give error message if we trigger is on temporary table or view, an
additional condition is added to check if .frm is sequence
(is_sequence==true) and error message is changed to show
"Trigger's '%-.192s' is view, temporary table or sequence" instead of
"Trigger's '%-.192s' is view or temporary table".
Diffstat (limited to 'mysql-test/main/trigger.result')
-rw-r--r-- | mysql-test/main/trigger.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/trigger.result b/mysql-test/main/trigger.result index 756fd8591dd..571d78aa9e2 100644 --- a/mysql-test/main/trigger.result +++ b/mysql-test/main/trigger.result @@ -319,7 +319,7 @@ drop table t1; drop table t3; create temporary table t1 (i int); create trigger trg before insert on t1 for each row set @a:=1; -ERROR HY000: Trigger's 't1' is view or temporary table +ERROR HY000: Trigger's 't1' is view, temporary table or sequence drop table t1; create table t1 (x1col char); create trigger tx1 before insert on t1 for each row set new.x1col = 'x'; |