Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 312087 Details for
Bug 455800
Update database during migration to change NULL resolution values to empty string
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
[patch]
Patch to update bugs.resolution to empty string during database migration (v1)
db_fixup_resolution.patch (text/plain), 682 bytes, created by
David Lawrence
on 2008-07-17 22:36:01 UTC
(
hide
)
Description:
Patch to update bugs.resolution to empty string during database migration (v1)
Filename:
MIME Type:
Creator:
David Lawrence
Created:
2008-07-17 22:36:01 UTC
Size:
682 bytes
patch
obsolete
>Index: redhat/db_fixup.sql >=================================================================== >RCS file: /cvs/qa/rh_bugzilla_3/redhat/db_fixup.sql,v >retrieving revision 1.13 >diff -u -r1.13 db_fixup.sql >--- redhat/db_fixup.sql 26 Jun 2008 15:51:41 -0000 1.13 >+++ redhat/db_fixup.sql 17 Jul 2008 22:34:31 -0000 >@@ -331,4 +331,9 @@ > > --- Create new columns in fielddefs needed for public custom field support > ALTER TABLE fielddefs ADD COLUMN public tinyint(4) NOT NULL default '0'; >+ >+--- Update bugs table, set NULL resolution values to empty string >+UPDATE bugs SET resolution = '' WHERE resolution = NULL; >+ALTER TABLE bugs MODIFY resolution VARCHAR(64) NOT NULL DEFAULT ''; >+ >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=312087">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Flags:
tfu
: review-
Actions:
View
|
Diff
Attachments on
bug 455800
:
312087
|
312098