Description of problem: It appears that the changes made for Bug 1174586 introduced a regression where searches for "Clone Of is null" and "Clone Of is not null" do not work correctly. Additionally, it appears that bugs created prior to 2013-10-03 have a zero value for Clone Of if a bug is not a clone, while bugs created after that date have NULL instead. The latter is correct. I suspect that the zero values were introduced by the changes for Bug 1000132, which were released in Bugzilla 4.4.0009. Version-Release number of selected component (if applicable): 4.4.6029 How reproducible: Always Steps to Reproduce: Attempt to search for RHEL6 bugs that were cloned from other bugs (i.e. "Clone Of is not NULL") -- for example: https://bugzilla.redhat.com/buglist.cgi?classification=Red%20Hat&columnlist=bug_status%2Cbug_severity%2Cpriority%2Cversion%2Cshort_desc%2Cblocks_all%2Ccf_clone_of&f1=cf_clone_of&o1=isnotnull&product=Red%20Hat%20Enterprise%20Linux%206 Actual results: Most of the returned bugs have an empty Clone Of value. Expected results: All bugs returned should have a non-empty Clone Of value. Additional info: none
This bug can be worked around by searching for "Clone of is equal to 0" instead of "is null" or "Clone Of is not equal to 0" instead of "is not null".
I've ripped out our old 'is null' and 'is not null' search terms and backported the Bugzilla 5 search code. The new terms will be 'is empty' and 'is not empty'. I've also added a small compatibility layer which will cause the old is null type queries to silently use the new search code. This will address the searching problems. We will probably need to update the existing cf_clone_of values to be NULL. This can be done in the script for bug 1201150
QE added cases to cover this bug. Verified on QA environment(bzweb01-qe) with version(4.4.8030-3, DB: mysql) QA environment(bzperfweb01.app.qa) with version(4.4.8030-3, DB: psql) Result: Pass
This change is now live. If there are any issues, do not reopen this bug. Instead, you should create a new bug and reference this bug.