FAQ
First off, sorry if any of you received this more than once. I erred in the
mail headers, and my attempts to correct were less than good


After a very tedious process of installing mysql-4.1.10 on HP-UX (both 11.00
and 11.11), I ran into trouble with building the DBD modules

using perl-5.8.5-dor, the builds fail because you need shared libs, something
mysql kindly prevented by `forgetting' the +Z flag, so ld barfs out (I mailed
them with the request to add it for builds to follow).

So I had to rebuild the whole damn thing from scratch just to get me a
libmysqlclient.sl

Now the DBD's build, but there are some strange failures (same for DBI-1.43
and DBI-1.47)

a5:/pro/3gl/CPAN/DBD-mysql-2.9004 176 > make test
PERL_DL_NONLAZY=1 /pro/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok
t/10dsnlist........ok
t/20createdrop.....ok
t/30insertfetch....ok
t/40bindparam......FAILED test 23
Failed 1/28 tests, 96.43% okay
t/40blobs..........ok
t/40listfields.....Use of uninitialized value in numeric eq (==) at t/40listfields.t line 132.
t/40listfields.....ok
t/40nulls..........ok
t/40numrows........ok
t/50chopblanks.....ok
t/50commit.........ok
t/60leaks..........skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed
t/ak-dbd...........ok
t/akmisc...........NOK 342Use of uninitialized value in numeric eq (==) at t/akmisc.t line 770.
t/akmisc...........FAILED test 342
Failed 1/351 tests, 99.72% okay
t/dbdadmin.........ok
t/insertid.........ok
t/mysql............ok
t/mysql2...........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/40bindparam.t 28 1 3.57% 23
t/akmisc.t 351 1 0.28% 342
1 test skipped.
Failed 2/18 test scripts, 88.89% okay. 2/767 subtests failed, 99.74% okay.
make: *** [test_dynamic] Error 2
Exit 2
a5:/pro/3gl/CPAN/DBD-mysql-2.9004 177 >

failing lines marked with *

40bindparam:

# Now try the explicit type settings
Test($state or $cursor->bind_param(1, " 4", SQL_INTEGER()))
or DbiError($dbh->err, $dbh->errstr);
* Test($state or $cursor->bind_param(2, "Andreas König"))
or DbiError($dbh->err, $dbh->errstr);
Test($state or $cursor->execute)
or DbiError($dbh->err, $dbh->errstr);

40listfields:

# NUM_OF_FIELDS should be zero (Non-Select)
* Test($state or ($cursor->{'NUM_OF_FIELDS'} == 0))
or !$verbose or printf("NUM_OF_FIELDS is %s, not zero.\n",
$cursor->{'NUM_OF_FIELDS'});
Test($state or (undef $cursor) or 1);

akmisc:

if ($mdriver eq 'mysql') {
* Test($state or ($sth->numfields == 0))
or printf("Expected num fields being zero, not %s.\n",
$sth->numfields);
}


Currently I cannot test with perl-5.9.2, because I only have a 64bit version,
and the mysql stuff is all 32bit

On HP-UX 11.11 (11i) where I /only/ have 64bit perl and mysql, I get almost the same, except that the libs mysql ships for 11.11 are shared, which makes it much easier to continue.

r3:/pro/3gl/CPAN/DBD-mysql-2.9004 110 > make test
PERL_DL_NONLAZY=1 /pro/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok
t/10dsnlist........ok
t/20createdrop.....ok
t/30insertfetch....ok
t/40bindparam......ok
t/40blobs..........ok
t/40listfields.....Use of uninitialized value in numeric eq (==) at t/40listfields.t line 132.
t/40listfields.....ok
t/40nulls..........ok
t/40numrows........ok
t/50chopblanks.....ok
t/50commit.........ok
t/60leaks..........skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed
t/ak-dbd...........ok
t/akmisc...........ok 50/351Use of uninitialized value in numeric eq (==) at t/akmisc.t line 770.
t/akmisc...........ok
t/dbdadmin.........ok 19/21t
t/dbdadmin.........ok
t/insertid.........ok
t/mysql............FAILED test 21
Failed 1/68 tests, 98.53% okay
t/mysql2...........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/mysql.t 68 1 1.47% 21
1 test skipped.
Failed 1/18 test scripts, 94.44% okay. 1/761 subtests failed, 99.87% okay.
make: *** [test_dynamic] Error 2
Exit 2
r3:/pro/3gl/CPAN/DBD-mysql-2.9004 111 >

The sock test (21) in t/mysql.t could be more lenient towards either HP-UX 11.11
or 64bit environments, because the test fails on /^\d+$/ where the result is a
very large, but negative, number

--8<--- Added print and -? to regex
# Some quick checks about the contents of the handle...
$dbh2->database eq $dbname and print("ok 20\n") or print("not ok 20\n");
print STDERR "# sock = ", $dbh2->sock, "\n";
$dbh2->sock =~ /^-?\d+$/ and print("ok 21\n") or print("not ok 21\n");
-->8---

# sock = -9223372032556295928


--
H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/)
using Perl 5.6.2, 5.8.0, 5.8.5, & 5.9.2 on HP-UX 10.20, 11.00 & 11.11,
AIX 4.3 & 5.2, SuSE 9.1 & 9.2, and Cygwin. http://www.cmve.net/~merijn
Smoking perl: http://www.test-smoke.org, perl QA: http://qa.perl.org
reports to: smokers-reports@perl.org, perl-qa@perl.org

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-dev @
categoriesperl
postedMar 11, '05 at 4:16p
activeMar 11, '05 at 4:16p
posts1
users1
websitedbi.perl.org

1 user in discussion

H.Merijn Brand: 1 post

People

Translate

site design / logo © 2019 Grokbase