Skip to Content.
Sympa Menu

freetds - Re: Inconsistent results - FreeTDS ( .53) and DBD S-- ybase ( 94 )

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Eric Deutsch" <edeutsch AT systemsbiology.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Inconsistent results - FreeTDS ( .53) and DBD S-- ybase ( 94 )
  • Date: Thu, 25 Apr 2002 13:06:43 -0700



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




Archive powered by MHonArc 2.6.24.

Top of Page