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

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

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
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.