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.
DBchange files provided in: b19fdd3ad820d5240b1b04f42ddd4a4a5a9b1f80 25aa025e633d19d20bbfab63de6183c74718fe93
DBchange files successfully applied to webdev DB.
Sebastian, please note in the bug what database changes were made. Thanks! Denise
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.
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