[freetds] Empty string in varcharmax column in ODBC mode

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Thu Jan 4 05:47:35 EST 2007


> 
> I think I have stumbled upon a bug in the ODBC implementation of
> FreeTDS.
> 
>  

Which version are you using?
Which protocol version are you using?

> 
> If you run the following query in ODBC mode against a SQL SERVER 2005,
> the query fails to finish.
> 
> 

Core dump, hang or error?
 
> 
> Select ISNULL(D.Description,'') AS Description from some_table
> 

Description is a varchar field? Is it nullable?

>  
> 
> If the column D.Description is a varcharmax, the query does 
> not finish.

What's varcharmax?

> Here's the kicker, it only fails about 50% of the time.
> 
>  
> 
> Note: this works fine in db-lib mode.
> 
>  
> 
> Thanks.
> 

bye
  freddy77



More information about the FreeTDS mailing list