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

[bugzilla_noreply at novell.com]

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


           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
statement.

1. Create an OdbcCommand with CommandTexdt set to "INSERT INTO tbl (col1)
VALUES (?)"
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.

Regards,
Mark


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