[Mono-bugs] [Bug 656831] New: OdbcCommand.ExecSQL mishandles SQL_NO_DATA

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=656831

https://bugzilla.novell.com/show_bug.cgi?id=656831#c0


           Summary: OdbcCommand.ExecSQL mishandles SQL_NO_DATA
    Classification: Mono
           Product: Mono: Class Libraries
           Version: SVN
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: Normal
          Priority: P5 - None
         Component: Sys.Data
        AssignedTo: mono-bugs at lists.ximian.com
        ReportedBy: Richard.Kettlewell at thales-esecurity.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---
           Blocker: ---


Created an attachment (id=402927)
 --> (http://bugzilla.novell.com/attachment.cgi?id=402927)
Patch to detect SQL_NO_DATA consistently.

User-Agent:       Mozilla/5.0 (X11; U; Linux x86_64; en-US) AppleWebKit/534.7
(KHTML, like Gecko) Chrome/7.0.517.44 Safari/534.7

OdbcCommand.ExecSQL detects SQL_NO_DATA in the case when there are no
parameters and treats it as success.  However when there are parameters, it
neglects this check and therefore throws an exception.

Reproducible: Always

Steps to Reproduce:
1. Create an empty table.
2. Make a *parameterized* query that tries to delete rows from it.
3. Execute the query with ExecuteNonQuery().
Actual Results:  
An exception is thrown.

Expected Results:  
ExecuteNonQuery() returns 0.

-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
You are the assignee for the bug.