From noreply@askmonty.org Wed Nov 18 01:40:28 2015 From: AskMonty KB To: discuss@lists.mariadb.org Subject: [Maria-discuss] New Question: Buffer size issue? Date: Wed, 18 Nov 2015 01:40:03 +0000 Message-ID: <20151118014003.10561.51686@kb02.mariadb.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4198897880216032319==" --===============4198897880216032319== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello, A new question has been asked in "General FAQ" by Bytesmiths. Please answer i= t at http://mariadb.com/kb/en/buffer-size-issue/ as the person asking the que= stion may not be subscribed to the mailing list. -------------------------------- I have a query that returns a string considerably longer than 1024 characters= . It was working properly in MariaDB 5.1. I have upgraded to 10.1.8, and it appears that the query return is being trun= cated at 1024 characters. I see this behaviour in three separate tools, inclu= ding php mysql calls, phpMyAdmin, and the mysql command line tool. (It was th= e mysql CLI, piped to wc, that told me that exactly 1024 characters were bein= g sent, but no more.) Assuming this is not a bug, but rather some variable to be tweaked, can someo= ne point me in the right direction? Thanks in advance! BTW: Here is the query, which has not changed since it was written in 5.1: 
SELECT GROUP_CONCAT(DISTINCT '', p.family, '' ORDER BY p.family SEPARATOR ', ') FR=
OM s_plants p LEFT JOIN s_plant_families f ON p.family =3D f.family
This query basically returns a string containing a long list of plant family = names, wrapped in HTML links. This is what I get back: 
Agavaceae, Aizoaceae, Alliaceae, Amaranthaceae, Anacardia=
ceae, Apiaceae, Apocynaceae, Araliaceae, Asteraceae, Boraginaceae, Brassicaceae, Campanulaceae, Caprifoliaceae, 

That last link with the open quote in the open anchor tag sure plays havoc wi=
th the rest of the page... :-)
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/buffer=
-size-issue/


--===============4198897880216032319==--