Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the SQL-Interp CPAN distribution.

Report information
The Basics
Id:
31488
Status:
open
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
MARKSTOS [...] cpan.org
Cc:
AdminCc:

BugTracker
Severity:
Normal
Broken in:
1.05
Fixed in:
(no value)



Subject: column names with spaces in them not handled.
Inserting a column with a name of "Job Title" fails because the column name is not quoted. We should confirm that the SQL standard is to use double quotes around the column name, and then start doing that in all cases. Mark
On Thu Dec 13 10:57:50 2007, MARKSTOS wrote:
Show quoted text
> Inserting a column with a name of "Job Title" fails because the column > name is not quoted. > > We should confirm that the SQL standard is to use double quotes around > the column name, and then start doing that in all cases.
I found that "Foo" is not the same as Foo in PostgreSQL, which becomes lower-cased ( "foo" ). I think the approach we should take here is adopt the "quote_char" and "name_sep" options from SQL::Abstract, which makes quoting column names an option, so the feature is available, and backwards compatibility is maintained.


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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