{{{
>>> from lp.registry.interfaces.distribution import IDistributionSet
>>> from lp.registry.interfaces.distroseries import IDistroSeriesSet
>>> ubuntu = getUtility(IDistributionSet).getByName("ubuntu")
>>> distroseriesset = getUtility(IDistroSeriesSet)
>>> list(distroseriesset.search(distribution=ubuntu))
[<DistroSeries u'warty'>, <DistroSeries u'hoary'>, <DistroSeries
u'grumpy'>, <DistroSeries u'breezy-autotest'>]
# Good
# SELECT DistroSeries.backports_not_automatic,[...] FROM DistroSeries
WHERE distribution = 1 ORDER BY DistroSeries.distribution,
DistroSeries.version
>>> list(distroseriesset.search(distribution=ubuntu)[1:1])
[]
# Good
# SELECT DistroSeries.backports_not_automatic,[...] FROM DistroSeries
WHERE distribution = 1 ORDER BY DistroSeries.distribution,
DistroSeries.version LIMIT 0 OFFSET 1
>>> list(distroseriesset.search(distribution=ubuntu)[0:0])
[<DistroSeries u'warty'>, <DistroSeries u'hoary'>, <DistroSeries
u'grumpy'>, <DistroSeries u'breezy-autotest'>]
# No limit nor offset in the generated query ... ?!
# SELECT DistroSeries.backports_not_automatic,[...] FROM DistroSeries
WHERE distribution = 1 ORDER BY DistroSeries.distribution,
DistroSeries.version
}}}
Looks like a storm bug SQLObjectResult Set[0:0] :
{{{ interfaces. distribution import IDistributionSet interfaces. distroseries import IDistroSeriesSet IDistributionSe t).getByName( "ubuntu" ) IDistroSeriesSe t)
>>> from lp.registry.
>>> from lp.registry.
>>> ubuntu = getUtility(
>>> distroseriesset = getUtility(
>>> list(distroseri esset.search( distribution= ubuntu) ) autotest' >] backports_ not_automatic, [...] FROM DistroSeries distribution, version
[<DistroSeries u'warty'>, <DistroSeries u'hoary'>, <DistroSeries
u'grumpy'>, <DistroSeries u'breezy-
# Good
# SELECT DistroSeries.
WHERE distribution = 1 ORDER BY DistroSeries.
DistroSeries.
>>> list(distroseri esset.search( distribution= ubuntu) [1:1]) backports_ not_automatic, [...] FROM DistroSeries distribution, version LIMIT 0 OFFSET 1
[]
# Good
# SELECT DistroSeries.
WHERE distribution = 1 ORDER BY DistroSeries.
DistroSeries.
>>> list(distroseri esset.search( distribution= ubuntu) [0:0]) autotest' >] backports_ not_automatic, [...] FROM DistroSeries distribution, version
[<DistroSeries u'warty'>, <DistroSeries u'hoary'>, <DistroSeries
u'grumpy'>, <DistroSeries u'breezy-
# No limit nor offset in the generated query ... ?!
# SELECT DistroSeries.
WHERE distribution = 1 ORDER BY DistroSeries.
DistroSeries.
}}}