diff options
| author | unknown <igor@rurik.mysql.com> | 2005-06-21 08:15:49 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-06-21 08:15:49 -0700 |
| commit | 8f318ec5a027051318c66ede077c7a43c539be6b (patch) | |
| tree | aa018577f36b4e1a202d66482464a98725f26231 /mysql-test/r/group_by.result | |
| parent | 109161c3facdb5a439c7a5adead84a595ce6ef3e (diff) | |
| download | mariadb-git-8f318ec5a027051318c66ede077c7a43c539be6b.tar.gz | |
group_by.result, group_by.test:
Correction for the test case of bug #11295 to remove
warning.
mysql-test/t/group_by.test:
Correction for the test case of bug #11295 to remove
warning.
mysql-test/r/group_by.result:
Correction for the test case of bug #11295 to remove
warning.
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 0fda8e2b048..edad116028f 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -745,9 +745,9 @@ CREATE TABLE t1 (id varchar(20) NOT NULL); INSERT INTO t1 VALUES ('trans1'), ('trans2'); CREATE TABLE t2 (id varchar(20) NOT NULL, err_comment blob NOT NULL); INSERT INTO t2 VALUES ('trans1', 'a problem'); -SELECT COUNT(DISTINCT(t1.id)), LEFT(err_comment, 256) AS err_comment -FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY err_comment; -COUNT(DISTINCT(t1.id)) err_comment +SELECT COUNT(DISTINCT(t1.id)), LEFT(err_comment, 256) AS comment +FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY comment; +COUNT(DISTINCT(t1.id)) comment 1 NULL 1 a problem DROP TABLE t1, t2; |