freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] HP/UX tests

From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
To: <freetds AT lists.ibiblio.org>
Subject: [freetds] HP/UX tests
Date: Wed, 10 Dec 2003 14:39:05 +0100

These are results from unittests executed under HP/UX 10.20.
It seem ctlib has some problems...

========================================
odbc
All tests passed, no strange results.

========================================
tds
a test fail.

Wrong result
Got: '' len 4
Expected: '??' len 4
FAIL: utf8_2

========================================
ctlib
All tests passed, note however strange results....

t0002.c: Testing bind & select
spid{§0ÿþ€ ecidÀÌÊã statusM0@ loginame hostname blk dbname cmd
1 0 sleeping sa

0 LOG WRITER
2 0 background sa

0 LAZY WRITER
3 0 background sa

0 master SIGNAL HANDLER
4 0 background sa

0 LOCK MONITOR
5 0 background sa

0 master TASK MANAGER
6 0 background sa

0 master TASK MANAGER
7 0 sleeping sa

0 CHECKPOINT SLEEP
8 0 background sa

0 master TASK MANAGER
9 0 background sa

0 master TASK MANAGER
10 0 background sa

0 master TASK MANAGER
11 0 background sa

0 master TASK MANAGER
12 0 background sa

0 master TASK MANAGER
13 0 background sa

0 master TASK MANAGER
14 0 background sa

0 master TASK MANAGER
15 0 background sa

0 master TASK MANAGER
16 0 background sa

0 master TASK MANAGER
51 0 sleeping NT AUTHORITY\SYSTEM *******

0 msdb AWAITING COMMAND
52 0 sleeping NT AUTHORITY\SYSTEM *******

0 msdb AWAITING COMMAND
53 0 sleeping ******* *******

0 *********** AWAITING COMMAND
54 0 sleeping sa ********

0 master AWAITING COMMAND
55 0 runnable sa *******

0 tempdb SELECT
ct_results fetched 21 rows.
ct_results: CS_STATUS_RESULT detected for sp_who
unnamed1
0
ct_results fetched 1 rows.
PASS: t0002

rpc_ct_param.c: submit a stored procedure using ct_param

ROW RESULTS

japae=eucJP libbcdhp.sl -
japae sjis japae=sjishp libbcdhp.sl -
cp930 eucJP cp930=eucJP libbcdhp.sl -
cp930 sjis cp930=sjishp libbcd .sl -
cp939 sjis cp939=sjishp libbcdhp.sl -
#
# korean (kore5, ebcdic)
#
kore5 koree kore5=koree libhpbcd.sl -
koree kore5 koree=kor ebcdic)
#
hp15CN chinse hp15CN=chinse libhpbcd.sl -
chinse hp15CN chinse=hp15CN libbcdhp.sl -
#
# chinese-t <-> chinese-s (big5 <-> lt libhp15.sl,_mblen_hp
hp15CN big5 hp15CN=big5 default libhp15.sl,_mblen_hp
#
#
# UCS2 <-> UTF-8
#
ucs2 utf8 - lucs2utf.sl -
utf -8
#
ucs4 utf8 - lucs4utf.sl -
utf8 ucs4 - lutfucs4.sl -
#
# HP supported codeset to UCS-2
#
roma8 ucs2 roma8=ucs2 lsbucs2.sl -
is cs2 iso82=ucs2 lsbucs2.sl -
iso85 ucs2 iso85=ucs2 lsbucs2.sl -
iso86 ucs2 iso86=ucs2 lsbucs2.sl -
iso87 ucs2 iso87=ucs2 lsbucs2.sl - 9 ucs2 iso89=ucs2
lsbucs2.sl -
iso815 ucs2 iso815=ucs2 lsbucs2.sl -
thai8 ucs2 thai8=ucs2 lsbucs2.sl -
eucJP ucs2 eucJP=ucs2 leucJPu
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

Open Client Message:
Message number: LAYER = (0) ORIGIN = (0) SEVERITY = (9) NUMBER = (96)
Message String: iconv E2BIG: Error converting between character sets. Output
buffer exhausted.
2
234

0.12

300.90

ff00000000000000000000000000000000000000
All done processing rows.

Server message:
Message number: 0, Severity 0, State 1, Line 1
Server '*******'
Procedure 'sample_rpc'
Message String: This is the message printed out by sample_rpc.

STATUS RESULTS

ÿ
-----------
0
All done processing rows.

Open Client Message:
Message number: LAYER = (0) ORIGIN = (0) SEVERITY = (9) NUMBER = (96)
Message String: iconv E2BIG: Error converting between character sets. Output
buffer exhausted.

PARAMETER RESULTS

@sintparamP libbcdhp.sl -
japae sjis japae=sjishp libbcdhp.sl -
cp930 eucJP cp930=eucJP libbcdhp.sl -
cp930 sjis cp930=sjishp libbcd @floatparam sjis cp939=sjishp
libbcdhp.sl -
#
# korean (kore5, ebcdic)
#
kore5 koree kore5=koree libhpbcd.sl -
koree kore5 koree=kor @moneyparamp15CN chinse hp15CN=chinse
libhpbcd.sl -
chinse hp15CN chinse=hp15CN libbcdhp.sl -
#
# chinese-t <-> chinese-s (big5 <-> @dateparam5.sl,_mblen_hp
hp15CN big5 hp15CN=big5 default libhp15.sl,_mblen_hp
#
#
# UCS2 <-> UTF-8
#
ucs2 utf8 - lucs2utf.sl -
utf @charparamutf8 - lucs4utf.sl -
utf8 ucs4 - lutfucs4.sl -
#
# HP supported codeset to UCS-2
#
roma8 ucs2 roma8=ucs2 lsbucs2.sl -
is @binaryparams2 lsbucs2.sl -
iso85 ucs2 iso85=ucs2 lsbucs2.sl -
iso86 ucs2 iso86=ucs2 lsbucs2.sl -
iso87 ucs2 iso87=ucs2 lsbucs2.sl -

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

236
2.12

302.90

Dec 10 2003 02:05PM
The char
parameters

ff0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
All done processing rows.
PASS: rpc_ct_param

rpc_ct_setparam.c: submit a stored procedure using ct_setparam

ROW RESULTS

TW
roc15 big5 roc15=big5 default libhp15.sl,_mblen_hp
roc15 chinte roc15=chinte libhpbcd.sl -
roc15 eucTW roc15=eucTW default libh is(hp), sjishi, sjispc,
jis, cp930, cp939, japae)
#
eucJP cp930 eucJP=cp930 libeucJPbcd.sl -
eucJP cp939 eucJP=cp939 libeucJPbcd.sl -
eucJP jis eucJP=jis libeucJPjis.sl -
eucJP sjishi eucJP=sjishi default libeucJP.sl,_mblen_eucJP
eucJP sjis eucJP=sjishp default ucJP=sjispc default
libeucJP.sl,_mblen_eucJP
sjis cp930 sjishp=cp930 libsjisbcd.sl -
sjis cp939 sjishp=cp939 libsjisbcd.sl -
sjis j is sjishp=jis libsjisjis.sl -
sjis eucJP sjishp=eucJP default libsjis.sl,_mblen_sjis
sjishi jis sjishi=jis libsjisjis.sl -
sjishi e blen_sjis
sjispc jis sjispc=jis libsjisjis.sl -
sjispc eucJP sjispc=eucJP default libsjis.sl,_mblen_sjis
jis eucJP - libjiseucJP.s -
jis sjis jis=sjishp libjissjis.sl -
jis sjispc jis=sjispc libjissjis.sl -
japae eucJP japae=eucJP libbcdhp.sl -
japae sjis japae=s
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------

Open Client Message:
Message number: LAYER = (0) ORIGIN = (0) SEVERITY = (9) NUMBER = (96)
Message String: iconv E2BIG: Error converting between character sets. Output
buffer exhausted.

0000000000000000000000000000000000000000
All done processing rows.

Server message:
Message number: 0, Severity 0, State 1, Line 1
Server '*******'
Procedure 'sample_rpc'
Message String: This is the message printed out by sample_rpc.

STATUS RESULTS

-----------
0
All done processing rows.

Open Client Message:
Message number: LAYER = (0) ORIGIN = (0) SEVERITY = (9) NUMBER = (96)
Message String: iconv E2BIG: Error converting between character sets. Output
buffer exhausted.

PARAMETER RESULTS

@sintparam=jis libeucJPjis.sl -
eucJP sjishi eucJP=sjishi default libeucJP.sl,_mblen_eucJP
eucJP sjis eucJP=sjishp default @floatparam
libeucJP.sl,_mblen_eucJP
sjis cp930 sjishp=cp930 libsjisbcd.sl -
sjis cp939 sjishp=cp939 libsjisbcd.sl -
sjis j @moneyparamisjis.sl -
sjis eucJP sjishp=eucJP default libsjis.sl,_mblen_sjis
sjishi jis sjishi=jis libsjisjis.sl -
sjishi e @dateparamis sjispc=jis libsjisjis.sl -
sjispc eucJP sjispc=eucJP default libsjis.sl,_mblen_sjis
jis eucJP - libjiseucJP.s @charparamshp libjissjis.sl
-
jis sjispc jis=sjispc libjissjis.sl -
japae eucJP japae=eucJP libbcdhp.sl -
japae sjis japae=s @binaryparam930 sjis cp930=sjishp
libbcdhp.sl -
cp939 eucJP cp939=eucJP libbcdhp.sl -
cp939 sjis cp939=sjish@

-----------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Dec 10
2003 02:05PM
The char parameters

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
All done processing rows.

ROW RESULTS

char parameters

--------------------------------------------------------- ------
-------------------- ------------------------ ------------------------------
-------------------- ------------------------------------------

Open Client Message:
Message number: LAYER = (0) ORIGIN = (0) SEVERITY = (9) NUMBER = (96)
Message String: iconv E2BIG: Error converting between character sets. Output
buffer exhausted.

0000000000000000000000000000000000000000
All done processing rows.

Server message:
Message number: 0, Severity 0, State 1, Line 1
Server '*******'
Procedure 'sample_rpc'
Message String: This is the message printed out by sample_rpc.

STATUS RESULTS

-----------
0
All done processing rows.

Open Client Message:
Message number: LAYER = (0) ORIGIN = (0) SEVERITY = (9) NUMBER = (96)
Message String: iconv E2BIG: Error converting between character sets. Output
buffer exhausted.

PARAMETER RESULTS

@sintparam @floatparam @moneyparam @dateparam
@charparam
@binaryparam

----------- -------------------- ------------------------
------------------------------
------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Dec 10 2003
02:05PM The char parameters

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
All done processing rows.
PASS: rpc_ct_setparam

========================================
dblib
All tests passed.

freddy77

[freetds] HP/UX tests, ZIGLIO Frediano, 12/10/2003