Bug 187873

Summary: SEGV when accessing $sth->{TYPE}->[$i] for a VIEW
Product: [Fedora] Fedora Reporter: Nigel Metheringham <nigel>
Component: perl-DBD-SQLiteAssignee: Jose Pedro Oliveira <jose.p.oliveira.oss>
Status: CLOSED CURRENTRELEASE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: medium    
Version: 5CC: extras-qa
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
URL: http://rt.cpan.org/Public/Bug/Display.html?id=12347
Whiteboard:
Fixed In Version: perl-DBD-SQLite-1.12-1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2006-04-12 15:14:19 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:
Attachments:
Description Flags
Workround patch for SEGV in type none

Description Nigel Metheringham 2006-04-04 07:50:49 UTC 
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
Comment 1 Nigel Metheringham 2006-04-04 07:50:49 UTC 
Created attachment 127276 [details]
Workround patch for SEGV in type
Comment 2 Jose Pedro Oliveira 2006-04-05 17:09:33 UTC 
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/
Comment 3 Jose Pedro Oliveira 2006-04-12 15:14:19 UTC 
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.