diff options
author | mkanat%kerio.com <> | 2005-02-25 07:43:28 +0100 |
---|---|---|
committer | mkanat%kerio.com <> | 2005-02-25 07:43:28 +0100 |
commit | e92cc4c9b115dfae6e352660c053e142634a3ef4 (patch) | |
tree | 61ba45aba841dcf21f286a79501579d2a7d71347 /Bugzilla | |
parent | 80c0cdba14f2fe81d7803e46af91ab5e77e45266 (diff) | |
download | bugzilla-e92cc4c9b115dfae6e352660c053e142634a3ef4.tar.gz bugzilla-e92cc4c9b115dfae6e352660c053e142634a3ef4.tar.xz |
Bug 17453: Enumerators in Bugzilla are not cross-DB compatible. This removes all 'enum' types in the database from Bugzilla.
Patch By Max Kanat-Alexander <mkanat@kerio.com> r=joel, a=justdave
Diffstat (limited to 'Bugzilla')
-rw-r--r-- | Bugzilla/Search.pm | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index a1058fbe5..8a08ef618 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -50,14 +50,26 @@ use Date::Parse; # Each field points to an array that contains the fields mapped # to, in order. our %specialorder = ( - 'bugs.target_milestone' => [ 'ms_order.sortkey','ms_order.value' ] + 'bugs.target_milestone' => [ 'ms_order.sortkey','ms_order.value' ], + 'bugs.bug_status' => [ 'bug_status.sortkey','bug_status.value' ], + 'bugs.rep_platform' => [ 'rep_platform.sortkey','rep_platform.value' ], + 'bugs.priority' => [ 'priority.sortkey','priority.value' ], + 'bugs.op_sys' => [ 'op_sys.sortkey','op_sys.value' ], + 'bugs.resolution' => [ 'resolution.sortkey', 'resolution.value' ], + 'bugs.bug_severity' => [ 'bug_severity.sortkey','bug_severity.value' ] ); # When we add certain fields to the ORDER BY, we need to then add a # table join to the FROM statement. This hash maps input fields to # the join statements that ned to be added. our %specialorderjoin = ( - 'bugs.target_milestone' => 'LEFT JOIN milestones AS ms_order ON ms_order.value = bugs.target_milestone AND ms_order.product_id = bugs.product_id' + 'bugs.target_milestone' => 'LEFT JOIN milestones AS ms_order ON ms_order.value = bugs.target_milestone AND ms_order.product_id = bugs.product_id', + 'bugs.bug_status' => 'LEFT JOIN bug_status ON bug_status.value = bugs.bug_status', + 'bugs.rep_platform' => 'LEFT JOIN rep_platform ON rep_platform.value = bugs.rep_platform', + 'bugs.priority' => 'LEFT JOIN priority ON priority.value = bugs.priority', + 'bugs.op_sys' => 'LEFT JOIN op_sys ON op_sys.value = bugs.op_sys', + 'bugs.resolution' => 'LEFT JOIN resolution ON resolution.value = bugs.resolution', + 'bugs.bug_severity' => 'LEFT JOIN bug_severity ON bug_severity.value = bugs.bug_severity' ); # Create a new Search |