percona-discussion team mailing list archive

[Yasufumi Kinoshita <yasufumi.kinoshita@xxxxxxxxxxx>]

Public bug reported:

When apply xtradb-drizzle-compat.patch, "mysql-test-run main.innodb_mysql" always fail.
I don't recommend to apply xtradb-drizzle-compat.patch for MySQL binary.

main.innodb_mysql              [ fail ]

mysqltest: In included file "./include/mix1.inc": At line 632: query
'create table bug29807 (a int)' failed: 1050: Table 'bug29807' already
exists

The result from queries just before the failure was:
< snip >
CREATE TABLE t3 (a CHAR(2), KEY (a)) ENGINE = MyISAM;
INSERT INTO t3 VALUES ('uk'),('bg');
SELECT * FROM t3 WHERE a = 'uk';
a
uk
DELETE FROM t3 WHERE a = 'uk';
SELECT * FROM t3 WHERE a = 'uk';
a
INSERT INTO t3 VALUES ('uk');
UPDATE t3 SET a = 'us' WHERE a = 'uk';
SELECT * FROM t3 WHERE a = 'uk';
a
DROP TABLE t1,t2,t3;
create table t1 (a int) engine=innodb;
select * from bug29807;
ERROR 42S02: Table 'test.bug29807' doesn't exist
drop table t1;
drop table bug29807;
ERROR 42S02: Unknown table 'bug29807'
create table bug29807 (a int);

** Affects: percona-xtradb
     Importance: Undecided
         Status: New

-- 
xtradb-drizzle-compat.patch fails mysql-test-run main.innodb_mysql
https://bugs.launchpad.net/bugs/315000
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona-XtraDB.

Status in Percona XtraDB Storage Engine for MySQL: New

Bug description:
When apply xtradb-drizzle-compat.patch, "mysql-test-run main.innodb_mysql" always fail.
I don't recommend to apply xtradb-drizzle-compat.patch for MySQL binary.

main.innodb_mysql              [ fail ]

mysqltest: In included file "./include/mix1.inc": At line 632: query 'create table bug29807 (a int)' failed: 1050: Table 'bug29807' already exists

The result from queries just before the failure was:
< snip >
CREATE TABLE t3 (a CHAR(2), KEY (a)) ENGINE = MyISAM;
INSERT INTO t3 VALUES ('uk'),('bg');
SELECT * FROM t3 WHERE a = 'uk';
a
uk
DELETE FROM t3 WHERE a = 'uk';
SELECT * FROM t3 WHERE a = 'uk';
a
INSERT INTO t3 VALUES ('uk');
UPDATE t3 SET a = 'us' WHERE a = 'uk';
SELECT * FROM t3 WHERE a = 'uk';
a
DROP TABLE t1,t2,t3;
create table t1 (a int) engine=innodb;
select * from bug29807;
ERROR 42S02: Table 'test.bug29807' doesn't exist
drop table t1;
drop table bug29807;
ERROR 42S02: Unknown table 'bug29807'
create table bug29807 (a int);