[R-sig-DB] dbWriteTable() is renaming the 'end' column

[Seth Falcon]

Hi Hervé,

2009/9/29 Hervé Pagès <hpages using fhcrc.org>:
> You are right that in the ANSI SQL standard, an SQL delimited identifier
> is delimited by double quotes, not backquotes, sorry.
> Anyway my point is that, among other possibilities, dbWriteTable() could
> send a CREATE statement with delimited identifiers, so SQL keywords are
> not an issue anymore. This is only one possibility. There are others,
> like just returning an error if the column name is a keyword, or
> allowing the user disable the mangling, etc. Anything
> sounds better than silently mangling the column names.

I agree that the silent name mangling is not so helpful, nor is the
inconsistency in behavior when SQL keywords are used in different
RSQLite functions.

The question to decide is what change should be made?  Such requests
could become errors with a message telling the user how to quote
problem strings.  Or the mangling could be changed to use the quoted
form and a warning issued.

I would be interested to hear any opinions from users of RSQLite.

+ seth


-- 
Seth Falcon | @sfalcon | http://userprimary.net/user