Skip to Content.
Sympa Menu

freetds - Re: [freetds] rc3 looks good on OpenVMS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] rc3 looks good on OpenVMS
  • Date: Thu, 28 May 2015 23:16:53 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page