#8396 closed enhancement (fixed)
[Database schema] Ticket description field might be too short.
Reported by: | Owned by: | Jun Omae | |
---|---|---|---|
Priority: | normal | Milestone: | 1.1.4 |
Component: | database backend | Version: | 0.11.4 |
Severity: | normal | Keywords: | mysql |
Cc: | Branch: | ||
Release Notes: |
Use |
||
API Changes: | |||
Internal Changes: |
Description
He,
have you ever considered using mediumtext instead of text for the description field of a ticket ?
I've got tickets exceeding the 65536 characters limit, that have been tested ok when switching to mediumtext type (in my case, this is useful for an import from clearquest tickets).
I have checked Bugzilla, and they are using mediumtext pretty much everywhere (at least in version 3.2).
Attached is the modified schema file.
Thx, Guillaume.
System information :
os : windows xp 32 bits sp2
py : 2.5
db : mysql server 5.0
Attachments (1)
Change History (12)
by , 16 years ago
Attachment: | db_default.py added |
---|
comment:1 by , 16 years ago
Keywords: | mysql added; patch removed |
---|
Please, take the time to produce and submit a real patch.
Also, be sure to review related tickets, in particular #6986.
comment:2 by , 16 years ago
Component: | ticket system → database backend |
---|---|
Milestone: | → 1.0 |
Severity: | trivial → normal |
comment:4 by , 14 years ago
Milestone: | triaging → next-major-0.1X |
---|
Related to the distinction of string vs. text in GenericTrac.
comment:5 by , 12 years ago
See also #11032 (closed as duplicate) which reported a similar issue but with wiki pages.
comment:6 by , 10 years ago
Milestone: | next-major-releases → 1.1.4 |
---|---|
Owner: | set to |
Status: | new → assigned |
Same issue on our environments. I think we should use mediumtext
type rather than text
type for MySQL.
In jomae.git@t8396, proposed changes adds db36.py
which changes text
type to mediumtext
type using directly ALTER TABLE
.
comment:8 by , 10 years ago
Release Notes: | modified (diff) |
---|---|
Resolution: | → fixed |
Status: | assigned → closed |
Committed in [13767].
comment:9 by , 10 years ago
Just curious, did you measure the impact on performance and on the size of the DB (before/after upgrade)?
comment:10 by , 10 years ago
Yeah. Very few differences on the performance and the size between text
and mediumtext
types.
Default db schema definition, modified under "Ticket system" for the description column type.