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.