diff options
| author | John H. Embretsen <john.embretsen@sun.com> | 2009-10-05 15:16:27 +0200 |
|---|---|---|
| committer | John H. Embretsen <john.embretsen@sun.com> | 2009-10-05 15:16:27 +0200 |
| commit | 85bb4aa09ee906c5cb8a3f7af8ff319e3a6c93b9 (patch) | |
| tree | 189d823c44a9e85b6e62485acc4b51b49280f253 /mysql-test/include/mix1.inc | |
| parent | de985fc732fb63791089f081fb8d10e57aafab5e (diff) | |
| download | mariadb-git-85bb4aa09ee906c5cb8a3f7af8ff319e3a6c93b9.tar.gz | |
Bug#47746 - main.innodb_mysql fails sporadically:
Mask part of EXPLAIN output with '#' to account for varying row count estimation.
mysql-test/include/mix1.inc:
Mask 'rows' column in EXPLAIN output (number varies sometimes between 1 and 2).
mysql-test/r/innodb_mysql.result:
Update result file after masking of rows estimation in EXPLAIN output.
Diffstat (limited to 'mysql-test/include/mix1.inc')
| -rw-r--r-- | mysql-test/include/mix1.inc | 2 |
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'; |