FreeTDS Development Group

["Castellano, Nicholas" <Nicholas_Castellano AT acml.com>]

The failure of src/dblib/unittests/t0022 is a known issue.  So far, it looks
like Microsoft introduced a bug in SQL Server 7.0 Service Pack 3, and that
the bug was carried forward to SQL Server 2000.

If you set your .freetds.conf to use TDS protocol 4.2 for this connection,
the test should pass.

It may be that there is some server option that controls this behavior, and
the option is not set on my systems.  If anyone is using SQL Server 7.0 SP3
or later, with TDS protocol 7 or higher, and t0022 works for you, *please*
let me know so we can figure out what knob needs to be turned to fix this
problem.

I have attached my testing matrix to show precisely where the "bug" seems to
have been introduced.  Note that in an earlier version I sent a few days
ago, I had SQL 7.0 SP2 + s70888i hotfix marked as a failure case.  Retesting
has shown that it actually passes on this version.  Either my original test
was flawed (or I just recorded the result incorrectly), or something else
more mysterious is going on here.

What was the other test that failed for you besides t0022?

Cheers,
--nick



-----Original Message-----
From: bounce-freetds-145195 AT franklin.oit.unc.edu
[mailto:bounce-freetds-145195 AT franklin.oit.unc.edu] 
Sent: Wednesday, October 16, 2002 9:16 AM
To: TDS Development Group
Subject: [freetds] freetds from cvs on cygwin - make check - 2 test failed


Start
About to logon
About to open
I don't know if this is helpful or not, but 2 off 22 tests failed.  Well,
its good that 20 tests passed!  :-)

Dropping proc
Msg 3701, Level 11, State 5
Server 'DANPC', Line 1
Cannot drop the procedure 't0022', because it does not exist in the system
catal og. creating proc declare @b int exec t0022 @b = @b output

Was expecting a retname to be @b.
FAIL: t0022
====================
2 of 22 tests failed
====================
make[4]: *** [check-TESTS] Error 1
make[4]: Leaving directory `/home/DanielMorgan/freetds/src/dblib/unittests'
make[3]: *** [check-am] Error 2
make[3]: Leaving directory `/home/DanielMorgan/freetds/src/dblib/unittests'
make[2]: *** [check-recursive] Error 1
make[2]: Leaving directory `/home/DanielMorgan/freetds/src/dblib'
make[1]: *** [check-recursive] Error 1
make[1]: Leaving directory `/home/DanielMorgan/freetds/src'
make: *** [check-recursive] Error 1


---
You are currently subscribed to freetds as: [Nicholas_Castellano AT acml.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that for certain accounts we do not accept
orders and/or instructions by e-mail, and for those accounts we will not be
responsible for carrying out such orders and/or instructions. Kindly refrain
from sending orders or instructions by e-mail unless you have confirmed that
we accept such communications for your account. Please also note that to
satisfy regulatory requirements we review the outgoing and incoming e-mail
correspondence of staff members serving certain functions.

Attachment: t0022.csv
Description: Binary data