Re: rc3 looks good on OpenVMS

Frediano Ziglio <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAHt6W4dtJMw1iJLVAtBE=SXro73sJC9UxHnYyeeGa1BV_7JXXw@mail.gmail.com>
Il 28/Mag/2015 09:58, "Craig A. Berry" <[email protected]> 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
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.