diff options
| author | Jon Olav Hauglid <jon.hauglid@sun.com> | 2009-12-10 13:15:20 +0100 |
|---|---|---|
| committer | Jon Olav Hauglid <jon.hauglid@sun.com> | 2009-12-10 13:15:20 +0100 |
| commit | b6fb4dbab23490eca5c181e3fb68ce61bdd36a87 (patch) | |
| tree | c183cb922102fa8b3f5b0b1f2f812d8b02880ef6 /mysql-test/r/view.result | |
| parent | 3173cf335b1cca8bc2265e060c4e983c038bbd0e (diff) | |
| download | mariadb-git-b6fb4dbab23490eca5c181e3fb68ce61bdd36a87.tar.gz | |
Backport of revno: 2617.68.45
Bug #47635 assert in start_waiting_global_read_lock during CREATE VIEW
The problem was that CREATE VIEW would trigger an assert if
a temporary table with the same name already existed.
This bug was fixed by the patch for Bug#47335. CREATE/ALTER VIEW
will now ignore temporary tables. See Bug#47335 for more information.
Test case added to view.test.
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index cb53bf462f5..c097b70680f 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -3976,3 +3976,18 @@ SELECT * FROM v1; f1 2 DROP VIEW v1; +# +# Bug #47635 assert in start_waiting_global_read_lock +# during CREATE VIEW +# +DROP TABLE IF EXISTS t1, t2; +DROP VIEW IF EXISTS t2; +CREATE TABLE t1 (f1 integer); +CREATE TEMPORARY TABLE IF NOT EXISTS t1 (f1 integer); +CREATE TEMPORARY TABLE t2 (f1 integer); +DROP TABLE t1; +FLUSH TABLES WITH READ LOCK; +CREATE VIEW t2 AS SELECT * FROM t1; +ERROR HY000: Can't execute the query because you have a conflicting read lock +UNLOCK TABLES; +DROP TABLE t1, t2; |