vieten / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

GROUP_CONCAT output is limited to 1024 characters #1240

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Create this table

CREATE TABLE `test` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `test` (`id`)
VALUES
    (1),
    (2),
    (3),
    (4),
    (5),
    (6),
    (7),
    (8),
    (9),
    (10),
    (11),
    (12),
    (13),
    (14),
    (15),
    (16),
    (17),
    (18),
    (19),
    (20),
    (21),
    (22),
    (23),
    (24),
    (25),
    (26),
    (27),
    (28),
    (29),
    (30),
    (31),
    (32),
    (33),
    (34),
    (35),
    (36),
    (37),
    (38),
    (39),
    (40),
    (41),
    (42),
    (43),
    (44),
    (45),
    (46),
    (47),
    (48),
    (49),
    (50),
    (51),
    (52),
    (53),
    (54),
    (55),
    (56),
    (57),
    (58),
    (59),
    (60),
    (61),
    (62),
    (63),
    (64),
    (65),
    (66),
    (67),
    (68),
    (69),
    (70),
    (71),
    (72),
    (73),
    (74),
    (75),
    (76),
    (77),
    (78),
    (79),
    (80),
    (81),
    (82),
    (83),
    (84),
    (85),
    (86),
    (87),
    (88),
    (89),
    (90),
    (91),
    (92),
    (93),
    (94),
    (95),
    (96),
    (97),
    (98),
    (99),
    (100),
    (101),
    (102),
    (103),
    (104),
    (105),
    (106),
    (107),
    (108),
    (109),
    (110),
    (111),
    (112),
    (113),
    (114),
    (115),
    (116),
    (117),
    (118),
    (119),
    (120),
    (121),
    (122),
    (123),
    (124),
    (125),
    (126),
    (127),
    (128),
    (129),
    (130),
    (131),
    (132),
    (133),
    (134),
    (135),
    (136),
    (137),
    (138),
    (139),
    (140),
    (141),
    (142),
    (143),
    (144),
    (145),
    (146),
    (147),
    (148),
    (149),
    (150),
    (151),
    (152),
    (153),
    (154),
    (155),
    (156),
    (157),
    (158),
    (159),
    (160),
    (161),
    (162),
    (163),
    (164),
    (165),
    (166),
    (167),
    (168),
    (169),
    (170),
    (171),
    (172),
    (173),
    (174),
    (175),
    (176),
    (177),
    (178),
    (179),
    (180),
    (181),
    (182),
    (183),
    (184),
    (185),
    (186),
    (187),
    (188),
    (189),
    (190),
    (191),
    (192),
    (193),
    (194),
    (195),
    (196),
    (197),
    (198),
    (199),
    (200),
    (201),
    (202),
    (203),
    (204),
    (205),
    (206),
    (207),
    (208),
    (209),
    (210),
    (211),
    (212),
    (213),
    (214),
    (215),
    (216),
    (217),
    (218),
    (219),
    (220),
    (221),
    (222),
    (223),
    (224),
    (225),
    (226),
    (227),
    (228),
    (229),
    (230),
    (231),
    (232),
    (233),
    (234),
    (235),
    (236),
    (237),
    (238),
    (239),
    (240),
    (241),
    (242),
    (243),
    (244),
    (245),
    (246),
    (247),
    (248),
    (249),
    (250),
    (251),
    (252),
    (253),
    (254),
    (255),
    (256),
    (257),
    (258),
    (259),
    (260),
    (261),
    (262),
    (263),
    (264),
    (265),
    (266),
    (267),
    (268),
    (269),
    (270),
    (271),
    (272),
    (273),
    (274),
    (275),
    (276),
    (277),
    (278),
    (279),
    (280),
    (281),
    (282),
    (283),
    (284),
    (285),
    (286),
    (287),
    (288),
    (289),
    (290),
    (291),
    (292),
    (293),
    (294),
    (295),
    (296),
    (297),
    (298),
    (299),
    (300),
    (301),
    (302),
    (303),
    (304),
    (305),
    (306),
    (307),
    (308),
    (309),
    (310),
    (311),
    (312),
    (313),
    (314),
    (315),
    (316),
    (317),
    (318),
    (319),
    (320),
    (321),
    (322),
    (323),
    (324),
    (325),
    (326),
    (327),
    (328),
    (329),
    (330),
    (331),
    (332),
    (333),
    (334),
    (335),
    (336),
    (337),
    (338),
    (339),
    (340),
    (341),
    (342),
    (343),
    (344),
    (345),
    (346),
    (347),
    (348),
    (349),
    (350),
    (351),
    (352),
    (353),
    (354),
    (355),
    (356),
    (357),
    (358),
    (359),
    (360),
    (361),
    (362),
    (363),
    (364),
    (365),
    (366),
    (367),
    (368),
    (369),
    (370),
    (371),
    (372),
    (373),
    (374),
    (375),
    (376),
    (377),
    (378),
    (379),
    (380),
    (381),
    (382),
    (383),
    (384),
    (385),
    (386),
    (387),
    (388),
    (389),
    (390),
    (391),
    (392),
    (393),
    (394),
    (395),
    (396),
    (397),
    (398),
    (399),
    (400);

2. Run this query

SELECT GROUP_CONCAT(id) FROM test;

3. Double click inside the cell with the concatenated ids

What is the expected output? What do you see instead?

I would except to see #s 1 - 400, separated by commas.
Instead I see the #s 1 - 283 separated by commas.

What version of Sequel Pro are you using? What version of MySQL are you
connecting to on the server?

Sequel Pro 0.9.9.1 build 3408
Mysql 5.5.9

Please provide any additional information below.

Original issue reported on code.google.com by adambenjaminvarga on 2 Dec 2011 at 10:27

GoogleCodeExporter commented 9 years ago
By default GROUP_CONCAT() is limited to displaying 1024 characters, but it can 
be adjusted via the  group_concat_max_len system variable.

See the following doc for more info:

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-co
ncat

Marking as won't fix as this intended MySQL behaviour.

Original comment by stuart02 on 14 Jan 2012 at 11:15