MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Satya B Date:September 4 2009 7:11am
Subject:bzr push into mysql-pe branch (satya.bn:3579 to 3580)
View as plain text  
 3580 Satya B	2009-09-04 [merge]
      merge mysql-5.1-bugteam to mysql-pe

    modified:
      mysql-test/r/create.result
      mysql-test/t/create.test
 3579 Satya B	2009-09-04 [merge]
      NULL merge mysql-5.1-bugteam to mysql-pe

=== modified file 'mysql-test/r/create.result'
--- a/mysql-test/r/create.result	2009-07-29 10:25:07 +0000
+++ b/mysql-test/r/create.result	2009-09-04 07:07:26 +0000
@@ -1577,6 +1577,19 @@ CREATE TABLE IF NOT EXISTS t2 (a INTEGER
 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);

=== modified file 'mysql-test/t/create.test'
--- a/mysql-test/t/create.test	2009-07-29 10:25:07 +0000
+++ b/mysql-test/t/create.test	2009-09-04 07:07:26 +0000
@@ -1202,6 +1202,23 @@ CREATE TABLE IF NOT EXISTS t2 (a INTEGER
 
 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
 


Attachment: [text/bzr-bundle] bzr/satya.bn@sun.com-20090904070726-erqngti0yhq3734g.bundle
Thread
bzr push into mysql-pe branch (satya.bn:3579 to 3580)Satya B4 Sep