[interchange-bugs] [rt.icdevgroup.org #337] DBI does not quote column names -> reserved words will break query

[Gert van der Spoel via RT]

Tue Jan 05 09:09:12 2010: Request 337 was acted upon.
Transaction: Ticket created by thunder
       Queue: Interchange
     Subject: DBI does not quote column names -> reserved words will break query
       Owner: Nobody
  Requestors: ic-rt at 3edge.com
      Status: new
 Ticket <URL: http://rt.icdevgroup.org/Ticket/Display.html?id=337 >


If a column name turns out to be (or become) a reserved word then queries in Interchange will break (ie set_slice etc) .. This is because column names are not quoted.

(pj: the DBI method quote_identifier() is specifically for that purpose.)

Example: 
Mysql 4 ->  'condition' would be a column name without a problem
Mysql 5 ->  'condition' is a reserved word and needs to be quoted

Boom ...