FreeTDS Development Group

["Wood, David" <David.Wood AT deshaw.com>]

Hello,

I have a strange problem best explained by example:

sqsh compiled against FreeTDS (broken - marked with "^^^^"):
------------------------------------------------------------
1> select asset_id, isin_nm, cusip from asset where
asset_id=0x00038602ab1a93a5
2> go
 asset_id             isin_nm              cusip
 -------------------- -------------------- ---------
 0x00038602ab1a93a50800 US68572YAA82         68572YAA8
                   ^^^^              

(1 row affected)

1> select asset_id from asset where asset_id=0x00038602ab1a93a5
2> go
 asset_id
 --------------------
   0x00038602ab1a93a5

(1 row affected)

====

tsql (no problem):
------------------
1> select asset_id, isin_nm, cusip from asset where
asset_id=0x00038602ab1a93a5
2> go
asset_id        isin_nm cusip
00038602ab1a93a5        US68572YAA82    68572YAA8

1> select asset_id from asset where asset_id=0x00038602ab1a93a5
2> go
asset_id
00038602ab1a93a5
1>

====

sqsh compiled against Sybase SDK v15 (no problem):
--------------------------------------------------
1> select asset_id, isin_nm, cusip from asset where
asset_id=0x00038602ab1a93a5
2> go
 asset_id             isin_nm              cusip
 -------------------- -------------------- ---------
   0x00038602ab1a93a5 US68572YAA82         68572YAA8

(1 row affected)

1> select asset_id from asset where asset_id=0x00038602ab1a93a5
2> go
 asset_id
 --------------------
   0x00038602ab1a93a5

(1 row affected)

====

1> sp__help asset
2> go
 ...
 Column name          Type          I Null Dflt Rule Table
Num
 -------------------- ------------- - ---- ---- ----
-------------------- ---
 asset_id             binary(8   )  0 No             asset
1
 ...
 cusip                char(9   )    0 Yes            asset
35
 ...
 isin_nm              varchar(20  ) 0 Yes            asset
87
 ...

ASE version: 12.5.2 Solaris Sparc
sqsh version: 2.1.4 (Solaris Sparc, Solaris x86, Linux all behave the
same way)
FreeTDS version: 0.64 (plus a couple of patches from the repository)

% tsql -C
Compile-time settings (established with the "configure" script):
                           Version: freetds v0.64
    MS db-lib source compatibility: no
       Sybase binary compatibility: unknown
                     Thread safety: yes
                     iconv library: yes
                       TDS version: 5.0
                             iODBC: no
                          unixodbc: yes

Any ideas?  David