Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id:
77724
Status:
resolved
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
perl [...] toby.ink
Cc:
AdminCc:

BugTracker
Severity:
Important
Broken in:
(no value)
Fixed in:
(no value)



Subject: bug in primary_key_info with regard to column names containing whitespace
Subject: sqlite-thing.pl
use 5.010; use strict; use Data::Dumper; use DBI; use Test::More tests => 2; my $dbh = DBI->connect('dbi:SQLite:database=:memory:') or die $DBI::errstr; $dbh->do($_) for q[CREATE TABLE "Country Info" ("Country Code" CHAR(2) PRIMARY KEY, "Name" VARCHAR(200))], q[INSERT INTO "Country Info" VALUES ('DE', 'Germany')], q[INSERT INTO "Country Info" VALUES ('FR', 'France')]; my $sth = $dbh->primary_key_info(undef, undef, "Country Info"); my $row; ok( $row = $sth->fetchrow_hashref, 'Found the primary key column.', ); is( $row->{COLUMN_NAME}, "Country Code", 'Key column name reported correctly.', ) or diag Dumper $row;
There is discussion of this issue here. https://rt.cpan.org/Ticket/Display.html?id=77723
Fixed in the trunk. Thanks. On Mon Jun 11 06:40:52 2012, TOBYINK wrote:
Show quoted text
> There is discussion of this issue here. > https://rt.cpan.org/Ticket/Display.html?id=77723
DBD::SQLite 1.38_01 with a fix is released. Thanks.


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.