[Mono-bugs] [Bug 326182] New: StoredProcedure parameters getting mixed up.

[bugzilla_noreply at novell.com]

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

           Summary: StoredProcedure parameters getting mixed up.
           Product: Mono: Class Libraries
           Version: 1.2
          Platform: i686
        OS/Version: Windows XP
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Sys.Data.SqlClient
        AssignedTo: mono-bugs at ximian.com
        ReportedBy: gcomeau at hotmail.com
         QAContact: mono-bugs at ximian.com
          Found By: ---


I call a stored procedure with 4 output parameters. The values gets mixed up
with the return value depending on when the RETURN_VALUE is added to the list
of parameters. 

If this bug is not an error on my part, it means that Mono 1.2.5.0 will
sometimes return incorrect results without warning. 


-----
Tried both Mono and MS compilators X Mono and MS runtimes. 
The Mono runtime always breaks. 


-----

Tried on 
Database: MS SqlServer (not sure about the version yet - will find out if
necessary)
C# Client: tried on both WinXP and FC 7 with the same results. 


Attached: 
1. My simple SqlServer stored procedures
2. The c# client code
3. makefile 

--------------------------------------------------
Test output: 

$ make
CYGWIN_NT-5.1 paprika 1.5.11(0.116/4/2) 2004-09-04 23:17 i686 unknown unknown
Cy
gwin
 #######################################################
 *               CSC Compiler, MS Runtime              *
 #######################################################
csc /out:a.exe StoredProcedureTests.cs
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.42
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

/a.exe
 ------------- TEST 0 -------------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 ------------- TEST 1 -------------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 ------------- TEST 2 -------------
 ----------- TEST 0 bis -----------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 #######################################################
 *               Mono Compiler, Mono Runtime           *
 #######################################################
gmcs --version
Mono C# compiler version 1.2.5.0
gmcs /out:b.exe -r:System.Data.dll StoredProcedureTests.cs
mono ./b.exe
 ------------- TEST 0 -------------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 ------------- TEST 1 -------------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [FAIL]      (expected '0', got '102')
@param2 [FAIL]      (expected '102', got '103')
@param3 [FAIL]      (expected '103', got '')
 ------------- TEST 2 -------------
 ----------- TEST 0 bis -----------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 #######################################################
 *               CSC Compiler, Mono Runtime            *
 #######################################################
mono ./a.exe
 ------------- TEST 0 -------------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 ------------- TEST 1 -------------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [FAIL]      (expected '0', got '102')
@param2 [FAIL]      (expected '102', got '103')
@param3 [FAIL]      (expected '103', got '')
 ------------- TEST 2 -------------
 ----------- TEST 0 bis -----------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 #######################################################
 *               Mono Compiler, MS Runtime             *
 #######################################################
/b.exe
 ------------- TEST 0 -------------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 ------------- TEST 1 -------------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]
 ------------- TEST 2 -------------
 ----------- TEST 0 bis -----------
@param1 [OK]
@param0 [OK]
@RETURN_VALUE [OK]
@param2 [OK]
@param3 [OK]

Guillaume Comeau at paprika ~/linuxcvs/delme
$ ssh


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