diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2010-07-12 15:19:35 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2010-07-12 15:19:35 +0400 |
| commit | 843acacb5d0e70ba108c654d6afec089e75ebfb7 (patch) | |
| tree | 48f629fa64653d5615a9875ee1bc8acbebe49daf /mysql-test/suite/vcol/inc/vcol_view.inc | |
| parent | 3a9aabaa26d9ae2b0c7d83669231385045f6e992 (diff) | |
| download | mariadb-git-843acacb5d0e70ba108c654d6afec089e75ebfb7.tar.gz | |
Post-merge .result fixes
Diffstat (limited to 'mysql-test/suite/vcol/inc/vcol_view.inc')
| -rw-r--r-- | mysql-test/suite/vcol/inc/vcol_view.inc | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/inc/vcol_view.inc b/mysql-test/suite/vcol/inc/vcol_view.inc index 2bf413e2471..64149a7bb31 100644 --- a/mysql-test/suite/vcol/inc/vcol_view.inc +++ b/mysql-test/suite/vcol/inc/vcol_view.inc @@ -69,10 +69,14 @@ create table t1 (a int not null, insert into t1 (a) values (1), (2), (3), (4); create view v1 as select b+1 from t1 order by 1 desc limit 2; select * from v1; +--echo MariaDB-5.3: the following EXPLAIN produces incorrect #rows for table t1. +--echo MariaDB-5.3: this is expected to go away when FROM subquery optimizations are pushed explain select * from v1; drop view v1; create view v1 as select c+1 from t1 order by 1 desc limit 2; select * from v1; +--echo MariaDB-5.3: the following EXPLAIN produces incorrect #rows for table t1. +--echo MariaDB-5.3: this is expected to go away when FROM subquery optimizations are pushed explain select * from v1; drop view v1; drop table t1; |