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)



Subject: Problem with names in DB that using square bracers
Download (untitled) / with headers
text/plain 385b
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.
Download (untitled) / with headers
text/plain 646b
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.
Download (untitled) / with headers
text/plain 561b
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.


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.