FreeTDS Development Group

["Pothen, Abi" <APothen AT nb.com>]

James,
 First of all let me thank all of you for your prompt response, great work
and dedication.
 
 Problem is still existing even if I just execute the Case 2 alone.
But the good news is, with data type float as you suggested problem just
vanished.
( with data types numeric and decimal problem exist )
 
Abi.

> >   I would like to provide few more information related to the 
> > following
> > problem.
> >   Problem is existing with freetds.conf option being, "tds 
> > version = 7.0".
> >   With "tds version = 4.2", result set is fine.
> >   
> > >   I am getting inconsistent results for the following sql 
> > statements. I
> > > would really appreciate if someone could help me to resolve 
> > this problem.
> > > 
> > >   I am using FreeTDS ( .53) and DBD Sybase ( 94 ) to 
> > connect to MS SQL 7
> > > and 2000 from a Sun Solaris box.
> > > 
> > > CREATE TABLE test 
> > > (
> > >     row_id         int    NOT NULL,
> > >     amt     decimal(18,4) NULL    
> > > )
> 
> Abi, 
> 
> Thank you for a very clear problem description.  I'm sure the reason no one
> has responded yet is that it's not a known problem, and is going to take
> some work to reproduce and track down.  
> 
> Let's make sure the problem is a function of the data and not the runtime
> order:  If you run Case 2 before Case 1, is Case 2 still mangled and Case 1
> still OK?  
> 
> Maybe with 4.2, the server has to convert the decimal field to foat to send
> it to the client?  I don't think there was a decimal datatype back in the
> 4.2 days.  If you "alter table test alter column amt float null", do you get
> good results with TDS 7.0?  
> 
> Regards, 
> --jkl