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)

History Show all quoted text
  Fri Apr 17 15:02:39 2009 pshangov [...] yahoo.com - Ticket created
Subject: incorrect SQL_IDENTIFIER_QUOTE_CHAR?
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
  Sat Apr 18 02:04:23 2009 adamk [...] cpan.org - Correspondence added
Can you put together a test script which demonstrates this bug?
  Sat Apr 18 02:04:24 2009 The RT System itself - Status changed from 'new' to 'open'
  Mon Mar 15 21:36:48 2010 ishigaki [...] cpan.org - Correspondence added
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
  Mon Mar 15 21:37:00 2010 ishigaki [...] cpan.org - Status changed from 'open' to 'resolved'