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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +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 _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
