[freetds] rc3 looks good on OpenVMS

Craig A. Berry craigberry at mac.com
Wed May 27 18:27:07 EDT 2015


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:

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



More information about the FreeTDS mailing list