[freetds] [0.95rc2] Preliminary test results

Frediano Ziglio freddy77 at gmail.com
Tue May 12 12:52:54 EDT 2015


2015-05-11 23:45 GMT+01:00 Sergio NNX <sfhacker at hotmail.com>:
>> Hi Sergio,
>>   can you try the new rc version? Should be much better.
>
> Compile-time settings (established with the "configure" script)
>                             Version: freetds v0.95rc2
>              freetds.conf directory: \freetds-0.95rc2\etc
>      MS db-lib source compatibility: no
>         Sybase binary compatibility: no
>                       Thread safety: yes
>                       iconv library: yes
>                         TDS version: 7.0
>                               iODBC: no
>                            unixodbc: yes
>               SSPI "trusted" logins: yes
>                            Kerberos: yes (Heimdal 1.6.99)
>                             OpenSSL: yes (OpenSSL 1.0.2a)
>                              GnuTLS: no
>
> Protocol Version = <whichever is set by 'make check' command>
>
> MS SQL Server version: 2008 (10.0.1600.22)
>
> ===================
> All 4 tests passed (replacements/unittests)
> ===================
>
> ===================
> All 20 tests passed (tds/unittests)
> ===================
>
> ===================
> All 29 tests passed (ctlib/unittests)
> ===================
>
> ====================
> 1 of 35 tests failed (dblib/unittests)
> ====================
>
> Failed tests: rpc
>
> [...]
> retrieving return status...
> 42
> retrieving output parameters...
> param name                  type length  data
> ----  -------------------   ----  ----- ------------------------------
> 1     @null_input             39      3  xml
> 2     @first_type             39      6  bigint
> 3     @nullout                56      0
> 4     @varchar_tds7_out       39   8000  ÷÷÷÷÷÷÷÷÷÷...
> 5     @nvarchar_tds7_out      39   4000  öööööööööö...
> 6     @nrows                  56      4  3
> Good: Got 6 output parameters and 1 return status of 42.
> Expected an empty resultset got 2.
> FAIL rpc.exe (exit status: 1)
>

I start to suspect this (and the other rpc test) could be due to some
changes in the protocol for mssql 2008 r2.
I'll need a dump to confirm it.

> ====================
> 3 of 72 tests failed (odbc/unittests)
> ====================
>
> Failed tests: genparams rpc freeclose
>
> genparams test output
>
> [...]
> DROP TABLE #tmp_insert
> SELECT GETDATE()
> SELECT CONVERT(DATETIME, '2003-07-22 13:02:03')
> CREATE TABLE #tmp_insert (col DATETIME)
> SELECT * FROM #tmp_insert WHERE col = CONVERT(DATETIME, '2015-05-12 13:02:03')
> genparams.c:191 rc=100 SQLFetch
> FAIL genparams.exe (exit status: 1)
>

Believe or not this test for me fails at a specific time near
midday... can you run again (just this test is enough).

> rpc test output
>
> [...]
> done.
> bound data for parameter 1 is 4 bytes: 42.
> bound data for parameter 2 is 3 bytes: 'xml'.
> bound data for parameter 3 is 6 bytes: 'bigint'.
> bound data for parameter 4 is 4 bytes: 6381921.
> bound data for parameter 5 is 4 bytes: 3.
> executing SQLFreeStmt
> 1 errors found in expected row count
> FAIL rpc.exe (exit status: 1)
>
> freeclose test output
>
> [...]
> Error finding last socket opened
> FAIL freeclose.exe (exit status: 1)
>

Can you try the attached version?

Frediano
-------------- next part --------------
A non-text attachment was scrubbed...
Name: freeclose.c
Type: text/x-csrc
Size: 11397 bytes
Desc: not available
URL: <http://lists.ibiblio.org/pipermail/freetds/attachments/20150512/f5f24228/attachment-0001.bin>


More information about the FreeTDS mailing list