[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:39 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
====================================================================== 

---------------------------------------------------------------------- 
 (0124673) svnbot (reporter) - 2010-07-17 12:39
 https://issues.asterisk.org/view.php?id=17369#c124673 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 277773

_U  trunk/
U   trunk/addons/res_config_mysql.c
U   trunk/include/asterisk/config.h
U   trunk/main/config.c
U   trunk/res/res_config_odbc.c
U   trunk/res/res_config_pgsql.c

------------------------------------------------------------------------
r277773 | tilghman | 2010-07-17 12:39:27 -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=277773 

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