CREATE TABLE with ENUM fields with large number of elements takes forever
Bug #589055 reported by
Stewart Smith
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Low
|
Stewart Smith | ||
Dexter |
Fix Released
|
Low
|
Stewart Smith |
Bug Description
e.g. with 70,000 elements (probably indicative of 65535 performance) it takes 4min 20seconds on my laptop (Intel(R) Core(TM)2 Duo CPU P8600 @ 2.40GHz).
http://
Related branches
lp:~stewart/drizzle/bug579310-enum-type-cleanup
- Jay Pipes: Pending requested
- Brian Aker: Pending requested
- Drizzle Developers: Pending requested
-
Diff: 498 lines (+178/-70)17 files modifiedclient/drizzletest.cc (+1/-1)
drizzled/field/enum.cc (+20/-56)
drizzled/field/enum.h (+4/-6)
drizzled/sql_table.cc (+36/-2)
drizzled/table_share.cc (+14/-0)
plugin/embedded_innodb/embedded_innodb_engine.cc (+2/-1)
plugin/tableprototester/tableprototester.cc (+46/-1)
plugin/tableprototester/tests/r/basic.result (+1/-0)
plugin/tableprototester/tests/r/missing_engine.result (+2/-2)
plugin/tableprototester/tests/r/too_many_enum_values.result (+4/-0)
plugin/tableprototester/tests/t/missing_engine.test (+1/-1)
plugin/tableprototester/tests/t/too_many_enum_values-master.opt (+1/-0)
plugin/tableprototester/tests/t/too_many_enum_values.test (+5/-0)
tests/r/type_enum_max_elements.result (+17/-0)
tests/r/type_enum_too_many_elements.result (+1/-0)
tests/t/type_enum_max_elements.test (+17/-0)
tests/t/type_enum_too_many_elements.test (+6/-0)
Changed in drizzle: | |
status: | Confirmed → Fix Committed |
Changed in drizzle: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.