diff options
| author | Patrick Crews <patrick.crews@sun.com> | 2009-04-16 13:47:44 -0400 |
|---|---|---|
| committer | Patrick Crews <patrick.crews@sun.com> | 2009-04-16 13:47:44 -0400 |
| commit | 5b05d360b0003de4aaa8b0e88d7a70d5c70dfb72 (patch) | |
| tree | 7a0e79be02899dcf22e51c42d3c0a87f180de463 /mysql-test/r/count_distinct3.result | |
| parent | 9301da563fa9643648413aedc2eadce72097d317 (diff) | |
| download | mariadb-git-5b05d360b0003de4aaa8b0e88d7a70d5c70dfb72.tar.gz | |
Bug#26887 - main.count_distinct3 fails randomly
Streamlined how we increase the size of our test table.
The new method shows run time decreased by ~60%.
This is not a guarantee that we will not see test timeouts (the random failures noted in the bug),
but it should significantly reduce the chances of this occurring.
Diffstat (limited to 'mysql-test/r/count_distinct3.result')
| -rw-r--r-- | mysql-test/r/count_distinct3.result | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/r/count_distinct3.result b/mysql-test/r/count_distinct3.result index 086e1360b0c..840c26669a1 100644 --- a/mysql-test/r/count_distinct3.result +++ b/mysql-test/r/count_distinct3.result @@ -2,7 +2,8 @@ DROP TABLE IF EXISTS t1, t2; CREATE TABLE t1 (id INTEGER, grp TINYINT, id_rev INTEGER); SELECT COUNT(*) FROM t1; COUNT(*) -4181000 +4201000 SELECT COUNT(DISTINCT id) FROM t1 GROUP BY grp; +# Begin cleanup +SET session myisam_sort_buffer_size = @orig_myisam_sort_buffer_size; DROP TABLE t1; -set @@read_buffer_size=default; |