can CREATE TABLE with ENUM column with > 2^16 values
Bug #589029 reported by
Stewart Smith
This bug report is a duplicate of:
Bug #589031: can CREATE TABLE with ENUM column with > 2^16 values.
Edit
Remove
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_
+------
1 row in set (0 sec)
drizzle> insert into too_many_
Query OK, 1 row affected (0.21 sec)
drizzle> select * from too_many_
+-------------+
| 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.
Changed in drizzle: | |
assignee: | Stephan King (ste) → nobody |
To post a comment you must log in.