Front page | perl.perl5.porters |
Postings from May 2004
[perl #29589] DBD::Pg and ASCII NULL
Thread Next
From:
David Muir Sharnoff
Date:
May 15, 2004 07:03
Subject:
[perl #29589] DBD::Pg and ASCII NULL
Message ID:
rt-3.0.9-29589-87440.14.043650344427@perl.org
# New Ticket Created by David Muir Sharnoff
# Please include the string: [perl #29589]
# in the subject line of all future correspondence about this issue.
# <URL: http://rt.perl.org:80/rt3/Ticket/Display.html?id=29589 >
This is a bug report for perl from muir@idiom.com,
generated with the help of perlbug 1.34 running under perl v5.8.3.
-----------------------------------------------------------------
[Please enter your report here]
DBD::Pg cannot insert ASCII nulls.
The following illustrates the problem is with DBD::Pg rather than with
PostgreSQL:
% psql rectangle
DROP TABLE xya;
DROP TABLE xyb;
CREATE TABLE xya (
abc BYTEA,
def BYTEA,
PRIMARY KEY (def));
CREATE TABLE xyb (
abc BYTEA,
def BYTEA,
PRIMARY KEY (def));
INSERT INTO xya VALUES ('', 'zero-length');
INSERT INTO xya VALUES ('\\000', 'null byte');
INSERT INTO xya VALUES ('ab', 'a b');
INSERT INTO xya VALUES ('a\\000b', 'a null b');
SELECT length(abc), * FROM xya;
% perl
use DBI;
$ENV{DBI_DSN} = 'dbi:Pg:dbname=rectangle' unless defined $ENV{DBI_DSN};
my $dbh = DBI->connect($ENV{DBI_DSN}, '', '', {
Taint => 0,
PrintError => 0,
RaiseError => 0,
AutoCommit => 1,
}) or die "connect to database: $DBI::errstr";
my $sth = $dbh->prepare("INSERT INTO xyb VALUES (?, ?)") || die $dbh->errstr;
$sth->execute('', 'zero-length') || die "zero-length: ".$dbh->errstr;
$sth->execute(chr(0), 'null byte') || die "null byte: ".$dbh->errstr;
$sth->execute('ab', 'a b') || die "a b: ".$dbh->errstr;
$sth->execute('a'.chr(0).'b', 'a null b') || die "a null b: ".$dbh->errstr;
$dbh->disconnect;
% psql rectangle
SELECT length(abc), * FROM xyb;
[Please do not change anything below this line]
-----------------------------------------------------------------
---
Flags:
category=library
severity=medium
---
Site configuration information for perl v5.8.3:
Configured by Debian Project at Sat Mar 27 17:07:14 EST 2004.
Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration:
Platform:
osname=linux, osvers=2.4.25-ti1211, archname=i386-linux-thread-multi
uname='linux kosh 2.4.25-ti1211 #1 thu feb 19 18:20:12 est 2004 i686 gnulinux '
config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN -Dcccdlflags=-fPIC -Darchname=i386-linux -Dprefix=/usr -Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8 -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.8.3 -Dsitearch=/usr/local/lib/perl/5.8.3 -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 -Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Uusesfio -Uusenm -Duseshrplib -Dlibperl=libperl.so.5.8.3 -Dd_dosuid -des'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O3',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include'
ccversion='', gccversion='3.3.3 (Debian 20040314)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.3.2.so, so=so, useshrplib=true, libperl=libperl.so.5.8.3
gnulibc_version='2.3.2'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
Locally applied patches:
---
@INC for perl v5.8.3:
/etc/perl
/usr/local/lib/perl/5.8.3
/usr/local/share/perl/5.8.3
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
/usr/local/lib/perl/5.8.2
/usr/local/share/perl/5.8.2
.
---
Environment for perl v5.8.3:
HOME=/home/muir
LANG=C
LANGUAGE (unset)
LD_LIBRARY_PATH (unset)
LOGDIR (unset)
PATH=.:/home/muir/bin/charm:/home/muir/bin:/home/muir/bin/share:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/shbin:/usr/local/sbin:/usr/local/bin:/usr/local/ptybin:/usr/X11R6/bin:/usr/bin/X11:/usr/local/tex/bin:/usr/ucb:/usr/bin:/bin:/etc:/usr/etc:/usr/games:/lib:/usr/lib:/usr/local/java/bin:/usr/lib/uucp:/usr/openwin/bin:/usr/openwin/bin/xview:/usr/openwin/demo:/usr/adm:/home/muir/tmp
PERL_BADLANG (unset)
SHELL=/bin/tcsh
Thread Next
-
[perl #29589] DBD::Pg and ASCII NULL
by David Muir Sharnoff