Skip Menu |
 

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id: 18035
Status: rejected
Priority: 0/
Queue: DBD-Pg

People
Owner: JBAKER [...] cpan.org
Requestors: nonsolosoft [...] diff.org
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: (no value)
Fixed in: (no value)



Subject: dollar numbered placeholders
MIME-Version: 1.0
X-Mailer: MIME-tools 5.418 (Entity 5.418)
X-RT-Original-Encoding: utf-8
Content-Type: multipart/mixed; boundary="----------=_1141734966-26178-1"
Content-Length: 0
Content-Type: text/plain; charset="utf8"
Content-Disposition: inline
Content-Transfer-Encoding: binary
Content-Length: 144
Download (untitled) / with headers
text/plain 144b
DBI::VERSION:1.50 DBD::Pg::VERSION:1.45 DBD::Pg::st execute failed: called with 2 bind variables when 0 are needed at /home/fer/test.pl line 13.
Subject: test.pl
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----------=_1141734966-26178-0"
X-Mailer: MIME-tools 5.418 (Entity 5.418)
Content-Length: 0
Content-Type: text/plain; charset="utf8"
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 0
Content-Type: application/x-perl; name="test.pl"
Content-Disposition: inline; filename="test.pl"
Content-Transfer-Encoding: base64
Content-Length: 336
Download test.pl
text/x-perl 336b
#!/usr/bin/perl #!/usr/bin/perl use DBI; print "DBI::VERSION:" . $DBI::VERSION; my $dbh=DBI->connect("dbi:Pg:dbname=template1", "pgsql", "", {AutoCommit => 0}); print "\nDBD::Pg::VERSION:" . $DBD::Pg::VERSION ."\n"; my $sth=$dbh->prepare(qq(SELECT count(*) FROM pg_class WHERE relpages BETWEEN $1 AND $2)); $sth->execute(100,105);
MIME-Version: 1.0
X-Mailer: MIME-tools 5.418 (Entity 5.418)
Content-Disposition: inline
Message-Id: <rt-3.5.HEAD-26188-1141771056-208.18035-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf8"
Content-Transfer-Encoding: binary
From: nonsolosoft [...] diff.org
X-RT-Original-Encoding: utf-8
X-RT-Original-Encoding: utf-8
Content-Length: 406
Download (untitled) / with headers
text/plain 406b
On Mar. 07 Mar. 2006 07:36:08, guest wrote: Show quoted text
> DBI::VERSION:1.50 > DBD::Pg::VERSION:1.45
Following is the output of: my $sth=$dbh->prepare(qq( SELECT count(*) FROM pg_class WHERE relpages BETWEEN $1 AND $2 )); $sth->execute(100,105); Just as from DBD::Pg docs. Show quoted text
> DBD::Pg::st execute failed: called with 2 bind variables when 0 are > needed at /home/fer/test.pl line 13.
With PostgreSQL 8.0.3 and 8.1.x
X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.5 required=8.0 tests=BAYES_00,FORGED_RCVD_HELO
In-Reply-To: <rt-3.5.HEAD-26188-1141771056-208.18035-5-0 [...] rt.cpan.org>
X-Mailer: Evolution 2.5.92
Received-SPF: neutral (x1.develooper.com: local policy)
References: <RT-Ticket-18035 [...] rt.cpan.org> <rt-3.5.HEAD-26188-1141771056-208.18035-5-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
X-RT-Original-Encoding: ascii
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id 68A634D8234 for <cpan-bug+dbd-pg [...] diesel.bestpractical.com>; Tue, 7 Mar 2006 17:44:53 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id E4EE74D80AA for <bug-DBD-Pg [...] rt.cpan.org>; Tue, 7 Mar 2006 17:44:52 -0500 (EST)
Received: (qmail 2338 invoked by alias); 7 Mar 2006 22:44:51 -0000
Received: from adsl-71-128-90-172.dsl.pltn13.pacbell.net (HELO gghcwest.com) (71.128.90.172) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Tue, 07 Mar 2006 14:44:45 -0800
Received: from toonses.gghcwest.com (toonses.gghcwest.com [192.168.168.115]) by gghcwest.com (8.12.10/8.12.9) with ESMTP id k27Mibmd023409 for <bug-DBD-Pg [...] rt.cpan.org>; Tue, 7 Mar 2006 14:44:37 -0800
Delivered-To: cpan-bug+dbd-pg [...] diesel.bestpractical.com
Subject: Re: [rt.cpan.org #18035] dollar numbered placeholders
Return-Path: <jwbaker [...] acm.org>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+dbd-pg [...] diesel.bestpractical.com
Date: Tue, 07 Mar 2006 14:44:39 -0800
Message-Id: <1141771479.22111.0.camel [...] toonses.gghcwest.com>
To: bug-DBD-Pg [...] rt.cpan.org
Content-Transfer-Encoding: 7bit
From: "Jeffrey W. Baker" <jwbaker [...] acm.org>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.5.HEAD-26188-1141771498-437.18035-0-0 [...] rt.cpan.org>
Content-Length: 673
Download (untitled) / with headers
text/plain 673b
On Tue, 2006-03-07 at 17:37 -0500, Guest via RT wrote: Show quoted text
> <URL: http://rt.cpan.org/Ticket/Display.html?id=18035 > > > On Mar. 07 Mar. 2006 07:36:08, guest wrote:
> > DBI::VERSION:1.50 > > DBD::Pg::VERSION:1.45
> > Following is the output of: > my $sth=$dbh->prepare(qq( > SELECT count(*) FROM pg_class WHERE relpages BETWEEN $1 AND $2 > )); > > $sth->execute(100,105); > > Just as from DBD::Pg docs. >
> > DBD::Pg::st execute failed: called with 2 bind variables when 0 are > > needed at /home/fer/test.pl line 13.
> > With PostgreSQL 8.0.3 and 8.1.x
This is not a bug, it's a user error. You cannot use a bare dollar sign inside double quotes (qq) in perl. -jwb
X-Scanned-BY: AMaViS-ng at bestpractical
MIME-Version: 1.0
X-Spam-Status: No, hits=-2.5 required=8.0 tests=BAYES_00,FORGED_RCVD_HELO
In-Reply-To: <rt-3.5.HEAD-26188-1141771498-437.18035-6-0 [...] rt.cpan.org>
Received-SPF: neutral (x1.develooper.com: local policy)
References: <RT-Ticket-18035 [...] rt.cpan.org> <rt-3.5.HEAD-26188-1141771056-208.18035-5-0 [...] rt.cpan.org> <1141771479.22111.0.camel [...] toonses.gghcwest.com> <rt-3.5.HEAD-26188-1141771498-437.18035-6-0 [...] rt.cpan.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Organization: NonSoLoSoft - Italy - http://www.nonsolosoft.com/
X-RT-Original-Encoding: utf-8
Received: from localhost (localhost.localdomain [127.0.0.1]) by diesel.bestpractical.com (Postfix) with ESMTP id A53794D8212 for <cpan-bug+dbd-pg [...] diesel.bestpractical.com>; Tue, 7 Mar 2006 18:26:04 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id 2D5394D80AA for <bug-DBD-Pg [...] rt.cpan.org>; Tue, 7 Mar 2006 18:26:04 -0500 (EST)
Received: (qmail 17088 invoked by alias); 7 Mar 2006 23:26:02 -0000
Received: from ns.virtuo.it (HELO agnus.ngi.it) (88.149.128.9) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Tue, 07 Mar 2006 15:26:00 -0800
Received: from k7.diff.org (81-174-26-135.f5.ngi.it [81.174.26.135]) by agnus.ngi.it (8.13.5/8.13.5) with ESMTP id k27NPoff013306 for <bug-DBD-Pg [...] rt.cpan.org>; Wed, 8 Mar 2006 00:25:50 +0100
Received: from [127.0.0.1] (localhost [127.0.0.1]) by k7.diff.org (8.13.4/8.13.4) with ESMTP id k27NR7u9019713 for <bug-DBD-Pg [...] rt.cpan.org>; Wed, 8 Mar 2006 00:27:07 +0100 (CET) (envelope-from nonsolosoft [...] diff.org)
Delivered-To: cpan-bug+dbd-pg [...] diesel.bestpractical.com
Subject: Re: [rt.cpan.org #18035] dollar numbered placeholders
User-Agent: Thunderbird 1.5 (X11/20060114)
Return-Path: <nonsolosoft [...] diff.org>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+dbd-pg [...] diesel.bestpractical.com
Date: Wed, 08 Mar 2006 00:27:07 +0100
Message-Id: <440E16CB.2030604 [...] diff.org>
To: bug-DBD-Pg [...] rt.cpan.org
Content-Transfer-Encoding: 7bit
From: Ferruccio Zamuner <nonsolosoft [...] diff.org>
X-RT-Original-Encoding: utf-8
RT-Message-ID: <rt-3.5.HEAD-26196-1141773971-424.18035-0-0 [...] rt.cpan.org>
Content-Length: 283
Download (untitled) / with headers
text/plain 283b
Jeffrey W. Baker via RT wrote: Show quoted text
> This is not a bug, it's a user error. You cannot use a bare dollar sign > inside double quotes (qq) in perl. > > -jwb
Gosp, you right! Sorry, I've discovered that I'd to sleep more. I hope you don't blame me. Thank you, \fer


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.