innodb max index column length is 191, not 256 or 768 as one would "expect"
Bug #578842 reported by
Stewart Smith
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
High
|
Stewart Smith | ||
Dexter |
Fix Released
|
High
|
Stewart Smith | ||
HailDB |
New
|
Undecided
|
Unassigned | ||
MySQL Server |
Unknown
|
Unknown
|
Bug Description
DICT_MAX_
was 768
could be 1024
or could be 768*4.
<stewart> lbieber, 256*4 would be consistent with mysql in utf8 mode.
<stewart> lbieber, and 768*4(3072) would be consistent with mysql in latin1
Related branches
lp:~stewart/drizzle/bug578842-max-index-size
- Jay Pipes (community): Approve
- Brian Aker: Pending requested
-
Diff: 666 lines (+79/-111)15 files modifiedplugin/innobase/dict/dict0dict.c (+2/-2)
plugin/innobase/include/rem0types.h (+1/-1)
plugin/schema_dictionary/tests/r/show.result (+1/-3)
tests/r/auto_increment.result (+1/-3)
tests/r/ctype_utf8.result (+1/-1)
tests/r/drizzledump.result (+2/-4)
tests/r/group_by.result (+1/-3)
tests/r/innodb.result (+26/-39)
tests/r/innodb_mysql.result (+3/-3)
tests/r/randgen_queries.result (+0/-3)
tests/r/subselect.result (+0/-2)
tests/r/type_blob.result (+3/-3)
tests/r/type_varchar.result (+35/-35)
tests/r/union.result (+0/-6)
tests/t/innodb.test (+3/-3)
Changed in drizzle: | |
importance: | Undecided → High |
To post a comment you must log in.
investigating claims of " the disk format of some fixed-length columns would change" and if we at all care...