[asterisk-bugs] [Asterisk 0018815]: [patch] func_odbc insertsql option may not work on SQL_NODATA

Mon Feb 28 03:32:24 CST 2011

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18815 
====================================================================== 
Reported By:                irroot
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18815
Category:                   Functions/func_odbc
Reproducibility:            always
Severity:                   tweak
Priority:                   normal
Status:                     ready for review
Asterisk Version:           1.6.2.17-rc2 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2011-02-15 09:04 CST
Last Modified:              2011-02-28 03:32 CST
====================================================================== 
Summary:                    [patch] func_odbc insertsql option may not work on
SQL_NODATA
Description: 
Figgured out why when UPDATE returned 0 Rows func_odbc saw this as a
failure
and returned no stmt

find a small patch attached to rectify this ...

SQL_NODATA was not taken into account as a valid return for SQLExecDirect
...

======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
related to          0018795 [patch] func_odbc insertsql option may ...
====================================================================== 

---------------------------------------------------------------------- 
 (0132428) svnbot (reporter) - 2011-02-28 03:32
 https://issues.asterisk.org/view.php?id=18815#c132428 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 308990

U   branches/1.6.2/funcs/func_odbc.c

------------------------------------------------------------------------
r308990 | tilghman | 2011-02-28 03:32:24 -0600 (Mon, 28 Feb 2011) | 7
lines

Statements updating zero rows may return SQL_NO_DATA.  This is fine; it's
handled.

(closes issue https://issues.asterisk.org/view.php?id=18815)
 Reported by: irroot
 Patches: 
       func_odbc.insert_nodata.patch uploaded by irroot (license 52)

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

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

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-02-28 03:32 svnbot         Checkin                                      
2011-02-28 03:32 svnbot         Note Added: 0132428                          
======================================================================