Bug 522776

Summary: SHA256: dbchange for rhnPackageSource multiple checksum support
Product: [Retired] Red Hat Network Reporter: Sebastian Skracic <sskracic>
Component: RHN/OtherAssignee: Sebastian Skracic <sskracic>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Network Quality Assurance <rhn-qa-list>
Severity: medium Docs Contact:
Priority: high    
Version: RHN StableCC: acarter, rhn-bugs
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-03-18 12:49:12 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, 523965    

Description Sebastian Skracic 2009-09-11 11:42:55 UTC 
rhnPackageSource has to support multiple checksums per (source) package.
Comment 1 Sebastian Skracic 2009-09-17 12:20:27 UTC 
On WEBDEV database.
Comment 2 Sebastian Skracic 2009-09-21 11:49:18 UTC 
Test Case #1:

Verify columns and data in rhnPackageSourceChecksum

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


Test Case #2:

Verify md5sum column has been dropped from rhnPackageSource table:

SQL> desc rhnpackagesource
...

EXPECTED: MD5SUM column should not appear.

Test Case #3:

Verify sample data in rhnPackageSourceChecksum:

SQL> select * from rhnPackageSourceChecksum where rownum < 5;

... should output 4 rows