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/t/create.test | |
| 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/t/create.test')
| -rw-r--r-- | mysql-test/t/create.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index 75ad6c056c1..5ffa1b93929 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -1198,6 +1198,23 @@ CREATE TABLE IF NOT EXISTS t2 (a INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY) DROP TABLE t1, t2; +--echo # +--echo # BUG#46384 - mysqld segfault when trying to create table with same +--echo # name as existing view +--echo # + +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; +--error ER_TABLE_EXISTS_ERROR +CREATE TABLE v1 AS SELECT * FROM t1; + +DROP VIEW v1; +DROP TABLE t1,t2; --echo End of 5.0 tests |