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: "Pothen, Abi" <APothen AT nb.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Inconsistent results - FreeTDS ( .53) and DBD S-- ybase ( 94 )
  • Date: Thu, 25 Apr 2002 10:29:40 -0400


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
> >




Archive powered by MHonArc 2.6.24.

Top of Page