Skip to Content.
Sympa Menu

freetds - [freetds] freebcp from 0.64 segfaults on image fields

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Constantin Vasilyev <vasilyev AT ncbi.nlm.nih.gov>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] freebcp from 0.64 segfaults on image fields
  • Date: Thu, 10 Aug 2006 15:42:11 -0400 (EDT)

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
0000004

Any idea what could be wrong?


Thanks in advance for looking into that,

Constantin Vasilyev
NCBI Contractor, DBA





Archive powered by MHonArc 2.6.24.

Top of Page