Checking if your kit is complete... Looks good Writing Makefile for DBI::Shell cp lib/DBI/Shell.pm blib/lib/DBI/Shell.pm cp lib/DBI/Shell/FindSqlFile.pm blib/lib/DBI/Shell/FindSqlFile.pm cp lib/DBI/Shell/SQLMinus.pm blib/lib/DBI/Shell/SQLMinus.pm cp lib/DBI/Shell/Completion.pm blib/lib/DBI/Shell/Completion.pm cp lib/DBI/Format.pm blib/lib/DBI/Format.pm cp lib/DBI/Shell/Timing.pm blib/lib/DBI/Shell/Timing.pm cp lib/DBI/Shell/Spool.pm blib/lib/DBI/Shell/Spool.pm cp lib/DBI/Format/SQLMinus.pm blib/lib/DBI/Format/SQLMinus.pm /home/cpanrun/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/home/cpanrun/build/5.6.1/lib/5.6.1/i686-linux-thread-multi -I/home/cpanrun/build/5.6.1/lib/5.6.1 dbish.PL dbish Extracted dbish from dbish.PL with variable substitutions. cp dbish blib/script/dbish /home/cpanrun/build/5.6.1/bin/perl -I/home/cpanrun/build/5.6.1/lib/5.6.1/i686-linux-thread-multi -I/home/cpanrun/build/5.6.1/lib/5.6.1 -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbish Manifying blib/man3/DBI::Shell.3 Manifying blib/man3/DBI::Format.3 Manifying blib/man1/dbish.1 Manifying blib/man3/DBI::Format::SQLMinus.3 PERL_DL_NONLAZY=1 /home/cpanrun/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/home/cpanrun/build/5.6.1/lib/5.6.1/i686-linux-thread-multi -I/home/cpanrun/build/5.6.1/lib/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t t/batch.............1..1 ok 1 ok t/core..............1..9 ok 1 - use DBI::Shell; DBI::Shell 11.93 using DBI 1.48 in batch mode ok 2 - Create Std handler Connecting to 'dbi:ExampleP:' as ''... ok 3 - Connect to dbi:ExampleP: Disconnecting from dbi:ExampleP:. ok 4 - Disconnect from dbi:ExampleP: ok 5 - Creating second handler DBI::Shell 11.93 using DBI 1.48 in batch mode ok 6 - Connect second dbi:ExampleP: Connecting to 'dbi:ExampleP:' as ''... ok 7 - Connect again. Disconnecting from dbi:ExampleP:. Connecting to 'dbi:ExampleP:' as ''... ok 8 - Connect again. Disconnecting from dbi:ExampleP:. ok 9 - Disconnect second dbi:ExampleP: ok t/func..............1..0 # Skip Function tests not completed skipped: Function tests not completed t/shell.............1..51 ok 1 - use DBI::Shell; DBI::Shell 11.93 using DBI 1.48 in batch mode ok 2 - Create new handler Connecting to 'dbi:ExampleP:' as ''... ok 3 - Connect to source Available drivers: DBM ExampleP File Proxy Sponge ok 4 - Do drivers TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,REMARKS '.',undef,'.','TABLE',undef '.',undef,'..','TABLE',undef '.',undef,'lib','TABLE',undef '.',undef,'t','TABLE',undef '.',undef,'blib','TABLE',undef [5 rows of 5 fields returned] ok 5 - Do table_info TYPE_NAME,DATA_TYPE,COLUMN_SIZE,LITERAL_PREFIX,LITERAL_SUFFIX,CREATE_PARAMS,NULLABLE,CASE_SENSITIVE,SEARCHABLE,UNSIGNED_ATTRIBUTE,FIXED_PREC_SCALE,AUTO_UNIQUE_VALUE,LOCAL_TYPE_NAME,MINIMUM_SCALE,MAXIMUM_SCALE 'VARCHAR',12,1024,'\'','\'',undef,0,1,1,0,0,0,undef,0,0 'INTEGER',4,10,'','',undef,0,0,1,0,0,0,undef,0,0 [2 rows of 15 fields returned] ok 6 - Do type_info ok 7 - Do clear ok 8 - Recall results history ok 9 - Recall command history ok 10 - Recall history ok 11 - Help ... batch: 1 chistory_size: 50 command_prefix: [/;] command_prefix_end: ; command_prefix_line: / debug: 0 desc_format: partbox desc_show_columns: COLUMN_NAME,DATA_TYPE,TYPE_NAME,COLUMN_SIZE,PK,NULLABLE,COLUMN_DEF,IS_NULLABLE,REMARKS desc_show_long: 1 desc_show_remarks: 1 editor: vi format: neat home_dir: /home/cpanrun init_autocommit: 1 init_trace: 0 prompt: dbi:ExampleP: rhistory_head: 5 rhistory_size: 50 rhistory_tail: 5 seperator: , sqlpath: . tmp_dir: undef tmp_file: dbish32373.sql user_level: 1 ok 12 - Options ... ok 13 - Have test file? Current statement buffer: select * from t ok 14 - Loading test file testsql.sql nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021 5,1350302,8,1178075565,18714,1178075565,17919,4096,1021,4096,2057,'..',1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021 [9 rows of 14 fields returned] ok 15 - Execute current buffer select * from t ok 16 - Get last command executed nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021 5,1350302,8,1178075565,18714,1178075565,17919,4096,1021,4096,2057,'..',1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021 [9 rows of 14 fields returned] ok 17 - Execute current buffer select * from t ok 18 - Get first command executed nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021 5,1350302,8,1178075565,18714,1178075565,17919,4096,1021,4096,2057,'..',1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021 [9 rows of 14 fields returned] ok 19 - Execute current buffer Current statement buffer: ok 20 - Save current buffer to file testsql.tmp ok 21 - Does testsql.tmp exists? ok 22 - Configuration file defined in environment Disconnecting from dbi:ExampleP:. Connecting to 'dbi:ExampleP:' as ''... ok 23 - Connect to source Current statement buffer: select * from t ok 24 - Load current buffer from testsql.sql nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021 5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021 [9 rows of 14 fields returned] ok 25 - Execute current buffer ok 26 - Do commit ok 27 - Do rollback ok 28 - Set format to neat select * from t ok 29 - Last executed command nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021 5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021 [9 rows of 14 fields returned] ok 30 - Execute current buffer ok 31 - Set format to box select * from t ok 32 - Last executed command +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ |nlink|ino |blocks|ctime |rdev |mtime |mode |blksize|gid |size |dev |name |atime |uid | +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 2| 959499| 8|1178075559| 8522|1178075559|17919| 4096|1021| 4096|2057|. |1178075572|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 5|1350302| 8|1178075572|18714|1178075572|17919| 4096|1021| 4096|2057|.. |1178075572|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 1| 959500| 8|1178075559| 1828|1035774529|33261| 4096|1021| 687|2057|batch.t |1178075569|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 1| 959501| 8|1178075559|18873|1035774529|33261| 4096|1021| 1044|2057|core.t |1178075569|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 1| 959502| 16|1178075559|18802|1035864543|33261| 4096|1021| 6828|2057|func.t |1178075570|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 1| 959505| 8|1178075559|12810|1039823183|33261| 4096|1021| 2856|2057|shell.t |1178075571|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 1| 962084| 8|1178075559|14132|1039823183|33261| 4096|1021| 1562|2057|spool.t |1039823183|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 1| 962085| 32|1178075559|19136|1038334172|33261| 4096|1021|14681|2057|sqlminus.t|1038334172|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ | 1| 962086| 16|1178075559| 1012|1035774529|33261| 4096|1021| 4960|2057|timing.t |1035774529|1021| +-----+-------+------+----------+-----+----------+-----+-------+----+-----+----+----------+----------+----+ [9 rows of 14 fields returned] ok 33 - Execute current buffer ok 34 - Set format to string select * from t ok 35 - Last executed command nlink ino blocks ctime rdev mtime mode blksize gid size dev name atime uid 2 959499 8 1178075559 8522 1178075559 17919 4096 1021 4096 2057 . 1178075572 1021 5 1350302 8 1178075572 18714 1178075572 17919 4096 1021 4096 2057 .. 1178075572 1021 1 959500 8 1178075559 1828 1035774529 33261 4096 1021 687 2057 batch.t 1178075569 1021 1 959501 8 1178075559 18873 1035774529 33261 4096 1021 1044 2057 core.t 1178075569 1021 1 959502 16 1178075559 18802 1035864543 33261 4096 1021 6828 2057 func.t 1178075570 1021 1 959505 8 1178075559 12810 1039823183 33261 4096 1021 2856 2057 shell.t 1178075571 1021 1 962084 8 1178075559 14132 1039823183 33261 4096 1021 1562 2057 spool.t 1039823183 1021 1 962085 32 1178075559 19136 1038334172 33261 4096 1021 14681 2057 sqlminus.t 1038334172 1021 1 962086 16 1178075559 1012 1035774529 33261 4096 1021 4960 2057 timing.t 1035774529 1021 [9 rows of 14 fields returned] ok 36 - Execute current buffer ok 37 - Set format to html select * from t ok 38 - Last executed command
nlinkino blocksctime rdev mtime mode blksizegid size dev name atime uid
2 959499 81178075559 8522117807555917919 40961021 40962057. 11780755721021
51350302 8117807557218714117807557217919 40961021 40962057.. 11780755721021
1 959500 81178075559 1828103577452933261 40961021 6872057batch.t 11780755691021
1 959501 8117807555918873103577452933261 40961021 10442057core.t 11780755691021
1 959502 16117807555918802103586454333261 40961021 68282057func.t 11780755701021
1 959505 8117807555912810103982318333261 40961021 28562057shell.t 11780755711021
1 962084 8117807555914132103982318333261 40961021 15622057spool.t 10398231831021
1 962085 32117807555919136103833417233261 40961021146812057sqlminus.t10383341721021
1 962086 161178075559 1012103577452933261 40961021 49602057timing.t 10357745291021
[9 rows of 14 fields returned] ok 39 - Execute current buffer ok 40 - Set format to raw select * from t ok 41 - Last executed command nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,.,1178075572,1021 5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,..,1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,batch.t,1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,core.t,1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,func.t,1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,shell.t,1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,spool.t,1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,sqlminus.t,1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,timing.t,1035774529,1021 [9 rows of 14 fields returned] ok 42 - Execute current buffer ok 43 - Set format to neat select * from t ok 44 - Last executed command nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021 5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021 [9 rows of 14 fields returned] ok 45 - Execute current buffer ok 46 - Set format to neat Negative number -1: Changed number 9: select * from t ok 47 - Get with -1 command nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021 5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021 [9 rows of 14 fields returned] ok 48 - Execute current buffer Negative number -2: Changed number 9: select * from t ok 49 - Get with -2 command nlink,ino,blocks,ctime,rdev,mtime,mode,blksize,gid,size,dev,name,atime,uid 2,959499,8,1178075559,8522,1178075559,17919,4096,1021,4096,2057,'.',1178075572,1021 5,1350302,8,1178075572,18714,1178075572,17919,4096,1021,4096,2057,'..',1178075572,1021 1,959500,8,1178075559,1828,1035774529,33261,4096,1021,687,2057,'batch.t',1178075569,1021 1,959501,8,1178075559,18873,1035774529,33261,4096,1021,1044,2057,'core.t',1178075569,1021 1,959502,16,1178075559,18802,1035864543,33261,4096,1021,6828,2057,'func.t',1178075570,1021 1,959505,8,1178075559,12810,1039823183,33261,4096,1021,2856,2057,'shell.t',1178075571,1021 1,962084,8,1178075559,14132,1039823183,33261,4096,1021,1562,2057,'spool.t',1039823183,1021 1,962085,32,1178075559,19136,1038334172,33261,4096,1021,14681,2057,'sqlminus.t',1038334172,1021 1,962086,16,1178075559,1012,1035774529,33261,4096,1021,4960,2057,'timing.t',1035774529,1021 [9 rows of 14 fields returned] ok 50 - Execute current buffer Disconnecting from dbi:ExampleP:. ok 51 - Disconnect ok t/spool.............1..14 ok 1 - use DBI::Shell; ok 2 - Testing Spool plugin for dbish. Configuration file dbish_config. DBI::Shell 11.93 using DBI 1.48 in batch mode commandline history written to /home/cpanrun/.dbish_history ok 3 - Create statement handler Connecting to 'dbi:ExampleP:' as ''... ok 4 - Connecting to source Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 5 nlink,ino,blocks,ctime,rdev 2,959499,8,1178075559,8522 5,1350302,8,1178075572,18714 1,959500,8,1178075559,1828 1,959501,8,1178075559,18873 1,959502,16,1178075559,18802 1,959505,8,1178075559,12810 1,962084,8,1178075559,14132 1,962085,32,1178075559,19136 1,962086,16,1178075559,1012 [9 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1) ok 6 spooling testspool.tmp ok 7 - Spooling testspool.tmp spooling output to file: testspool.tmp ok 8 - Spooling to testspool.tmp select nlink,ino,blocks,ctime,rdev from t ok 9 - Get command nlink,ino,blocks,ctime,rdev 2,959499,8,1178075559,8522 5,1350302,8,1178075573,18714 1,959500,8,1178075559,1828 1,959501,8,1178075559,18873 1,959502,16,1178075559,18802 1,959505,8,1178075559,12810 1,962084,8,1178075559,14132 1,962085,32,1178075559,19136 1,962086,16,1178075559,1012 [9 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1) ok 10 - Execute current buffer ok 11 - Spool off not spooling ok 12 - Spool is off ok 13 - Created Spool file Disconnecting from dbi:ExampleP:. ok 14 - Disconnect ok t/sqlminus..........1..109 ok 1 - use DBI::Shell; ok 2 - require Text::Reform; ok 3 - Testing SQLMinus plugin for dbish. Configuration file dbish_config. DBI::Shell 11.93 using DBI 1.48 in batch mode commandline history written to /home/cpanrun/.dbish_history ok 4 - Create statement handler Connecting to 'dbi:ExampleP:' as ''... ok 5 - Connecting to source ok 6 - Change format to sqlminus ok 7 - List columns defined with formats fred: no column format defined. ok 8 - Show column format for fred nlink: no column format defined. ok 9 - Show column format for nlink format cleared ok 10 - Clear all column formats ok 11 ok 12 ok 13 ok 14 blocks column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ino column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char nlink column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ok 15 Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 16 nlink ino blocks ctime rdev -------------------- -------------------- -------------------- -------------------- ---------- 2 959499 8 1178075559 8522 5 1350302 8 1178075573 18714 1 959500 8 1178075559 1828 1 959501 8 1178075559 18873 1 959502 16 1178075559 18802 1 959505 8 1178075559 12810 1 962084 8 1178075559 14132 1 962085 32 1178075559 19136 1 962086 16 1178075559 1012 Page Number: 0 [9 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.07 usr + 0.00 sys = 0.07 CPU) @ 14.29/s (n=1) ok 17 ok 18 blocks column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 noprint 1 on 1 type char ino column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char nlink column_format a20 format <<<<<<<<<<<<<<<<<<<< length 20 on 1 type char ok 19 Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 20 nlink ino blocks rdev -------------------- -------------------- -------------------- ---- 2 959499 8 8522 5 1350302 8 1871 1 959500 8 1828 1 959501 8 1887 1 959502 16 1880 1 959505 8 1281 1 962084 8 1413 1 962085 32 1913 1 962086 16 1012 Page Number: 0 [9 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.05 usr + 0.00 sys = 0.05 CPU) @ 20.00/s (n=1) ok 21 ok 22 Current statement buffer: select nlink,ino,blocks,ctime,rdev from t ok 23 nlink ino blocks ctime rdev -------------------- -------------------- -------------------- -------------------- ---------- 2 959499 8 1178075559 8522 5 1350302 8 1178075573 18714 1 959500 8 1178075559 1828 1 959501 8 1178075559 18873 1 959502 16 1178075559 18802 1 959505 8 1178075559 12810 1 962084 8 1178075559 14132 1 962085 32 1178075559 19136 1 962086 16 1178075559 1012 Page Number: 0 [9 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.07 usr + 0.00 sys = 0.07 CPU) @ 14.29/s (n=1) ok 24 format cleared ok 25 ok 26 ok 27 ctime ---------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.02 usr + 0.01 sys = 0.03 CPU) @ 33.33/s (n=1) ok 28 ok 29 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.02 usr + 0.00 sys = 0.02 CPU) @ 50.00/s (n=1) ok 30 ok 31 ctime ---------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 32 ok 33 ctime ---------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 34 format cleared ok 35 ok 36 ctime ---------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 37 command: heading heading: undef ok 38 command: underline underline: null ok 39 - turn underline off ctime 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 40 command: underline underline: - ok 41 ctime ---------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 42 command: underline underline: undef ok 43 command: heading heading: on ok 44 ok 45 ctime column_format a10 format <<<<<<<<<< heading This is my heading length 10 on 1 type char ok 46 This is my undefunde- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 47 command: underline underline: - ok 48 ok 49 New ---------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 50 column ctime format: column_format a10 format <<<<<<<<<< heading New Heading length 10 on 1 type char ok 51 format cleared ok 52 ctime ---------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 53 command: underline underline: - ok 54 ok 55 Underline test - -------------------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 56 command: underline underline: null ok 57 - Turn underline off ok 58 Underline test off 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 59 command: underline underline: on ok 60 ok 61 Underline test on ononononononononono- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 62 ok 63 ok 64 ok 65 ok 66 ok 67 ok 68 invalid justification o ok 69 invalid justification on ok 70 invalid justification yuck ok 71 ok 72 invalid justification irhgt ok 73 ok 74 ok 75 ctime column_format a20 format >>>>>>>>>>>>>>>>>>>> heading Justify test j r justify r length 20 on 1 type char ok 76 format cleared ok 77 command: underline underline: - ok 78 command: heading heading: null ok 79 - Turn heading off command: heading heading: on ok 80 ok 81 Justify left -------------------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 82 ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< heading Justify left justify l length 20 on 1 type char ok 83 ok 84 Justify right -------------------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 85 ctime column_format a20 format >>>>>>>>>>>>>>>>>>>> heading Justify right justify r length 20 on 1 type char ok 86 ok 87 Justify center -------------------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 88 ctime column_format a20 format ^^^^^^^^^^^^^^^^^^^^ heading Justify center justify c length 20 on 1 type char ok 89 ok 90 Justify off -------------------- 1178075559 1178075573 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 1178075559 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.03 usr + 0.00 sys = 0.03 CPU) @ 33.33/s (n=1) ok 91 ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< heading Justify off length 20 on 1 type char ok 92 ctime column_format a20 format <<<<<<<<<<<<<<<<<<<< heading Justify off length 20 on 1 type char ok 93 format cleared ok 94 command: null null: 'stuff' ok 95 - Null value text tests command: null null: 'null ok 96 command: null null: "" ok 97 command: null null: &localtime() ok 98 command: null null: null ok 99 - set null off command: pagesize pagesize: null ok 100 - pagesize off command: pagesize pagesize: 10 ok 101 - set pagesize 10 command: pagesize pagesize: 10 ok 102 - is pagesize 10 command: limit limit: null ok 103 - row limit undef command: limit limit: 100 ok 104 - set row limit 100 command: limit limit: 100 ok 105 - row limit is 100 command: limit limit: null ok 106 - row limit is off DBD::ExampleP::db prepare failed: Unknown field names: yuck_error. Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 107 last dbi error : 1 last dbi error string : Unknown field names: yuck_error last dbi error state : S1000 ok 108 Disconnecting from dbi:ExampleP:. ok 109 - Disconnect from source. ok t/timing............1..77 ok 1 - use DBI::Shell; DBI::Shell 11.93 using DBI 1.48 in batch mode commandline history written to /home/cpanrun/.dbish_history ok 2 - Create shell instance Connecting to 'dbi:ExampleP:' as ''... ok 3 - Connecting to dbi:ExampleP: Current statement buffer: select name from t where name = 'timing.t' ok 4 - Loading test file: testtiming.sql name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1) ok 5 - Execute loaded statement ok 6 - Change output format to neat timing: off ok 7 - Turn timing OFF timing: off ok 8 - Timing is OFF select name from t where name = 'timing.t' ok 9 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] ok 10 - Execute statement in buffer timing: on ok 11 - Turn timing ON timing: on ok 12 - Timing is ON select name from t where name = 'timing.t' ok 13 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 14 - Execute statement in buffer timing: on ok 15 - Display timing status select name from t where name = 'timing.t' ok 16 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 17 - Execute statement in buffer /option timing_timing=1 ok 18 - Check options: timing_timing ok 19 - Check options: timing_timing=1 ok 20 - Check options: timing_timing=0 timing: off ok 21 - Timing is OFF ok 22 - Check options: timing_timing=1 timing: on ok 23 - Timing is ON timing: off ok 24 - Turn timing OFF timing: off ok 25 - Test timing is OFF timing: on ok 26 - Turn timing ON timing: on ok 27 - Test timing is ON timing: off ok 28 - Turn timing stop timing: off ok 29 - Test timing is OFF timing: on ok 30 - Turn timing start timing: on ok 31 - Test timing is ON timing: off ok 32 - Turn timing end timing: off ok 33 - Test timing is OFF timing: on ok 34 - Turn timing begin timing: on ok 35 - Test timing is ON /option timing_style=auto ok 36 - Current timing style options: timing_style ok 37 - Current timing style options: timing_style=bad select name from t where name = 'timing.t' ok 38 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 0 0 0 0 1 bad ok 39 - Execute statement in buffer ok 40 - Current timing style options: timing_style=auto select name from t where name = 'timing.t' ok 41 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 42 - Execute statement in buffer ok 43 - Current timing style options: timing_style=noc select name from t where name = 'timing.t' ok 44 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) ok 45 - Execute statement in buffer ok 46 - Current timing style options: timing_style=nop select name from t where name = 'timing.t' ok 47 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU) ok 48 - Execute statement in buffer ok 49 - Current timing style options: timing_style=none select name from t where name = 'timing.t' ok 50 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 0 0 0 0 1 none ok 51 - Execute statement in buffer ok 52 - Current timing style options: timing_style=all select name from t where name = 'timing.t' ok 53 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) ok 54 - Execute statement in buffer /option timing_format=5.2f ok 55 - Current timing format options: timing_format ok 56 - Current timing style options: timing_style=5.2f select name from t where name = 'timing.t' ok 57 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU) ok 58 - Execute statement in buffer ok 59 - Current timing style options: timing_style=5.5f select name from t where name = 'timing.t' ok 60 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs (0.00000 usr 0.00000 sys + 0.00000 cusr 0.00000 csys = 0.00000 CPU) ok 61 - Execute statement in buffer ok 62 - Current timing style options: timing_style=5d select name from t where name = 'timing.t' ok 63 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0 usr 0 sys + 0 cusr 0 csys = 0 CPU) ok 64 - Execute statement in buffer ok 65 - Current timing style options: timing_style=1s select name from t where name = 'timing.t' ok 66 - Get the last statement executed name '.' '..' 'batch.t' 'core.t' 'func.t' 'shell.t' 'spool.t' 'sqlminus.t' 'timing.t' [9 rows of 1 fields returned] Elapsed: 0 wallclock secs (0 usr 0 sys + 0 cusr 0 csys = 0 CPU) ok 67 - Execute statement in buffer ok 68 - Resetting current timing_format=5.2f /option timing_prefix=Elapsed: ok 69 - Current timing prefix options: timing_prefix, Default ok 70 - Current timing prefix options: timing_prefix="Timing: " ok 71 - Current timing prefix options: timing_prefix=\"Timing: \" ok 72 - Current timing prefix options: timing_prefix="Timing: " ok 73 - Current timing prefix options: timing_prefix=Timing: ok 74 - Current timing prefix options: timing_prefix=Timing: ok 75 - Current timing prefix options: timing_prefix='undef' /option timing_prefix='undef' ok 76 - Current timing prefix options: timing_prefix, undefined Disconnecting from dbi:ExampleP:. ok 77 - Disconnect from source. ok All tests successful, 1 test skipped. Files=7, Tests=261, 10 wallclock secs ( 9.42 cusr + 0.46 csys = 9.88 CPU) Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell.pm Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Format.pm Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Format/SQLMinus.pm Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/FindSqlFile.pm Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/SQLMinus.pm Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Completion.pm Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Timing.pm Installing /home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Spool.pm Installing /home/cpanrun/build/5.6.1/man/man1/dbish.1 Installing /home/cpanrun/build/5.6.1/man/man3/DBI::Shell.3 Installing /home/cpanrun/build/5.6.1/man/man3/DBI::Format.3 Installing /home/cpanrun/build/5.6.1/man/man3/DBI::Format::SQLMinus.3 Installing /home/cpanrun/build/5.6.1/bin/dbish Appending installation info to /home/cpanrun/build/5.6.1/lib/5.6.1/i686-linux-thread-multi/perllocal.pod