// OUTPUT FROM TEST:
./test-run --suite=broken create-table-like-with-fk-bug-lp622465
Logging: ./test-run --suite=broken create-table-like-with-fk-bug-lp622465
Drizzle Version 2010.09.1727
Using MTR_BUILD_THREAD = -69.4
Using MASTER_MYPORT = 9306
Using MASTER_MYPORT1 = 9307
Using SLAVE_MYPORT = 9308
Using SLAVE_MYPORT1 = 9309
Using SLAVE_MYPORT2 = 9310
Using MC_PORT = 9316
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
================================================================================
DEFAULT STORAGE ENGINE: innodb
TEST RESULT TIME (ms)
--------------------------------------------------------------------------------
broken.create-table-like-with-fk-bug-lp622465 [ fail ]
drizzletest: At line 18: query 'CREATE TABLE t3 LIKE t2' failed: 1005: Can't create table 'test.t3' (errno: 121)
The result from queries just before the failure was:
DROP TABLE IF EXISTS `t3`;
DROP TABLE IF EXISTS `t2`;
DROP TABLE IF EXISTS `t1`;
CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=INNODB;
CREATE TABLE t2 LIKE t1;
ALTER TABLE t2 ADD FOREIGN KEY (id) REFERENCES t1(id);
CREATE TABLE t3 LIKE t2;
More results from queries before failure can be found in /home/tdavies/hacking/dzzRepo/drizzle-bug622465/tests/var/log/create-table-like-with-fk-bug-lp622465.log
Aborting: broken.create-table-like-with-fk-bug-lp622465 failed in default mode.
To continue, re-run with '--force'.
Stopping All Servers
// OUTPUT FROM WITHIN CLIENT:
drizzle> use test
Database changed
drizzle> drop table if exists `t1`;
Query OK, 0 rows affected, 1 warning (0 sec)
drizzle> drop table if exists `t2`;
Query OK, 0 rows affected, 1 warning (0 sec)
drizzle> drop table if exists `t3`;
Query OK, 0 rows affected, 1 warning (0 sec)
drizzle> create table t1 (id int primary key);
Query OK, 0 rows affected (0.04 sec)
I Confirm this.
// OUTPUT FROM TEST: table-like- with-fk- bug-lp622465 table-like- with-fk- bug-lp622465 ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= === ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---
./test-run --suite=broken create-
Logging: ./test-run --suite=broken create-
Drizzle Version 2010.09.1727
Using MTR_BUILD_THREAD = -69.4
Using MASTER_MYPORT = 9306
Using MASTER_MYPORT1 = 9307
Using SLAVE_MYPORT = 9308
Using SLAVE_MYPORT1 = 9309
Using SLAVE_MYPORT2 = 9310
Using MC_PORT = 9316
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
=======
DEFAULT STORAGE ENGINE: innodb
TEST RESULT TIME (ms)
-------
broken. create- table-like- with-fk- bug-lp622465 [ fail ]
drizzletest: At line 18: query 'CREATE TABLE t3 LIKE t2' failed: 1005: Can't create table 'test.t3' (errno: 121)
The result from queries just before the failure was:
DROP TABLE IF EXISTS `t3`;
DROP TABLE IF EXISTS `t2`;
DROP TABLE IF EXISTS `t1`;
CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=INNODB;
CREATE TABLE t2 LIKE t1;
ALTER TABLE t2 ADD FOREIGN KEY (id) REFERENCES t1(id);
CREATE TABLE t3 LIKE t2;
More results from queries before failure can be found in /home/tdavies/ hacking/ dzzRepo/ drizzle-bug622465/tests/ var/log/ create- table-like- with-fk- bug-lp622465. log
Aborting: broken. create- table-like- with-fk- bug-lp622465 failed in default mode.
To continue, re-run with '--force'.
Stopping All Servers
// OUTPUT FROM WITHIN CLIENT:
drizzle> use test
Database changed
drizzle> drop table if exists `t1`;
Query OK, 0 rows affected, 1 warning (0 sec)
drizzle> drop table if exists `t2`;
Query OK, 0 rows affected, 1 warning (0 sec)
drizzle> drop table if exists `t3`;
Query OK, 0 rows affected, 1 warning (0 sec)
drizzle> create table t1 (id int primary key);
Query OK, 0 rows affected (0.04 sec)
drizzle> create table `t2` like `t1`;
Query OK, 0 rows affected (0.04 sec)
drizzle> alter table `t2` add foreign key (`id`) references `t1`(`id`);
Query OK, 0 rows affected (0.15 sec)
Records: 0 Duplicates: 0 Warnings: 0
drizzle> create table `t3` like `t2`;
ERROR 1005 (HY000): Can't create table 'test.t3' (errno: 121)
drizzle>