diff options
| author | igor@olga.mysql.com <> | 2006-07-25 12:47:01 -0700 |
|---|---|---|
| committer | igor@olga.mysql.com <> | 2006-07-25 12:47:01 -0700 |
| commit | 88e6b91096db9b3dca0b0940d66cc1cf0ffd0441 (patch) | |
| tree | c5768cd1dd5ca300d3aa991cb7771ad4c6e29d60 /mysql-test/r | |
| parent | 69856b29b2b9c3c3e0f8adbcf6f130a0f2e1434e (diff) | |
| parent | 9e9fb3e4e494bad69ce0ce668645e08d224809ee (diff) | |
| download | mariadb-git-88e6b91096db9b3dca0b0940d66cc1cf0ffd0441.tar.gz | |
Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into olga.mysql.com:/home/igor/mysql-5.0-opt
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index d8a539da3fe..dc09a68682c 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -641,3 +641,16 @@ select charset(group_concat(c1 order by c2)) from t1; charset(group_concat(c1 order by c2)) latin1 drop table t1; +CREATE TABLE t1 (a INT(10), b LONGTEXT, PRIMARY KEY (a)); +SET GROUP_CONCAT_MAX_LEN = 20000000; +INSERT INTO t1 VALUES (1,REPEAT(CONCAT('A',CAST(CHAR(0) AS BINARY),'B'), 40000)); +INSERT INTO t1 SELECT a + 1, b FROM t1; +SELECT a, CHAR_LENGTH(b) FROM t1; +a CHAR_LENGTH(b) +1 120000 +2 120000 +SELECT CHAR_LENGTH( GROUP_CONCAT(b) ) FROM t1; +CHAR_LENGTH( GROUP_CONCAT(b) ) +240001 +SET GROUP_CONCAT_MAX_LEN = 1024; +DROP TABLE t1; |