FreeTDS Development Group

["Eric Deutsch" <edeutsch AT systemsbiology.org>]

Hi, I can confirm that I see the same erroneous behavior using Linux to
SQL Server 2000 with both Perl and SQSH.

Eric


> From: Pothen, Abi [mailto:APothen AT nb.com]
> 
> Hi,
> 
>   Since I don't have SQSH, I tried unixODBC's isql and the problem is
> still existing. Also I tried numeric(10,4) and that didn't help
either.
> 
> Thanks,
> Abi.
> 
> > Hi,
> >
> > I don't have time at the moment to look at this but I will as soon
as I
> > do.  In the meantime, two questions.
> >
> > Have you tried running the select under SQSH to see if it is perl
> > specific?
> >
> > and, if you decrease the size of the numeric to say, (10,4) do you
still
> > get the problem?  That is, is it specific to large numerics?
> >
> > Brian
> >
> > On Wed, 24 Apr 2002, Pothen, Abi wrote:
> >
> > > 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
> > >
> 
> ---
> You are currently subscribed to freetds as:
[edeutsch AT systemsbiology.org]
> To unsubscribe, forward this message to leave-freetds-
> 127899P AT franklin.oit.unc.edu