[Mono-bugs] [Bug 78830][Cri] New - DataSet dont works correctly with ForeignKey

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by carsten.jendro at gmx.net.

http://bugzilla.ximian.com/show_bug.cgi?id=78830

--- shadow/78830	2006-07-12 06:38:19.000000000 -0400
+++ shadow/78830.tmp.22543	2006-07-12 06:38:19.000000000 -0400
@@ -0,0 +1,57 @@
+Bug#: 78830
+Product: Mono: Class Libraries
+Version: 1.1
+OS: All
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 016 Two days
+Priority: Critical
+Component: Sys.Data
+AssignedTo: tsenganal at novell.com                            
+ReportedBy: carsten.jendro at gmx.net               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: DataSet dont works correctly with ForeignKey 
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+
+I use a typed dataset with a lot of foreign key contraints, i also have
+foreign key constraints to columns in the same table, i load the dataset
+from mysql into memory, make changes and write changes back via dataadapter.
+
+After some changes i got a lot of different errors that looks like
+inkonsistency inside the dataset (false fk constraint exceptions, it tryes
+to insert already existing rows to the database. before Mono 1.1.15 i got
+very often Stack Overflow Exceptions inside the DataSet, these errors seems
+to be fixed since 1.1.15)
+
+I tested all mono version from 1.1.12.1 to 1.1.16. 
+
+i dont use dataset.EnforceConstrints = false at any time. (this function is
+also buggy, in all versions, including 1.1.15 / 1.1.16)
+
+
+Steps to reproduce the problem:
+
+I have muttiple Datasets with different tables and different FK
+constraints, errors occures in all these datasets.
+
+create a random one with visual studio, 3 tables with foreign key to other
+tables and own table should be enought.
+
+read tables from database, insert some new lines, update database, repeat
+this for a while and errors will occure.
+
+
+How often does this happen? 
+
+normally after 5 to 15 updates on different tables
+
+Additional Information:
+
+I use MySqlConnector.Net 1.0.7