diff options
Diffstat (limited to 'mysql-test/r/derived_view.result')
| -rw-r--r-- | mysql-test/r/derived_view.result | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/mysql-test/r/derived_view.result b/mysql-test/r/derived_view.result index c0daabc148f..2b041448d3b 100644 --- a/mysql-test/r/derived_view.result +++ b/mysql-test/r/derived_view.result @@ -2234,7 +2234,7 @@ DROP VIEW v; DROP TABLE t1,t2; # # mdev-5105: memory overwrite in multi-table update -# using natuaral join with a view +# using natural join with a view # create table t1(a int,b tinyint,c tinyint)engine=myisam; create table t2(a tinyint,b float,c int, d int, e int, f int, key (b), key(c), key(d), key(e), key(f))engine=myisam; @@ -2244,6 +2244,19 @@ update t3 natural join v1 set a:=1; drop view v1; drop table t1,t2,t3; # +# mdev-5288: assertion failure for query over a view with ORDER BY +# +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; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +Warnings: +Note 1003 select 4 AS `a` from dual where (4 > 100) order by 1 +DROP VIEW v1; +DROP TABLE t1; +# # end of 5.3 tests # set optimizer_switch=@exit_optimizer_switch; |