[freetds] freebcp from 0.64 segfaults on image fields

Constantin Vasilyev vasilyev at ncbi.nlm.nih.gov
Thu Aug 10 15:42:11 EDT 2006

Hi All,

I noticed that attempt to bcp out a table with image column containing
data >129bytes long causing freebcp's segfault:

bash-2.05b$ uname -smr
Linux 2.4.23-P4-4G i686
bash-2.05b$ sqsh -S MSSQL0 -D testdb
[101] MSSQL0.testdb.1> create table img(id int identity, data image)
[101] MSSQL0.testdb.2> insert img (data) select replicate ('a',130)
[101] MSSQL0.testdb.3> go
bash-2.05b$ freebcp testdb.dbo.img out /tmp/foo.bcp -c -S MSSQL0 -U ... -P ...

Starting copy...

Segmentation fault

Image fields of smaller size (129 bytes and less) work fine.

In native mode (-n option), freebcp gives error:

Msg 20053, Level 4
Requested data conversion does not exist

and produced data file doesn't seem to be right:

bash-2.05b$ od -h /tmp/foo.bcp
0000000 ffff ffff

Any idea what could be wrong?

Thanks in advance for looking into that,

Constantin Vasilyev
NCBI Contractor, DBA

More information about the FreeTDS mailing list