Skip to Content.
Sympa Menu

freetds - Re: [freetds] DBD::Sybase placeholder support

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] DBD::Sybase placeholder support
  • Date: Mon, 12 May 2008 16:03:26 +0200

James K. Lowden wrote:
I was provided with an interesting rumor today: it seems placeholders *do*
work in DBD::Sybase! I haven't been able to test it yet, but perhaps
someone out there would?

I just built freetds 0.82, and DBD::Sybase from CVS (all on MacOSX), and ran the tests against an ASE 12.5.4 db.

Summary:

Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/exec.t 4 1024 22 4 18.18% 19-22
t/main.t 1 256 34 1 2.94% 28
t/place.t 2 512 16 2 12.50% 13 16
t/xblob.t 2 512 11 2 18.18% 6 10
1 test and 61 subtests skipped.
Failed 4/15 test scripts, 73.33% okay. 9/342 subtests failed, 97.37% okay.


which is a lot better than it used to be.

The place.t script fails in areas that are in fact unrelated to placeholders:

lappy-peppler-org:DBD-Sybase mpeppler$ perl -Mblib t/place.t
1..16
ok 1 - Create table
ok 2 - prepare
cs_convert failed (to_numeric(222.333)) at t/place.t line 36.
ok 3 - insert 1
ok 4
ok 5
ok 6
ok 7
ok 8 - insert 2
cs_convert failed (to_numeric(222.333)) at t/place.t line 49.
ok 9 - insert 3 (fail)
ok 10 - prepare 2
ok 11 - select
ok 12 - fetch count
not ok 13
# Failed test in t/place.t at line 61.
# Structures begin differing at:
# $got->[0][1] = 'Jan 3 1998 12:00AM'
# $expected->[0][1] = 'Jan 3 1998 12:00:00:000AM'
ok 14
ok 15 - fetch 2
not ok 16
# Failed test in t/place.t at line 70.
# Structures begin differing at:
# $got->[0][1] = 'Jan 25 1998 12:00AM'
# $expected->[0][1] = 'Jan 25 1998 12:00:00:000AM'
# Looks like you failed 2 tests of 16.


So it looks like there are problems with calls to cs_convert(), and default date formats that differ from what OpenClient does.

So it does look like things are a lot better (at least with ASE as the back end).

Michael
--
Michael Peppler - Peppler Consulting SaRL
mpeppler AT peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html




Archive powered by MHonArc 2.6.24.

Top of Page