test fails 5.0.67 rev7
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona patches |
Fix Released
|
High
|
Unassigned |
Bug Description
mysqlshow [ fail ]
--- /usr/local/
+++ /usr/local/
@@ -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_
--- /usr/local/
+++ /usr/local/
@@ -28,6 +28,7 @@
USER_PRIVILEGES
USER_STATISTICS
VIEWS
+INNODB_IO_PATTERN
show tables from INFORMATION_SCHEMA like 'T%';
Tables_
TABLES
information_schema [ fail ]
--- /usr/local/
+++ /usr/local/
@@ -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,
@@ -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_
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_
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_
MAX(table_name)
VIEWS
@@ -1337,6 +1341,7 @@
COLUMN_PRIVILEGES information_
INDEX_STATISTICS information_
INNODB_
+INNODB_IO_PATTERN information_
KEY_COLUMN_USAGE information_
PROCESSLIST information_
PROFILING information_
mysqltest: Result content mismatch
Changed in percona-patches: | |
assignee: | nobody → yasufumi-kinoshita |
importance: | Undecided → High |
status: | New → Confirmed |
Changed in percona-patches: | |
status: | Confirmed → Fix Committed |
Changed in percona-patches: | |
assignee: | vadim-tk → nobody |
please review changes