This distribution has been tested as part of the cpan-testers
effort to test as many new uploads to CPAN as possible.  See
http://testers.cpan.org/

Please cc any replies to [email protected] to keep other
test volunteers informed and to prevent any duplicate effort.

--
Dear Joseph Landman,
    
This is a computer-generated report for DBIx-SimplePerl-1.90
on perl-5.8.7, created automatically by CPAN-Reporter-1.06 
and sent to the CPAN Testers mailing list.  

If you have received this email directly, it is because the person testing 
your distribution chose to send a copy to your CPAN email address; there 
may be a delay before the official report is received and processed 
by CPAN Testers.

Thank you for uploading your work to CPAN.  Congratulations!
All tests were successful.

Sections of this report:

    * Tester comments
    * Program output
    * Prerequisites
    * Environment and other context

------------------------------
TESTER COMMENTS
------------------------------

Additional comments from tester: 

[none provided]

------------------------------
PROGRAM OUTPUT
------------------------------

Output from '/usr/bin/make test':

PERL_DL_NONLAZY=1 
/home/src/perl/repoperls/installed-perls/maint-5.8/pbyWflA/[EMAIL 
PROTECTED]/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 
'blib/arch')" t/*.t
t/DBIx-SimplePerl......D[18734] db_open: args -> 'dbuser:dbpass:dsn'
D[18734] db_open: open optional args -> 'AutoCommit => 1, RaiseError => 0'
D[18734]: DBIx::SimplePerl database connection succeeded
D[18734]: DBIx::SimplePerl database connection dump = $VAR1 = bless( {
                 '_dbh' => bless( {}, 'DBI::db' ),
                 'debug' => 1
               }, 'DBIx::SimplePerl' );

D[18734] db_create_table: SQL='CREATE TABLE "test1" (
        number   integer,
        fp   number,
        name   varchar(30))'
D[18734] db_create_table: prepare succeeded
D[18734] db_create_table: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES 
("2","1.2","joe")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES 
("3","1.4","oje")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES 
("4","1.6","eoj")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_update: prepare = 'UPDATE "test1"  SET fp="1.8" WHERE number="3"' 
D[18734] db_update: prepare succeeded
D[18734] db_update: execute succeeded
D[18734] db_search: prepare = 'SELECT * FROM "test1" WHERE name="joe"' 
D[18734] db_search: prepare succeeded
prepare: SELECT * FROM "test1" WHERE name="joe"
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
joe:    2       1.2
D[18734] db_delete: SQL='DELETE FROM "test1" WHERE name="joe"'
D[18734] db_delete: prepare succeeded
D[18734] db_delete: execute succeeded
D[18734] db_close
D[18734] db_open: args -> 'dbuser:dbpass:dsn:AutoCommit'
D[18734] db_open: open optional args -> 'AutoCommit => 0, RaiseError => 0'
D[18734]: DBIx::SimplePerl database connection succeeded
D[18734]: DBIx::SimplePerl database connection dump = $VAR1 = bless( {
                 '_sth' => undef,
                 'quote' => {
                              'value' => '"',
                              'table' => '"',
                              'field' => ''
                            },
                 '_dbh' => bless( {}, 'DBI::db' ),
                 'debug' => 1
               }, 'DBIx::SimplePerl' );

D[18734] db_create_table: SQL='CREATE TABLE "test2" (
        number   integer,
        q   text,
        fp   number,
        name   text)'
D[18734] db_create_table: prepare succeeded
D[18734] db_create_table: execute succeeded
D[18734] db_commit
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("0","a","0","a0-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("1","a","1.1","a1-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("2","a","2.2","a2-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("3","b","3.3","a3-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("4","b","4.4","a4-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("5","b","5.5","a5-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("6","b","6.6","a6-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("7","a","7.7","a7-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("8","b","8.8","a8-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("9","a","9.9","a9-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("10","a","11","a10-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("11","a","12.1","a11-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("12","b","13.2","a12-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("13","a","14.3","a13-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("14","b","15.4","a14-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("15","a","16.5","a15-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("16","a","17.6","a16-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("17","a","18.7","a17-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("18","a","19.8","a18-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("19","b","20.9","a19-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("20","a","22","a20-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("21","a","23.1","a21-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("22","a","24.2","a22-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("23","a","25.3","a23-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("24","a","26.4","a24-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("25","a","27.5","a25-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("26","b","28.6","a26-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("27","a","29.7","a27-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("28","a","30.8","a28-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("29","a","31.9","a29-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("30","b","33","a30-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("31","b","34.1","a31-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("32","a","35.2","a32-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("33","a","36.3","a33-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("34","a","37.4","a34-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("35","b","38.5","a35-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("36","b","39.6","a36-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("37","a","40.7","a37-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("38","b","41.8","a38-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("39","a","42.9","a39-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("40","b","44","a40-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("41","b","45.1","a41-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("42","a","46.2","a42-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("43","b","47.3","a43-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("44","a","48.4","a44-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("45","b","49.5","a45-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("46","a","50.6","a46-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("47","b","51.7","a47-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("48","a","52.8","a48-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("49","a","53.9","a49-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("50","a","55","a50-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("51","a","56.1","a51-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("52","a","57.2","a52-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("53","b","58.3","a53-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("54","a","59.4","a54-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("55","b","60.5","a55-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("56","a","61.6","a56-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("57","a","62.7","a57-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("58","a","63.8","a58-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("59","a","64.9","a59-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("60","a","66","a60-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("61","b","67.1","a61-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("62","b","68.2","a62-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("63","a","69.3","a63-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("64","b","70.4","a64-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("65","b","71.5","a65-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("66","b","72.6","a66-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("67","b","73.7","a67-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("68","a","74.8","a68-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("69","a","75.9","a69-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("70","b","77","a70-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("71","b","78.1","a71-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("72","b","79.2","a72-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("73","a","80.3","a73-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("74","b","81.4","a74-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("75","a","82.5","a75-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("76","b","83.6","a76-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("77","a","84.7","a77-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("78","a","85.8","a78-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("79","a","86.9","a79-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("80","a","88","a80-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("81","a","89.1","a81-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("82","b","90.2","a82-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("83","a","91.3","a83-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("84","a","92.4","a84-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("85","a","93.5","a85-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("86","b","94.6","a86-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("87","b","95.7","a87-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("88","b","96.8","a88-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("89","b","97.9","a89-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("90","a","99","a90-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("91","b","100.1","a91-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("92","a","101.2","a92-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("93","a","102.3","a93-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("94","a","103.4","a94-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("95","b","104.5","a95-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("96","b","105.6","a96-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("97","b","106.7","a97-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("98","b","107.8","a98-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES 
("99","a","108.9","a99-b")' 
D[18734] db_add: prepare succeeded
D[18734] db_add: execute succeeded
D[18734] db_commit
D[18734] db_search: prepare = 'SELECT count(number) FROM "test1"' 
D[18734] db_search: prepare succeeded
prepare: SELECT count(number) FROM "test1"
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
**************************  DISTINCT *********** 
D[18734] db_search: prepare = 'SELECT DISTINCT number FROM "test2"' 
D[18734] db_search: prepare succeeded
prepare: SELECT DISTINCT number FROM "test2"
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 0
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 1
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 2
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 3
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 4
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 5
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 6
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 7
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 8
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 9
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 10
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 11
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 12
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 13
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 14
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 15
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 16
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 17
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 18
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 19
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 20
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 21
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 22
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 23
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 24
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 25
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 26
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 27
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 28
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 29
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 30
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 31
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 32
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 33
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 34
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 35
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 36
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 37
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 38
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 39
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 40
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 41
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 42
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 43
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 44
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 45
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 46
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 47
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 48
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 49
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 50
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 51
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 52
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 53
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 54
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 55
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 56
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 57
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 58
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 59
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 60
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 61
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 62
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 63
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 64
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 65
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 66
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 67
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 68
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 69
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 70
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 71
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 72
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 73
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 74
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 75
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 76
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 77
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 78
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 79
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 80
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 81
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 82
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 83
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 84
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 85
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 86
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 87
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 88
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 89
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 90
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 91
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 92
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 93
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 94
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 95
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 96
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 97
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 98
        };

D[18734] db_next: returning hashref
distinct return=$VAR1 = {
          'number' => 99
        };

D[18734] db_next: returning hashref
D[18734] db_search: prepare = 'SELECT * FROM "test2" WHERE number="10"' 
D[18734] db_search: prepare succeeded
prepare: SELECT * FROM "test2" WHERE number="10"
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
D[18734] db_next: returning hashref
search_operator return=$VAR1 = {
          'number' => 10,
          'q' => 'a',
          'name' => 'a10-b',
          'fp' => 11
        };

D[18734] db_next: returning hashref
D[18734] db_search: prepare = 'SELECT max(fp) FROM "test1"' 
D[18734] db_search: prepare succeeded
prepare: SELECT max(fp) FROM "test1"
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
D[18734] db_search: prepare = 'SELECT max(fp) FROM "test2"' 
D[18734] db_search: prepare succeeded
prepare: SELECT max(fp) FROM "test2"
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
D[18734] db_search: prepare = 'SELECT min(fp) FROM "test1"' 
D[18734] db_search: prepare succeeded
prepare: SELECT min(fp) FROM "test1"
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
D[18734] db_search: prepare = 'SELECT min(fp) FROM "test2"' 
D[18734] db_search: prepare succeeded
prepare: SELECT min(fp) FROM "test2"
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
D[18734] db_search: prepare = 'SELECT * FROM "test1" WHERE number in ("1", "2", 
"3", "4", "5")' 
D[18734] db_search: prepare succeeded
prepare: SELECT * FROM "test1" WHERE number in ("1", "2", "3", "4", "5")
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
D[18734] db_search: prepare = 'SELECT * FROM "test2" WHERE number in ("10", 
"20", "30")' 
D[18734] db_search: prepare succeeded
prepare: SELECT * FROM "test2" WHERE number in ("10", "20", "30")
D[18734] db_search: executing search
D[18734] db_search: execute succeeded
D[18734] db_rows: returning 0
rows=0
D[18734] db_next: returning hashref
return=$VAR1 = {
          'number' => 10,
          'q' => 'a',
          'name' => 'a10-b',
          'fp' => 11
        };

D[18734] db_next: returning hashref
return=$VAR1 = {
          'number' => 20,
          'q' => 'a',
          'name' => 'a20-b',
          'fp' => 22
        };

D[18734] db_next: returning hashref
return=$VAR1 = {
          'number' => 30,
          'q' => 'b',
          'name' => 'a30-b',
          'fp' => 33
        };

D[18734] db_next: returning hashref


## ERROR TESTS... these are to make sure we can catch/report
## error conditions properly
## incorrect table name, should fail.... without killing the program

D[18734] db_search: prepare = 'SELECT min(fp) FROM "test3"' 
DBD::SQLite::db prepare failed: no such table: test3(1) at dbdimp.c line 271 at 
/home/sand/.cpan/build/DBIx-SimplePerl-1.90-UeCzpF/blib/lib/DBIx/SimplePerl.pm 
line 910.
D[18734]: DBIx::SimplePerl database error '1'
D[18734] db_update: prepare = 'UPDATE "test3"  SET homedir="2" WHERE 
username="1"' 
DBD::SQLite::db prepare failed: no such table: test3(1) at dbdimp.c line 271 at 
/home/sand/.cpan/build/DBIx-SimplePerl-1.90-UeCzpF/blib/lib/DBIx/SimplePerl.pm 
line 982.
D[18734]: DBIx::SimplePerl database error '1'
D[18734] db_update: prepare = 'UPDATE "test3"  SET homedir="2" WHERE 
username="1"' 
DBD::SQLite::db prepare failed: no such table: test3(1) at dbdimp.c line 271 at 
/home/sand/.cpan/build/DBIx-SimplePerl-1.90-UeCzpF/blib/lib/DBIx/SimplePerl.pm 
line 982.
D[18734]: DBIx::SimplePerl database error '1'
D[18734] db_close
ok
All tests successful.
Files=1, Tests=25,  1 wallclock secs ( 0.05 usr  0.01 sys +  0.26 cusr  0.02 
csys =  0.34 CPU)
Result: PASS

------------------------------
PREREQUISITES
------------------------------

Prerequisite modules loaded:

requires:

    Module          Need Have 
    --------------- ---- -----
    Class::Accessor 0.22 0.31 
    DBI             1.5  1.601

------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------

Environment variables:

    LANG = de_DE.UTF-8
    PATH = 
/usr/lib/ccache:/home/sand/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/local/perl/bin:/usr/X11/bin:/sbin:/usr/sbin
    PERL5LIB = 
    PERL5_CPANPLUS_IS_RUNNING = 18655
    PERL5_CPAN_IS_RUNNING = 18655
    PERL_MM_USE_DEFAULT = 1
    SHELL = /usr/bin/zsh
    TERM = screen

Perl special variables (and OS-specific diagnostics, for MSWin32):

    $^X = /home/src/perl/repoperls/installed-perls/maint-5.8/pbyWflA/[EMAIL 
PROTECTED]/bin/perl
    $UID/$EUID = 1005 / 1005
    $GID = 1005 1005
    $EGID = 1005 1005

Perl module toolchain versions installed:

    Module              Have  
    ------------------- ------
    CPAN                1.9205
    Cwd                 3.25  
    ExtUtils::CBuilder  0.21  
    ExtUtils::Command   1.13  
    ExtUtils::Install   1.44  
    ExtUtils::MakeMaker 6.38  
    ExtUtils::Manifest  1.51  
    ExtUtils::ParseXS   2.18  
    File::Spec          3.25  
    Module::Build       0.2805
    Module::Signature   0.55  
    Test::Harness       3.04  
    Test::More          0.72  
    YAML                0.66  
    YAML::Syck          0.99  
    version             0.74  


--

Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
  Platform:
    osname=linux, osvers=2.6.14, archname=i686-linux-thread-multi-64int
    uname='linux k75 2.6.14 #1 fri jan 27 16:22:47 cet 2006 i686 gnulinux '
    
config_args='-Dprefix=/home/src/perl/repoperls/installed-perls/maint-5.8/pbyWflA/[EMAIL
 PROTECTED] -Dinstallusrbinperl=n -Uversiononly -des -Duse64bitint -Dusedevel 
-Dusethreads'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=define use5005threads=undef useithreads=define 
usemultiplicity=define
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=define use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS 
-fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include 
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
    optimize='-O2',
    cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS 
-fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include'
    ccversion='', gccversion='4.0.3 20060115 (prerelease) (Debian 4.0.2-7)', 
gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', 
lseeksize=8
    alignbytes=4, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib
    libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
    perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
    libc=/lib/libc-2.3.5.so, so=so, useshrplib=false, libperl=libperl.a
    gnulibc_version='2.3.5'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
    cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'

Reply via email to