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

[Asterisk Bug Tracker]

The following issue has been CLOSED 
====================================================================== 
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:                     closed
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:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             2009-07-30 09:40 CDT
Last Modified:              2009-07-30 13:35 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.
====================================================================== 

---------------------------------------------------------------------- 
 (0108403) tilghman (administrator) - 2009-07-30 13:35
 https://issues.asterisk.org/view.php?id=15615#c108403 
---------------------------------------------------------------------- 
Since this was judged to be a non-backwards-compatible change, it was
changed and is available only in the 1.6.x series.  This is not a change
that we can make in 1.4, as it involves changing how the realtime functions
work. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-07-30 13:35 tilghman       Note Added: 0108403                          
2009-07-30 13:35 tilghman       Status                   new => closed       
2009-07-30 13:35 tilghman       Resolution               open => no change
required
======================================================================