diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-06-09 00:13:00 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-06-09 00:13:00 -0700 |
| commit | 7f345153f91c5395e5ab4ce5906fcabbb6d06f51 (patch) | |
| tree | 00d8d3897c98f18bad884c69195cef98e8739105 /mysql-test/r/view.result | |
| parent | db0c3406011d9a6d6fdb98c1c1f7925d243bd1f9 (diff) | |
| download | mariadb-git-7f345153f91c5395e5ab4ce5906fcabbb6d06f51.tar.gz | |
Fixed LP bug #794038.
INSERT/UPDATE/DELETE statement that used a temptable view v1 could lead to
a crash if v1 was defined as a select from a mergeable view v2 that selected
rows from a temptable view v3.
When INSERT/UPDATE/DELETE uses a view that is not updatable then field
translation for the view should be created before the prepare phase.
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 4eaf1eb4793..9f720019303 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -4168,3 +4168,19 @@ a a b 2 2 30 DROP VIEW v2; DROP TABLE t1,t2; +# +# Bug#794038: crash with INSERT/UPDATE/DELETE +# over a non-updatable view +# +CREATE TABLE t1 (a int); +CREATE ALGORITHM = TEMPTABLE VIEW v1 AS SELECT * FROM t1; +CREATE ALGORITHM = MERGE VIEW v2 AS SELECT * FROM v1; +CREATE ALGORITHM = TEMPTABLE VIEW v3 AS SELECT * FROM v2; +INSERT INTO v3 VALUES (1); +ERROR HY000: The target table v3 of the INSERT is not insertable-into +UPDATE v3 SET a=0; +ERROR HY000: The target table v3 of the UPDATE is not updatable +DELETE FROM v3; +ERROR HY000: The target table v3 of the DELETE is not updatable +DROP VIEW v1,v2,v3; +DROP TABLE t1; |