[Home]

Summary:ASTERISK-17643: [patch] Column names should be escaped
Reporter:Martin Vit (festr)Labels:
Date Opened:2011-04-04 09:45:58Date Closed:2011-05-03 19:13:25
Priority:MajorRegression?No
Status:Closed/CompleteComponents:Addons/cdr_mysql
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:( 0) patch
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 ``.
Comments:By: Digium Subversion (svnbot) 2011-05-03 19:05:46

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 ASTERISK-17643)
Reported by: festr
Patches:
      patch uploaded by festr (license 443)

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

http://svn.digium.com/view/asterisk-addons?view=rev&revision=1150
By: Digium Subversion (svnbot) 2011-05-03 19:12:26

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 ASTERISK-17643)
Reported by: festr
Patches:
      patch uploaded by festr (license 443)

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

http://svn.digium.com/view/asterisk?view=rev&revision=316429
By: Digium Subversion (svnbot) 2011-05-03 19:13:25

Repository: asterisk
Revision: 316430

_U  trunk/
U   trunk/addons/cdr_mysql.c
U   trunk/addons/res_config_mysql.c

------------------------------------------------------------------------
r316430 | tilghman | 2011-05-03 19:13:24 -0500 (Tue, 03 May 2011) | 14 lines

Merged revisions 316429 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.8

........
 r316429 | tilghman | 2011-05-03 19:12:25 -0500 (Tue, 03 May 2011) | 7 lines
 
 Escape column names in case they contain illegal characters ('-') or reserved words.
 
 (closes issue ASTERISK-17643)
  Reported by: festr
  Patches:
        patch uploaded by festr (license 443)
........

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

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