[Yum-devel] [PATCH] Fix yum in sqlite 3.1

[Hans-Peter Jansen]

On Tuesday 15 March 2005 16:48, Gijs Hollestelle wrote:
> Hi all,
>
> I've just spend some time, making the yum code sqlite 3.1 friendly.
> It turned out to be less work than I expected. Attached is a patch
> that explicitly names all the requested columns when we select from
> multiple tables. I've ran some quick tests on sqlite 3.0 and 3.1
> and they both appear to work.
>
> If people agree that this is the way to solve the problem, I'll
> apply the patch.

Are you sure about this one?

--- sqlitesack.py	10 Mar 2005 22:44:39 -0000	1.16
+++ sqlitesack.py	15 Mar 2005 15:46:21 -0000
@@ -126,11 +126,13 @@
         result = []
         for (rep,cache) in self.otherdb.items():
             cur = cache.cursor()
-            cur.execute("select * from packages,changelog where packages.pkgId = %s and packages.pkgKey = changelog.pkgKey",pkgId)
+            cur.execute("select chagelog.date as date,\
                                 ^^^^^^^^
+                chagelog.author as author.\
                 ^^^^^^^^
+                changelog.changelog as changelog from packages,changelog where packages.pkgId = %s and packages.pkgKey = changelog.pkgKey",pkgId)

chagelog?

Just ignore me, if I'm wrong. 

I haven't looked into this any deeper, sorry..

Pete