Bug #17497 Partitions: crash if add partition on temporary table

Description:
I create a temporary table with partitioning.
I try to alter ... add partition. Failure.
I say "show create table". Crash.

How to repeat:
mysql> create temporary table t9 (s1 int) partition by list (s1) (partition p1 values in (1));
Query OK, 0 rows affected (0.00 sec)

mysql> alter table t9 add partition (partition p2 values in (5));
ERROR 1005 (HY000): Can't create table 't9' (errno: 17)
mysql> show create table t9;
ERROR 2013 (HY000): Lost connection to MySQL server during query

Thank you for the bug report.

060216 20:51:03 [Note] libexec/mysqld: ready for connections.
Version: '5.1.7-beta-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
mysqld got signal 11;

<cut>

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x922bfa0 = show create table t9
thd->thread_id=2

Should we even allow someone to create a partition on a temp table?

No, we should not allow adding partitions to temp tables.  Jim, can you just disallow alter table add partition when the underlying table is temp?

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3595

Fixed in 5.1.8.

From the changeset comment: "Temporary tables are no longer allowed to be partitioned."

you can no longer even do a CREATE TEMPORARY TABLE ... PARTITION BY

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

Documented new restriction in 5.1.8 changelog and 5.1 Manual partitioning chapter.