[Python-modules-team] Bug#520338: python-axiom: Does not work with sqlite >= 3.6.4

[Vincent Bernat]

Package: python-axiom
Version: 0.5.30-1
Severity: grave
Justification: renders package unusable

Hi!

With the current version of sqlite3 in unstable, Axiom does not work
any more. It fails with an error like that:

axiom.errors.SQLError: <SQLError: 'CREATE TABLE main.axiom_attributes (
type_id INTEGER, row_offset INTEGER, indexed BOOLEAN, sqltype VARCHAR,
allow_none BOOLEAN, pythontype VARCHAR, attribute VARCHAR, docstring
TEXT )'(()) caused <class 'pysqlite2.dbapi2.OperationalError'>: near
"indexed": syntax error>

Since sqlite 3.6.4, INDEXED is a reserved keyword introduced by
"INDEXED BY" clause.

I did not find the corresponding bug report into upstream bug
tracker.

-- System Information:
Debian Release: squeeze/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=fr_FR.utf8, LC_CTYPE=fr_FR.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages python-axiom depends on:
ii  python                        2.5.4-2    An interactive high-level object-o
ii  python-epsilon                0.5.12-1   utility Python modules commonly us
ii  python-pysqlite2              2.5.0-2    Python interface to SQLite 3
ii  python-support                0.8.7      automated rebuilding support for P
ii  python-twisted-conch          1:8.2.0-1  The Twisted SSH Implementation
ii  python-twisted-core           8.2.0-1    Event-based framework for internet
ii  python-zopeinterface          3.3.1-7    The implementation of interface de

python-axiom recommends no packages.

python-axiom suggests no packages.

-- no debconf information