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