Code review comment for lp://staging/~brian-murray/oops-repository/bucketversion

Would this still work for your needs if it was a composite type of (DpkgVersionComparator, UTF8) where the latter part of the tuple represents the Ubuntu release that version is responsible for? The ordering matters here, as we want to sort on the dpkg version primarily.

Getting the first version this issue was ever seen in would still be:
bucketversions_cf.get(column_count=1) -> ('1.0-0ubuntu1', 'Ubuntu 12.04')

Getting the total count of instances for the first version this issue was ever seen in, regardless of release, would require two operations as far as I can tell [1]:
bucketversions_cf.get(column_count=1) -> ('1.0-0ubuntu1', 'Ubuntu 12.04')
bucketversions_cf.get_range(column_start='1.0-0ubuntu1', column_finish='1.0-0ubuntu2~')

But if we grabbed the entire row, we could build an accurate table of "package versions with this error", as described in the specification:
https://wiki.ubuntu.com/ErrorTracker#Bucket_page

And mentioned in the following bug report:
https://bugs.launchpad.net/errors/+bug/1078801

Alternatively we could have another column family responsible for this finer granularity.

1: http://mail-archives.apache.org/mod_mbox/cassandra-user/201208.mbox/%<email address hidden>%3E