#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 , 15 years ago
| Attachment: | db_default.py added |
|---|
comment:1 by , 15 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 , 15 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 , 11 years ago
See also #11032 (closed as duplicate) which reported a similar issue but with wiki pages.
comment:6 by , 9 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 , 9 years ago
| Release Notes: | modified (diff) |
|---|---|
| Resolution: | → fixed |
| Status: | assigned → closed |
Committed in [13767].
comment:9 by , 9 years ago
Just curious, did you measure the impact on performance and on the size of the DB (before/after upgrade)?
comment:10 by , 9 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.