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

Bug #589029 reported by Stewart Smith
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Confirmed
Medium
Unassigned

Bug Description

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)
Changed in drizzle:
assignee: Stephan King (ste) → nobody
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.