Red Hat Bugzilla – Bug 187873
SEGV when accessing $sth->{TYPE}->[$i] for a VIEW
Last modified: 2007-11-30 17:11:29 EST
Description of problem: Enumeration of type information on a VIEW causes a SEGV. This would be avoidable, except that DBIx::Class hits this on startup if you have a database including a VIEW. See http://rt.cpan.org/Public/Bug/Display.html?id=12347 Version-Release number of selected component (if applicable): perl-DBD-SQLite-1.11 How reproducible: Every time Steps to Reproduce: See upstream bug report
Created attachment 127276 [details] Workround patch for SEGV in type
Imported and build for devel. SRPM and build logs available here: http://buildsys.fedoraproject.org/logs/fedora-development-extras/7258-perl-DBD-SQLite-1.11-4.fc6/
Patch still needed with DBD::SQLite 1.12. Without the patch in comment #1 the following script still crashes when accesing the TYPE information. ---------- #!/usr/bin/perl -w use strict; use DBI; my $dbh = DBI->connect("dbi:SQLite:dbname=foo", "", ""); my $sth = $dbh->prepare("SELECT * FROM f"); $sth->execute(); $sth->fetch(); my $types = $sth->{TYPE}; my $names = $sth->{NAME}; print "# Names: @$names\n"; print "# Types: @$types\n"; $sth->finish; $dbh->disconnect; ---------- perl-DBD-SQLite-1.12-1 built for FC-5 and devel.