FreeTDS Development Group

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

> From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
> Sent: August 30, 2002 10:46 AM
>
> char use same function of varchar/text... quite strange

I might have overlooked something. 

> > real, float fair    No numeric, image, integers; maybe money.  
> 
> Added integers and fixed money

        :)

> > money               wrong   float & real yield -283649471676416.
> 
> Fixed

Cool.  I'm sorry my 32-bit-only test platform caused the problem.  I agree
it's an awkward fix, but at least it works for now.  

> > smallmoney  odd     201203.04 -> real yields 201203.046875 

money->real adds precision, granted.  But we shouldn't be tacking on the
extra 0.006875.  That's an error; we should be within 10^-8 or so.  May the
problem is actually in the test program/platform, but it bears
investigation.  

> > numeric             broken  char/varchar only. 
> > decimal             broken  char/varchar, float/real only.
> > timestamp   broken  char/varchar only. 
> 
> willconvert should return false for many types...

Is it returning True for any types that Sybase returns False for?
dbwillconvert() expresses our goal, not our status.  It seemed to me like
too much trouble to keep it synchronized with our status.  

> > image,varbinary     broken  char, text, binary only.  
> > 
> 
> Do you take in account that many test fail for 
> overflow/underflow reason ?

No, not in convert_acid.  In my report I did, though, which is why I didn't
mention tinyint problems, for example.  

> > == conclusions ==
> > 
> > 0.  Everything can be made into a char/varchar!
> > 1.  Money needs attention.  Should convert to int, should correctly
> > convert to floating point.  This is just a debugging effort; 
> > the code is
> > there.  
> 
> Fixed. See other mail for money.

Wonderful!
 
> > 2.  What happened to float -> int? 
> 
> Added.

Yeah!

> So we are ready for a pre-release ?

Yes!  I do think we should look into smallmoney->real, though.  

I'll set one up tonight if I can.  

I have some UG work to do, planning on using the weekend for it.  This
coming Mondy is Labor Day here in the USA, a holiday.  I should be done by
Tuesday.  

Awesome work, Frediano!

Regards, 

--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 for certain accounts we do not accept
orders and/or instructions by e-mail, and for those accounts we will not be
responsible for carrying out such orders and/or instructions. Kindly refrain
from sending orders or instructions by e-mail unless you have confirmed that
we accept such communications for your account. Please also note that to
satisfy regulatory requirements we review the outgoing and incoming e-mail
correspondence of staff members serving certain functions.