Skip Menu |
 

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

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

People
Owner: Nobody in particular
Requestors: pshangov [...] yahoo.com
Cc:
AdminCc:

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



Subject: incorrect SQL_IDENTIFIER_QUOTE_CHAR?
Download (untitled) / with headers
text/plain 304b
DBD::SQLite has '"' (double quote) as hardcoded value for SQL_IDENTIFIER_QUOTE_CHAR, however on my system $dbh->primary key returns `id` (with backticks). This in turn breaks DBIx::Class::Schema::Loader, which tries to find a column named "`id`". Using DBD::SQLite 1.22_08, strawberry perl 5.10 on WinXP
Can you put together a test script which demonstrates this bug?
Download (untitled) / with headers
text/plain 456b
Hi. This was actually an issue of dequoting primary_key_info, and fixed in 1.30_01. Thanks. On 2009-4-17 Fri 15:02:39, pshangov wrote: Show quoted text
> DBD::SQLite has '"' (double quote) as hardcoded value for > SQL_IDENTIFIER_QUOTE_CHAR, however on my system $dbh->primary key > returns `id` (with backticks). This in turn breaks > DBIx::Class::Schema::Loader, which tries to find a column named
"`id`". Show quoted text
> > Using DBD::SQLite 1.22_08, strawberry perl 5.10 on WinXP


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

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