[freetds] RESULTS of testing 64bit Hardy vs. 0.82RC4

Igor Chudov igor at chudov.com
Thu Apr 24 01:08:38 EDT 2008


Looks like 0.82 compiles straight out of the box, here's the output. 

Also, I re-ran my perl script that was causing problems with types
from "select *" being returned as zeroes. But I am not sure if just 

     ./configure --prefix=/usr && make all install

is enough. 

######################################################################
Making check in include
make[1]: Entering directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/include'
make[1]: Nothing to be done for `check'.
make[1]: Leaving directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/include'
Making check in src
make[1]: Entering directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src'
Making check in replacements
make[2]: Entering directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/replacements'
make[2]: Nothing to be done for `check'.
make[2]: Leaving directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/replacements'
Making check in tds
make[2]: Entering directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds'
make  check-recursive
make[3]: Entering directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds'
Making check in unittests
make[4]: Entering directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds/unittests'
make  t0001 t0002 t0003 t0004 t0005 t0006 t0007 t0008 dynamic1 convert dataread utf8_1 utf8_2 utf8_3 numeric iconv_fread
make[5]: Entering directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/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]: `iconv_fread' is up to date.
make[5]: Leaving directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds/unittests'
make  check-TESTS
make[5]: Entering directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds/unittests'
tds_connect() failed
try_tds_login() failed
t0001.c: Testing login, logout
FAIL: t0001
tds_connect() failed
try_tds_login() failed
t0002.c: Test basic submit query, results
FAIL: t0002
tds_connect() failed
try_tds_login() failed
t0003.c: Testing DB change -- 'use tempdb'
FAIL: t0003
tds_connect() failed
try_tds_login() failed
t0004.c: Test large (>512 bytes) queries
FAIL: t0004
tds_connect() failed
try_tds_login() failed
t0005.c: Test large (>512 bytes) replies
FAIL: t0005
tds_connect() failed
try_tds_login() failed
t0006.c: Test SYBREAL, SYBFLT8 values
FAIL: t0006
some checks...
1234
123
-1234
error
0
0
123
123
123
error
error
error
error
error
error
error
error
0xfffffffffffffb2e
error
0x0000000000000000
0x0000000000000000
0x000000000000007b
0x000000000000007b
0x000000000000007b
error
error
error
error
error
error
error
error
overflow checks...
0x7fffffffffffffff
error
0x8000000000000000
error
2147483647
error
-2147483648
error
32767
error
-32768
error
255
error
0
error
overflow on big number checks...
error
error
error
error
12
0x00000000000004d2
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
38716 0
38716 0
38414 0
37022 0
38717 0
38717 0
38717 0
38717 0
38717 0
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
prec=18 scale=5 00 00 00 00 00 00 00 00 7B 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0.00123
prec=18 scale=4 00 00 00 00 00 00 00 00 7B 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0.0123
prec=18 scale=3 00 00 00 00 00 00 00 00 7B 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0.123
prec=18 scale=2 00 00 00 00 00 00 00 00 7B 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
1.23
prec=18 scale=1 00 00 00 00 00 00 00 00 7B 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
12.3
prec=18 scale=4 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0.0000
prec=18 scale=0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0
PASS: t0008
tds_connect() failed
try_tds_login() failed
dynamic1.c: Test dynamic queries
FAIL: dynamic1
converted 39 (varchar, 12 bytes) : 47 (char, 12 bytes).
        0 iterations/second converting       varchar => char.
converted 39 (varchar, 12 bytes) : 35 (text, 12 bytes).
        0 iterations/second converting       varchar => text.
converted 39 (varchar, 6 bytes) : 45 (binary, 2 bytes).
        0 iterations/second converting       varchar => binary.
converted 39 (varchar, 1 bytes) : 37 (varbinary, 1 bytes).
        0 iterations/second converting       varchar => varbinary.
converted 39 (varchar, 6 bytes) : 34 (image, 2 bytes).
        0 iterations/second converting       varchar => image.
converted 39 (varchar, 3 bytes) : 48 (tinyint, 1 bytes).
converted 39 (varchar, 3 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting       varchar => smallint.
converted 39 (varchar, 3 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting       varchar => int.
converted 39 (varchar, 3 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting       varchar => bigint.
converted 39 (varchar, 7 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting       varchar => float.
converted 39 (varchar, 7 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting       varchar => real.
converted 39 (varchar, 7 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting       varchar => numeric.
converted 39 (varchar, 7 bytes) : 106 (decimal, 35 bytes).
converted 39 (varchar, 1 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting       varchar => bit.
converted 39 (varchar, 7 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting       varchar => money.
converted 39 (varchar, 7 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting       varchar => smallmoney.
converted 39 (varchar, 12 bytes) : 61 (datetime, 8 bytes).
        0 iterations/second converting       varchar => datetime.
converted 39 (varchar, 12 bytes) : 58 (smalldatetime, 4 bytes).
        0 iterations/second converting       varchar => smalldatetime.
converted 47 (char, 12 bytes) : 39 (varchar, 12 bytes).
        0 iterations/second converting          char => varchar.
converted 47 (char, 12 bytes) : 35 (text, 12 bytes).
        0 iterations/second converting          char => text.
converted 47 (char, 6 bytes) : 45 (binary, 2 bytes).
        0 iterations/second converting          char => binary.
converted 47 (char, 1 bytes) : 37 (varbinary, 1 bytes).
        0 iterations/second converting          char => varbinary.
converted 47 (char, 6 bytes) : 34 (image, 2 bytes).
        0 iterations/second converting          char => image.
converted 47 (char, 3 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting          char => tinyint.
converted 47 (char, 3 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting          char => smallint.
converted 47 (char, 3 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting          char => int.
converted 47 (char, 3 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting          char => bigint.
converted 47 (char, 7 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting          char => float.
converted 47 (char, 7 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting          char => real.
converted 47 (char, 7 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting          char => numeric.
converted 47 (char, 7 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting          char => decimal.
converted 47 (char, 1 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting          char => bit.
converted 47 (char, 7 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting          char => money.
converted 47 (char, 7 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting          char => smallmoney.
converted 47 (char, 12 bytes) : 61 (datetime, 8 bytes).
        0 iterations/second converting          char => datetime.
converted 47 (char, 12 bytes) : 58 (smConversion not yet implemented:
	failed (-2) to convert 45 (binary, 7 bytes) : 108 (numeric).
Conversion not yet implemented:
	failed (-2) to convert 45 (binary, 7 bytes) : 106 (decimal).
Conversion not yet implemented:
	failed (-2) to convert 45 (binary, 1 bytes) : 50 (bit).
alldatetime, 4 bytes).
        0 iterations/second converting          char => smalldatetime.
converted 35 (text, 12 bytes) : 39 (varchar, 12 bytes).
        0 iterations/second converting          text => varchar.
converted 35 (text, 12 bytes) : 47 (char, 12 bytes).
        0 iterations/second converting          text => char.
converted 35 (text, 6 bytes) : 45 (binary, 2 bytes).
        0 iterations/second converting          text => binary.
converted 35 (text, 1 bytes) : 37 (varbinary, 1 bytes).
        0 iterations/second converting          text => varbinary.
converted 35 (text, 6 bytes) : 34 (image, 2 bytes).
        0 iterations/second converting          text => image.
converted 35 (text, 3 bytes) : 48 (tinyint, 1 bytes).
converted 35 (text, 3 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting          text => smallint.
converted 35 (text, 3 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting          text => int.
converted 35 (text, 3 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting          text => bigint.
converted 35 (text, 7 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting          text => float.
converted 35 (text, 7 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting          text => real.
converted 35 (text, 7 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting          text => numeric.
converted 35 (text, 7 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting          text => decimal.
converted 35 (text, 1 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting          text => bit.
converted 35 (text, 7 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting          text => money.
converted 35 (text, 7 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting          text => smallmoney.
converted 35 (text, 12 bytes) : 61 (datetime, 8 bytes).
        0 iterations/second converting          text => datetime.
converted 35 (text, 12 bytes) : 58 (smalldatetime, 4 bytes).
        0 iterations/second converting          text => smalldatetime.
converted 45 (binary, 12 bytes) : 39 (varchar, 24 bytes).
        0 iterations/second converting        binary => varchar.
converted 45 (binary, 12 bytes) : 47 (char, 24 bytes).
        0 iterations/second converting        binary => char.
converted 45 (binary, 12 bytes) : 35 (text, 24 bytes).
        0 iterations/second converting        binary => text.
converted 45 (binary, 1 bytes) : 37 (varbinary, 1 bytes).
        0 iterations/second converting        binary => varbinary.
converted 45 (binary, 6 bytes) : 34 (image, 6 bytes).
        0 iterations/second converting        binary => image.
converted 45 (binary, 3 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting        binary => tinyint.
converted 45 (binary, 3 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting        binary => smallint.
converted 45 (binary, 3 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting        binary => int.
converted 45 (binary, 3 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting        binary => bigint.
converted 45 (binary, 7 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting        binary => float.
converted 45 (binary, 7 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting        binary => real.
converted 45 (binary, 7 bytes) : 108 (numeric, -2 bytes).
        0 iterations/second converting        binary => numeric.
converted 45 (binary, 7 bytes) : 106 (decimal, -2 bytes).
        0 iterations/second converting        binary => decimal.
converted 45 (binary, 1 bytes) : 50 (bit, -2 bytes).
        0 iterations/second converting        binary => bit.
converted 45 (binary, 7 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting        binary => money.
converted 45 (binary, 7 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting        binary => smallmoney.
converted 37 (varbConversion not yet implemented:
	failed (-2) to convert 37 (varbinary, 7 bytes) : 108 (numeric).
Conversion not yet implemented:
	failed (-2) to convert 37 (varbinary, 7 bytes) : 106 (decimal).
Conversion not yet implemented:
	failed (-2) to convert 37 (varbinary, 1 bytes) : 50 (bit).
Conversion not yet implemented:
	failed (-2) to convert 34 (image, 7 bytes) : 108 (numeric).
Conversion not yet implemented:
	failed (-2) to convert 34 (image, 7 bytes) : 106 (decimal).
Conversion not yet implemented:
	failed (-2) to convert 34 (image, 1 bytes) : 50 (bit).
inary, 12 bytes) : 39 (varchar, 24 bytes).
        0 iterations/second converting     varbinary => varchar.
converted 37 (varbinary, 12 bytes) : 47 (char, 24 bytes).
        0 iterations/second converting     varbinary => char.
converted 37 (varbinary, 12 bytes) : 35 (text, 24 bytes).
        0 iterations/second converting     varbinary => text.
converted 37 (varbinary, 6 bytes) : 45 (binary, 6 bytes).
        0 iterations/second converting     varbinary => binary.
converted 37 (varbinary, 6 bytes) : 34 (image, 6 bytes).
        0 iterations/second converting     varbinary => image.
converted 37 (varbinary, 3 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting     varbinary => tinyint.
converted 37 (varbinary, 3 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting     varbinary => smallint.
converted 37 (varbinary, 3 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting     varbinary => int.
converted 37 (varbinary, 3 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting     varbinary => bigint.
converted 37 (varbinary, 7 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting     varbinary => float.
converted 37 (varbinary, 7 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting     varbinary => real.
converted 37 (varbinary, 7 bytes) : 108 (numeric, -2 bytes).
        0 iterations/second converting     varbinary => numeric.
converted 37 (varbinary, 7 bytes) : 106 (decimal, -2 bytes).
        0 iterations/second converting     varbinary => decimal.
converted 37 (varbinary, 1 bytes) : 50 (bit, -2 bytes).
        0 iterations/second converting     varbinary => bit.
converted 37 (varbinary, 7 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting     varbinary => money.
converted 37 (varbinary, 7 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting     varbinary => smallmoney.
converted 34 (image, 12 bytes) : 39 (varchar, 24 bytes).
        0 iterations/second converting         image => varchar.
converted 34 (image, 12 bytes) : 47 (char, 24 bytes).
        0 iterations/second converting         image => char.
converted 34 (image, 12 bytes) : 35 (text, 24 bytes).
        0 iterations/second converting         image => text.
converted 34 (image, 6 bytes) : 45 (binary, 6 bytes).
        0 iterations/second converting         image => binary.
converted 34 (image, 1 bytes) : 37 (varbinary, 1 bytes).
        0 iterations/second converting         image => varbinary.
converted 34 (image, 3 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting         image => tinyint.
converted 34 (image, 3 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting         image => smallint.
converted 34 (image, 3 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting         image => int.
converted 34 (image, 3 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting         image => bigint.
converted 34 (image, 7 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting         image => float.
converted 34 (image, 7 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting         image => real.
converted 34 (image, 7 bytes) : 108 (numeric, -2 bytes).
        0 iterations/second converting         image => numeric.
converted 34 (image, 7 bytes) : 106 (decimal, -2 bytes).
        0 iterations/second converting         image => decimal.
converted 34 (image, 1 bytes) : 50 (bit, -2 bytes).
        0 iterations/second converting         image => bit.
converted 34 (image, 7 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting         image => money.
converted 34 (image, 7 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting         image => smallmoney.
converted 48 (tinyint, 1 bytes) : 39 (varchar, 2 bytes).
        0 iterations/second converting       tinyint => varchar.
converted 48 (tinyint, 1 bytes) : 47 (char, 2 bytes).
        0 iterations/second converting       tinyint => char.
converted 48 (tinyint, 1 bytes) : 35 (text, 2 bytes).
        0 iterations/second converting       tinyint => text.
converted 48 (tinyint, 1 bytes) : 45 (binary, 1 bytes).
        0 iterations/second converting       tinyint => binary.
converted 48 (tinyint, 1 bytes) : 37 (varbinary, 1 bytes).
        0 iterations/second converting       tinyint => varbinary.
converted 48 (tinyint, 1 bytes) : 34 (image, 1 bytes).
        0 iterations/second converting       tinyint => image.
converted 48 (tinyint, 1 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting       tinyint => smallint.
converted 48 (tinyint, 1 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting       tinyint => int.
converted 48 (tinyint, 1 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting       tinyint => bigint.
converted 48 (tinyint, 1 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting       tinyint => float.
converted 48 (tinyint, 1 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting       tinyint => real.
converted 48 (tinyint, 1 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting       tinyint => numeric.
converted 48 (tinyint, 1 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting       tinyint => decimal.
converted 48 (tinyint, 1 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting       tinyint => bit.
converted 48 (tinyint, 1 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting       tinyint => money.
converted 48 (tinyint, 1 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting       tinyint => smallmoney.
converted 52 (smallint, 2 bytes) : 39 (varchar, 2 bytes).
        0 iterations/second converting      smallint => varchar.
converted 52 (smallint, 2 bytes) : 47 (char, 2 bytes).
        0 iterations/second converting      smallint => char.
converted 52 (smallint, 2 bytes) : 35 (text, 2 bytes).
        0 iterations/second converting      smallint => text.
converted 52 (smallint, 2 bytes) : 45 (binary, 2 bytes).
        0 iterations/second converting      smallint => binary.
converted 52 (smallint, 2 bytes) : 37 (varbinary, 2 bytes).
        0 iterations/second converting      smallint => varbinary.
converted 52 (smallint, 2 bytes) : 34 (image, 2 bytes).
        0 iterations/second converting      smallint => image.
converted 52 (smallint, 2 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting      smallint => tinyint.
converted 52 (smallint, 2 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting      smallint => int.
converted 52 (smallint, 2 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting      smallint => bigint.
converted 52 (smallint, 2 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting      smallint => float.
converted 52 (smallint, 2 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting      smallint => real.
converted 52 (smallint, 2 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting      smallint => numeric.
converted 52 (smallint, 2 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting      smallint => decimal.
converted 52 (smallint, 2 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting      smallint => bit.
converted 52 (smallint, 2 bytes) : 60 (money, 8 bytes).
converted 52 (smallint, 2 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting      smallint => smallmoney.
converted 56 (int, 4 bytes) : 39 (varchar, 2 bytes).
        0 iterations/second converting           int => varchar.
converted 56 (int, 4 bytes) : 47 (char, 2 bytes).
        0 iterations/second converting           int => char.
converted 56 (int, 4 bytes) : 35 (text, 2 bytes).
converted 56 (int, 4 bytes) : 45 (binary, 4 bytes).
        0 iterations/second converting           int => binary.
converted 56 (int, 4 bytes) : 37 (varbinary, 4 bytes).
converted 56 (int, 4 bytes) : 34 (image, 4 bytes).
        0 iterations/second converting           int => image.
converted 56 (int, 4 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting           int => tinyint.
converted 56 (int, 4 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting           int => smallint.
converted 56 (int, 4 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting           int => bigint.
converted 56 (int, 4 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting           int => float.
converted 56 (int, 4 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting           int => real.
converted 56 (int, 4 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting           int => numeric.
converted 56 (int, 4 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting           int => decimal.
converted 56 (int, 4 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting           int => bit.
converted 56 (int, 4 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting           int => money.
converted 56 (int, 4 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting           int => smallmoney.
converted 127 (bigint, 8 bytes) : 39 (varchar, 2 bytes).
        0 iterations/second converting        bigint => varchar.
converted 127 (bigint, 8 bytes) : 47 (char, 2 bytes).
        0 iterations/second converting        bigint => char.
converted 127 (bigint, 8 bytes) : 35 (text, 2 bytes).
        0 iterations/second converting        bigint => text.
converted 127 (bigint, 8 bytes) : 45 (binary, 8 bytes).
        0 iterations/second converting        bigint => binary.
converted 127 (bigint, 8 bytes) : 37 (varbinary, 8 bytes).
        0 iterations/second converting        bigint => varbinary.
converted 127 (bigint, 8 bytes) : 34 (image, 8 bytes).
        0 iterations/second converting        bigint => image.
converted 127 (bigint, 8 bytes) : 48 (tinyint, 1 bytes).
converted 127 (bigint, 8 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting        bigint => smallint.
converted 127 (bigint, 8 bytes) : 56 (int, 4 bytes).
converted 127 (bigint, 8 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting        bigint => float.
converted 127 (bigint, 8 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting        bigint => real.
converted 127 (bigint, 8 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting        bigint => numeric.
converted 127 (bigint, 8 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting        bigint => decimal.
converted 127 (bigint, 8 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting        bigint => bit.
converted 127 (bigint, 8 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting        bigint => money.
converted 127 (bigint, 8 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting        bigint => smallmoney.
converted 62 (float, 8 bytes) : 39 (varchar, 7 bytes).
        0 iterations/second converting         float => varchar.
converted 62 (float, 8 bytes) : 47 (char, 7 bytes).
        0 iterations/second converting         float => char.
converted 62 (float, 8 bytes) : 35 (text, 7 bytes).
        0 iterations/second converting         float => text.
converted 62 (float, 8 bytes) : 45 (binary, 8 bytes).
        0 iterations/second converting         float => binary.
converted 62 (float, 8 bytes) : 37 (varbinary, 8 bytes).
        0 iterations/second converting         float => varbinary.
converted 62 (float, 8 bytes) : 34 (image, 8 bytes).
        0 iterations/second converting         float => image.
converted 62 (float, 8 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting         float => tinyint.
converted 62 (float, 8 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting         float => smallint.
converted 62 (float, 8 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting         float => int.
converted 62 (float, 8 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting         float => bigint.
converted 62 (float, 8 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting         float => real.
converted 62 (float, 8 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting         float => numeric.
converted 62 (float, 8 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting         float => decimal.
converted 62 (float, 8 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting         float => bit.
converted 62 (float, 8 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting         float => money.
converted 62 (float, 8 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting         float => smallmoney.
converted 59 (real, 4 bytes) : 39 (varchar, 7 bytes).
        0 iterations/second converting          real => varchar.
converted 59 (real, 4 bytes) : 47 (char, 7 bytes).
        0 iterations/second converting          real => char.
converted 59 (real, 4 bytes) : 35 (text, 7 bytes).
        0 iterations/second converting          real => text.
converted 59 (real, 4 bytes) : 45 (binary, 4 bytes).
        0 iterations/second converting          real => binary.
converted 59 (real, 4 bytes) : 37 (varbinary, 4 bytes).
        0 iterations/second converting          real => varbinary.
converted 59 (real, 4 bytes) : 34 (image, 4 bytes).
converted 59 (real, 4 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting          real => tinyint.
converted 59 (real, 4 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting          real => smallint.
converted 59 (real, 4 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting          real => int.
converted 59 (real, 4 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting          real => bigint.
converted 59 (real, 4 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting          real => float.
converted 59 (real, 4 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting          real => numeric.
converted 59 (real, 4 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting          real => decimal.
converted 59 (real, 4 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting          real => bit.
converted 59 (real, 4 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting          real => money.
converted 59 (real, 4 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting          real => smallmoney.
converted 108 (numeric, 35 bytes) : 39 (varchar, 4 bytes).
        0 iterations/second converting       numeric => varchar.
converted 108 (numeric, 35 bytes) : 47 (char, 4 bytes).
        0 iterations/second converting       numeric => char.
converted 108 (numeric, 35 bytes) : 35 (text, 4 bytes).
        0 iterations/second converting       numeric => text.
converted 108 (numeric, 35 bytes) : 45 (binary, 35 bytes).
        0 iterations/second converting       numeric => binary.
converted 108 (numeric, 35 bytes) : 37 (varbinary, 35 bytes).
        0 iterations/second converting       numeric => varbinary.
converted 108 (numeric, 35 bytes) : 34 (image, 35 bytes).
        0 iterations/second converting       numeric => image.
converted 108 (numeric, 35 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting       numeric => tinyint.
converted 108 (numeric, 35 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting       numeric => smallint.
converted 108 (numeric, 35 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting       numeric => int.
converted 108 (numeric, 35 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting       numeric => bigint.
converted 108 (numeric, 35 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting       numeric => float.
converted 108 (numeric, 35 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting       numeric => real.
converted 108 (numeric, 35 bytes) : 106 (decimal, 35 bytes).Conversion not yet implemented:
	failed (-2) to convert 108 (numeric, 35 bytes) : 60 (money).
Conversion not yet implemented:
	failed (-2) to convert 108 (numeric, 35 bytes) : 122 (smallmoney).
Conversion not yet implemented:
	failed (-2) to convert 106 (decimal, 35 bytes) : 60 (money).
Conversion not yet implemented:
	failed (-2) to convert 106 (decimal, 35 bytes) : 122 (smallmoney).

        0 iterations/second converting       numeric => decimal.
converted 108 (numeric, 35 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting       numeric => bit.
converted 108 (numeric, 35 bytes) : 60 (money, -2 bytes).
        0 iterations/second converting       numeric => money.
converted 108 (numeric, 35 bytes) : 122 (smallmoney, -2 bytes).
        0 iterations/second converting       numeric => smallmoney.
converted 106 (decimal, 35 bytes) : 39 (varchar, 4 bytes).
        0 iterations/second converting       decimal => varchar.
converted 106 (decimal, 35 bytes) : 47 (char, 4 bytes).
        0 iterations/second converting       decimal => char.
converted 106 (decimal, 35 bytes) : 35 (text, 4 bytes).
        0 iterations/second converting       decimal => text.
converted 106 (decimal, 35 bytes) : 45 (binary, 35 bytes).
        0 iterations/second converting       decimal => binary.
converted 106 (decimal, 35 bytes) : 37 (varbinary, 35 bytes).
converted 106 (decimal, 35 bytes) : 34 (image, 35 bytes).
        0 iterations/second converting       decimal => image.
converted 106 (decimal, 35 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting       decimal => tinyint.
converted 106 (decimal, 35 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting       decimal => smallint.
converted 106 (decimal, 35 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting       decimal => int.
converted 106 (decimal, 35 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting       decimal => bigint.
converted 106 (decimal, 35 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting       decimal => float.
converted 106 (decimal, 35 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting       decimal => real.
converted 106 (decimal, 35 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting       decimal => numeric.
converted 106 (decimal, 35 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting       decimal => bit.
converted 106 (decimal, 35 bytes) : 60 (money, -2 bytes).
        0 iterations/second converting       decimal => money.
converted 106 (decimal, 35 bytes) : 122 (smallmoney, -2 bytes).
        0 iterations/second converting       decimal => smallmoney.
converted 50 (bit, 4 bytes) : 39 (varchar, 1 bytes).
        0 iterations/second converting           bit => varchar.
converted 50 (bit, 4 bytes) : 47 (char, 1 bytes).
        0 iterations/second converting           bit => char.
converted 50 (bit, 4 bytes) : 35 (text, 1 bytes).
        0 iterations/second converting           bit => text.
converted 50 (bit, 4 bytes) : 45 (binary, 1 bytes).
        0 iterations/second converting           bit => binary.
converted 50 (bit, 4 bytes) : 37 (varbinary, 1 bytes).
        0 iterations/second converting           bit => varbinary.
converted 50 (bit, 4 bytes) : 34 (image, 1 bytes).
        0 iterations/second converting           bit => image.
converted 50 (bit, 4 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting           bit => tinyint.
converted 50 (bit, 4 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting           bit => smallint.
converted 50 (bit, 4 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting           bit => int.
converted 50 (bit, 4 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting           bit => bigint.
converted 50 (bit, 4 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting           bit => float.
converted 50 (bit, 4 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting           bit => real.
converted 50 (bit, 4 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting           bit => numeric.
converted 50 (bit, 4 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting           bit => decimal.
converted 50 (bit, 4 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting           bit => money.
converted 50 (bit, 4 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting           bit => smallmoney.
converted 60 (money, 8 bytes) : 39 (varchar, 4 bytes).
        0 iterations/second converting         money => varchar.
converted 60 (money, 8 bytes) : 47 (char, 4 bytes).
        0 iterations/second converting         money => char.
converted 60 (money, 8 bytes) : 35 (text, 4 bytes).
        0 iterations/second converting         money => text.
converted 60 (money, 8 bytes) : 45 (binary, 8 bytes).
        0 iterations/second converting         money => binary.
converted 60 (money, 8 bytes) : 37 (varbinary, 8 bytes).
        0 iterations/second converting         money => varbinary.
converted 60 (money, 8 bytes) : 34 (image, 8 bytes).
        0 iterations/second converting         money => image.
converted 60 (money, 8 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting         money => tinyint.
converted 60 (money, 8 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting         money => smallint.
converted 60 (money, 8 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting         money => int.
converted 60 (money, 8 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting         money => bigint.
converted 60 (money, 8 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting         money => float.
converted 60 (money, 8 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting         money => real.
converted 60 (money, 8 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting         money => numeric.
converted 60 (money, 8 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting         money => decimal.
converted 60 (money, 8 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting         money => bit.
converted 60 (money, 8 bytes) : 122 (smallmoney, 4 bytes).
        0 iterations/second converting         money => smallmoney.
converted 122 (smallmoney, 4 bytes) : 39 (varchar, 4 bytes).
        0 iterations/second converting    smallmoney => varchar.
converted 122 (smallmoney, 4 bytes) : 47 (char, 4 bytes).
        0 iterations/second converting    smallmoney => char.
converted 122 (smallmoney, 4 bytes) : 35 (text, 4 bytes).
        0 iterations/second converting    smallmoney => text.
converted 122 (smallmoney, 4 bytes) : 45 (binary, 4 bytes).
        0 iterations/second converting    smallmoney => binary.
converted 122 (smallmoney, 4 bytes) : 37 (varbinary, 4 bytes).
        0 iterations/second converting    smallmoney => varbinary.
converted 122 (smallmoney, 4 bytes) : 34 (image, 4 bytes).
        0 iterations/second converting    smallmoney => image.
converted 122 (smallmoney, 4 bytes) : 48 (tinyint, 1 bytes).
        0 iterations/second converting    smallmoney => tinyint.
converted 122 (smallmoney, 4 bytes) : 52 (smallint, 2 bytes).
        0 iterations/second converting    smallmoney => smallint.
converted 122 (smallmoney, 4 bytes) : 56 (int, 4 bytes).
        0 iterations/second converting    smallmoney => int.
converted 122 (smallmoney, 4 bytes) : 127 (bigint, 8 bytes).
        0 iterations/second converting    smallmoney => bigint.
converted 122 (smallmoney, 4 bytes) : 62 (float, 8 bytes).
        0 iterations/second converting    smallmoney => float.
converted 122 (smallmoney, 4 bytes) : 59 (real, 4 bytes).
        0 iterations/second converting    smallmoney => real.
converted 122 (smallmoney, 4 bytes) : 108 (numeric, 35 bytes).
        0 iterations/second converting    smallmoney => numeric.
converted 122 (smallmoney, 4 bytes) : 106 (decimal, 35 bytes).
        0 iterations/second converting    smallmoney => decimal.
converted 122 (smallmoney, 4 bytes) : 50 (bit, 1 bytes).
        0 iterations/second converting    smallmoney => bit.
converted 122 (smallmoney, 4 bytes) : 60 (money, 8 bytes).
        0 iterations/second converting    smallmoney => money.
converted 61 (datetime, 8 bytes) : 39 (varchar, 19 bytes).
        0 iterations/second converting      datetime => varchar.
converted 61 (datetime, 8 bytes) : 47 (char, 19 bytes).
        0 iterations/second converting      datetime => char.
converted 61 (datetime, 8 bytes) : 35 (text, 19 bytes).
        0 iterations/second converting      datetime => text.
converted 61 (datetime, 8 bytes) : 45 (binary, 8 bytes).
        0 iterations/second converting      datetime => binary.
converted 61 (datetime, 8 bytes) : 37 (varbinary, 8 bytes).
        0 iterations/second converting      datetime => varbinary.
converted 61 (datetime, 8 bytes) : 34 (image, 8 bytes).
        0 iterations/second converting      datetime => image.
converted 61 (datetime, 8 bytes) : 58 (smalldatetime, 4 bytes).
        0 iterations/second converting      datetime => smalldatetime.
converted 58 (smalldatetime, 4 bytes) : 39 (varchar, 19 bytes).
        0 iterations/second converting smalldatetime => varchar.
converted 58 (smalldatetime, 4 bytes) : 47 (char, 19 bytes).
        0 iterations/second converting smalldatetime => char.
converted 58 (smalldatetime, 4 bytes) : 35 (text, 19 bytes).
        0 iterations/second converting smalldatetime => text.
converted 58 (smalldatetime, 4 bytes) : 45 (binary, 4 bytes).
        0 iterations/second converting smalldatetime => binary.
converted 58 (smalldatetime, 4 bytes) : 37 (varbinary, 4 bytes).
converted 58 (smalldatetime, 4 bytes) : 34 (image, 4 bytes).
        0 iterations/second converting smalldatetime => image.
converted 58 (smalldatetime, 4 bytes) : 61 (datetime, 8 bytes).
        0 iterations/second converting smalldatetime => datetime.
PASS: convert
tds_connect() failed
try_tds_login() failed
dataread.c: Testing conversion from server
FAIL: dataread
tds_connect() failed
try_tds_login() failed
FAIL: utf8_1
tds_connect() failed
try_tds_login() failed
FAIL: utf8_2
tds_connect() failed
try_tds_login() failed
FAIL: utf8_3
1234 -> 1234.00 ok!
1234.1234 -> 1234.123 ok!
1234.1234 -> 1234.123400000000 ok!
1234 -> 1234.000 ok!
1234.1234 -> 1234.1234 ok!
1234.1234 -> 1234.1234000000000 ok!
1234 -> 1234.0000 ok!
1234.1234 -> 1234.12340 ok!
1234.1234 -> 1234.12340000000000 ok!
1234 -> 1234.00000 ok!
1234.1234 -> 1234.123400 ok!
1234.1234 -> 1234.123400000000000 ok!
1234 -> 1234.000000 ok!
1234.1234 -> 1234.1234000 ok!
1234.1234 -> 1234.1234000000000000 ok!
1234 -> 1234.0000000 ok!
1234.1234 -> 1234.12340000 ok!
1234.1234 -> 1234.12340000000000000 ok!
1234 -> 1234.00000000 ok!
1234.1234 -> 1234.123400000 ok!
1234.1234 -> 1234.123400000000000000 ok!
1234 -> 1234.000000000 ok!
1234.1234 -> 1234.1234000000 ok!
1234.1234 -> 1234.1234000000000000000 ok!
1234 -> 1234.0000000000 ok!
1234.1234 -> 1234.12340000000 ok!
1234.1234 -> 1234.12340000000000000000 ok!
1234 -> 1234.00000000000 ok!
1234.1234 -> 1234.123400000000 ok!
1234.1234 -> 1234.123400000000000000000 ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> error ok!
1234 -> 1234 ok!
1234.765 -> 1234.76 ok!
765432.2 -> 765432.20 ok!
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
res 0 out_len 511
res 0 out_len 510
res 0 out_len 509
res 0 out_len 508
res 0 out_len 507
res 0 out_len 506
res 0 out_len 505
res 0 out_len 504
res 0 out_len 503
res 0 out_len 502
res 0 out_len 501
res 0 out_len 500
res 0 out_len 499
res 0 out_len 498
res 0 out_len 497
res 0 out_len 496
res 0 out_len 495
res 0 out_len 494
res 0 out_len 493
res 0 out_len 492
res 0 out_len 491
res 0 out_len 490
res 0 out_len 489
res 0 out_len 488
res 0 out_len 487
res 0 out_len 486
res 0 out_len 485
res 0 out_len 484
res 0 out_len 483
res 0 out_len 482
res 0 out_len 481
res 0 out_len 480
PASS: iconv_fread
=====================
11 of 16 tests failed
=====================
make[5]: *** [check-TESTS] Error 1
make[5]: Leaving directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds/unittests'
make[4]: *** [check-am] Error 2
make[4]: Leaving directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds/unittests'
make[3]: *** [check-recursive] Error 1
make[3]: Leaving directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds'
make[2]: *** [check] Error 2
make[2]: Leaving directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src/tds'
make[1]: *** [check-recursive] Error 1
make[1]: Leaving directory `/home/myuserid/tmp/freetds/freetds-0.82RC4/src'
make: *** [check-recursive] Error 1



More information about the FreeTDS mailing list