summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2006-01-06 01:08:48 +0200
committerunknown <monty@mysql.com>2006-01-06 01:08:48 +0200
commit29fde5280234821d4e8fa429991cddf60fa2093f (patch)
tree14416e5a83f9880e39f89a0bf5f03a8613ef7ce0 /mysql-test/r/view.result
parentf133b06567c459ad299cf16c38b5d3655abe1266 (diff)
parent64206b1850bc93c74f93c3e0dd2e2e909240fcda (diff)
downloadmariadb-git-29fde5280234821d4e8fa429991cddf60fa2093f.tar.gz
Merge bk-internal.mysql.com:/home/bk/mysql-5.0
into mysql.com:/home/my/mysql-5.0 mysql-test/r/create.result: Auto merged mysql-test/r/trigger.result: Auto merged mysql-test/r/view.result: Auto merged mysql-test/t/create.test: Auto merged mysql-test/t/trigger.test: Auto merged mysql-test/t/view.test: Auto merged sql/field.cc: Auto merged sql/ha_ndbcluster.cc: Auto merged sql/item.cc: Auto merged sql/item.h: Auto merged sql/log_event.cc: Auto merged sql/opt_range.cc: Auto merged sql/sp.cc: Auto merged sql/sp_head.h: Auto merged sql/sql_acl.cc: Auto merged sql/sql_base.cc: Auto merged sql/sql_insert.cc: Auto merged sql/sql_parse.cc: Auto merged sql/sql_select.cc: Auto merged mysql-test/t/disabled.def: Manual merge sql/mysqld.cc: Manual merge sql/sp_head.cc: Manual merge sql/sql_trigger.cc: Manual merge
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r--mysql-test/r/view.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result
index 7e7d0617b51..b9380dcf033 100644
--- a/mysql-test/r/view.result
+++ b/mysql-test/r/view.result
@@ -2423,6 +2423,9 @@ drop view v1;
drop table t1;
create table t1(f1 int, f2 int);
insert into t1 values (null, 10), (null,2);
+select f1, sum(f2) from t1 group by f1;
+f1 sum(f2)
+NULL 12
create view v1 as select * from t1;
select f1, sum(f2) from v1 group by f1;
f1 sum(f2)