[Mono-bugs] [Bug 419316] New: SourceColumnNullMapping property of DbParameter Ignored in DbDataAdapter. Update

[bugzilla_noreply at novell.com]

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


           Summary: SourceColumnNullMapping property of DbParameter Ignored
                    in DbDataAdapter.Update
           Product: Mono: Class Libraries
           Version: 1.9
          Platform: x86
        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: robert_hood at admworld.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: Development


Description of Problem:
The SourceColumnNullMapping property appears to be ignored in the
DbDataAdapter.Update method.  in .NET, if the source column value is null, the
parameter value becomes 0.  If the source column value is not null, the
parameter value becomes 1.

Steps to reproduce the problem:
1. Use the MySql 5.2.2 Designer in Visual Studio to create a typed data set
2. One column in the resulting table must be nullable.
3. The MySql designer sets the SourceColumnNullMapping property for internal
use
4. Verify that a parameter on the UpdateCommand of the typed data adapter has
the SourceColumnNullMapping property set to True
4. Fill the data set
5. Make a change to a field.  Ensure that there is a value in one of the
nullable fields
6. Create an instance of the typed data adapter.
7. Call .Update on the typed data adapter
8. Exception is thrown


Actual Results:
System.FormatException is thrown from the MySql Data providers when it attempts
to convert the column's actual value to an int32.  

Expected Results:
After DbDataAdapter finds its source column and sets the parameter value, it
should check the parameter SourceColumnNullMapping property, and based on that
change the parameter value to 1 or 0 accordingly.

How often does this happen? 
Every time Update is called

Additional Information:


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