On Tue, Feb 10, 2009 at 1:29 PM, Cantwell, Bryan
<[email protected]> 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/[email protected]
