783873 - Search failure against Oracle database

Status: RESOLVED DUPLICATE of bug 780028

(Bugzilla :: Query/Bug List, defect)

Description

[Richard]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0.1
Build ID: 20120713134347

Steps to reproduce:

Opened the main Bugzilla web page
Clicked on "Search" (the magnifying glass)
On the "Simple search" tab I did not select any values - I just pressed the "Search" button


Actual results:

Please stand by ...
Software error:

DBD::Oracle::db prepare failed: ORA-00960: ambiguous column naming in select list (DBD ERROR: error possibly near <*> indicator at char 1855 in 'SELECT bugs.bug_id  bug_id, bugs.bug_severity  bug_severity, bugs.priority  priority, bugs.bug_status  bug_status, bugs.resolution  resolution, map_product.name  product, map_component.name  component, CASE WHEN INSTR(map_assigned_to.login_name, '@') != 0 THEN SUBSTR(map_assigned_to.login_name, 1, INSTR(map_assigned_to.login_name, '@') - 1) ELSE map_assigned_to.login_name END  assigned_to, bugs.short_desc  short_desc, bugs.delta_ts  changeddate, bugs.bug_status  bug_status, bugs.priority  priority, CASE WHEN INSTR(map_assigned_to.login_name, '@') != 0 THEN SUBSTR(map_assigned_to.login_name, 1, INSTR(map_assigned_to.login_name, '@') - 1) ELSE map_assigned_to.login_name END  assigned_to, bugs.bug_id  bug_id
  FROM bugs
LEFT JOIN bug_group_map  security_map ON bugs.bug_id = security_map.bug_id
INNER JOIN products  map_product ON bugs.product_id = map_product.id
INNER JOIN components  map_component ON bugs.component_id = map_component.id
INNER JOIN profiles  map_assigned_to ON bugs.assigned_to = map_assigned_to.userid
INNER JOIN bug_status  map_bug_status ON bugs.bug_status = map_bug_status.value
INNER JOIN priority  map_priority ON bugs.priority = map_priority.value
  WHERE  rownum <=500 AND  bugs.creation_ts IS NOT NULL
   AND security_map.group_id IS NULL
   AND  bugs.bug_status IN ('UNCONFIRMED','CONFIRMED','IN_PROGRESS') 
GROUP BY bugs.bug_id, bugs.bug_severity,bugs.priority,bugs.bug_status,bugs.resolution,map_product.name,map_component.name,CASE WHEN INSTR(map_assigned_to.login_name, '@') != 0 THEN SUBSTR(map_assigned_to.login_name, 1, INSTR(map_assigned_to.login_name, '@') - 1) ELSE map_assigned_to.login_name END,bugs.short_desc,bugs.delta_ts,map_bug_status.sortkey,map_bug_status.value,map_priority.sortkey,map_priority.value
ORDER BY map_bug_status.sortkey, map_bug_status.value, map_priority.sortkey, map_priority.value, <*>assigned_to, bug_id
/* LIMIT 500 */
') [for Statement "SELECT bugs.bug_id  bug_id, bugs.bug_severity  bug_severity, bugs.priority  priority, bugs.bug_status  bug_status, bugs.resolution  resolution, map_product.name  product, map_component.name  component, CASE WHEN INSTR(map_assigned_to.login_name, '@') != 0 THEN SUBSTR(map_assigned_to.login_name, 1, INSTR(map_assigned_to.login_name, '@') - 1) ELSE map_assigned_to.login_name END  assigned_to, bugs.short_desc  short_desc, bugs.delta_ts  changeddate, bugs.bug_status  bug_status, bugs.priority  priority, CASE WHEN INSTR(map_assigned_to.login_name, '@') != 0 THEN SUBSTR(map_assigned_to.login_name, 1, INSTR(map_assigned_to.login_name, '@') - 1) ELSE map_assigned_to.login_name END  assigned_to, bugs.bug_id  bug_id
  FROM bugs
LEFT JOIN bug_group_map  security_map ON bugs.bug_id = security_map.bug_id
INNER JOIN products  map_product ON bugs.product_id = map_product.id
INNER JOIN components  map_component ON bugs.component_id = map_component.id
INNER JOIN profiles  map_assigned_to ON bugs.assigned_to = map_assigned_to.userid
INNER JOIN bug_status  map_bug_status ON bugs.bug_status = map_bug_status.value
INNER JOIN priority  map_priority ON bugs.priority = map_priority.value
  WHERE  rownum <=500 AND  bugs.creation_ts IS NOT NULL
   AND security_map.group_id IS NULL
   AND  bugs.bug_status IN ('UNCONFIRMED','CONFIRMED','IN_PROGRESS') 
GROUP BY bugs.bug_id, bugs.bug_severity,bugs.priority,bugs.bug_status,bugs.resolution,map_product.name,map_component.name,CASE WHEN INSTR(map_assigned_to.login_name, '@') != 0 THEN SUBSTR(map_assigned_to.login_name, 1, INSTR(map_assigned_to.login_name, '@') - 1) ELSE map_assigned_to.login_name END,bugs.short_desc,bugs.delta_ts,map_bug_status.sortkey,map_bug_status.value,map_priority.sortkey,map_priority.value
ORDER BY map_bug_status.sortkey, map_bug_status.value, map_priority.sortkey, map_priority.value, assigned_to, bug_id
/* LIMIT 500 */
"] at Bugzilla/DB/Oracle.pm line 491
	Bugzilla::DB::Oracle::prepare(undef, 'SELECT bugs.bug_id  bug_id, bugs.bug_severity  bug_severity, ...') called at /var/www/html/bugzilla/buglist.cgi line 832



Expected results:

Well I would have expected it to return a list of all items - (as an aside, I'm not sure whether this is the cause but although mylyn seems to update bugzilla fine -well it says it has in Eclipse - the submitted bugs do not seem to become available to other eclipse mylyn users, even if assigned to them)

Comment 1

[Frédéric Buclin]

Already fixed in Bugzilla 4.2.3.