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.8 patch 32025, 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/pOwntgt/[EMAIL PROTECTED]/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/DBIx-SimplePerl......D[18616] db_open: args -> 'dbuser:dbpass:dsn' D[18616] db_open: open optional args -> 'AutoCommit => 1, RaiseError => 0' D[18616]: DBIx::SimplePerl database connection succeeded D[18616]: DBIx::SimplePerl database connection dump = $VAR1 = bless( { '_dbh' => bless( {}, 'DBI::db' ), 'debug' => 1 }, 'DBIx::SimplePerl' ); D[18616] db_create_table: SQL='CREATE TABLE "test1" ( number integer, fp number, name varchar(30))' D[18616] db_create_table: prepare succeeded D[18616] db_create_table: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES ("2","1.2","joe")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES ("3","1.4","oje")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES ("4","1.6","eoj")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_update: prepare = 'UPDATE "test1" SET fp="1.8" WHERE number="3"' D[18616] db_update: prepare succeeded D[18616] db_update: execute succeeded D[18616] db_search: prepare = 'SELECT * FROM "test1" WHERE name="joe"' D[18616] db_search: prepare succeeded prepare: SELECT * FROM "test1" WHERE name="joe" D[18616] db_search: executing search D[18616] db_search: execute succeeded joe: 2 1.2 D[18616] db_delete: SQL='DELETE FROM "test1" WHERE name="joe"' D[18616] db_delete: prepare succeeded D[18616] db_delete: execute succeeded D[18616] db_close D[18616] db_open: args -> 'dbuser:dbpass:dsn:AutoCommit' D[18616] db_open: open optional args -> 'AutoCommit => 0, RaiseError => 0' D[18616]: DBIx::SimplePerl database connection succeeded D[18616]: DBIx::SimplePerl database connection dump = $VAR1 = bless( { '_sth' => undef, 'quote' => { 'value' => '"', 'table' => '"', 'field' => '' }, '_dbh' => bless( {}, 'DBI::db' ), 'debug' => 1 }, 'DBIx::SimplePerl' ); D[18616] db_create_table: SQL='CREATE TABLE "test2" ( number integer, q text, fp number, name text)' D[18616] db_create_table: prepare succeeded D[18616] db_create_table: execute succeeded D[18616] db_commit D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("0","b","0","a0-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("1","b","1.1","a1-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("2","b","2.2","a2-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("3","a","3.3","a3-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("4","b","4.4","a4-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("5","b","5.5","a5-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("6","a","6.6","a6-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("7","b","7.7","a7-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("8","b","8.8","a8-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("9","b","9.9","a9-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("10","a","11","a10-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("11","b","12.1","a11-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("12","b","13.2","a12-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("13","b","14.3","a13-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("14","b","15.4","a14-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("15","b","16.5","a15-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("16","a","17.6","a16-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("17","b","18.7","a17-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("18","a","19.8","a18-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("19","a","20.9","a19-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("20","a","22","a20-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("21","a","23.1","a21-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("22","b","24.2","a22-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("23","b","25.3","a23-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("24","b","26.4","a24-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("25","b","27.5","a25-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("26","b","28.6","a26-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("27","a","29.7","a27-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("28","a","30.8","a28-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("29","b","31.9","a29-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("30","b","33","a30-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("31","b","34.1","a31-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("32","b","35.2","a32-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("33","a","36.3","a33-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("34","a","37.4","a34-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("35","a","38.5","a35-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("36","a","39.6","a36-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("37","a","40.7","a37-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("38","a","41.8","a38-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("39","b","42.9","a39-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("40","a","44","a40-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("41","a","45.1","a41-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("42","a","46.2","a42-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("43","b","47.3","a43-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("44","b","48.4","a44-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("45","b","49.5","a45-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("46","b","50.6","a46-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("47","a","51.7","a47-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("48","a","52.8","a48-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("49","a","53.9","a49-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("50","b","55","a50-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("51","b","56.1","a51-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("52","a","57.2","a52-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("53","a","58.3","a53-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("54","a","59.4","a54-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("55","b","60.5","a55-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("56","a","61.6","a56-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("57","b","62.7","a57-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("58","a","63.8","a58-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("59","b","64.9","a59-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("60","a","66","a60-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("61","b","67.1","a61-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("62","a","68.2","a62-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("63","a","69.3","a63-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("64","b","70.4","a64-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("65","a","71.5","a65-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("66","a","72.6","a66-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("67","a","73.7","a67-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("68","b","74.8","a68-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("69","b","75.9","a69-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("70","a","77","a70-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("71","b","78.1","a71-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("72","b","79.2","a72-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("73","a","80.3","a73-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("74","a","81.4","a74-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("75","b","82.5","a75-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("76","b","83.6","a76-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("77","a","84.7","a77-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("78","b","85.8","a78-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("79","b","86.9","a79-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("80","b","88","a80-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("81","a","89.1","a81-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("82","a","90.2","a82-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("83","a","91.3","a83-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("84","a","92.4","a84-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("85","a","93.5","a85-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("86","a","94.6","a86-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("87","b","95.7","a87-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("88","b","96.8","a88-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("89","a","97.9","a89-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("90","a","99","a90-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("91","a","100.1","a91-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("92","a","101.2","a92-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("93","a","102.3","a93-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("94","b","103.4","a94-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("95","b","104.5","a95-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("96","b","105.6","a96-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("97","b","106.7","a97-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("98","a","107.8","a98-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("99","b","108.9","a99-b")' D[18616] db_add: prepare succeeded D[18616] db_add: execute succeeded D[18616] db_commit D[18616] db_search: prepare = 'SELECT count(number) FROM "test1"' D[18616] db_search: prepare succeeded prepare: SELECT count(number) FROM "test1" D[18616] db_search: executing search D[18616] db_search: execute succeeded ************************** DISTINCT *********** D[18616] db_search: prepare = 'SELECT DISTINCT number FROM "test2"' D[18616] db_search: prepare succeeded prepare: SELECT DISTINCT number FROM "test2" D[18616] db_search: executing search D[18616] db_search: execute succeeded D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 0 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 1 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 2 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 3 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 4 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 5 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 6 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 7 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 8 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 9 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 10 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 11 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 12 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 13 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 14 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 15 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 16 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 17 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 18 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 19 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 20 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 21 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 22 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 23 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 24 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 25 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 26 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 27 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 28 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 29 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 30 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 31 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 32 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 33 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 34 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 35 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 36 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 37 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 38 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 39 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 40 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 41 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 42 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 43 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 44 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 45 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 46 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 47 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 48 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 49 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 50 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 51 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 52 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 53 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 54 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 55 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 56 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 57 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 58 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 59 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 60 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 61 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 62 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 63 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 64 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 65 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 66 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 67 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 68 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 69 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 70 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 71 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 72 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 73 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 74 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 75 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 76 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 77 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 78 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 79 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 80 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 81 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 82 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 83 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 84 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 85 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 86 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 87 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 88 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 89 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 90 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 91 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 92 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 93 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 94 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 95 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 96 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 97 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 98 }; D[18616] db_next: returning hashref distinct return=$VAR1 = { 'number' => 99 }; D[18616] db_next: returning hashref D[18616] db_search: prepare = 'SELECT * FROM "test2" WHERE number="10"' D[18616] db_search: prepare succeeded prepare: SELECT * FROM "test2" WHERE number="10" D[18616] db_search: executing search D[18616] db_search: execute succeeded D[18616] db_next: returning hashref search_operator return=$VAR1 = { 'number' => 10, 'q' => 'a', 'name' => 'a10-b', 'fp' => 11 }; D[18616] db_next: returning hashref D[18616] db_search: prepare = 'SELECT max(fp) FROM "test1"' D[18616] db_search: prepare succeeded prepare: SELECT max(fp) FROM "test1" D[18616] db_search: executing search D[18616] db_search: execute succeeded D[18616] db_search: prepare = 'SELECT max(fp) FROM "test2"' D[18616] db_search: prepare succeeded prepare: SELECT max(fp) FROM "test2" D[18616] db_search: executing search D[18616] db_search: execute succeeded D[18616] db_search: prepare = 'SELECT min(fp) FROM "test1"' D[18616] db_search: prepare succeeded prepare: SELECT min(fp) FROM "test1" D[18616] db_search: executing search D[18616] db_search: execute succeeded D[18616] db_search: prepare = 'SELECT min(fp) FROM "test2"' D[18616] db_search: prepare succeeded prepare: SELECT min(fp) FROM "test2" D[18616] db_search: executing search D[18616] db_search: execute succeeded D[18616] db_search: prepare = 'SELECT * FROM "test1" WHERE number in ("1", "2", "3", "4", "5")' D[18616] db_search: prepare succeeded prepare: SELECT * FROM "test1" WHERE number in ("1", "2", "3", "4", "5") D[18616] db_search: executing search D[18616] db_search: execute succeeded D[18616] db_search: prepare = 'SELECT * FROM "test2" WHERE number in ("10", "20", "30")' D[18616] db_search: prepare succeeded prepare: SELECT * FROM "test2" WHERE number in ("10", "20", "30") D[18616] db_search: executing search D[18616] db_search: execute succeeded D[18616] db_rows: returning 0 rows=0 D[18616] db_next: returning hashref return=$VAR1 = { 'number' => 10, 'q' => 'a', 'name' => 'a10-b', 'fp' => 11 }; D[18616] db_next: returning hashref return=$VAR1 = { 'number' => 20, 'q' => 'a', 'name' => 'a20-b', 'fp' => 22 }; D[18616] db_next: returning hashref return=$VAR1 = { 'number' => 30, 'q' => 'b', 'name' => 'a30-b', 'fp' => 33 }; D[18616] 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[18616] 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-ClcqDg/blib/lib/DBIx/SimplePerl.pm line 910. D[18616]: DBIx::SimplePerl database error '1' D[18616] 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-ClcqDg/blib/lib/DBIx/SimplePerl.pm line 982. D[18616]: DBIx::SimplePerl database error '1' D[18616] 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-ClcqDg/blib/lib/DBIx/SimplePerl.pm line 982. D[18616]: DBIx::SimplePerl database error '1' D[18616] db_close ok All tests successful. Files=1, Tests=25, 1 wallclock secs ( 0.07 usr 0.01 sys + 0.30 cusr 0.02 csys = 0.40 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 = 18538 PERL5_CPAN_IS_RUNNING = 18538 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/pOwntgt/[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.2808 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 8 patch 32025) configuration: Platform: osname=linux, osvers=2.6.22-1-k7, archname=i686-linux-64int uname='linux k75 2.6.22-1-k7 #1 smp sun jul 29 15:15:55 utc 2007 i686 gnulinux ' config_args='-Dprefix=/home/src/perl/repoperls/installed-perls/maint-5.8/pOwntgt/[EMAIL PROTECTED] -Dinstallusrbinperl=n -Uversiononly -Dusedevel -des -Duse64bitint' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=define d_sfio=undef uselargefiles=define usesocks=undef use64bitint=define use64bitall=undef uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='cc', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O2', cppflags='-fno-strict-aliasing -pipe -I/usr/local/include' ccversion='', gccversion='4.1.2 20061115 (prerelease) (Debian 4.1.1-21)', 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 /usr/lib64 libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc libc=/lib/libc-2.6.1.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='2.6.1' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E' cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib'
