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

[Paul Gilbert]

> -----Original Message-----
> From: r-sig-db-bounces using stat.math.ethz.ch [mailto:r-sig-db-
> bounces using stat.math.ethz.ch] On Behalf Of Seth Falcon
> Sent: September 30, 2009 12:02 PM
> To: Hervé Pagès
> Cc: r-sig-db using stat.math.ethz.ch
> Subject: Re: [R-sig-DB] dbWriteTable() is renaming the 'end' column
> 
> 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.

I think the quoting problem is an SQL standard, so it might be nice to push it up to DBI rather than each of the implementations below trying to deal with it. (I have not thought through this, there may be problems.)

Paul
> 
> + seth
> 
> 
> --
> Seth Falcon | @sfalcon | http://userprimary.net/user
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
====================================================================================

La version française suit le texte anglais.

------------------------------------------------------------------------------------

This email may contain privileged and/or confidential information, and the Bank of
Canada does not waive any related rights. Any distribution, use, or copying of this
email or the information it contains by other than the intended recipient is
unauthorized. If you received this email in error please delete it immediately from
your system and notify the sender promptly by email that you have done so. 

------------------------------------------------------------------------------------

Le présent courriel peut contenir de l'information privilégiée ou confidentielle.
La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute diffusion,
utilisation ou copie de ce courriel ou des renseignements qu'il contient par une
personne autre que le ou les destinataires désignés est interdite. Si vous recevez
ce courriel par erreur, veuillez le supprimer immédiatement et envoyer sans délai à
l'expéditeur un message électronique pour l'aviser que vous avez éliminé de votre
ordinateur toute copie du courriel reçu.