Bug #20207 | charset output problem with group_concat, jointure and order by | ||
---|---|---|---|
Submitted: | 1 Jun 2006 14:32 | Modified: | 20 Jul 2006 15:34 |
Reporter: | Fabien Chaillou | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.22 | OS: | Linux (Linux ubuntu dapper drake 6.06) |
Assigned to: | CPU Architecture: | Any |
[1 Jun 2006 14:32]
Fabien Chaillou
[1 Jun 2006 14:41]
Fabien Chaillou
The request before the last is wrong, it works not because i switched the table in the from and join part but because i made the order by e1 and not e.e1, It seems it works with ORDER BY f.e1 and it misrenders with ORDER BY e.e1 mysql> SELECT GROUP_CONCAT(f.f1) FROM f LEFT JOIN e USING (e1) GROUP BY e.e1 ORDER BY e1; +--------------------+ | GROUP_CONCAT(f.f1) | +--------------------+ | Buggué | +--------------------+ 1 row in set (0,00 sec) mysql> SELECT GROUP_CONCAT(f.f1) FROM f LEFT JOIN e USING (e1) GROUP BY e.e1 ORDER BY e.e1; +--------------------+ | GROUP_CONCAT(f.f1) | +--------------------+ | Buggué | +--------------------+ 1 row in set (0,00 sec) mysql> SELECT GROUP_CONCAT(f.f1) FROM f LEFT JOIN e USING (e1) GROUP BY e.e1 ORDER BY f.e1; +--------------------+ | GROUP_CONCAT(f.f1) | +--------------------+ | Buggué | +--------------------+ 1 row in set (0,00 sec) Sorry for the typo error
[1 Jun 2006 14:45]
Fabien Chaillou
I also forgot to say that everything works fine without the group_concat otherwise i wouldn't have put it in the synopsis
[1 Jun 2006 17:12]
Valeriy Kravchuk
Thank you for a problem report. As group_concat is important here, please, check bug #16712. Is it related?
[2 Jun 2006 9:14]
Fabien Chaillou
I don't think it is related to this bug. It is showing longtext and not longblob here is the ouput : mysql> create view vvv1 as SELECT GROUP_CONCAT(f.f1) FROM e LEFT JOIN f USING (e1) GROUP BY e.e1 ORDER BY e.e1; Query OK, 0 rows affected (0,00 sec) mysql> create view vvv2 as SELECT GROUP_CONCAT(f.f1) FROM e LEFT JOIN f USING (e1) GROUP BY e.e1 ORDER BY e2; Query OK, 0 rows affected (0,00 sec) mysql> desc vvv1; +--------------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+----------+------+-----+---------+-------+ | GROUP_CONCAT(f.f1) | longtext | YES | | NULL | | +--------------------+----------+------+-----+---------+-------+ 1 row in set (0,00 sec) mysql> desc vvv2; +--------------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+----------+------+-----+---------+-------+ | GROUP_CONCAT(f.f1) | longtext | YES | | NULL | | +--------------------+----------+------+-----+---------+-------+ 1 row in set (0,00 sec) So it is still longtext on the case it works and on those it doesn't.
[20 Jun 2006 15:34]
Valeriy Kravchuk
Can you, please, try to repeat with 'set names utf8' instead of 'set character set ...' and inform about the results? In my case I've got consistent results (in utf8) for all your queries.
[20 Jul 2006 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".