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

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
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
Target Version:             1.4.35
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-07-16 16:54 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
====================================================================== 

---------------------------------------------------------------------- 
 (0124659) svnbot (reporter) - 2010-07-16 16:54
 https://issues.asterisk.org/view.php?id=17369#c124659 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 277568

U   branches/1.4/res/res_config_odbc.c
U   branches/1.4/res/res_config_pgsql.c

------------------------------------------------------------------------
r277568 | tilghman | 2010-07-16 16:54:28 -0500 (Fri, 16 Jul 2010) | 8
lines

Since we split values at the semicolon, we should store values with a
semicolon as an encoded value.

(closes issue https://issues.asterisk.org/view.php?id=17369)
 Reported by: gkservice
 Patches: 
       20100625__issue17369.diff.txt uploaded by tilghman (license 14)
 Tested by: tilghman

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=277568 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-07-16 16:54 svnbot         Checkin                                      
2010-07-16 16:54 svnbot         Note Added: 0124659                          
======================================================================