[Mono-bugs] [Bug 364432] New: ODBC: Parameter with DbType.Time and value DBNull. Value produces invalid SQL statement

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Sun Feb 24 12:00:38 EST 2008


           Summary: ODBC: Parameter with DbType.Time and value DBNull.Value
                    produces invalid SQL statement
           Product: Mono: Class Libraries
           Version: 1.2.6
          Platform: i686
        OS/Version: Windows XP
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Sys.Data
        AssignedTo: bnc-blr-team-mono at forge.provo.novell.com
        ReportedBy: mjscod at gmx.de
         QAContact: mono-bugs at lists.ximian.com
          Found By: Customer

SQL Statements with parameters of type DbType.Time produces an invalid

1. Create an OdbcCommand with CommandTexdt set to "INSERT INTO tbl (col1)
2. Add a parameter with type DbType.Time, set the value to DBNull.Valjue
3. Execute it (ExecuteNonQuery)

This seems to produce a statement like "INSERT INTO tbl (col1) VALUES ()" and
therefore fails.

I use Sybase SQL Anywhere 10 + all bug fixes.


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

More information about the mono-bugs mailing list