Launchpad itself

The return value of HWDevice.getSubmissions().count() is bogus

Bug #327181 reported by Abel Deuring on 2009-02-09

Affects		Status	Importance	Assigned to	Milestone
	Launchpad itself	Fix Released	Medium	Eleanor Berger	Launchpad itself 2.2.2

Bug Description

HWDevice.getSubmissions(...).count() returns in most cases a too large number.

This seems to be caused by the "DISTINCT" clause in the underlying Storm query, issued in HWSubmissonSet.search(). While the DISTINCT clause appears properly in the SQL query returnung the submissions, an equivalent is missing in the SQL query issued by result_set.count().

The workaround is quite ugly: Seek in the result set for the largest index that does not raise an index error.

Tags:

Abel Deuring (adeuring) on 2009-02-09

Changed in malone:
status:	New → Triaged

Revision history for this message

Abel Deuring (adeuring) wrote on 2009-02-12:

See also this Storm bug: https://bugs.edge.launchpad.net/storm/+bug/217644

Björn Tillenius (bjornt) on 2009-02-13

Changed in malone:
milestone:	none → 2.2.2

Eleanor Berger (intellectronica) on 2009-02-13

Changed in malone:
assignee:	nobody → intellectronica

Eleanor Berger (intellectronica) on 2009-02-16

Changed in malone:
importance:	Undecided → Medium
status:	Triaged → In Progress

Revision history for this message

Eleanor Berger (intellectronica) wrote on 2009-02-20:

RF 7826

Changed in malone:
status:	In Progress → Fix Committed

Eleanor Berger (intellectronica) on 2009-02-27

Changed in malone:
status:	Fix Committed → Fix Released

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.