Package: libdbd-pg-perl
Version: 1.41-3
Severity: important

I'm using placeholders of the form $1, $2, etc.  Executing a query
causes a segmentation fault if it contains the same placeholder more
than once.

  SELECT count(*) FROM pg_class WHERE relpages > $1

works, but

  SELECT count(*) FROM pg_class WHERE relpages > $1 AND reltuples > $1

causes a segmentation fault when the query is executed.  Both these
queries are examples copied from the documentation at 'perldoc DBD::Pg':
see the 'Legal' examples under 'Placeholders'.

See also the attached example script.


-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.8-2-k7
Locale: LANG=en_CA, LC_CTYPE=en_CA (charmap=ISO-8859-1)

Versions of packages libdbd-pg-perl depends on:
ii  libc6                      2.3.2.ds1-22  GNU C Library: Shared libraries an
ii  libdbi-perl                1.46-6        Perl5 database interface by Tim Bu
ii  libpq3                     7.4.7-6sarge1 PostgreSQL C client library
ii  perl                       5.8.4-8       Larry Wall's Practical Extraction 
ii  perl-base [perlapi-5.8.4]  5.8.4-8       The Pathologically Eclectic Rubbis

-- no debconf information

Attachment: test.pl
Description: Perl program

Reply via email to