diff options
| author | Sergey Vojtovich <svoj@sun.com> | 2009-07-14 15:06:04 +0500 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@sun.com> | 2009-07-14 15:06:04 +0500 |
| commit | cc541211c8232ff41386f99cebc446da1a06cacf (patch) | |
| tree | 74e564b644c182b72bd6b9ad0cc93ae70454e898 /mysql-test/r/trigger.result | |
| parent | 880743284eb250e1e1a33b1d3705443741b9cca2 (diff) | |
| parent | f9025ea331802d0427b46235d5ddf15b7ee4e795 (diff) | |
| download | mariadb-git-cc541211c8232ff41386f99cebc446da1a06cacf.tar.gz | |
Merge 5.1-bugteam -> 5.1-innodb_plugin.
Diffstat (limited to 'mysql-test/r/trigger.result')
| -rw-r--r-- | mysql-test/r/trigger.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result index 23f15f618f2..4476735735c 100644 --- a/mysql-test/r/trigger.result +++ b/mysql-test/r/trigger.result @@ -2073,4 +2073,18 @@ select @a, @b; drop trigger trg1; drop trigger trg2; drop table t1, t2; +CREATE TABLE t1 ( a INT, b INT ); +CREATE TABLE t2 ( a INT AUTO_INCREMENT KEY, b INT ); +INSERT INTO t1 (a) VALUES (1); +CREATE TRIGGER tr1 +BEFORE INSERT ON t2 +FOR EACH ROW +BEGIN +UPDATE a_nonextisting_table SET a = 1; +END// +CREATE TABLE IF NOT EXISTS t2 ( a INT, b INT ) SELECT a, b FROM t1; +ERROR 42S02: Table 'test.a_nonextisting_table' doesn't exist +SELECT * FROM t2; +a b +DROP TABLE t1, t2; End of 5.1 tests. |