Skip Menu |

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

Report information
The Basics
Id: 55466
Status: resolved
Priority: 0/
Queue: DBD-SQLite
People
Owner: Nobody in particular
Requestors: alexandrfedorov [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Thu Mar 11 07:46:04 2010 alexandrfedorov [...] gmail.com - Ticket created
Subject: Problem with names in DB that using square bracers
I was created SQLite DB in program "SQLite Administrator", and after executing primary_key_info i'm get primary key columns in '[id]' format. I'm looked in schema of DB it is right. Sqlite console program works good with that DB with queries like "SELECT * FROM sometable WHERE id > 4". I don't find explanation of this behavior on www.sqlite.org and wish to understand this with you.
  Sun Mar 14 22:58:40 2010 ishigaki [...] cpan.org - Correspondence added
Hi. You can find explanation of this non-standard quoting at http:// www.sqlite.org/lang_keywords.html . As of this writing, DBD::SQLite doesn't take special care of this blacket quoting though. On 2010-3-11 Thu 07:46:04, zloyrusskiy wrote: Show quoted text
> I was created SQLite DB in program "SQLite Administrator", and after > executing primary_key_info i'm get primary key columns in '[id]'
format. Show quoted text
> I'm looked in schema of DB it is right. > > Sqlite console program works good with that DB with queries like
"SELECT Show quoted text
> * FROM sometable WHERE id > 4". I don't find explanation of this > behavior on www.sqlite.org and wish to understand this with you.
  Sun Mar 14 22:58:42 2010 The RT System itself - Status changed from 'new' to 'open'
  Wed Mar 31 02:17:42 2010 ishigaki [...] cpan.org - Correspondence added
1.30_02 now take the '[id]' format into account and extracts the right id. Closed this ticket as fixed. Thanks. On 2010-3-11 Thu 07:46:04, zloyrusskiy wrote: Show quoted text
> I was created SQLite DB in program "SQLite Administrator", and after > executing primary_key_info i'm get primary key columns in '[id]' format. > I'm looked in schema of DB it is right. > > Sqlite console program works good with that DB with queries like "SELECT > * FROM sometable WHERE id > 4". I don't find explanation of this > behavior on www.sqlite.org and wish to understand this with you.
  Wed Mar 31 02:17:43 2010 ishigaki [...] cpan.org - Status changed from 'open' to 'resolved'