FreeTDS Development Group

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

Hi all, sorry I've been lax about testing the latest versions.  I just
downloaded the latest from CVS and ran a few of my test programs against
it.  The results were:

1) TEXT gets truncated by 1 character (see previous thread and message)
2) NUMERIC seems broken again for me

I do a CREATE, INSERT, and SELECT * to/from a table that looks like:

CREATE TABLE dbo.dbaccesstests (
        test_id         int IDENTITY NOT NULL,
        intfield        int NOT NULL,
        charfield       varchar(50) NOT NULL,
        numfield        numeric(10,0) NOT NULL,
        floatfield      float NOT NULL,
        realfield       real NOT NULL,
        datefield       datetime NOT NULL,
        textfield       text NOT NULL,
        intfield2   int NOT NULL,
        )

Using my current production version of FreeTDS which is a CVS snapshot
from 2002-04-06, I get (columns separated by " | "):

1 | 20 | butter? | 123 | 3.1415 | 2.77699995040894 | 2000-01-25 18:00:00
| some text | 99

Using today's CVS snapshot, I get:

1 | 20 | butter? | -8863084066665136128 | 3.1415 | 2.77699995040894 |
2000-01-25 18:00:00 | some tex | 99

The TEXT field fix is described above.  The NUMERIC field fix I'm not
sure about.  I looked quickly at the diff between the two versions and
there's lots of work on NUMERIC and nothing was immediately obvious.
Anyone else able to reproduce this or have ideas what could be wrong?

I'd hope these two guys could be resolved before 0.60.

Thanks,
Eric


> -----Original Message-----
> From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> Sent: Monday, July 08, 2002 12:28 PM
> To: TDS Development Group
> Subject: [freetds] pre2?
> 
> Brian,
> 
> I think we're about done adding patches for 0.60, and except for the
TEXT
> truncation under 7.0, I think we're feature-complete.  I'm planning on
> scribbling in the UG this week; should be ready by the weekend.  How
do
> things look to you?
> 
> --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