summaryrefslogtreecommitdiff
path: root/mysql-test/t/view.test
diff options
context:
space:
mode:
authorevgen@moonbone.local <>2005-11-16 02:08:20 +0300
committerevgen@moonbone.local <>2005-11-16 02:08:20 +0300
commit7749b8d15b6bd7490be2b0afc636e09f7168abe0 (patch)
treed99833389492c7d58b799afe2da88bb8b5443c4d /mysql-test/t/view.test
parent13ae8d8d7096cf9eff7952f176a4e81cd0afc777 (diff)
parent35f7b50b181ec58f149a8f0bfc720ab81f762695 (diff)
downloadmariadb-git-7749b8d15b6bd7490be2b0afc636e09f7168abe0.tar.gz
Merge
Diffstat (limited to 'mysql-test/t/view.test')
-rw-r--r--mysql-test/t/view.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index 899279dc912..7608d121c55 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -2255,6 +2255,16 @@ show create view v1;
drop view v1;
#
+# Bug #14816 test_if_order_by_key() expected only Item_fields.
+#
+create table t1 (id INT, primary key(id));
+insert into t1 values (1),(2);
+create view v1 as select * from t1;
+explain select id from v1 order by id;
+drop view v1;
+drop table t1;
+
+#
# Bug #14850 Item_ref's values wasn't updated
#
create table t1(f1 int, f2 int);