Bug #930 Restriction of merge table size when using query caching

Description:
There appears to be a limit of 255 member tables in a merge table when you have query_cache_size > 0. If query caching is off and number of table > 255 there are no problems. If query caching is on and number of member tables <= 255 - no probs. It is when query_cache_size > 0 and the unioned tables of the merge table number >= 256 that the connection dies with a SIGNAL 11.

How to repeat:
1) Create a merge table (say 'tmerge') with 255 member tables
2) Set query_cache_size > 0 (say 1M)
3) query merge table (eg SELECT COUNT(*) FROM tmerge;):

mysql> select count(*) from tmerge;
+----------+
| count(*) |
+----------+
|  5463827 |
+----------+

4) Create tmerge with > 255 tables
5) Repeat query:

mysql> select count(*) from tmerge;
ERROR 2013: Lost connection to MySQL server during query

I have uploaded a PHP script to generate the tables. Just enter user and password in the appropriate lines.

Generate merge table

Attachment: mergetest.php (application/octet-stream, text), 933 bytes.

Sanja, could you take a look at this please?

ChangeSet 
  1.1552 03/07/30 14:59:56 bell@sanja.is.com.ua +3 -0 
  support of more then 255 tables dependence in query cache (fixed BUG#930)