Re: DBD::Sybase placeholder support

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
[email protected]      -                  http://www.peppler.org
Sybase DBA/Developer      -   TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ       -   http://www.peppler.org/FAQ/linux.html