diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-07-05 03:03:31 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-07-05 03:03:31 +0300 |
| commit | 0f792995ec25f26a43c9f34a5f58fbf48e2dadcd (patch) | |
| tree | 203e283c53d8c9a1e1adedca89bac532a03e81d2 /mysql-test/r | |
| parent | e25c83e0c6b6db5c5aec223b8f4d18210017181d (diff) | |
| download | mariadb-git-0f792995ec25f26a43c9f34a5f58fbf48e2dadcd.tar.gz | |
reduced using of slow current_thd/current_lex macro
initialization of item_thd moved to constructor (in any case we need thd in constructor)
initialization of group_concat_max_len to constructor to avoid incorrect length reporting (BUG#757)
removed Item_func_group_concat::fix_length_and_dec() because item have its own fix_fields and will not have inherited items
mysql-test/r/func_gconcat.result:
test for BUG#757
mysql-test/t/func_gconcat.test:
test for BUG#757
sql/item_sum.cc:
reduced using of slow current_thd/current_lex macro
initialization of item_thd moved to constructor (in any case we need thd in constructor)
initialization of group_concat_max_len to constructor to avoid incorrect length reporting (BUG#757)
sql/item_sum.h:
removed Item_func_group_concat::fix_length_and_dec() because item have its own fix_fields and will not have inherited items
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index 770a98f69f9..3b8d8abed9e 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -177,3 +177,12 @@ ERROR HY000: Invalid use of group function select grp,group_concat(c order by 2) from t1 group by grp; ERROR 42S22: Unknown column '2' in 'group statement' drop table t1; +create table t1 (id int, name varchar(16)); +insert into t1 values (1,'longername'),(1,'evenlongername'); +select ifnull(group_concat(concat(t1.id, ':', t1.name)), 'shortname') as 'without distinct: how it should be' from t1; +without distinct: how it should be +1:longername,1:evenlongername +select distinct ifnull(group_concat(concat(t1.id, ':', t1.name)), 'shortname') as 'with distinct: cutoff at length of shortname' from t1; +with distinct: cutoff at length of shortname +1:longername,1:evenlongername +drop table t1; |