FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

Il 28/Mag/2015 09:58, "Craig A. Berry" <craigberry AT mac.com> ha scritto:
>
> Everything builds cleanly and I'm getting all tests passing when I test
against Microsoft SQL 2008 R2.  With SQL 2012 this test below fails, but I
think it's just because "compute" has been removed in SQL 2012:
>

I was just going to ask you if you could test VMs. Good!
Yes, that test check how compute queries reply so cannot work but is not a
Freetds issue

> SQL text will be read from ../../../src/dblib/unittests/t0023.sql
> Starting dsa0:[craig.freetds-0^.95rc3.src.dblib.unittests]t0023.exe
> About to logon
> About to open
> creating table
>          1: create table #dblib0023 (col1 int not null,  col2 char(1) not
null, col3 datetime not null)
> insert
>          1: insert into #dblib0023 values (1, 'A', 'Jan  1 2002
10:00:00AM')
>          1: insert into #dblib0023 values (2, 'A', 'Jan  2 2002
10:00:00AM')
>          1: insert into #dblib0023 values (3, 'A', 'Jan  3 2002
10:00:00AM')
>          1: insert into #dblib0023 values (8, 'B', 'Jan  4 2002
10:00:00AM')
>          1: insert into #dblib0023 values (9, 'B', 'Jan  5 2002
10:00:00AM')
> select
>          1: select col1, col2, col3 from #dblib0023 order by col2 compute
sum(col1) by col2 compute max(col3)
> Msg 156, Level 15, State 1
> Server 'ABC0012312'
> , Line 1
>
> Incorrect syntax near the keyword 'compute'.
> exit: no unanticipated messages allowed in unit tests
>

Frediano