Right, my (implied) point was that you have AT LEAST one limitation -- your max_packet_size. And I showed the way the original author can investigate and figure out the rest himself :)
On Wed, Feb 11, 2009 at 4:28 AM, Johan De Meersman <vegiv...@tuxera.be> wrote: > What you just tested, on the other hand, was the limit of your maxpacket :-) > Up that to something unlikely and try again :-) > > On Tue, Feb 10, 2009 at 9:24 PM, Baron Schwartz <ba...@xaprb.com> wrote: >> >> On Tue, Feb 10, 2009 at 1:29 PM, Cantwell, Bryan >> <bcantw...@firescope.com> wrote: >> > I am trying to put the result of a function that returns MEDIUMTEXT into >> > a user variable in my procedure. I haven't attempted to push the limits >> > of the MEDIUMTEXT size, but wonder if the user variable can even handle >> > this? >> >> >> The REPEAT() function helps here: >> >> mysql> set @var := repeat('a', 1024 * 1024); >> Query OK, 0 rows affected (0.05 sec) >> >> mysql> select length(@var); >> +--------------+ >> | length(@var) | >> +--------------+ >> | 1048576 | >> +--------------+ >> 1 row in set (0.01 sec) >> >> So it accepts a mebibyte, let's see if we can notch that up :) >> >> mysql> set @var := repeat('a', 1024 * 1024 * 1024); >> Query OK, 0 rows affected, 1 warning (0.00 sec) >> >> mysql> show warnings; >> >> +---------+------+------------------------------------------------------------------------------+ >> | Level | Code | Message >> | >> >> +---------+------+------------------------------------------------------------------------------+ >> | Warning | 1301 | Result of repeat() was larger than >> max_allowed_packet (16777216) - truncated | >> >> +---------+------+------------------------------------------------------------------------------+ >> 1 row in set (0.00 sec) >> >> -- >> Baron Schwartz, Director of Consulting, Percona Inc. >> Our Blog: http://www.mysqlperformanceblog.com/ >> Our Services: http://www.percona.com/services.html >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be >> > > > > -- > Celsius is based on water temperature. > Fahrenheit is based on alcohol temperature. > Ergo, Fahrenheit is better than Celsius. QED. > -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org