[asterisk-bugs] [Asterisk 0017369]: [patch] realtime shows 2x fullcontact if delimited by '; '

[Asterisk Bug Tracker]

The following issue is now READY FOR TESTING. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17369 
====================================================================== 
Reported By:                gkservice
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   17369
Category:                   Functions/func_realtime
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           1.4.31 
JIRA:                       SWP-1520 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-05-21 02:00 CDT
Last Modified:              2010-06-25 17:22 CDT
====================================================================== 
Summary:                    [patch] realtime shows 2x fullcontact if delimited
by ';'
Description: 
in mysql we can see:
>>>>>>>>>
mysql> select name, port, fullcontact, ipaddr from sip_buddies where name
= '746';
+------+------+-----------------------------------------+--------------+
| name | port | fullcontact                             | ipaddr       |
+------+------+-----------------------------------------+--------------+
| 746  | 5060 | sip:746 at 192.168.3.24:5060;transport=udp | 192.168.3.24 |
+------+------+-----------------------------------------+--------------+
1 row in set (0.00 sec)
>>>>>>>>>
but " realtime load sippeers name 746" shows
>>>>>>>>>
name  746
fullcontact  sip:746 at 192.168.3.24:5060
fullcontact  transport=udp
ipaddr  192.168.3.24
port  5060
>>>>>>>>>
so with this the dialplan function "REALTIME" shows only the last
fullcontact Entry (transport=udp) and not all fullcontact
====================================================================== 

---------------------------------------------------------------------- 
 (0123920) tilghman (administrator) - 2010-06-25 17:22
 https://issues.asterisk.org/view.php?id=17369#c123920 
---------------------------------------------------------------------- 
This should solve it, by encoding fields with semicolons embedded.  AFAIK,
there is nothing in Asterisk currently that stores multiple fields directly
and expects them to come back separately.  We'll probably have to
eventually provision for that, but this should solve the issue in the
meantime. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-06-25 17:22 tilghman       Note Added: 0123920                          
2010-06-25 17:22 tilghman       Status                   assigned => ready for
testing
======================================================================