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

Mon Feb 28 03:34:17 CST 2011

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18815 
====================================================================== 
Reported By:                irroot
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   18815
Category:                   Functions/func_odbc
Reproducibility:            always
Severity:                   tweak
Priority:                   normal
Status:                     closed
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:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2011-02-15 09:04 CST
Last Modified:              2011-02-28 03:34 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 ...
====================================================================== 

---------------------------------------------------------------------- 
 (0132430) svnbot (reporter) - 2011-02-28 03:34
 https://issues.asterisk.org/view.php?id=18815#c132430 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 308992

_U  trunk/
U   trunk/funcs/func_odbc.c

------------------------------------------------------------------------
r308992 | tilghman | 2011-02-28 03:34:16 -0600 (Mon, 28 Feb 2011) | 21
lines

Merged revisions 308991 via svnmerge from 
https://origsvn.digium.com/svn/asterisk/branches/1.8

................
  r308991 | tilghman | 2011-02-28 03:33:22 -0600 (Mon, 28 Feb 2011) | 14
lines

  Merged revisions 308990 via svnmerge from 
  https://origsvn.digium.com/svn/asterisk/branches/1.6.2

  ........
    r308990 | tilghman | 2011-02-28 03:32:22 -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=308992 

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