Re: make test of DBD-Sybase-1.04_15 (using freetds 0.62.4

On Wed, 2004-12-08 at 03:35, Eric Titmas wrote:
> I've installed these, when I run make test I get more errors than the
> README mentions. Are they ok ? if not, what should I do?
> 
> Regards,
> Eric Titmas
> 
> Here's what the README.freetds says to expect:
> 
> The "make test" process will fail for a number of tests:
> 
> Failed Test Stat Wstat Total Fail  Failed  List of Failed
> -------------------------------------------------------------------------------
> t/exec.t       0   139    ??   ??       %  ??
> t/main.t                  16    2  12.50%  13-14
> t/xblob.t                  6    2  33.33%  5-6
> 13 subtests skipped.

The README is very much out-of-date. Thanks for reminding me that I need
to fix it.

> Here's what I got:
> 
> PERL_DL_NONLAZY=1 /bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/autocommit....cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> FAILED tests 3-4

Hmmm - that's a new one. I've changed the way the CS_LOCALE struct is
allocated and used, and in when used with Sybase libs this works
normally.

In previous versions the locale was configured for each connection, now
I store the locale in the context and share it among connections that
use the same configuration (same charset, etc)

I guess FreeTDS doesn't (yet) allow us to store the CS_LOCALE data in
the CS_CONTEXT:

    if(retcode == CS_SUCCEED) {
	if((retcode = cs_config(context, CS_SET, CS_LOC_PROP, locale, 
				CS_UNUSED, NULL)) != CS_SUCCEED) {
		warn("cs_config(CS_LOC_PROP) failed");
	}

Any comments from FreeTDS?


>       Failed 2/4 tests, 50.00% okay
> t/base..........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> ok
> t/exec..........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> dubious
>       Test returned status 0 (wstat 139, 0x8b)
>       test program seems to have generated a core
> DIED. FAILED tests 5-17
>       Failed 13/17 tests, 23.53% okay
> t/fail..........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> FAILED tests 2, 5, 10, 12
>       Failed 4/13 tests, 69.23% okay (less 3 skipped tests: 6 okay, 46.15%)
> t/login.........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> ok
> t/main..........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> Setting of CS_OPT_TEXTSIZE failed. at t/main.t line 123.
> type_info_all result has 19 keys but 20 fields at t/main.t line 180
> dubious
>       Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 18-19
>       Failed 2/19 tests, 89.47% okay
> t/multi_sth.....cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> Panic: dynamic SQL (? placeholders) are not supported by the server you are connecting to at
> /home/ssds/titmas/sybase/DBD-Sybase-1.04_15/blib/lib/DBD/Sybase.pm line 160.
> # Looks like you planned 43 tests but only ran 9.
> # Looks like your test died just after 9.
> dubious
>       Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 10-43
>       Failed 34/43 tests, 20.93% okay
> t/nsql..........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> ok
> t/place.........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> ?-style placeholders aren't supported with this SQL Server.
> ok
>         10/11 skipped:
> t/thread........skipped
>         all skipped: this perl 5.008003 not configured to support iThreads
> t/xblk..........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> #     Failed test (t/xblk.t at line 73)
> Can't call method "execute" on an undefined value at t/xblk.t line 83.
> # Looks like you planned 62 tests but only ran 5.
> # Looks like your test died just after 5.
> dubious
>       Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 5-62
>       Failed 58/62 tests, 6.45% okay
> t/xblob.........cs_config(CS_LOC_PROP) failed at /usr/local/lib/perl5/5.8.3/sun4-solaris/DynaLoader.pm line 249.
> Use of uninitialized value in print at t/xblob.t line 56.
> Setting of CS_OPT_TEXTSIZE failed. at t/xblob.t line 63.
> Use of uninitialized value in unpack at t/xblob.t line 76.
> Use of uninitialized value in print at t/xblob.t line 130.
> DBD::Sybase::st syb_ct_send_data failed: Server message number=170 severity=15 state=1 line=1 server=SDOCQWEB01 text=Line 1: Incorrect syntax near
> '0x00000000000000000000000000000000'. at t/xblob.t line 134.
> Setting of CS_OPT_TEXTSIZE failed. at t/xblob.t line 138.
> Use of uninitialized value in unpack at t/xblob.t line 152.
> FAILED tests 5, 9
>       Failed 2/10 tests, 80.00% okay
> Failed 7/12 test scripts, 41.67% okay. 115/193 subtests failed, 40.41% okay.
> Failed Test    Stat Wstat Total Fail  Failed  List of Failed
> -------------------------------------------------------------------------------
> t/autocommit.t                4    2  50.00%  3-4
> t/exec.t          0   139    17   25 147.06%  5-17
> t/fail.t                     13    4  30.77%  2 5 10 12
> t/main.t        255 65280    19    4  21.05%  18-19
> t/multi_sth.t   255 65280    43   68 158.14%  10-43
> t/xblk.t        255 65280    62  115 185.48%  5-62
> t/xblob.t                    10    2  20.00%  5 9
> 1 test and 13 subtests skipped.
> make: *** [test_dynamic] Error 29
> 
> 
-- 
Michael Peppler  -  [email protected]  -  http://www.peppler.org/
Sybase DBA/Developer
Available for contract work - http://www.peppler.org/resume.html