diff options
author | Kristofer Pettersson <kristofer.pettersson@sun.com> | 2009-09-15 09:33:25 +0200 |
---|---|---|
committer | Kristofer Pettersson <kristofer.pettersson@sun.com> | 2009-09-15 09:33:25 +0200 |
commit | a041c79ec9122277a9c09d3082011f46d24d4578 (patch) | |
tree | e2b6157a2db75a4dc07850ee7a3c74ab9822b71f /mysql-test/r/create.result | |
parent | cae61b1ce435366e05b52cc9251257163bf4846a (diff) | |
parent | 09f07bc1107c0facc32c16c58bae0215ce08eeea (diff) | |
download | mariadb-git-a041c79ec9122277a9c09d3082011f46d24d4578.tar.gz |
autocommit
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); |