[asterisk-bugs] [Asterisk 0012069]: func_odbc does not use readhandle for readsql

[noreply at bugs.digium.com]

The following issue has been CLOSED 
====================================================================== 
http://bugs.digium.com/view.php?id=12069 
====================================================================== 
Reported By:                kactus
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   12069
Category:                   Functions/func_odbc
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Asterisk Version:           1.6.0-beta1 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             02-25-2008 23:15 CST
Last Modified:              02-27-2008 09:35 CST
====================================================================== 
Summary:                    func_odbc does not use readhandle for readsql
Description: 
Hi

When using func_odbc in format

[FUNCTION]
readhandle=database
readsql= select a from b

readsql will never execute unless a writehandle is set with the dns name.
This also occurs whether or not dns=database is set as well.

in the source you can see that stmt is initialised to null at line 254 in
func_odbc.c (function acf_odbc_read) and is only then set on line 313 when
writehandle is being tested.

stmt is then tested on line 319  and if a valid writehandle has not been
found it throw an error and exits the function.

====================================================================== 

---------------------------------------------------------------------- 
 Corydon76 - 02-27-08 09:35  
---------------------------------------------------------------------- 
Betas don't change; but it was fixed in SVN.  Please try the latest SVN
before reopening a bug that was fixed. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
02-27-08 09:35  Corydon76      Note Added: 0083027                          
02-27-08 09:35  Corydon76      Status                   assigned => closed  
02-27-08 09:35  Corydon76      Resolution               reopened => fixed   
======================================================================