sqlite3 3.6.10 doesn't work with objects named "release" keyword, breaks yum

[David O'Callaghan]

Binary package hint: sqlite3

Hi,

I hit the bug described at https://bugzilla.redhat.com/show_bug.cgi?id=481189 and in this thread
http://<email address hidden>/msg39664.html

In short, if you try to create a table with a "release" column it fails as this has been made a keyword since 3.6.8. This is a problem when using yum (I manage Redhat boxes from my Ubuntu desktop...)

This bug has previously been reported and fixed by sqlite and fedora. It would be great if the fix could be incorporated in Ubuntu too.

Kind regards,

David

 * * *

Description: Ubuntu jaunty (development branch)
Release: 9.04
sqlite3:
  Installed: 3.6.10-1
  Candidate: 3.6.10-1
  Version table:
 *** 3.6.10-1 0
        500 http://ie.archive.ubuntu.com jaunty/main Packages
        100 /var/lib/dpkg/status
yum:
  Installed: 3.2.21-1
  Candidate: 3.2.21-1
  Version table:
 *** 3.2.21-1 0
        500 http://ie.archive.ubuntu.com jaunty/universe Packages
        100 /var/lib/dpkg/status

[David O'Callaghan (david-ocallaghan)]

Workaround: install sqlite3_3.6.12-1 from sid. Yum now works as expected.

[Glyph Lefkowitz (glyph)]

This has been identified upstream as:

  http://www.sqlite.org/cvstrac/tktview?tn=3590

and fixed in:

  http://www.sqlite.org/cvstrac/chngview?cn=6186