summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_group.result
diff options
context:
space:
mode:
authorgkodinov/kgeorge@macbook.gmz <>2006-09-27 13:03:41 +0300
committergkodinov/kgeorge@macbook.gmz <>2006-09-27 13:03:41 +0300
commita01e7b12ce119bba8e3f2ef141d13e49c46dd4f3 (patch)
tree65907e2a768f8c8264d23443578b32087e11b8f4 /mysql-test/r/func_group.result
parentfb077c0efd02bc1503f0267ce4d7c94117f3e505 (diff)
parent903387afc00fbc367aefbc32f973ea3b52d85fd9 (diff)
downloadmariadb-git-a01e7b12ce119bba8e3f2ef141d13e49c46dd4f3.tar.gz
Merge macbook.gmz:/Users/kgeorge/mysql/work/B21174-5.0-opt
into macbook.gmz:/Users/kgeorge/mysql/work/B21174-5.1-opt
Diffstat (limited to 'mysql-test/r/func_group.result')
-rw-r--r--mysql-test/r/func_group.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result
index 3838f04e20d..40ca0a38db2 100644
--- a/mysql-test/r/func_group.result
+++ b/mysql-test/r/func_group.result
@@ -851,8 +851,8 @@ CREATE TABLE t1 (a INT, b INT);
INSERT INTO t1 VALUES (1,1),(1,2),(2,3);
SELECT (SELECT COUNT(DISTINCT t1.b)) FROM t1 GROUP BY t1.a;
(SELECT COUNT(DISTINCT t1.b))
-0
2
+1
SELECT (SELECT COUNT(DISTINCT 12)) FROM t1 GROUP BY t1.a;
(SELECT COUNT(DISTINCT 12))
1
@@ -1004,7 +1004,7 @@ SELECT SQL_NO_CACHE
WHERE ttt.a = ccc.b AND ttt.a = t.a GROUP BY ttt.a) AS minid
FROM t1 t, t2 c WHERE t.a = c.b;
minid
-NULL
+1
DROP TABLE t1,t2;
create table t1 select variance(0);
show create table t1;