Percona Server moved to https://jira.percona.com/projects/PS

Merge lp:~percona-dev/percona-server/test_userstat_bug602047_for55 into lp:~percona-dev/percona-server/5.5.8

  1. test_userstat_bug602047_for55
  2. Merge into 5.5.8
Proposed by Valentine Gostev
Status: Merged
Approved by: Vadim Tkachenko
Approved revision: no longer in the source branch.
Merged at revision: 67
Proposed branch: lp:~percona-dev/percona-server/test_userstat_bug602047_for55
Merge into: lp:~percona-dev/percona-server/5.5.8
Diff against target: 31 lines (+22/-0)
2 files modified
mysql-test/userstat_bug602047.result (+13/-0)
mysql-test/userstat_bug602047.test (+9/-0)
To merge this branch: bzr merge lp:~percona-dev/percona-server/test_userstat_bug602047_for55
Reviewer Review Type Date Requested Status
Percona developers Pending
Review via email: mp+48801@code.launchpad.net

Description of the change

Added test case for bug 602047

To post a comment you must log in.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added file 'mysql-test/userstat_bug602047.result'
2--- mysql-test/userstat_bug602047.result 1970-01-01 00:00:00 +0000
3+++ mysql-test/userstat_bug602047.result 2011-02-07 15:56:04 +0000
4@@ -0,0 +1,13 @@
5+DROP TABLE IF EXISTS t1;
6+SET GLOBAL userstat_running=ON;
7+CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB;
8+INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
9+SELECT COUNT(*) FROM t1;
10+COUNT(*)
11+10
12+SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1';
13+ROWS_READ
14+10
15+SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1';
16+ROWS_READ
17+10
18
19=== added file 'mysql-test/userstat_bug602047.test'
20--- mysql-test/userstat_bug602047.test 1970-01-01 00:00:00 +0000
21+++ mysql-test/userstat_bug602047.test 2011-02-07 15:56:04 +0000
22@@ -0,0 +1,9 @@
23+--disable_warnings
24+DROP TABLE IF EXISTS t1;
25+--enable_warnings
26+SET GLOBAL userstat_running=ON;
27+CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB;
28+INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
29+SELECT COUNT(*) FROM t1;
30+SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1';
31+SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1';

Subscribers

People subscribed via source and target branches

to all changes: