[Pkg-dspam-misc] Bug#369179: libdspam7-drv-pgsql: Invalid SQL when token type is NUMERIC(10)

[Rupa Schomaker]

Package: libdspam7-drv-pgsql
Version: 3.6.4-4
Severity: important

The PG driver for dspam supports bigint for the token field and numeric(10).
bigint is prefered, but if moving from hash to sql the value is too large
to fit into a bigint and so the workaround is to use numeric(10) instead.
(there is a program to dump a numeric(10) version to a bigint version, but
that segfaults -- another bug for that when I have the data I need).

Anyway, the token data in improperly quoted.  Patch below:

--- pgsql_drv.c.orig    2006-05-27 20:15:38.309621367 -0400
+++ pgsql_drv.c 2006-05-27 20:03:20.597998961 -0400
@@ -2620,7 +2620,7 @@
   if (type == 1) {
     snprintf(buffer, bufsz, "%lld", token);
   } else {
-    snprintf(buffer, bufsz, "'%llu'", token);
+    snprintf(buffer, bufsz, "%llu", token);
   }
   return buffer;
 }


-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16.13-xenU
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages libdspam7-drv-pgsql depends on:
ii  dbconfig-common               1.8.13     common framework for packaging dat
ii  debconf [debconf-2.0]         1.5.1      Debian configuration management sy
ii  libc6                         2.3.6-9    GNU C Library: Shared libraries
ii  libdspam7                     3.6.4-4    DSPAM is a scalable and statistica
ii  libldap2                      2.1.30-13  OpenLDAP libraries
ii  libpq4                        8.1.4-1    PostgreSQL C client library
ii  postgresql-client-8.1         8.1.4-1    front-end programs for PostgreSQL 
ii  ucf                           2.0010     Update Configuration File: preserv

Versions of packages libdspam7-drv-pgsql recommends:
ii  postgresql-8.1                8.1.4-1    object-relational SQL database, ve

-- debconf information:
  libdspam7-drv-pgsql/pgsql/method: unix socket
  libdspam7-drv-pgsql/remote/host:
  libdspam7-drv-pgsql/pgsql/manualconf:
  libdspam7-drv-pgsql/pgsql/authmethod-admin: ident
  libdspam7-drv-pgsql/db/dbname:
  libdspam7-drv-pgsql/pgsql/changeconf: false
  libdspam7-drv-pgsql/install-error: abort
  libdspam7-drv-pgsql/import-oldsettings:
  libdspam7-drv-pgsql/internal/reconfiguring: false
  libdspam7-drv-pgsql/pgsql/authmethod-user: ident
  libdspam7-drv-pgsql/database-type: pgsql
  libdspam7-drv-pgsql/performing_upgrade: true
  libdspam7-drv-pgsql/remove-error: abort
  libdspam7-drv-pgsql/remote/newhost:
  libdspam7-drv-pgsql/db/app-user:
  libdspam7-drv-pgsql/purge: false
  libdspam7-drv-pgsql/dbconfig-remove: true
* libdspam7-drv-pgsql/dbconfig-install: false
  libdspam7-drv-pgsql/dbconfig-upgrade: true
  libdspam7-drv-pgsql/pgsql/admin-user: postgres
  libdspam7-drv-pgsql/pgsql/no-empty-passwords:
  libdspam7-drv-pgsql/upgrade-backup: true
  libdspam7-drv-pgsql/upgrade-error: abort
  libdspam7-drv-pgsql/remote/port:
  libdspam7-drv-pgsql/passwords-do-not-match:

!DSPAM:4478ebf433731223273615!