diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-06-15 21:48:38 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-06-15 21:48:38 -0700 |
| commit | 078b59f5bcb2f4f5d45451a40b798cc92913f7fb (patch) | |
| tree | 3e1874756e544c0c0c4852ac5a6b3d5fe60b26bd /mysql-test/r/multi_update.result | |
| parent | a9d73e093aa68351fd6776a892012deffa27fb7d (diff) | |
| parent | ab411f8f1c2e84082623c038eb024c15c58745b5 (diff) | |
| download | mariadb-git-078b59f5bcb2f4f5d45451a40b798cc92913f7fb.tar.gz | |
Merge of mwl #106 into 5.3.
Diffstat (limited to 'mysql-test/r/multi_update.result')
| -rw-r--r-- | mysql-test/r/multi_update.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index 7dd35f2c81c..bdb59eed946 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -668,6 +668,11 @@ INSERT INTO t1 VALUES('2001-01-01'); UPDATE (SELECT 1 FROM t1 WHERE f1 = (SELECT f1() FROM t1)) x, t1 SET f1 = 1; Warnings: Warning 1292 Incorrect datetime value: '1' +CREATE view v1 as SELECT f1() FROM t1; +UPDATE (SELECT 1 FROM t1 WHERE f1 = (select * from v1)) x, t1 SET f1 = 1; +Warnings: +Warning 1292 Incorrect datetime value: '1' +DROP VIEW v1; DROP FUNCTION f1; DROP TABLE t1; end of tests |