diff options
| author | Satya B <satya.bn@sun.com> | 2009-09-04 12:27:10 +0530 |
|---|---|---|
| committer | Satya B <satya.bn@sun.com> | 2009-09-04 12:27:10 +0530 |
| commit | 7bfdc5bbf5cd0ffb9e35d19d80ac9aa527938ba1 (patch) | |
| tree | 97b65ef8882290efa15fe796624491f237faaa0d /mysql-test/r/create.result | |
| parent | 83967a64298453dd514cf17e7ec8c6b29cbf6543 (diff) | |
| parent | 6e27ef435e3863382295f1a1d41424c9b8d4c197 (diff) | |
| download | mariadb-git-7bfdc5bbf5cd0ffb9e35d19d80ac9aa527938ba1.tar.gz | |
merge mysql-5.0-bugteam to mysql-5.1-bugteam
Diffstat (limited to 'mysql-test/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 3373d206952..b829ef30fb1 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -1572,6 +1572,19 @@ CREATE TABLE IF NOT EXISTS t2 (a INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY) SELECT a FROM t1; ERROR 23000: Duplicate entry '1' for key 'PRIMARY' DROP TABLE t1, t2; +# +# BUG#46384 - mysqld segfault when trying to create table with same +# name as existing view +# +CREATE TABLE t1 (a INT); +CREATE TABLE t2 (a INT); +INSERT INTO t1 VALUES (1),(2),(3); +INSERT INTO t2 VALUES (1),(2),(3); +CREATE VIEW v1 AS SELECT t1.a FROM t1, t2; +CREATE TABLE v1 AS SELECT * FROM t1; +ERROR 42S01: Table 'v1' already exists +DROP VIEW v1; +DROP TABLE t1,t2; End of 5.0 tests CREATE TABLE t1 (a int, b int); insert into t1 values (1,1),(1,2); |