diff options
| author | unknown <igor@rurik.mysql.com> | 2005-06-21 04:24:21 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-06-21 04:24:21 -0700 |
| commit | 7b1ec027325870da62d0a6b36eeb04b03bd0f576 (patch) | |
| tree | 6a5160e60d71a61a6276fc0e587e3660e267c5bf /mysql-test/r/group_by.result | |
| parent | 15b113e186939e091af4c93759dfc1ca66a37fda (diff) | |
| download | mariadb-git-7b1ec027325870da62d0a6b36eeb04b03bd0f576.tar.gz | |
group_by.result, group_by.test:
Added a test case for bug #11295.
item_buff.cc:
Fixed bug #11295.
This a correction for the patch of bug #11088 that takes into
account a possible NULL values of the BLOB column.
sql/item_buff.cc:
Fixed bug #11295.
This a correction for the patch of bug #11088 that takes into
account a possible NULL values of the BLOB column.
mysql-test/t/group_by.test:
Added a test case for bug #11295.
mysql-test/r/group_by.result:
Added a test case for bug #11295.
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index e279fca2a9d..7f78b8bda9b 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -741,3 +741,13 @@ SELECT dt DIV 1 AS f, id FROM t1 GROUP BY f; f id 20050501123000 1 DROP TABLE t1; +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 +1 NULL +1 a problem +DROP TABLE t1, t2; |