diff options
author | unknown <sergefp@mysql.com> | 2005-09-09 12:57:00 +0400 |
---|---|---|
committer | unknown <sergefp@mysql.com> | 2005-09-09 12:57:00 +0400 |
commit | fa3c6c76f2ce62ce042546320cf8f1fb517d2b54 (patch) | |
tree | b538b56b0e4ed80836f168e9cde261842bb73d7f /mysql-test/t/group_by.test | |
parent | 0ef988ada34636dee1af7c802f96b136eb7cc936 (diff) | |
download | mariadb-git-fa3c6c76f2ce62ce042546320cf8f1fb517d2b54.tar.gz |
Post-merge fixes
Diffstat (limited to 'mysql-test/t/group_by.test')
-rw-r--r-- | mysql-test/t/group_by.test | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index 4631fad3352..df5535386a5 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -575,6 +575,12 @@ 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 comment + FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY comment; + +DROP TABLE t1, t2; + # # BUG#12695: Item_func_isnull::update_used_tables # did not update const_item_cache @@ -585,12 +591,6 @@ select sql_buffer_result max(f1) is null from t1; select sql_buffer_result max(f1)+1 from t1; drop table t1; -SELECT COUNT(DISTINCT(t1.id)), LEFT(err_comment, 256) AS comment - FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY comment; - -DROP TABLE t1, t2; - - # # Bug #12266 GROUP BY expression on DATE column produces result with # reduced length |