Skip Menu |

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

Report information
The Basics
Id: 77724
Status: resolved
Priority: 0/
Queue: DBD-SQLite

Owner: Nobody in particular
Requestors: perl [...]

Bug Information
Severity: Important
Broken in: (no value)
Fixed in: (no value)

Subject: bug in primary_key_info with regard to column names containing whitespace
text/x-perl 633b
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.
Download (untitled) / with headers
text/plain 167b
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. >
DBD::SQLite 1.38_01 with a fix is released. Thanks.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to