Bug 229065
| Summary: | double ?? in prepare causes seg fault on execute | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Robert Haas <robertmhaas> |
| Component: | perl-DBD-Pg | Assignee: | Marcela Mašláňová <mmaslano> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | rawhide | CC: | jpazdziora, perl-devel |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | perl-DBD-Pg-1.49-5.fc8.2 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2008-03-27 07:16:28 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
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. |
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.