[asterisk-bugs] [Asterisk 0015615]: realtime function does not return pair when column data value is null

[Asterisk Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15615 
====================================================================== 
Reported By:                sohosys
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   15615
Category:                   Functions/func_realtime
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
Asterisk Version:           1.4.25.1 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-07-30 09:40 CDT
Last Modified:              2009-07-30 09:40 CDT
====================================================================== 
Summary:                    realtime function does not return pair when column
data value is null
Description: 
when using the realtime function, if a data column in the underlying MySql
database has a null value the field name/value pair is omitted completely.
This changes the field count in the returned data string making it
impossible to parse in a repeatable fashion. Some fields in the database
require null default values (mainly in the sip users table). The generally
accepted practice when converting from defined data types to string values
is to translate the null data value to an empty string. The function should
return value='' rather than omitting the column from the results.
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-07-30 09:40 sohosys        New Issue                                    
2009-07-30 09:40 sohosys        Asterisk Version          => 1.4.25.1        
2009-07-30 09:40 sohosys        Regression                => No              
2009-07-30 09:40 sohosys        SVN Branch (only for SVN checkouts, not tarball
releases) => N/A             
======================================================================