Description of problem: If you attempt to prepare and execute a statement that contains "??", perl seg faults. Version-Release number of selected component (if applicable): perl-5.8.8-10 perl-DBI-1.52-1.fc6 perl-DBD-Pg-1.49-1.fc6 postgresql-8.1.8-1.fc6 How reproducible: require DBI; my $dbh = DBI->connect('DBI:Pg:'); my $sth = $dbh->prepare("SELECT foo(??)"); $sth->execute(1, 1); Steps to Reproduce: 1. Put the script above into a file 2. Fiddle connection string if necessary. Any valid database will cause the same result. 3. Feed it to perl. Actual results: Segmentation fault Expected results: Query gets executed and succeeds or fails or whatever the case may be. Additional info: I also tried this on an FC4 system with the same result, so it's not a new regression.
This bug still exists in Fedora Core 7. perl-5.8.8-27.fc7 perl-DBI-1.53-2.fc7 perl-DBD-Pg-1.49-3.fc7 postgresql-8.2.6-1.fc7
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: http://svn.perl.org/viewvc/modules/DBD-Pg/trunk/dbdimp.c?r1=10445&r2=10479 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 of package.
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.