diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2015-03-07 19:30:19 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2015-03-07 19:30:19 +0300 |
| commit | 66ad265f3b58121d5a48c492dff79f48863df7c0 (patch) | |
| tree | 4f4406098bb04379f57bcb94bc9684a4daf40144 /mysql-test/t/analyze_stmt.test | |
| parent | 143f5d9172647a43cdcf5c27b8a78f32c9f639c0 (diff) | |
| download | mariadb-git-66ad265f3b58121d5a48c492dff79f48863df7c0.tar.gz | |
MDEV-7674: ANALYZE shows r_rows=0
Change r_rows to be double
Diffstat (limited to 'mysql-test/t/analyze_stmt.test')
| -rw-r--r-- | mysql-test/t/analyze_stmt.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/analyze_stmt.test b/mysql-test/t/analyze_stmt.test index 4da16cf6474..b64dfe62182 100644 --- a/mysql-test/t/analyze_stmt.test +++ b/mysql-test/t/analyze_stmt.test @@ -244,3 +244,18 @@ create table t1(a int); prepare stmt from "analyze select * from t1"; execute stmt; drop table t1; + +--echo # +--echo # MDEV-7674: ANALYZE shows r_rows=0 +--echo # + +create table t1(a int); +insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); + +create table t2 (a int, key(a)); +insert into t2 values (0),(1); + +analyze select * from t1 straight_join t2 force index(a) where t2.a=t1.a; + +drop table t1,t2; + |