Will Hawes wrote:
Yesterday a colleague new to DBIC ran into a problem with a column named using a reserved word in MySQL. He worked around it by using a different column name, but while discussing the issue he asked why quote_char and name_sep are not set automatically. I don't know the answer and Googling has left me none the wiser.
The semantics of SQL are different depending on whether identifier names are quoted or barewords; according to the standard and some DBMSs, bareword identifiers match case-insensitively while quoted ones match case-sensitively. Therefore, identifiers being automatically quoted or not quoted would have different semantics. So the semantics of DBIC would be different if it automatically did or didn't quote identifiers, all other things being equal.
-- Darren Duncan _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk