[Mono-bugs] [Bug 75420][Nor] New - Bytes swapped when inserting Guid in a table

[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 dezelin at gmail.com.

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

--- shadow/75420	2005-06-29 10:34:06.000000000 -0400
+++ shadow/75420.tmp.24058	2005-06-29 10:34:06.000000000 -0400
@@ -0,0 +1,53 @@
+Bug#: 75420
+Product: Mono: Class Libraries
+Version: 1.1
+OS: 
+OS Details: Ubuntu Linux 5.04 x86
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: Sys.Data.SqlClient
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: dezelin at gmail.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Bytes swapped when inserting Guid in a table
+
+Description of Problem:
+
+When trying to insert a new row in an MS SQL database table with a Guid
+column, first 3 Guid elements are byte-swapped.
+
+Example:
+
+1. Create a table (Table1) with a Guid column (Id)
+2. Try to run a simple insert query from a Mono application: 
+
+INSERT INTO Table1 (Id) VALUES (0x03145b8a2fe248d7833599e18cbf43f8)
+
+3. Check newly inserted row with Enterprise Manager. You will see that this
+Guid is inserted:
+
+8A5B1403-E22F-D748-8335-99E18CBF43F8
+
+Actual Results:
+8A5B1403-E22F-D748-8335-99E18CBF43F8
+
+
+Expected Results:
+03145b8a-2fe2-48d7-8335-99e18cbf43f8
+
+How often does this happen? 
+Always
+
+Additional Information:
+The same thing is happening when you use Enterpise Manager to run this
+query. So I think it's maybe a MS SQL server bug. Do you want me to provide
+a workaround for this bug (Guid should be sent in form of
+{03145b8a-2fe2-48d7-8335-99e18cbf43f8} so it's only 4 characters per Guid more)
+
+Cheers,
+Aleksandar Dezelin