[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