Red Hat Bugzilla – Bug 229065
double ?? in prepare causes seg fault on execute
Last modified: 2008-03-27 03:16:28 EDT
Description of problem:
If you attempt to prepare and execute a statement that contains "??", perl seg
Version-Release number of selected component (if applicable):
my $dbh = DBI->connect('DBI:Pg:');
my $sth = $dbh->prepare("SELECT foo(??)");
Steps to Reproduce:
1. Put the script above into a file
2. Fiddle connection string if necessary. Any valid database will cause the
3. Feed it to perl.
Query gets executed and succeeds or fails or whatever the case may be.
I also tried this on an FC4 system with the same result, so it's not a new
This bug still exists in Fedora Core 7.
Reproduced in F8 with perl-DBD-Pg-1.49-5.fc8.1.
With DBD-Pg-2.2.2 from CPAN, I get
DBD::Pg::st execute failed: ERROR: syntax error at or near "$2"
LINE 1: SELECT foo($1$2)
^ at -e line 1.
so the problem seems to be properly fixed there.
And the patch to fix this in 1.49 is here:
So ... we will either want to use 2.2.2+ in Fedora 9, or apply that patch to
1.49. Which one will it be?
I'd like to use 2.2.2 version, but I wait for perl-5.10.
F-7 and F-8 will be updated soon. The rawhide should be fixed with new version
perl-DBD-Pg-1.49-5.fc8.2 has been submitted as an update for Fedora 8
perl-DBD-Pg-1.49-4.fc7 has been submitted as an update for Fedora 7
perl-DBD-Pg-1.49-4.fc7 has been pushed to the Fedora 7 testing repository. If problems still persist, please make note of it in this bug report.
If you want to test the update, you can install it with
su -c 'yum --enablerepo=updates-testing update perl-DBD-Pg'. You can provide feedback for this update here: http://admin.fedoraproject.org/updates/F7/FEDORA-2008-2440
perl-DBD-Pg-1.49-5.fc8.2 has been pushed to the Fedora 8 stable repository. If problems still persist, please make note of it in this bug report.
perl-DBD-Pg-1.49-4.fc7 has been pushed to the Fedora 7 stable repository. If problems still persist, please make note of it in this bug report.