summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
diff options
context:
space:
mode:
authorunknown <evgen@moonbone.local>2005-11-18 01:16:15 +0300
committerunknown <evgen@moonbone.local>2005-11-18 01:16:15 +0300
commitd29438f25e79acaa11a8b88fc8279bdb7cb1a338 (patch)
treed57ef6d97fc9978a8ea6d82ef93515e06d07cafc /mysql-test/r/view.result
parent57ad6b20ed8b22b010af1c354b23591570f12b09 (diff)
parent56f43d9d021ddad1342d5f9c8b47f56a4adbc04e (diff)
downloadmariadb-git-d29438f25e79acaa11a8b88fc8279bdb7cb1a338.tar.gz
Manually merged
sql/sql_view.cc: Auto merged
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r--mysql-test/r/view.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result
index 42708a7c835..ae92d0178e2 100644
--- a/mysql-test/r/view.result
+++ b/mysql-test/r/view.result
@@ -2323,6 +2323,14 @@ id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t3 ALL NULL NULL NULL NULL 3 Using where
DROP VIEW v1,v2;
DROP TABLE t1,t2,t3;
+create table t1 (f1 int);
+create view v1 as select t1.f1 as '123
+456' from t1;
+select * from v1;
+123
+456
+drop view v1;
+drop table t1;
create table t1 (f1 int, f2 int);
insert into t1 values(1,1),(1,2),(1,3);
create view v1 as select f1 ,group_concat(f2 order by f2 asc) from t1 group by f1;