Re: DBD::Oracle Release Candidate 1

On 16/02/11 11:32, H.Merijn Brand wrote:
> On Fri, 11 Feb 2011 13:43:34 -0500, John Scoles<[email protected]>
> wrote:
>
>> Here is the latest and greatest DBD::Oracle for your programming pleasure.
>>
>> You can find the Zip file here
>
> A ZIP is a quite unusual way to release CPAN modules, even for RC's
>
>> <a
>> href="http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zip">DBD-Oracle-1.28-RC1.zip</A>
>
> You need to work on longdouble support I guess
>
> Sorry for the long mail. I think it contains a lot of info to digest :)
>
> A summary for a few boxes ...
>
<snipped Merijn's results>

Like Merijn I also get 31lob failures on linux 64 bit. I was using database 11.1.0.6.0 and Instant Client11.2.0.2.0. Results below.

Also, if line 1735 of oci8.c is changed to:

		PerlIO_printf(DBILOGFP, "	blob_read field %d, ftype %d, offset %ld, len %lu, destoffset %ld, retlen %lu\n",
                       fbh->field_num+1, ftype, offset, (unsigned long)len, destoffset, ul_t(amtp));

it makes a legitimate warning go away.

t/31lob....1..12
ok 1 - returned valid locator
ok 2 - inserted into BLOB successfully
ok 3 - got back what we put in
ok 4 - returned valid locator
ok 5 - returned valid locator
ok 6 - returned initialized locator
ok 7 - returned length
ok 8 - returned written value

not ok 9 - returned length via PL/SQL
#   Failed test 'returned length via PL/SQL'
#   at t/31lob.t line 152.
#          got: undef
#     expected: '40000'
Errors in file :
OCI-21500: internal error code, arguments: [kghufree_06], [0x000A8C6D8], [0], [0], [0], [], [], []
��������������������������������������������������������������������������������������������������������`8<��������������������������Z��S+������������������������Z��S+������������������������Z��S+0:<��0:<��0:<��0:<��0:<��0:<��0:<��0:<��Errors in file :
OCI-21500: internal error code, arguments: [kghufree_06], [0x000A8C6D8], [0], [0], [0], [], [], []
��������������������������������������������������������������������������������������������������������P:<��������������������������Z��S+������������������������Z��S+������������������������Z��S+ <<�� <<�� <<�� <<�� <<�� <<�� <<�� <<��dubious
	Test returned status 1 (wstat 256, 0x100)
DIED. FAILED tests 9-12
	Failed 4/12 tests, 66.67% okay
Failed Test Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/31lob.t      1   256    12    7  58.33%  9-12
Failed 1/1 test scripts, 0.00% okay. 4/12 subtests failed, 66.67% okay.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com