can CREATE TABLE with ENUM column with > 2^16 values

[Stewart Smith]

If you CREATE TABLE with an ENUM column with 70,000 elements you get:

drizzle> source /tmp/a
Query OK, 0 rows affected (4 min 20 sec)

drizzle> show tables;
+----------------------+
| Tables_in_test |
+----------------------+
| too_many_enum_values |
+----------------------+
1 row in set (0 sec)

drizzle> insert into too_many_enum_values values (70000);
Query OK, 1 row affected (0.21 sec)

drizzle> select * from too_many_enum_values;
+-------------+
| many_values |
+-------------+
| a4463 |
+-------------+
1 row in set (0 sec)

Which is very wrong.

a) ENUM cannot have more than 2**16
b) incorrect data
c) over 4 minutes to run CREATE TABLE sets a new record.

[Stewart Smith (stewart)]

The MySQL bug is completely different, largely due to limits in the FRM file format:
http://bugs.mysql.com/bug.php?id=54194

i.e. the limit of the FRM file is 64kb-ish