diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-11-14 13:25:05 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-11-14 13:25:05 -0800 |
| commit | f8a6ee59acb082678cf601a10cbe9c1152748242 (patch) | |
| tree | d8b94022590919fb3d56abb52e6beb68eb837236 /mysql-test/t/derived_view.test | |
| parent | 41b0545194a75d96b6a0b7bcf7f0d21923478623 (diff) | |
| download | mariadb-git-f8a6ee59acb082678cf601a10cbe9c1152748242.tar.gz | |
Fixed bug mdev-5288.
This bug was a consequence of the incorrect fix for bug mdev-5091.
Diffstat (limited to 'mysql-test/t/derived_view.test')
| -rw-r--r-- | mysql-test/t/derived_view.test | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/mysql-test/t/derived_view.test b/mysql-test/t/derived_view.test index 8d1b3109d20..3da58d8ae23 100644 --- a/mysql-test/t/derived_view.test +++ b/mysql-test/t/derived_view.test @@ -1566,7 +1566,7 @@ DROP TABLE t1,t2; --echo # --echo # mdev-5105: memory overwrite in multi-table update ---echo # using natuaral join with a view +--echo # using natural join with a view --echo # create table t1(a int,b tinyint,c tinyint)engine=myisam; @@ -1579,6 +1579,19 @@ drop view v1; drop table t1,t2,t3; --echo # +--echo # mdev-5288: assertion failure for query over a view with ORDER BY +--echo # + +CREATE TABLE t1 (a int, b int) ENGINE=MyISAM; +INSERT INTO t1 VALUES (4,1); + +CREATE ALGORITHM=MERGE VIEW v1 AS SELECT * FROM t1; +EXPLAIN EXTENDED SELECT a FROM v1 WHERE a > 100 ORDER BY b; + +DROP VIEW v1; +DROP TABLE t1; + +--echo # --echo # end of 5.3 tests --echo # |