From: eugene Date: April 20 2006 9:34am Subject: bk commit into 5.0 tree (evgen:1.2089) BUG#14169 List-Archive: http://lists.mysql.com/commits/5196 X-Bug: 14169 Message-Id: <20060420093419.DBA8122EB2F@moonbone.moonbone.local> Below is the list of changes that have just been committed into a local 5.0 repository of evgen. When evgen does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html ChangeSet 1.2089 06/04/20 13:34:14 evgen@stripped +2 -0 func_gconcat.result, func_gconcat.test: Remove duplicate test case for bug#14169 mysql-test/r/func_gconcat.result 1.57 06/04/20 13:33:34 evgen@stripped +0 -10 Remove duplicate test case for bug#14169 mysql-test/t/func_gconcat.test 1.43 06/04/20 13:33:03 evgen@stripped +0 -11 Remove duplicate test case for bug#14169 # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: evgen # Host: moonbone.local # Root: /work/14169-bug-5.0-mysql --- 1.56/mysql-test/r/func_gconcat.result 2006-04-20 11:42:06 +04:00 +++ 1.57/mysql-test/r/func_gconcat.result 2006-04-20 13:33:34 +04:00 @@ -611,16 +611,6 @@ 1 3 drop table t1; -create table t1 (f1 int unsigned, f2 varchar(255)); -insert into t1 values (1,repeat('a',255)),(2,repeat('b',255)); -select f2,group_concat(f1) from t1 group by f2; -Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr -def test t1 t1 f2 f2 253 255 255 Y 0 0 8 -def group_concat(f1) 253 400 1 Y 128 0 63 -f2 group_concat(f1) -aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 1 -bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb 2 -drop table t1; set names latin1; create table t1 (a char, b char); insert into t1 values ('a', 'a'), ('a', 'b'), ('b', 'a'), ('b', 'b'); --- 1.42/mysql-test/t/func_gconcat.test 2006-04-20 05:08:10 +04:00 +++ 1.43/mysql-test/t/func_gconcat.test 2006-04-20 13:33:03 +04:00 @@ -398,17 +398,6 @@ select count(distinct (f1+1)) from t1 group by f1 with rollup; drop table t1; -# -# Bug#14169 type of group_concat() result changed to blob if tmp_table was used -# -create table t1 (f1 int unsigned, f2 varchar(255)); -insert into t1 values (1,repeat('a',255)),(2,repeat('b',255)); ---enable_metadata -select f2,group_concat(f1) from t1 group by f2; -# select f2,group_concat(f1) from t1 group by f2 order by 2; ---disable_metadata -drop table t1; - # End of 4.1 tests #