diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-04-07 13:40:27 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-04-07 13:40:27 +0400 |
| commit | ed305c0fd52d17110e9cc7c2e515d1f881de1102 (patch) | |
| tree | ae3b554eff35a4a8665edbc744ba5228f92e1c60 /mysql-test/r/trigger.result | |
| parent | 113a980ff1b31c8e712070bf50f75818a9dc42b4 (diff) | |
| download | mariadb-git-ed305c0fd52d17110e9cc7c2e515d1f881de1102.tar.gz | |
MDEV-12461 TYPE OF and ROW TYPE OF anchored data types
Diffstat (limited to 'mysql-test/r/trigger.result')
| -rw-r--r-- | mysql-test/r/trigger.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result index e6c8f6a5e2f..9224756407b 100644 --- a/mysql-test/r/trigger.result +++ b/mysql-test/r/trigger.result @@ -2368,3 +2368,23 @@ tr1 1 2016-01-01 10:10:10.33 tr2 2 2016-01-01 10:10:10.99 drop table t1; set time_zone= @@global.time_zone; +# +# Start of 10.3 tests +# +# +# MDEV-12461 TYPE OF and ROW TYPE OF anchored data types +# +CREATE TABLE t1 (a INT, b INT, total INT); +CREATE TRIGGER tr1 BEFORE INSERT ON t1 +FOR EACH ROW +BEGIN +DECLARE va TYPE OF t1.a DEFAULT NEW.a; +DECLARE vb TYPE OF t1.b DEFAULT NEW.b; +SET NEW.total:= va + vb; +END; +$$ +INSERT INTO t1 (a,b) VALUES (10, 20); +SELECT * FROM t1; +a b total +10 20 30 +DROP TABLE t1; |