Back
From: Steven Schubiger (SCHUBIGER)
Subject: PASS DBIx-SimplePerl-1.95 v5.12.2 GNU/Linux
Date: 2010-10-31T12:00:47Z
This distribution has been tested as part of the CPAN Testers
project, supporting the Perl programming language. See
http://wiki.cpantesters.org/ for more information or email
questions to cpan-testers-discuss@perl.org
--
Dear Joseph Landman,
This is a computer-generated report for DBIx-SimplePerl-1.95
on perl 5.12.2, created by CPAN-Reporter-1.1805.
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:
this report is from an automated smoke testing program
and was not reviewed by a human for accuracy
------------------------------
PROGRAM OUTPUT
------------------------------
Output from '/usr/bin/make test':
PERL_DL_NONLAZY=1 /home/sts/cpansmoke/perl-5.12.2/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
D[4969] db_open: args -> 'dbuser:dbpass:dsn'
D[4969] db_open: open optional args -> 'AutoCommit => 1, RaiseError => 0'
D[4969]: DBIx::SimplePerl database connection succeeded
D[4969]: DBIx::SimplePerl database connection dump = $VAR1 = bless( {
'_dbh' => bless( {}, 'DBI::db' ),
'debug' => 1
}, 'DBIx::SimplePerl' );
D[4969] db_create_table: SQL='CREATE TABLE "test1" (
number integer,
fp number,
name varchar(30))'
D[4969] db_create_table: prepare succeeded
D[4969] db_create_table: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES ("2","1.2","joe")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES ("3","1.4","oje")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test1" (number,fp,name) VALUES ("4","1.6","eoj")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_update: prepare = 'UPDATE "test1" SET fp="1.8" WHERE number="3"'
D[4969] db_update: prepare succeeded
D[4969] db_update: execute succeeded
D[4969] db_search: prepare = 'SELECT * FROM "test1" WHERE name="joe"'
D[4969] db_search: prepare succeeded
prepare: SELECT * FROM "test1" WHERE name="joe"
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
joe: 2 1.2
D[4969] db_delete: SQL='DELETE FROM "test1" WHERE name="joe"'
D[4969] db_delete: prepare succeeded
D[4969] db_delete: execute succeeded
D[4969] db_close
D[4969] db_open: args -> 'dbuser:dbpass:dsn:AutoCommit'
D[4969] db_open: open optional args -> 'AutoCommit => 0, RaiseError => 0'
D[4969]: DBIx::SimplePerl database connection succeeded
D[4969]: DBIx::SimplePerl database connection dump = $VAR1 = bless( {
'_sth' => undef,
'quote' => {
'value' => '"',
'table' => '"',
'field' => ''
},
'_dbh' => bless( {}, 'DBI::db' ),
'debug' => 1
}, 'DBIx::SimplePerl' );
D[4969] db_create_table: SQL='CREATE TABLE "test2" (
number integer,
q text,
fp number,
name text)'
D[4969] db_create_table: prepare succeeded
D[4969] db_create_table: execute succeeded
D[4969] db_commit
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("0","b","0","a0-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("1","a","1.1","a1-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("2","b","2.2","a2-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("3","a","3.3","a3-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("4","b","4.4","a4-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("5","a","5.5","a5-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("6","b","6.6","a6-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("7","b","7.7","a7-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("8","a","8.8","a8-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("9","b","9.9","a9-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("10","a","11","a10-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("11","b","12.1","a11-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("12","b","13.2","a12-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("13","a","14.3","a13-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("14","a","15.4","a14-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("15","b","16.5","a15-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("16","a","17.6","a16-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("17","b","18.7","a17-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("18","a","19.8","a18-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("19","a","20.9","a19-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("20","b","22","a20-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("21","a","23.1","a21-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("22","b","24.2","a22-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("23","a","25.3","a23-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("24","a","26.4","a24-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("25","a","27.5","a25-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("26","a","28.6","a26-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("27","a","29.7","a27-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("28","a","30.8","a28-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("29","b","31.9","a29-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("30","b","33","a30-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("31","a","34.1","a31-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("32","a","35.2","a32-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("33","b","36.3","a33-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("34","a","37.4","a34-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("35","a","38.5","a35-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("36","b","39.6","a36-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("37","a","40.7","a37-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("38","a","41.8","a38-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("39","a","42.9","a39-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("40","b","44","a40-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("41","b","45.1","a41-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("42","a","46.2","a42-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("43","b","47.3","a43-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("44","b","48.4","a44-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("45","a","49.5","a45-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("46","a","50.6","a46-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("47","a","51.7","a47-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("48","b","52.8","a48-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("49","a","53.9","a49-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("50","a","55","a50-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("51","a","56.1","a51-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("52","b","57.2","a52-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("53","a","58.3","a53-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("54","a","59.4","a54-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("55","a","60.5","a55-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("56","a","61.6","a56-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("57","a","62.7","a57-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("58","b","63.8","a58-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("59","a","64.9","a59-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("60","a","66","a60-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("61","a","67.1","a61-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("62","b","68.2","a62-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("63","b","69.3","a63-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("64","a","70.4","a64-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("65","b","71.5","a65-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("66","b","72.6","a66-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("67","b","73.7","a67-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("68","b","74.8","a68-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("69","a","75.9","a69-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("70","a","77","a70-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("71","a","78.1","a71-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("72","b","79.2","a72-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("73","b","80.3","a73-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("74","b","81.4","a74-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("75","a","82.5","a75-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("76","a","83.6","a76-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("77","a","84.7","a77-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("78","b","85.8","a78-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("79","b","86.9","a79-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("80","b","88","a80-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("81","b","89.1","a81-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("82","a","90.2","a82-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("83","a","91.3","a83-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("84","b","92.4","a84-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("85","a","93.5","a85-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("86","b","94.6","a86-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("87","a","95.7","a87-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("88","a","96.8","a88-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("89","b","97.9","a89-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("90","a","99","a90-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("91","a","100.1","a91-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("92","a","101.2","a92-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("93","a","102.3","a93-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("94","b","103.4","a94-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("95","a","104.5","a95-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("96","a","105.6","a96-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("97","a","106.7","a97-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("98","b","107.8","a98-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_add: prepare = 'INSERT INTO "test2" (number,q,fp,name) VALUES ("99","b","108.9","a99-b")'
D[4969] db_add: prepare succeeded
D[4969] db_add: execute succeeded
D[4969] db_commit
D[4969] db_search: prepare = 'SELECT count(number) FROM "test1"'
D[4969] db_search: prepare succeeded
prepare: SELECT count(number) FROM "test1"
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
************************** DISTINCT ***********
D[4969] db_search: prepare = 'SELECT DISTINCT number FROM "test2"'
D[4969] db_search: prepare succeeded
prepare: SELECT DISTINCT number FROM "test2"
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '0'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '1'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '2'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '3'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '4'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '5'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '6'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '7'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '8'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '9'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '10'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '11'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '12'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '13'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '14'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '15'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '16'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '17'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '18'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '19'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '20'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '21'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '22'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '23'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '24'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '25'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '26'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '27'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '28'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '29'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '30'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '31'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '32'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '33'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '34'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '35'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '36'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '37'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '38'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '39'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '40'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '41'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '42'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '43'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '44'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '45'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '46'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '47'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '48'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '49'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '50'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '51'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '52'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '53'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '54'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '55'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '56'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '57'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '58'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '59'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '60'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '61'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '62'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '63'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '64'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '65'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '66'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '67'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '68'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '69'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '70'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '71'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '72'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '73'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '74'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '75'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '76'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '77'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '78'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '79'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '80'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '81'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '82'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '83'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '84'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '85'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '86'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '87'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '88'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '89'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '90'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '91'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '92'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '93'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '94'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '95'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '96'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '97'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '98'
};
D[4969] db_next: returning hashref
distinct return=$VAR1 = {
'number' => '99'
};
D[4969] db_next: returning hashref
D[4969] db_search: prepare = 'SELECT * FROM "test2" WHERE number="10"'
D[4969] db_search: prepare succeeded
prepare: SELECT * FROM "test2" WHERE number="10"
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
D[4969] db_next: returning hashref
search_operator return=$VAR1 = {
'number' => '10',
'q' => 'a',
'name' => 'a10-b',
'fp' => '11'
};
D[4969] db_next: returning hashref
D[4969] db_search: prepare = 'SELECT max(fp) FROM "test1"'
D[4969] db_search: prepare succeeded
prepare: SELECT max(fp) FROM "test1"
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
D[4969] db_search: prepare = 'SELECT max(fp) FROM "test2"'
D[4969] db_search: prepare succeeded
prepare: SELECT max(fp) FROM "test2"
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
D[4969] db_search: prepare = 'SELECT min(fp) FROM "test1"'
D[4969] db_search: prepare succeeded
prepare: SELECT min(fp) FROM "test1"
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
D[4969] db_search: prepare = 'SELECT min(fp) FROM "test2"'
D[4969] db_search: prepare succeeded
prepare: SELECT min(fp) FROM "test2"
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
D[4969] db_search: prepare = 'SELECT * FROM "test1" WHERE number in ("1", "2", "3", "4", "5")'
D[4969] db_search: prepare succeeded
prepare: SELECT * FROM "test1" WHERE number in ("1", "2", "3", "4", "5")
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
D[4969] db_search: prepare = 'SELECT * FROM "test2" WHERE number in ("10", "20", "30")'
D[4969] db_search: prepare succeeded
prepare: SELECT * FROM "test2" WHERE number in ("10", "20", "30")
D[4969] db_search: executing search
D[4969] db_search: execute succeeded
D[4969] db_rows: returning 0
rows=0
D[4969] db_next: returning hashref
return=$VAR1 = {
'number' => '10',
'q' => 'a',
'name' => 'a10-b',
'fp' => '11'
};
D[4969] db_next: returning hashref
return=$VAR1 = {
'number' => '20',
'q' => 'b',
'name' => 'a20-b',
'fp' => '22'
};
D[4969] db_next: returning hashref
return=$VAR1 = {
'number' => '30',
'q' => 'b',
'name' => 'a30-b',
'fp' => '33'
};
D[4969] 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[4969] db_search: prepare = 'SELECT min(fp) FROM "test3"'
DBD::SQLite::db prepare failed: no such table: test3 at /home/sts/cpansmoke/perl-5.12.2/cpan/build/DBIx-SimplePerl-1.95-rrLWiK/blib/lib/DBIx/SimplePerl.pm line 934.
D[4969]: DBIx::SimplePerl database error '1'
D[4969] db_update: prepare = 'UPDATE "test3" SET homedir="2" WHERE username="1"'
DBD::SQLite::db prepare failed: no such table: test3 at /home/sts/cpansmoke/perl-5.12.2/cpan/build/DBIx-SimplePerl-1.95-rrLWiK/blib/lib/DBIx/SimplePerl.pm line 1006.
D[4969]: DBIx::SimplePerl database error '1'
D[4969] db_update: prepare = 'UPDATE "test3" SET homedir="2" WHERE username="1"'
DBD::SQLite::db prepare failed: no such table: test3 at /home/sts/cpansmoke/perl-5.12.2/cpan/build/DBIx-SimplePerl-1.95-rrLWiK/blib/lib/DBIx/SimplePerl.pm line 1006.
D[4969]: DBIx::SimplePerl database error '1'
D[4969] db_close
t/DBIx-SimplePerl.t .. ok
All tests successful.
Files=1, Tests=25, 1 wallclock secs ( 0.02 usr 0.00 sys + 0.08 cusr 0.01 csys = 0.11 CPU)
Result: PASS
------------------------------
PREREQUISITES
------------------------------
Prerequisite modules loaded:
requires:
Module Need Have
--------------- ---- -----
Class::Accessor 0.22 0.34
DBI 1.5 1.615
------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------
Environment variables:
AUTOMATED_TESTING = 1
LANG = en_US.UTF-8
PATH = /usr/local/bin:/usr/bin:/bin:/usr/games
PERL5LIB = /home/sts/cpansmoke/perl-5.12.2/cpan/build/Class-Accessor-0.34-ayfUwv/blib/arch:/home/sts/cpansmoke/perl-5.12.2/cpan/build/Class-Accessor-0.34-ayfUwv/blib/lib
PERL5OPT =
PERL5_CPANPLUS_IS_RUNNING = 4899
PERL5_CPAN_IS_RUNNING = 4899
PERL5_CPAN_IS_RUNNING_IN_RECURSION = 29183,4899
PERL_CR_SMOKER_CURRENT = DBIx-SimplePerl-1.95
PERL_EXTUTILS_AUTOINSTALL = --defaultdeps
PERL_MM_USE_DEFAULT = 1
SHELL = /bin/bash
TERM = screen
Perl special variables (and OS-specific diagnostics, for MSWin32):
$^X = /home/sts/cpansmoke/perl-5.12.2/bin/perl
$UID/$EUID = 1000 / 1000
$GID = 1000 1000
$EGID = 1000 1000
Perl module toolchain versions installed:
Module Have
------------------- -------
CPAN 1.94_56
Cwd 3.31
ExtUtils::CBuilder 0.27
ExtUtils::Command 1.16
ExtUtils::Install 1.55
ExtUtils::MakeMaker 6.56
ExtUtils::Manifest 1.57
ExtUtils::ParseXS 2.21
File::Spec 3.31_01
Module::Build 0.3603
Module::Signature n/a
Test::Harness 3.17
Test::More 0.94
YAML n/a
YAML::Syck 1.15
version 0.82
--
Summary of my perl5 (revision 5 version 12 subversion 2) configuration:
Platform:
osname=linux, osvers=2.6.26-2-openvz-686, archname=i686-linux-thread-multi
uname='linux cpansmoke1 2.6.26-2-openvz-686 #1 smp thu sep 16 22:16:19 utc 2010 i686 gnulinux '
config_args='-des -Dusethreads -Dprefix=/home/sts/cpansmoke/perl-5.12.2'
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 -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
ccversion='', gccversion='4.3.2', 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 =' -fstack-protector -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=/lib/libc-2.7.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.7'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib -fstack-protector'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_ITHREADS
USE_LARGE_FILES USE_PERLIO USE_PERL_ATOF
USE_REENTRANT_API
Built under linux
Compiled at Oct 27 2010 20:24:10
%ENV:
PERL5LIB="/home/sts/cpansmoke/perl-5.12.2/cpan/build/Class-Accessor-0.34-ayfUwv/blib/arch:/home/sts/cpansmoke/perl-5.12.2/cpan/build/Class-Accessor-0.34-ayfUwv/blib/lib"
PERL5OPT=""
PERL5_CPANPLUS_IS_RUNNING="4899"
PERL5_CPAN_IS_RUNNING="4899"
PERL5_CPAN_IS_RUNNING_IN_RECURSION="29183,4899"
PERL_CR_SMOKER_CURRENT="DBIx-SimplePerl-1.95"
PERL_EXTUTILS_AUTOINSTALL="--defaultdeps"
PERL_MM_USE_DEFAULT="1"
@INC:
/home/sts/cpansmoke/perl-5.12.2/cpan/build/Class-Accessor-0.34-ayfUwv/blib/arch
/home/sts/cpansmoke/perl-5.12.2/cpan/build/Class-Accessor-0.34-ayfUwv/blib/lib
/home/sts/cpansmoke/perl-5.12.2/lib/site_perl/5.12.2/i686-linux-thread-multi
/home/sts/cpansmoke/perl-5.12.2/lib/site_perl/5.12.2
/home/sts/cpansmoke/perl-5.12.2/lib/5.12.2/i686-linux-thread-multi
/home/sts/cpansmoke/perl-5.12.2/lib/5.12.2
.