diff options
author | Alexander Nozdrin <alik@sun.com> | 2009-11-25 16:46:45 +0300 |
---|---|---|
committer | Alexander Nozdrin <alik@sun.com> | 2009-11-25 16:46:45 +0300 |
commit | 3c11750e363da6e1017d5bc86e9e7e03b2c4e101 (patch) | |
tree | 3e8e0dbed8da743714f85fb19c404dce34319d8b /mysql-test/t/errors.test | |
parent | e2a34cbf706926e10016079a094a2877eb2f4f18 (diff) | |
parent | be0add42f53b23d8a5e279cb3041a3fc93e375a0 (diff) | |
download | mariadb-git-3c11750e363da6e1017d5bc86e9e7e03b2c4e101.tar.gz |
Auto-merge from mysql-next-mr.
Diffstat (limited to 'mysql-test/t/errors.test')
-rw-r--r-- | mysql-test/t/errors.test | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/t/errors.test b/mysql-test/t/errors.test index 820766c3a78..44c514f1244 100644 --- a/mysql-test/t/errors.test +++ b/mysql-test/t/errors.test @@ -68,6 +68,40 @@ INSERT INTO t1 SELECT b FROM t1; DROP TABLE t1; # End of 5.0 tests +flush status; +--disable_warnings +drop table if exists t1, t2; +--enable_warnings +create table t1 (a int unique); +create table t2 (a int); +drop function if exists f1; +drop function if exists f2; + +delimiter |; + +create function f1() returns int +begin + insert into t1 (a) values (1); + insert into t1 (a) values (1); + return 1; +end| +create function f2() returns int +begin + insert into t2 (a) values (1); + return 2; +end| +delimiter ;| + +flush status; +--error 1062 +select f1(), f2(); +show status like 'Com_insert'; +select * from t1; +select * from t2; +drop table t1; +drop table t2; +drop function f1; +drop function f2; # # testing the value encoding in the error messages of set_var # |