Summary:ASTERISK-14565: realtime function does not return pair when column data value is null
Reporter:sohosys (sohosys)Labels:
Date Opened:2009-07-30 09:40:02Date Closed:2011-06-07 14:00:28
Versions:Frequency of
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.


to reproduce; add a realtime function lookup to any dial plan, compare the string results of a row with no null values to a row with at least one null value.
Comments:By: Tilghman Lesher (tilghman) 2009-07-30 13:35:32

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.