FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
> Sent: November 7, 2002 7:43 AM
> 
> Trying to use following query using tsql:
> 
> 1> select degrees(-0.4)
> 2> go
>       
> 166153499493666223.069050350390476800 
> 1> select exp(-0.4)
> 2> go
> Msg 20019, Level 7, State 0, Server OpenClient, Line 1
> Attempt to initiate a new SQL Server operation with results pending.
> tds_submit_query() failed
> 1> bye

Reproduced.  It is a problem with our TDS version 5.0 implementation.  

$ tsql -S stpmdb -U U -P P
1> select @@version
2> go

Adaptive Server Enterprise/11.5.1.1/P/Digital UNIX/4.0/SWR 8710 ESD
4/OPT/Wed Dec  1 14:56:46 PST 1999
1> version
using TDS version 5.0
1> select degrees(-0.4)
2> go

270831807719185897.814343581861679109

        
        But with the same client and server:

$ TDSVER=4.2 tsql -S stpmdb -U U -P P
1> select degrees(-0.4)
2> go

-22.9183118052329
1> select @@version
2> go

Adaptive Server Enterprise/11.5.1.1/P/Digital UNIX/4.0/SWR 8710 ESD
4/OPT/Wed Dec  1 14:56:46 PST 1999

Also works fine with TDS 7 or 8.  

--jkl


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 we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.