Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 521312

Summary:	[SHA256] dbchange: rhnErrataFile support for multiple checksums
Product:	[Retired] Red Hat Network	Reporter:	Sebastian Skracic <sskracic>
Component:	RHN/Other	Assignee:	Sebastian Skracic <sskracic>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Network Quality Assurance <rhn-qa-list>
Severity:	medium	Docs Contact:
Priority:	high
Version:	RHN Stable	CC:	acarter, dhughes, rhn-bugs
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:	US58
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-03-18 12:48:43 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	519193, 519741

Description Sebastian Skracic 2009-09-04 17:47:12 UTC

This is to track dbchange related work for support of multiple checksums
in errata files (packages), which is kept in rhnErrataFile, and possibly
in rhnErrataFileTmp, tables.

Comment 1 Sebastian Skracic 2009-09-07 12:55:29 UTC

DBchange files provided in:

b19fdd3ad820d5240b1b04f42ddd4a4a5a9b1f80
25aa025e633d19d20bbfab63de6183c74718fe93

Comment 2 Sebastian Skracic 2009-09-07 12:55:55 UTC

DBchange files successfully applied to webdev DB.

Comment 3 Denise Hughes 2009-09-08 19:56:23 UTC

Sebastian, please note in the bug what database changes were made.  

Thanks!
Denise

Comment 4 Sebastian Skracic 2009-09-09 11:38:48 UTC

Test Case #1:

Verify columns and data in rhnErrataFileChecksum (type: desc
rhnErrataFileChecksum)


SQL> desc rhnerratafilechecksum
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_ID                                   NOT NULL NUMBER
 CHECKSUM_TYPE_ID                          NOT NULL NUMBER
 CHECKSUM                                  NOT NULL VARCHAR2(128)

Sample data:

SQL> select * from rhnerratafilechecksum where rownum < 5;

... should output 4 rows


Test Case #2:

Verify md5column has been dropped from rhnErrataFile table:

SQL> desc rhnErrataFile

....

EXPECTED: Column MD5SUM does not appear.


Test Case #3:

Verify columns and data in rhnErrataFileChecksumTmp

SQL> desc rhnErrataFileChecksumTmp

Sample data: might not be available, since this table holds only transient data.


Test Case #4:

Verify md5column has been dropped from rhnErrataFileTmp table:

SQL> desc rhnErrataFileTmp

...

EXPECTED: Column MD5SUM does not appear.

Comment 5 Denise Hughes 2009-09-11 21:24:54 UTC

Verified on webdev.

Testopia ID:
https://testopia.devel.redhat.com/bugzilla/tr_show_case.cgi?case_id=12099
https://testopia.devel.redhat.com/bugzilla/tr_show_case.cgi?case_id=12125
https://testopia.devel.redhat.com/bugzilla/tr_show_case.cgi?case_id=12126
https://testopia.devel.redhat.com/bugzilla/tr_show_case.cgi?case_id=12127
https://testopia.devel.redhat.com/bugzilla/tr_show_case.cgi?case_id=12128
https://testopia.devel.redhat.com/bugzilla/tr_show_case.cgi?case_id=12129
https://testopia.devel.redhat.com/bugzilla/tr_show_case.cgi?case_id=12130
https://testopia.devel.redhat.com/bugzilla/tr_show_case.cgi?case_id=12131