percona-discussion team mailing list archive

[Percona <launchpad@xxxxxxxxxxx>]

released in build10

** Changed in: percona-patches
       Status: Fix Committed => Fix Released

-- 
test fails 5.0.67 rev7 
https://bugs.launchpad.net/bugs/302895
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.

Status in Patches for MySQL by Percona: Fix Released

Bug description:
mysqlshow                      [ fail ]

--- /usr/local/mysql-5.0.67-testcrach/mysql-test/r/mysqlshow.result     2008-11-27 20:35:35.000000000 +0300
+++ /usr/local/mysql-5.0.67-testcrach/mysql-test/r/mysqlshow.reject     2008-11-27 20:46:25.000000000 +0300
@@ -102,6 +102,7 @@
 | USER_PRIVILEGES                       |
 | USER_STATISTICS                       |
 | VIEWS                                 |
+| INNODB_IO_PATTERN                     |
 +---------------------------------------+
 Database: INFORMATION_SCHEMA
 +---------------------------------------+
@@ -130,6 +131,7 @@
 | USER_PRIVILEGES                       |
 | USER_STATISTICS                       |
 | VIEWS                                 |
+| INNODB_IO_PATTERN                     |
 +---------------------------------------+

information_schema_db          [ fail ]

--- /usr/local/mysql-5.0.67-testcrach/mysql-test/r/information_schema_db.result 2008-11-27 20:35:35.000000000 +0300
+++ /usr/local/mysql-5.0.67-testcrach/mysql-test/r/information_schema_db.reject 2008-11-27 20:42:18.000000000 +0300
@@ -28,6 +28,7 @@
 USER_PRIVILEGES
 USER_STATISTICS
 VIEWS
+INNODB_IO_PATTERN
 show tables from INFORMATION_SCHEMA like 'T%';
 Tables_in_information_schema (T%)
 TABLES

information_schema             [ fail ]

--- /usr/local/mysql-5.0.67-testcrach/mysql-test/r/information_schema.result    2008-11-27 20:35:35.000000000 +0300
+++ /usr/local/mysql-5.0.67-testcrach/mysql-test/r/information_schema.reject    2008-11-27 20:42:14.000000000 +0300
@@ -59,6 +59,7 @@
 USER_PRIVILEGES
 USER_STATISTICS
 VIEWS
+INNODB_IO_PATTERN
 columns_priv
 db
 func
@@ -742,7 +743,7 @@
 CREATE VIEW a1 (t_CRASHME) AS SELECT f1 FROM t_crashme GROUP BY f1;
 CREATE VIEW a2 AS SELECT t_CRASHME FROM a1;
 count(*)
-108
+109
 drop view a2, a1;
 drop table t_crashme;
 select table_schema,table_name, column_name from
@@ -812,12 +813,13 @@
 TABLE_PRIVILEGES       TABLE_NAME      select
 TABLE_STATISTICS       TABLE_NAME      select
 VIEWS  TABLE_NAME      select
+INNODB_IO_PATTERN      TABLE_NAME      select
 delete from mysql.user where user='mysqltest_4';
 delete from mysql.db where user='mysqltest_4';
 flush privileges;
 SELECT table_schema, count(*) FROM information_schema.TABLES GROUP BY TABLE_SCHEMA;
 table_schema   count(*)
-information_schema     23
+information_schema     24
 mysql  17
 create table t1 (i int, j int);
 create trigger trg1 before insert on t1 for each row
@@ -1225,6 +1227,7 @@
 USER_PRIVILEGES        GRANTEE
 USER_STATISTICS        USER
 VIEWS  TABLE_SCHEMA
+INNODB_IO_PATTERN      SPACE
 SELECT t.table_name, c1.column_name
 FROM information_schema.tables t
 INNER JOIN
@@ -1263,6 +1266,7 @@
 USER_PRIVILEGES        GRANTEE
 USER_STATISTICS        USER
 VIEWS  TABLE_SCHEMA
+INNODB_IO_PATTERN      SPACE
 SELECT MAX(table_name) FROM information_schema.tables;
 MAX(table_name)
 VIEWS
@@ -1337,6 +1341,7 @@
 COLUMN_PRIVILEGES      information_schema.COLUMN_PRIVILEGES    1
 INDEX_STATISTICS       information_schema.INDEX_STATISTICS     1
 INNODB_BUFFER_POOL_CONTENT     information_schema.INNODB_BUFFER_POOL_CONTENT   1
+INNODB_IO_PATTERN      information_schema.INNODB_IO_PATTERN    1
 KEY_COLUMN_USAGE       information_schema.KEY_COLUMN_USAGE     1
 PROCESSLIST    information_schema.PROCESSLIST  1
 PROFILING      information_schema.PROFILING    1

mysqltest: Result content mismatch