[asterisk-bugs] [Asterisk 0015133]: Null fields do not get stored as null in mysql

[Asterisk Bug Tracker]

The following issue requires your FEEDBACK. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15133 
====================================================================== 
Reported By:                johnakabean
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   15133
Category:                   Addons/cdr_addon_mysql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.4.24 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-05-16 19:36 CDT
Last Modified:              2009-05-18 07:04 CDT
====================================================================== 
Summary:                    Null fields do not get stored as null in mysql
Description: 
If a field, such as account code, has nothing to input, asterisk stores it
as something NOT Null; this issue is with ALL fields asterisk uses in
storing the cdr in mysql but I have not seen if the problem originates in
the cdr generator backend itself or in the mysql addon module.
====================================================================== 

---------------------------------------------------------------------- 
 (0104903) tilghman (administrator) - 2009-05-18 07:04
 https://issues.asterisk.org/view.php?id=15133#c104903 
---------------------------------------------------------------------- 
That's a function of the CDR fields.  All of the standard fields in
Asterisk are empty strings by default, not NULL, so MySQL is correctly
logging this fact.  Only non-standard fields can ever be set NULL.  Also,
non-standard fields are only supported in this backend, starting in version
1.6.0. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-18 07:04 tilghman       Note Added: 0104903                          
2009-05-18 07:04 tilghman       Status                   new => feedback     
======================================================================