FreeTDS Development Group

[will trillich <will AT serensoft.com>]

we're having trouble compiling DBD::Sybase (perl modules)
for use with freetds -- so we went back a step and tried
to confirm that freetds was not just compiled, but healthy
as well... :)

when we run "make check" we get lots of output, but it
it not affected at all by the PWD file (we use genuine
credentials and then randomized credentials and save
"make check > outputlog" and "diff" shows NO difference
between the two). either way "11 of 15 tests failed"...

boy there's a lot of output! are any of these actual
connect errors? if not, how can we test the db server
connection?

$ uname -a
HP-UX starsrv1 B.11.11 U 9000/800 106404636 unlimited-user license

$ make check
Making check in include
make[1]: Entering directory `/dump/freetds-0.64.dev.20050905/include'
make[1]: Nothing to be done for `check'.
make[1]: Leaving directory `/dump/freetds-0.64.dev.20050905/include'
Making check in src
make[1]: Entering directory `/dump/freetds-0.64.dev.20050905/src'
Making check in replacements
make[2]: Entering directory 
`/dump/freetds-0.64.dev.20050905/src/replacements'
make[2]: Nothing to be done for `check'.
make[2]: Leaving directory 
`/dump/freetds-0.64.dev.20050905/src/replacements'
Making check in tds
make[2]: Entering directory `/dump/freetds-0.64.dev.20050905/src/tds'
make  check-recursive
make[3]: Entering directory `/dump/freetds-0.64.dev.20050905/src/tds'
Making check in unittests
make[4]: Entering directory 
`/dump/freetds-0.64.dev.20050905/src/tds/unittests'
make  t0001 t0002 t0003 t0004 t0005 t0006 t0007 t0008 dynamic1 convert 
dataread utf8_1 utf8_2 utf8_3 numeric
make[5]: Entering directory 
`/dump/freetds-0.64.dev.20050905/src/tds/unittests'
make[5]: `t0001' is up to date.
make[5]: `t0002' is up to date.
make[5]: `t0003' is up to date.
make[5]: `t0004' is up to date.
make[5]: `t0005' is up to date.
make[5]: `t0006' is up to date.
make[5]: `t0007' is up to date.
make[5]: `t0008' is up to date.
make[5]: `dynamic1' is up to date.
make[5]: `convert' is up to date.
make[5]: `dataread' is up to date.
make[5]: `utf8_1' is up to date.
make[5]: `utf8_2' is up to date.
make[5]: `utf8_3' is up to date.
make[5]: `numeric' is up to date.
make[5]: Leaving directory 
`/dump/freetds-0.64.dev.20050905/src/tds/unittests'
make  check-TESTS
make[5]: Entering directory 
`/dump/freetds-0.64.dev.20050905/src/tds/unittests'
t0001.c: Testing login, logout
tds_connect() failed
try_tds_login() failed
FAIL: t0001
t0002.c: Test basic submit query, results
tds_connect() failed
try_tds_login() failed
FAIL: t0002
t0003.c: Testing DB change -- 'use tempdb'
tds_connect() failed
try_tds_login() failed
FAIL: t0003
t0004.c: Test large (>512 bytes) queries
tds_connect() failed
try_tds_login() failed
FAIL: t0004
t0005.c: Test large (>512 bytes) replies
tds_connect() failed
try_tds_login() failed
FAIL: t0005
t0006.c: Test SYBREAL, SYBFLT8 values
tds_connect() failed
try_tds_login() failed
FAIL: 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
len=2 AB FD
len=2 AB FD
len=2 00 00
len=1 00
len=2 01 00
len=1 01
PASS: t0007
test some valid values..
prec=18 scale=0 00 00 00 00 00 00 00 04 D2 00 00 00 00 00 00 00 00 00 00 
00 00 00 00 00 00 00 00 00 00 00 00 00 00
prec=18 scale=0 00 00 00 00 00 49 96 02 D2 00 00 00 00 00 00 00 00 00 00 
00 00 00 00 00 00 00 00 00 00 00 00 00 00
1234567890
prec=18 scale=0 00 01 B6 9B 4B A6 30 F3 4E 00 00 00 00 00 00 00 00 00 00 
00 00 00 00 00 00 00 00 00 00 00 00 00 00
123456789012345678
prec=18 scale=0 00 0D E0 B6 B3 A7 63 FF FF 00 00 00 00 00 00 00 00 00 00 
00 00 00 00 00 00 00 00 00 00 00 00 00 00
999999999999999999
test overflow..
error
error
prec=38 scale=0 00 00 00 00 01 8E E9 0F F6 C3 73 E0 EE 4E 3F 0A D2 00 00 
00 00 00 00 00 00 00 00 00 00 00 00 00 00
123456789012345678901234567890
error
prec=38 scale=0 00 4B 3B 4C A8 5A 86 C4 7A 09 8A 22 3F FF FF FF FF 00 00 
00 00 00 00 00 00 00 00 00 00 00 00 00 00
99999999999999999999999999999999999999
error
prec=18 scale=1 00 00 00 00 00 00 00 30 34 00 00 00 00 00 00 00 00 00 00 
00 00 00 00 00 00 00 00 00 00 00 00 00 00
prec=18 scale=2 00 00 00 00 00 00 01 E2 40 00 00 00 00 00 00 00 00 00 00 
00 00 00 00 00 00 00 00 00 00 00 00 00 00
1234.56

[snip]

765432.2 -> 765432.20 ok!
765432.2 -> error ok!
10000000000000000000000000 -> error ok!
1000000000000000000 -> error ok!
10000000000000000 -> 10000000000000000 ok!
10000000000000000 -> error ok!
All passed!
PASS: numeric
=====================
11 of 15 tests failed
=====================
make[5]: *** [check-TESTS] Error 1
make[5]: Leaving directory 
`/dump/freetds-0.64.dev.20050905/src/tds/unittests'
make[4]: *** [check-am] Error 2
make[4]: Leaving directory 
`/dump/freetds-0.64.dev.20050905/src/tds/unittests'
make[3]: *** [check-recursive] Error 1
make[3]: Leaving directory `/dump/freetds-0.64.dev.20050905/src/tds'
make[2]: *** [check] Error 2
make[2]: Leaving directory `/dump/freetds-0.64.dev.20050905/src/tds'
make[1]: *** [check-recursive] Error 1
make[1]: Leaving directory `/dump/freetds-0.64.dev.20050905/src'
make: *** [check-recursive] Error 1