summaryrefslogtreecommitdiff
path: root/mysql-test/r/group_by.result
diff options
context:
space:
mode:
authorunknown <igor@rurik.mysql.com>2005-06-16 11:59:00 -0700
committerunknown <igor@rurik.mysql.com>2005-06-16 11:59:00 -0700
commitf2e153e53f412e9d88c3fb0f97725031e15edf13 (patch)
treef946cc8458e9b27bbe7ccdd4496420f7dc93dc6e /mysql-test/r/group_by.result
parent0f57c00481307dcad6bcf9f1ba27fc60f4c298a4 (diff)
downloadmariadb-git-f2e153e53f412e9d88c3fb0f97725031e15edf13.tar.gz
group_by.result, group_by.test:
Correction after merge of fix for bug #8614. mysql-test/t/group_by.test: Correction after merge of fix for bug #8614. mysql-test/r/group_by.result: Correction after merge of fix for bug #8614.
Diffstat (limited to 'mysql-test/r/group_by.result')
-rw-r--r--mysql-test/r/group_by.result8
1 files changed, 2 insertions, 6 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result
index ae986dc2a75..6e36d32bd2b 100644
--- a/mysql-test/r/group_by.result
+++ b/mysql-test/r/group_by.result
@@ -721,11 +721,8 @@ SELECT hostname, COUNT(DISTINCT user_id) as no FROM t1
WHERE hostname LIKE '%aol%'
GROUP BY hostname;
hostname no
-cache-dtc-af05.proxy.aol.com
-DROP TABLE t1; 1
-drop table if exists t1, t2;
-Warnings:
-Note 1051 Unknown table 't2'
+cache-dtc-af05.proxy.aol.com 1
+DROP TABLE t1;
create table t1 (c1 char(3), c2 char(3));
create table t2 (c3 char(3), c4 char(3));
insert into t1 values ('aaa', 'bb1'), ('aaa', 'bb2');
@@ -747,7 +744,6 @@ aaa
show warnings;
Level Code Message
drop table t1, t2;
-DROP TABLE t1;
CREATE TABLE t1 (a int, b int);
INSERT INTO t1 VALUES (1,2), (1,3);
SELECT a, b FROM t1 GROUP BY 'const';