[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:                     closed
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:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2010-05-21 02:00 CDT
Last Modified:              2010-07-17 12:41 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
====================================================================== 

---------------------------------------------------------------------- 
 (0124674) svnbot (reporter) - 2010-07-17 12:41
 https://issues.asterisk.org/view.php?id=17369#c124674 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 277774

_U  branches/1.6.2/
U   branches/1.6.2/res/res_config_odbc.c
U   branches/1.6.2/res/res_config_pgsql.c

------------------------------------------------------------------------
r277774 | tilghman | 2010-07-17 12:40:59 -0500 (Sat, 17 Jul 2010) | 22
lines

Merged revisions 277773 via svnmerge from 
https://origsvn.digium.com/svn/asterisk/trunk

................
  r277773 | tilghman | 2010-07-17 12:39:28 -0500 (Sat, 17 Jul 2010) | 15
lines
  
  Merged revisions 277568 via svnmerge from 
  https://origsvn.digium.com/svn/asterisk/branches/1.4
  
  ........
    r277568 | tilghman | 2010-07-16 16:54:29 -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=277774 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-07-17 12:41 svnbot         Checkin                                      
2010-07-17 12:41 svnbot         Note Added: 0124674                          
======================================================================