Merge lp:~percona-dev/percona-server/test_userstat_bug602047 into lp:percona-server/release-5.1.54-12

[Valentine Gostev]

Added test case for userstat patch bug 602047

[Alexey Kopytov (akopytov)]

Looks good to me.

review: Approve

[Vadim Tkachenko (vadim-tk)]

Should be merged into 5.5.8 too

=== added file 'mysql-test/userstat_bug602047.result'
--- mysql-test/userstat_bug602047.result	1970-01-01 00:00:00 +0000
+++ mysql-test/userstat_bug602047.result	2011-02-07 15:13:38 +0000
@@ -0,0 +1,13 @@
+DROP TABLE IF EXISTS t1;
+SET GLOBAL userstat_running=ON;
+CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB;
+INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
+SELECT COUNT(*) FROM t1;
+COUNT(*)
+10
+SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1';
+ROWS_READ
+10
+SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1';
+ROWS_READ
+10
 
=== added file 'mysql-test/userstat_bug602047.test'
--- mysql-test/userstat_bug602047.test	1970-01-01 00:00:00 +0000
+++ mysql-test/userstat_bug602047.test	2011-02-07 15:13:38 +0000
@@ -0,0 +1,9 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1; 
+--enable_warnings
+SET GLOBAL userstat_running=ON;
+CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB;
+INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
+SELECT COUNT(*) FROM t1; 
+SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1';
+SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1';