FreeTDS Development Group

[Ben Gribaudo <me AT bengribaudo.com>]

Hi,

I am working on verifying that FreeTDS works as it should on a Debian 
3.1 box. Would any of you be able to help me understand the output of 
make check that's attached?

Lines 9-27, et all: Are the "error" outputs expected? Line 43 tells me 
all tests pass but the lines with "error" make me wonder.
Lines 50-75: Line 75 says they pass but the server error messages above 
that line make me wonder. Are those the expected output?
Lines 90-110, 162-167, 432, et al: Should the library errors be occurring?
Lines 125-147, et al: Are these cannot drop table complaints normal?
Lines 151-159, et al: "CS_CMD_FAIL" concerns me. Is that expected?
Lines 359-365, 393-396: Again, are these normal or erroneous?
Lines 456-460: Why does this test pass if there is a problem? Or is that 
considered not a failure but just a warning?

Thank you,
Ben

Making check in include
[snip]
t0006.c: Test SYBREAL, SYBFLT8 values
PASS: t0006
some checks...
1234
123
-1234
error
overflow checks...
2147483647
error
-2147483648
error
32767
error
-32768
error
255
error
0
error
overflow on big number checks...
error
error
error
error
12
unique type...
12345678-1234-1234-9876543298765432
12345678-1234-1E34-9876AB3298765432
error
error
error
12345678-1234-A234-9876543298765432
error
error
binary test...
len=2 12 34
[snip]
PASS: utf8_2
===================
All 13 tests passed
===================
make[4]: Leaving directory `/usr/src/freetds/freetds-0.63/src/tds/unittests'
[sni]
PASS: ct_options
lang_ct_param.c: submit language query with variables using ct_param

Server message:
Message number: 3701, Severity 11, State 5, Line 1
Server 'SERVER'
Message String: Cannot drop the table '#ctparam_lang', because it does not 
exist in the system catalog.
ct_results() result_type CS_CMD_FAIL.

Server message:
Message number: 170, Severity 15, State 1, Line 1
Server 'SERVER'
Message String: Line 1: Incorrect syntax near ')'.

Server message:
Message number: 137, Severity 15, State 2, Line 1
Server 'SERVER'
Message String: Must declare the variable '@in1'.

Server message:
Message number: 170, Severity 15, State 1, Line 1
Server 'SERVER'
Message String: Line 1: Incorrect syntax near ')'.

Server message:
Message number: 137, Severity 15, State 2, Line 1
Server 'SERVER'
Message String: Must declare the variable '@in1'.
PASS: lang_ct_param
array_bind.c: Retrieve data using array binding
ct_results() result_type CS_CMD_FAIL.
ct_fetch returned 2 rows
col1 = 1 col2= 'AAAA', col3 = 'Jan  1 2002 10:00AM'
col1 = 2 col2= 'BBBB', col3 = 'Jan  2 2002 10:00AM'
ct_fetch returned 2 rows
col1 = 3 col2= 'CCCC', col3 = 'Jan  3 2002 10:00AM'
col1 = 8 col2= 'DDDD', col3 = 'Jan  4 2002 10:00AM'
ct_fetch returned 1 rows
col1 = 9 col2= 'EEEE', col3 = 'Jan  5 2002 10:00AM'
PASS: array_bind
cs_diag.c: Testing context callbacks
Trying clientmsg_cb with context

CS-Library Message:
number 33816852 layer 2 origin 4 severity 1 number 20
msgstring: cs_convert: cslib user api layer: common library error: The 
conversion/operation resulted in overflow.
osstring: (null)

CS-Library Message:
number 33620240 layer 2 origin 1 severity 1 number 16
msgstring: cs_convert: cslib user api layer: external error: Conversion 
between 56 and 61 datatypes is not supported.
osstring: (null)
PASS: cs_diag
[snip]
PASS: rpc_ct_setparam
ct_diagclient.c: Retrieve data using array binding
Maximum message limit is set to: 1
ct_results() result_type CS_CMD_FAIL.
Number of client messages returned: 1

Open Client Message:
number 16843145 layer 1 origin 1 severity 1 number 137
msgstring: ct_bind: user api layer: external error: A bind count of 4 is not 
consistent with the count supplied for existing binds. The current bind count 
is 2.
osstring: (null)
ct_fetch returned 2 rows
col1 = 1 col2= 'AAAA'
col1 = 2 col2= 'BBBB'
PASS: ct_diagclient
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
Maximum message limit is set to 4.
Number of messages returned: 4

Server Message:
number 3701 severity 11 state 5 line 1
server: SERVER
proc: (null)
text: Cannot drop the table '#ctlibarray1', because it does not exist in the 
system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: SERVER
proc: (null)
text: Cannot drop the table '#ctlibarray2', because it does not exist in the 
system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: SERVER
proc: (null)
text: Cannot drop the table '#ctlibarray3', because it does not exist in the 
system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: SERVER
proc: (null)
text: Cannot drop the table '#ctlibarray4', because it does not exist in the 
system catalog.
PASS: ct_diagserver
ct_diagall.c: Retrieve data using array binding
Maximum message limit is set to: 5
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_fetch returned 2 rows
col1 = 1 col2= 'AAAA'
col1 = 2 col2= 'BBBB'
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
Total number of client/server messages = 5
Number of client messages returned: 1

Open Client Message:
number 16843145 layer 1 origin 1 severity 1 number 137
msgstring: ct_bind: user api layer: external error: A bind count of 4 is not 
consistent with the count supplied for existing binds. The current bind count 
is 2.
osstring: (null)
Number of server messages returned: 4

Server Message:
number 3701 severity 11 state 5 line 1
server: SERVER
proc: (null)
text: Cannot drop the table '#ctlibarray1', because it does not exist in the 
system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: SERVER
proc: (null)
text: Cannot drop the table '#ctlibarray2', because it does not exist in the 
system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: SERVER
proc: (null)
text: Cannot drop the table '#ctlibarray3', because it does not exist in the 
system catalog.

Server Message:
number 3701 severity 11 state 5 line 1
server: SERVER
proc: (null)
text: Cannot drop the table '#ctlibarray4', because it does not exist in the 
system catalog.
PASS: ct_diagall
Trying cs_config with CS_USERDATA

Testing CS_SET/GET USERDATA with char array
Testing CS_SET/GET USERDATA with char array
Testing CS_SET/GET USERDATA with int
PASS: cs_config
PASS: cancel
blk_in.c: Retrieve data using array binding
Sending same row 10 times...
10 rows copied.
done
PASS: blk_in
blk_out.c: Retrieve data using array binding
ct_results() result_type CS_CMD_FAIL.
retrieved 1 (4,0) AAAA (5,0) Jan  1 2002 10:00AM (20,0)
retrieved 2 (4,0) BBBB (5,0) Jan  2 2002 10:00AM (20,0)
retrieved 3 (4,0) CCCC (5,0) Jan  3 2002 10:00AM (20,0)
retrieved 8 (4,0) DDDD (5,0) Jan  4 2002 10:00AM (20,0)
retrieved 3 (0,-1) EEEE (5,0) Jan  5 2002 10:00AM (20,0)
PASS: blk_out
ct_cursor.c: Testing ct_cursor()
Trying login
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
Trying declare, rows , open in one SEND

col1
------

AAA

BBB

CCC

Trying declare, rows, open one at a time

col1
------

AAA

BBB

CCC

Running normal select command after cursor operations
Trying logout
Test suceeded
PASS: ct_cursor
ct_cursors.c: use multiple cursors on the same connection
Trying login
ct_results() result_type CS_CMD_FAIL.
ct_results() result_type CS_CMD_FAIL.
opening first cursor on connection
opening second cursor on connection
AAA                     XXX
BBB                     YYY
CCC                     ZZZ
closing first cursor on connection
closing second cursor on connection
Trying logout
Test succeded
PASS: ct_cursors
===================
All 26 tests passed
===================
make[4]: Leaving directory `/usr/src/freetds/freetds-0.63/src/ctlib/unittests'
make[3]: Leaving directory `/usr/src/freetds/freetds-0.63/src/ctlib/unittests'
make[3]: Entering directory `/usr/src/freetds/freetds-0.63/src/ctlib'
make[3]: Nothing to be done for `check-am'.
make[3]: Leaving directory `/usr/src/freetds/freetds-0.63/src/ctlib'
make[2]: Leaving directory `/usr/src/freetds/freetds-0.63/src/ctlib'
Making check in dblib
make[2]: Entering directory `/usr/src/freetds/freetds-0.63/src/dblib'
Making check in unittests
make[3]: Entering directory 
`/usr/src/freetds/freetds-0.63/src/dblib/unittests'
make  t0001 t0002 t0003 t0004 t0005 t0006 t0007 t0008 t0009 t0010 t0011 t0012 
t0013 t0014 t0015 t0016 t0017 t0018 t0019 t0020 t0021 t0022 t0023 rpc 
dbmorecmds bcp
make[4]: Entering directory 
`/usr/src/freetds/freetds-0.63/src/dblib/unittests'
make[4]: `t0001' is up to date.
make[4]: `t0002' is up to date.
make[4]: `t0003' is up to date.
make[4]: `t0004' is up to date.
make[4]: `t0005' is up to date.
make[4]: `t0006' is up to date.
make[4]: `t0007' is up to date.
make[4]: `t0008' is up to date.
make[4]: `t0009' is up to date.
make[4]: `t0010' is up to date.
make[4]: `t0011' is up to date.
make[4]: `t0012' is up to date.
make[4]: `t0013' is up to date.
make[4]: `t0014' is up to date.
make[4]: `t0015' is up to date.
make[4]: `t0016' is up to date.
make[4]: `t0017' is up to date.
make[4]: `t0018' is up to date.
make[4]: `t0019' is up to date.
make[4]: `t0020' is up to date.
make[4]: `t0021' is up to date.
make[4]: `t0022' is up to date.
make[4]: `t0023' is up to date.
make[4]: `rpc' is up to date.
make[4]: `dbmorecmds' is up to date.
make[4]: `bcp' is up to date.
make[4]: Leaving directory `/usr/src/freetds/freetds-0.63/src/dblib/unittests'
make  check-TESTS
make[4]: Entering directory 
`/usr/src/freetds/freetds-0.63/src/dblib/unittests'
found Dev.tempdb for user in "../../../PWD"
Start
About to logon
About to open "Dev"
QUOTED_IDENTIFIER is OFF
Dropping table
Msg 3701, Level 11, State 5
Server 'SERVER', Line 1
Cannot drop the table '#dblib0001', because it does not exist in the system 
catalog.
creating table
insert
[snip]
PASS: t0001
found Dev.tempdb for user in "../../../PWD"
Start
About to logon
About to open
Dropping table
Msg 3701, Level 11, State 5
Server 'SERVER', Line 1
Cannot drop the table '#dblib0002', because it does not exist in the system 
catalog.
creating table
insert
select
col 1 is i
[snip]
Read a row of data -> 12 row 012
dblib okay on t0002.c
PASS: t0002
found Dev.tempdb for user in "../../../PWD"
Start
About to logon
About to open
Dropping table
Msg 3701, Level 11, State 5
Server 'SERVER', Line 1
Cannot drop the table '#dblib0003', because it does not exist in the system 
catalog.
creating table
insert
select
col 1 is i
col 2 is s
Read a row of data -> 1 row 001
[snip]
Read a row of data -> 49 row 049
dblib okay on t0003.c
PASS: t0003
found Dev.tempdb for user in "../../../PWD"
Start
About to logon
About to open
Dropping table
Msg 3701, Level 11, State 5
Server 'SERVER', Line 1
Cannot drop the table '#dblib0004', because it does not exist in the system 
catalog.
creating table
insert
insert into #dblib0004 values (1, 'row 0001')
[snip]
Read a row of data -> 24 row 0024
second select
select * from #dblib0004 where i>950 order by i
About to exec for the second time.  Should fail
DB-LIBRARY error (severity 7, dberr 20019, oserr -1, dberrstr Attempt to 
initiate a new SQL Server operation with results pending., oserrstr 
OpenClient):
dblib okay on t0004.c
PASS: t0004
found Dev.tempdb for user in "../../../PWD"
Start
About to logon
About to open
Dropping table
Msg 3701, Level 11, State 5
Server 'SERVER', Line 1
Cannot drop the table '#dblib0005', because it does not exist in the system 
catalog.
creating table
insert
select * from #dblib0005 where i < 5 order by i
col 1 is i
col 2 is s
Read a row of data -> 1 row 0001
Read a row of data -> 2 row 0002
Read a row of data -> 3 row 0003
Read a row of data -> 4 row 0004
This query should succeeded as we have fetched exactly the.
number of rows in the result set
select * from #dblib0005 where i < 6 order by i
col 1 is i
col 2 is s
Read a row of data -> 1 row 0001
Read a row of data -> 2 row 0002
Read a row of data -> 3 row 0003
Read a row of data -> 4 row 0004
This query should fail as we have not fetched all the
rows in the result set
select * from #dblib0005 where i > 950 order by i
DB-LIBRARY error (severity 7, dberr 20019, oserr -1, dberrstr Attempt to 
initiate a new SQL Server operation with results pending., oserrstr 
OpenClient):
calling dbcancel to flush results
Dropping proc
creating proc
create proc t0005_proc (@b int out) as
begin
select * from #dblib0005 where i < 6 order by i
select @b = 42
end

calling proc
declare @myout int exec t0005_proc @b = @myout output
col 1 is i
col 2 is s
Read a row of data -> 1 row 0001
Read a row of data -> 2 row 0002
Read a row of data -> 3 row 0003
Read a row of data -> 4 row 0004
Read a row of data -> 5 row 0005
This next command should succeed as we have fetched exactly the.
number of rows in the result set
select getdate()
dblib okay on t0005.c
PASS: t0005
[snip]
PASS: t0016
found Dev.tempdb for user in "../../../PWD"
Start
About to logon
About to open, PASSWORD: , USER: , SERVER:
After logon
Dropping table
Msg 3701, Level 11, State 5
Server 'SERVER', Line 1
Cannot drop the table '#dblib0017', because it does not exist in the system 
catalog.
Creating table
select
DB-LIBRARY error (severity 3, dberr 20070, oserr -1, dberrstr I/O error while 
reading bcp data-file., oserrstr OpenClient):
1 rows copied
dblib okay on t0017.c
PASS: t0017
[snip]
Read a row of data -> 49 row 049
Number of rows affected by update = 50.
dblib okay on t0018.c
PASS: t0018
DB-LIBRARY error (severity 4, dberr 20049, oserr -1, dberrstr Data-conversion 
resulted in overflow., oserrstr OpenClient):
DB-LIBRARY error (severity 4, dberr 20049, oserr -1, dberrstr Data-conversion 
resulted in overflow., oserrstr OpenClient):
All tests passed!
PASS: t0019
[snip]
PASS: t0021
found Dev.tempdb for user in "../../../PWD"
Start
About to logon
About to open
Dropping proc
creating proc
declare @b int
exec t0022 @b = @b output

WARNING:  Received no return parameters from server!
WARNING:  This is likely due to a bug in Microsoft
WARNING:  SQL Server 7.0 SP3 and later.
WARNING:  Please try again using TDS protocol 4.2.
PASS: t0022
[snip]
===================
All 26 tests passed
===================
make[4]: Leaving directory `/usr/src/freetds/freetds-0.63/src/dblib/unittests'
[snip]