summaryrefslogtreecommitdiff
path: root/mysql-test/include
diff options
context:
space:
mode:
authorJohn H. Embretsen <john.embretsen@sun.com>2009-10-05 15:16:27 +0200
committerJohn H. Embretsen <john.embretsen@sun.com>2009-10-05 15:16:27 +0200
commit23bdf0d805026b220061487688f0cb2d2b272975 (patch)
tree189d823c44a9e85b6e62485acc4b51b49280f253 /mysql-test/include
parentbbda071ed56bd02673b2652a9134a7e313492ce0 (diff)
downloadmariadb-git-23bdf0d805026b220061487688f0cb2d2b272975.tar.gz
Bug#47746 - main.innodb_mysql fails sporadically:
Mask part of EXPLAIN output with '#' to account for varying row count estimation.
Diffstat (limited to 'mysql-test/include')
-rw-r--r--mysql-test/include/mix1.inc2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/include/mix1.inc b/mysql-test/include/mix1.inc
index 6dabe4864a9..194d9e41108 100644
--- a/mysql-test/include/mix1.inc
+++ b/mysql-test/include/mix1.inc
@@ -442,6 +442,8 @@ INSERT INTO t1(id, dept, age, name) VALUES
EXPLAIN SELECT DISTINCT t1.name, t1.dept FROM t1 WHERE t1.name='rs5';
SELECT DISTINCT t1.name, t1.dept FROM t1 WHERE t1.name='rs5';
DELETE FROM t1;
+--echo # Masking (#) number in "rows" column of the following EXPLAIN output, as it may vary (bug#47746).
+--replace_column 9 #
EXPLAIN SELECT DISTINCT t1.name, t1.dept FROM t1 WHERE t1.name='rs5';
SELECT DISTINCT t1.name, t1.dept FROM t1 WHERE t1.name='rs5';