FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il gio, 2002-12-12 alle 21:33, Lowden, James K ha scritto:
> I think we have  a problem with computed rows in ct-lib and TDS 8.0.  
> 
> t0009.c creates a table:
> 
>       CREATE TABLE #ctlib0009 
>       (  col1 int not null
>       ,  col2 char(1) not null
>       ,  col3 datetime not null
>       )
> 
> inserts some data, and issues a query:
> 
>       select  col1, col2, col3 
>       from    #ctlib0009 
>       order by  col2
>       compute sum(col1) by col2
>       compute max(col3)
> 
> I get garbage for the value of "compute max(col3)".  You might want to check
> yours *before* updating from cvs, in case I broke something.  
> 

Fixed in CVS... tds_alloc_compute_result did not reserve space for
nullable bits...

freddy77