[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:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   19063
Category:                   Addons/cdr_addon_mysql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     ready for testing
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:              
====================================================================== 
Date Submitted:             2011-04-04 09:45 CDT
Last Modified:              2011-05-03 19:05 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 ``. 
====================================================================== 

---------------------------------------------------------------------- 
 (0134381) svnbot (reporter) - 2011-05-03 19:05
 https://issues.asterisk.org/view.php?id=19063#c134381 
---------------------------------------------------------------------- 
Repository: asterisk-addons
Revision: 1150

U   branches/1.6.2/cdr/cdr_addon_mysql.c
U   branches/1.6.2/res/res_config_mysql.c

------------------------------------------------------------------------
r1150 | tilghman | 2011-05-03 19:05:46 -0500 (Tue, 03 May 2011) | 7 lines

Quote column names, in case they contain special characters like '-' or
are 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-addons?view=rev&revision=1150 

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