[Mono-bugs] [Bug 69110][Blo] Changed - DataSet doesnt contain some rows returned by query

[bugzilla-daemon@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 dobos_s@ibcnet.hu.

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

--- shadow/69110	2004-11-04 17:17:16.000000000 -0500
+++ shadow/69110.tmp.31892	2004-11-04 17:32:14.000000000 -0500
@@ -2,13 +2,13 @@
 Product: Mono: Class Libraries
 Version: 1.0
 OS: GNU/Linux [Other]
 OS Details: Slackware 9.1/2.4.22
 Status: NEW   
 Resolution: 
-Severity: 
+Severity: Unknown
 Priority: Blocker
 Component: Sys.Data
 AssignedTo: mono-bugs@ximian.com                            
 ReportedBy: dobos_s@ibcnet.hu               
 QAContact: mono-bugs@ximian.com
 TargetMilestone: ---
@@ -112,6 +112,56 @@
 Additional Information:
 This happens with mono-1.0.2,4
 Running mono with trace it seems, that LoadDataRow method
 doesnt care that the result has joined tables. It finds out that
 the returned column is a primary key and recognizes, that the current 
 returned key already present in processed data, so it drops it.
+
+------- Additional Comments From dobos_s@ibcnet.hu  2004-11-04 17:32 -------
+Compare difference between dataset schema of MS and mono runs:
+
+MS:
+<?xml version="1.0" encoding="ibm852"?>
+<xs:schema id="NewDataSet" xmlns="" 
+xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-
+microsoft-com:xml-msdata">
+  <xs:element name="NewDataSet" msdata:IsDataSet="true" 
+msdata:Locale="hu-HU">
+    <xs:complexType>
+      <xs:choice maxOccurs="unbounded">
+        <xs:element name="Table">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="id" type="xs:long" minOccurs="0" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+      </xs:choice>
+    </xs:complexType>
+  </xs:element>
+</xs:schema>
+
+mono:
+<?xml version="1.0" encoding="us-ascii"?>
+<xs:schema xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" 
+id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema">
+  <xs:element name="NewDataSet" msdata:IsDataSet="true" 
+msdata:Locale="">
+    <xs:complexType>
+      <xs:choice maxOccurs="unbounded">
+        <xs:element name="Table">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element minOccurs="0" name="id" type="xs:long" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+      </xs:choice>
+    </xs:complexType>
+    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
+      <xs:selector xpath=".//Table" />
+      <xs:field xpath="id" />
+    </xs:unique>
+  </xs:element>
+</xs:schema>
+
+Mono reports and handles Constraint1, but I think he shouldnt.