[asterisk-bugs] [Asterisk 0019063]: [patch] Column names should be escaped

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=19063 
====================================================================== 
Reported By:                festr
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   19063
Category:                   Addons/cdr_addon_mysql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     closed
Asterisk Version:           SVN 
JIRA:                       SWP-3306 
Regression:                 No 
Reviewboard Link:           311978 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 311978 
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2011-04-04 09:45 CDT
Last Modified:              2011-05-03 19:12 CDT
====================================================================== 
Summary:                    [patch] Column names should be escaped
Description: 
Coulmns are not escaped so you get error inserting columns with names like
this: 'bla-bla' or 'trim' etc. Attaching patch to escape columns with ``. 
====================================================================== 

---------------------------------------------------------------------- 
 (0134382) svnbot (reporter) - 2011-05-03 19:12
 https://issues.asterisk.org/view.php?id=19063#c134382 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 316429

U   branches/1.8/addons/cdr_mysql.c
U   branches/1.8/addons/res_config_mysql.c

------------------------------------------------------------------------
r316429 | tilghman | 2011-05-03 19:12:26 -0500 (Tue, 03 May 2011) | 7
lines

Escape column names in case they contain illegal characters ('-') or
reserved words.

(closes issue https://issues.asterisk.org/view.php?id=19063)
 Reported by: festr
 Patches: 
       patch uploaded by festr (license 443)

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

http://svn.digium.com/view/asterisk?view=rev&revision=316429 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-05-03 19:12 svnbot         Checkin                                      
2011-05-03 19:12 svnbot         Note Added: 0134382                          
======================================================================