Microsoft (R) Program Maintenance Utility   Version 7.00.8882
Copyright (C) Microsoft Corp 1988-2000. All rights reserved.

Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBIx\SimplePerl.pm
Writing C:\cpanrun-5.8\build\5-8-0\site\lib\auto\DBIx\SimplePerl\.packlist
Appending installation info to C:\cpanrun-5.8\build\5-8-0\lib/perllocal.pod
ePerl
ok 3 - instantiated
D[2680] db_open: args -> 'dbuser:dbpass:dsn'
D[2680] db_open: open optional args -> 'AutoCommit => 1, RaiseError => 0'
D[2680]: DBIx::SimplePerl database connection succeeded
D[2680]: DBIx::SimplePerl database connection dump = $VAR1 = bless( {
                 '_dbh' => bless( {}, 'DBI::db' ),
                 'debug' => 1
               }, 'DBIx::SimplePerl' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

D[2680] db_next: returning hashref
D[2680] db_search: prepare = 'SELECT max(fp) FROM "test1"' 
D[2680] db_search: prepare succeeded
prepare: SELECT max(fp) FROM "test1"
D[2680] db_search: executing search
D[2680] db_search: execute succeeded
D[2680] db_search: prepare = 'SELECT max(fp) FROM "test2"' 
ok 15 - SQLite db_search with max
D[2680] db_search: prepare succeeded
prepare: SELECT max(fp) FROM "test2"
D[2680] db_search: executing search
D[2680] db_search: execute succeeded
D[2680] db_search: prepare = 'SELECT min(fp) FROM "test1"' 
ok 16 - SQLite db_search with max and select
D[2680] db_search: prepare succeeded
prepare: SELECT min(fp) FROM "test1"
D[2680] db_search: executing search
D[2680] db_search: execute succeeded
D[2680] db_search: prepare = 'SELECT min(fp) FROM "test2"' 
ok 17 - SQLite db_search with min 
D[2680] db_search: prepare succeeded
prepare: SELECT min(fp) FROM "test2"
D[2680] db_search: executing search
D[2680] db_search: execute succeeded
ok 18 - SQLite db_search with min and select
D[2680] db_search: prepare = 'SELECT * FROM "test1" WHERE number in ("1", "2", "3", "4", "5")' 
D[2680] db_search: prepare succeeded
prepare: SELECT * FROM "test1" WHERE number in ("1", "2", "3", "4", "5")
D[2680] db_search: executing search
D[2680] db_search: execute succeeded
ok 19 - SQLite db_search with vector_in
ok 20 - SQLite db_ping
D[2680] db_search: prepare = 'SELECT * FROM "test2" WHERE number in ("10", "20", "30")' 
D[2680] db_search: prepare succeeded
prepare: SELECT * FROM "test2" WHERE number in ("10", "20", "30")
D[2680] db_search: executing search
D[2680] db_search: execute succeeded
D[2680] db_rows: returning 0
rows=0
D[2680] db_next: returning hashref
return=$VAR1 = {
          'number' => '10',
          'q' => 'a',
          'name' => 'a10-b',
          'fp' => '11'
        };

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

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

D[2680] 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[2680] db_search: prepare = 'SELECT min(fp) FROM "test3"' 
ok 21 - SQLite db_next
DBD::SQLite::db prepare failed: no such table: test3(1) at dbdimp.c line 271 at C:\cpanrun-5.8\depot\main\contrib-patched\perl\CPAN\src\DBIx-SimplePerl\blib\lib/DBIx/SimplePerl.pm line 910.
D[2680]: DBIx::SimplePerl database error '1'
T[2680] error detection test return no such table: test3(1) at dbdimp.c line 271
ok 22 - SQLite erroneous db_search to flag error condition worked
# no such table: test3(1) at dbdimp.c line 271
# 
D[2680] db_update: prepare = 'UPDATE "test3"  SET homedir="2" WHERE username="1"' 
ok 23 - SQLite erroneous db_delete to flag error condition worked
# no search specified
# 
DBD::SQLite::db prepare failed: no such table: test3(1) at dbdimp.c line 271 at C:\cpanrun-5.8\depot\main\contrib-patched\perl\CPAN\src\DBIx-SimplePerl\blib\lib/DBIx/SimplePerl.pm line 982.
D[2680]: DBIx::SimplePerl database error '1'
D[2680] db_update: prepare = 'UPDATE "test3"  SET homedir="2" WHERE username="1"' 
ok 24 - SQLite erroneous db_update to flag error condition worked
# no such table: test3(1) at dbdimp.c line 271
# 
DBD::SQLite::db prepare failed: no such table: test3(1) at dbdimp.c line 271 at C:\cpanrun-5.8\depot\main\contrib-patched\perl\CPAN\src\DBIx-SimplePerl\blib\lib/DBIx/SimplePerl.pm line 982.
D[2680]: DBIx::SimplePerl database error '1'
ok 25 - SQLite db_update to flag unopened database error condition worked
# no such table: test3(1) at dbdimp.c line 271
# 
D[2680] db_close
1..25
ok
All tests successful.
Files=1, Tests=25,  1 wallclock secs ( 0.00 cusr +  0.00 csys =  0.00 CPU)