diff options
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 2ccac059724..6b10edc7abd 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -1790,6 +1790,15 @@ DROP VIEW v1; DROP TABLE t1; # +# Test for bug #11709 View was ordered by wrong column +# +create table t1 (f1 int, f2 int); +create view v1 as select f1 as f3, f2 as f1 from t1; +insert into t1 values (1,3),(2,1),(3,2); +select * from v1 order by f1; +drop table t1; + +# # Test for bug #11771: wrong query_id in SELECT * FROM <view> # |