diff options
| author | unknown <bell@laptop.sanja.is.com.ua> | 2003-10-12 16:10:40 +0300 |
|---|---|---|
| committer | unknown <bell@laptop.sanja.is.com.ua> | 2003-10-12 16:10:40 +0300 |
| commit | 6159df3ee3195ea7bd9bedf565851baa9df1d11e (patch) | |
| tree | e135c16b61e0dad6fa747a11b3799464c2744da5 /mysql-test/r/func_gconcat.result | |
| parent | e41e9e55128f02ca64b49a0eb9390768e0efe3ce (diff) | |
| download | mariadb-git-6159df3ee3195ea7bd9bedf565851baa9df1d11e.tar.gz | |
fixed fix_fields() parameters for GROUP_CONCAT() ORDER BY clause
(BUG#1537)
mysql-test/r/func_gconcat.result:
test of BUG#1537
mysql-test/t/func_gconcat.test:
test of BUG#1537
sql/item_sum.cc:
passing correct address of pointer to item to fix_dields(), using that addres to get access to item after fix_fields
Diffstat (limited to 'mysql-test/r/func_gconcat.result')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index 2b6079d5ffd..5eae6b4b871 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -196,3 +196,14 @@ insert into t1 values('test'),('test2'); select * from t1 having group_concat(bar)=''; bar drop table t1; +create table t1 (a int, a1 varchar(10)); +create table t2 (a0 int); +insert into t1 values (0,"a"),(0,"b"),(1,"c"); +insert into t2 values (1),(2),(3); +select group_concat(a1 order by (t1.a IN (select a0 from t2))) from t1; +group_concat(a1 order by (t1.a IN (select a0 from t2))) +b,a,c +select group_concat(a1 order by (t1.a)) from t1; +group_concat(a1 order by (t1.a)) +b,a,c +drop table t1, t2; |