I was able to reproduce on Percona Servers 5.5.35-33.0 and 5.6.15-63.0, can't reproduce on PS 5.1.73-rel14.11
Note: I did DROP TABLE IF EXISTS test before doing the procedure on 5.5 and 5.6.
mysql> select @@tmp_table_size; +------------------+ | @@tmp_table_size | +------------------+ | 16777216 | +------------------+ 1 row in set (0.00 sec)
mysql> select @@max_heap_table_size; +-----------------------+ | @@max_heap_table_size | +-----------------------+ | 16777216 | +-----------------------+ 1 row in set (0.00 sec)
See attachment for test results.
I was able to reproduce on Percona Servers 5.5.35-33.0 and 5.6.15-63.0, can't reproduce on PS 5.1.73-rel14.11
Note: I did DROP TABLE IF EXISTS test before doing the procedure on 5.5 and 5.6.
mysql> select @@tmp_table_size; ------- -----+ ------- -----+ ------- -----+
+------
| @@tmp_table_size |
+------
| 16777216 |
+------
1 row in set (0.00 sec)
mysql> select @@max_heap_ table_size; ------- ------- ---+ table_size | ------- ------- ---+ ------- ------- ---+
+------
| @@max_heap_
+------
| 16777216 |
+------
1 row in set (0.00 sec)
See attachment for test results.