[ic] Quoting Identifiers

Jon Jensen jon at endpoint.com
Thu Mar 12 20:40:20 UTC 2015


On Fri, 13 Mar 2015, Peter wrote:

> At present Interchange doesn't quote identifiers when making SQL 
> queries.  This just caused an issue for a client of mine who is moving 
> catalogs from an old version of mysql to a newer one and has a column 
> name of "condition" which is now a reserved word in mysql (it didn't 
> used to be).  There are also a number of other good reasons to quote 
> identifiers which I won't enumerate here.
>
> I would just push a patch up for this, except that this does result in a 
> BC change.  When you quote an identifier it becomes case-sensitive, but 
> unquoted identifiers are not, or (as is the case in postgresql) are 
> converted to lowercase.  Therefore I think it's best to enable it with a 
> config directive which can be added to the default catalog.cfg so new 
> catalogs pick up the change, but old ones will need it to be explicitly 
> enabled if this is desired.

It makes sense to me to implement it as a new non-default option.

Jon


-- 
Jon Jensen
End Point Corporation
https://www.endpoint.com/



More information about the interchange-users mailing list