[asterisk-bugs] [Asterisk 0015039]: [patch] Function ODBC_FETCH returns more than one row

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=15039 
====================================================================== 
Reported By:                jims
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   15039
Category:                   Functions/func_odbc
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Asterisk Version:           1.6.1.0 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2009-05-06 01:35 CDT
Last Modified:              2009-05-07 12:53 CDT
====================================================================== 
Summary:                    [patch] Function ODBC_FETCH returns more than one
row
Description: 
ODBC_FETCH is used in multi row queries to fetch one row at a time. In
1.6.0.9 this works correctly.

In 1.6.1.0 it is no longer working correctly. I have also tested the
latest trunk version (Revision: 192632) and the problem is also there.

ODBC_FETCH returns the first row correctly. eg "row1"

However on subsequent requests it returns all previous requested rows and
the current one in a string. eg "row1row2" then "row1row2row3"
====================================================================== 

---------------------------------------------------------------------- 
 (0104386) svnbot (reporter) - 2009-05-07 12:53
 http://bugs.digium.com/view.php?id=15039#c104386 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 193008

_U  branches/1.6.2/
U   branches/1.6.2/funcs/func_odbc.c

------------------------------------------------------------------------
r193008 | tilghman | 2009-05-07 12:53:01 -0500 (Thu, 07 May 2009) | 14
lines

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

........
  r193006 | tilghman | 2009-05-07 12:51:13 -0500 (Thu, 07 May 2009) | 7
lines
  
  Second result should not contain data from the first result.
  (closes issue http://bugs.digium.com/view.php?id=15039)
   Reported by: jims
   Patches: 
         20090506__issue15039.diff.txt uploaded by tilghman (license 14)
   Tested by: jims
........

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

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

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-07 12:53 svnbot         Checkin                                      
2009-05-07 12:53 svnbot         Note Added: 0104386                          
======================================================================