[Pkg-sympa-devel] Bug#642464: sympa --upgrade confused by sqlite

[Clint Adams]

Package: sympa
Version: 6.1.4~dfsg-1~bpo60+1

sympa --upgrade outputs this:

err Upgrade::probe_db() Field 'dkim_d_bulkspool'  (table 'bulkspool_table' ; database '/var/lib/dbconfig-common/sqlite3/sympa/sympa') does NOT have awaited type (varchar(50)).

It believes that dkim_d_bulkspool is of type 'text' even though it does
not appear to be so in reality:

sqlite> .schema bulkspool_table
CREATE TABLE bulkspool_table (
        messagekey_bulkspool    text NOT NULL,
        message_bulkspool       text NOT NULL,
        lock_bulkspool          integer NOT NULL, dkim_d_bulkspool varchar(50), dkim_header_list_bulkspool varchar(500), dkim_i_bulkspool varchar(100), dkim_privatekey_bulkspool varchar(1000), dkim_selector_bulkspool varchar(50), messageid_bulkspool text,
        PRIMARY KEY (messagekey_bulkspool)
);
CREATE INDEX bulkspool_idx ON bulkspool_table(messagekey_bulkspool);