Skip to Content.
Sympa Menu

freetds - Re: sybperl 2.15 again

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: sybperl 2.15 again
  • Date: 29 Oct 2002 08:32:41 -0800

On Tue, 2002-10-29 at 08:17, Steven J. Backus wrote:
> "Lowden, James K" <LowdenJK AT bernstein.com> writes:
> > For building with FreeTDS you can now add -DNOBLK to the
> > EXTRA_DEFS line in CONFIG. ^^^^^^
>
> Yep did that.
>
> Michael Peppler <mpeppler AT peppler.org> writes:
> > cd CTlib; make test
>
> PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib
> -I/usr/perl5/5.00503/i86pc-solaris -I/usr/perl5/5.00503 -e 'use
> Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> t/ctlib.............cs_cmp(CS_DATETIME) failed at
> ../blib/lib/Sybase/CTlib.pm line 110.
> cs_cmp(CS_MONEY) failed at ../blib/lib/Sybase/CTlib.pm line 183.

The cs_calc/cs_cmp routines are just stubs, so they won't work. They are
only used if you set the UseMoney, UseNumeric or UseDateTime attributes.
These are turned off by default, so you shouldn't hit this problem by
accident.

> t/cursor............Your vendor has not defined Sybase::CTlib macro
> CS_CURSOR_DECLARE at t/cursor.t line 66
> dubious

You'd hit this if you tried to use ct_cursor() and friends to open
client-side cursors. I don't know of anyone who actually uses this
feature...

> t/nsql..............ok
> t/prepare...........No dynamic SQL statement is currently active on this
> handle. at t/prepare.t line 70.
> No dynamic SQL statement is currently active on this handle. at t/prepare.t
> line 77.

prepare.t tests for ct_dynamic() and friends (i.e. prepared statements
with ?-style placeholders). FreeTDS doesn't support that yet.

> > cd ../DBlib; make test
> PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib
> -I/usr/perl5/5.00503/i86pc-solaris -I/usr/perl5/5.00503 -e 'use
> Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> t/dblib.............Sybase message 5701, Severity 10, state 2
> Server `episun7'
> Line 0
> Changed database context to 'ged'.

Hmm - these should normally be hidden (I think...). Not a big deal,
though.

> Use of uninitialized value at t/dblib.t line 180.
> FAILED tests 20-22
> Failed 3/22 tests, 86.36% okay

Tests 20-22 test async calls (dbpoll() and friends). Won't work with
FreeTDS. No biggee.

> t/money.............Msg 5701, Level 10, State 2
> Server 'episun7',
> Changed database context to 'ged'.
>
> FAILED tests 2, 4-7, 9-13
> Failed 10/13 tests, 23.08% okay

Again - uses the UseMoney attribute to return CS_MONEY datatypes in
native format and the dbmnyXXX() routines to perform arithmetic on these
values. I guess that the dbmnyXXX() routines haven't been implemented
yet.

> Hmmm...might be necessary to redefine success, declare it, and move
> on.

I think that's about as good as it's going to get... :-)

Try writing some sample scripts and see how they behave using either
CTlib or DBlib.

Michael
--
Michael Peppler / mpeppler AT peppler.org / http://www.mbay.net/~mpeppler
mpeppler AT zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!

Attachment: signature.asc
Description: This is a digitally signed message part




Archive powered by MHonArc 2.6.24.

Top of Page