[Yum-devel] [PATCH] Fix the history.vtrans_prob_pkgs VIEW for F12 sqlite, *sigh*. BZ 620872
seth vidal
skvidal at fedoraproject.org
Fri Aug 6 21:07:01 UTC 2010
On Fri, 2010-08-06 at 16:59 -0400, James Antill wrote:
> ---
> yum/history.py | 14 ++++++++------
> 1 files changed, 8 insertions(+), 6 deletions(-)
>
ACK.
-sv
> diff --git a/yum/history.py b/yum/history.py
> index 502b908..d339f4c 100644
> --- a/yum/history.py
> +++ b/yum/history.py
> @@ -914,17 +914,19 @@ class YumHistory:
> version || '-' || release || '.' || arch AS nevra
> FROM trans_skip_pkgs JOIN pkgtups USING(pkgtupid)
> ORDER BY name;
> -''', # NOTE: Old versions of sqlite don't like this next view, they are only
> - # there for debugging anyway ... but it's worth remembering.
> +''', # NOTE: Old versions of sqlite don't like the normal way to do the next
> + # view. So we do it with the select. It's for debugging only, so
> + # no big deal.
> '''\
> \
> - CREATE VIEW vtrans_prob_pkgs AS
> + CREATE VIEW vtrans_prob_pkgs2 AS
> SELECT tid,rpid,name,epoch,version,release,arch,pkgtups.pkgtupid,
> - main,
> + main,problem,msg,
> name || '-' || epoch || ':' ||
> version || '-' || release || '.' || arch AS nevra
> - FROM (trans_prob_pkgs JOIN trans_rpmdb_problems USING(rpid))
> - JOIN pkgtups USING(pkgtupid)
> + FROM (SELECT * FROM trans_prob_pkgs,trans_rpmdb_problems WHERE
> + trans_prob_pkgs.rpid=trans_rpmdb_problems.rpid)
> + JOIN pkgtups USING(pkgtupid)
> ORDER BY name;
> ''']
>
More information about the Yum-devel
mailing list