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 /export/home/cpanrun/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/export/home/cpanrun/build/5.6.1/lib/5.6.1/sun4-solaris-thread-multi -I/export/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 /export/home/cpanrun/build/5.6.1/bin/perl -I/export/home/cpanrun/build/5.6.1/lib/5.6.1/sun4-solaris-thread-multi -I/export/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 /export/home/cpanrun/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/export/home/cpanrun/build/5.6.1/lib/5.6.1/sun4-solaris-thread-multi -I/export/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: /export/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: dbish16647.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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102 5,571047,2,1178084396,0,1178084396,16895,8192,1,512,8388616,'..',1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102 [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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102 5,571047,2,1178084396,0,1178084396,16895,8192,1,512,8388616,'..',1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102 [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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102 5,571047,2,1178084396,0,1178084396,16895,8192,1,512,8388616,'..',1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102 [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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102 5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102 [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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084415,102 5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102 [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|790338| 2|1178084388| 0|1178084388|16895| 8192| 1| 512|8388616|. |1178084415|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ | 5|571047| 2|1178084415| 0|1178084415|16895| 8192| 1| 512|8388616|.. |1178084415|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ | 1|790354| 2|1178084388| 0|1035774529|33261| 8192| 1| 687|8388616|batch.t |1178084407|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ | 1|790355| 4|1178084388| 0|1035774529|33261| 8192| 1| 1044|8388616|core.t |1178084409|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ | 1|790356| 14|1178084388| 0|1035864543|33261| 8192| 1| 6828|8388616|func.t |1178084412|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ | 1|790357| 6|1178084388| 0|1039823183|33261| 8192| 1| 2856|8388616|shell.t |1178084413|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ | 1|790358| 4|1178084388| 0|1039823183|33261| 8192| 1| 1562|8388616|spool.t |1039823183|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ | 1|790359| 30|1178084388| 0|1038334172|33261| 8192| 1|14681|8388616|sqlminus.t|1038334172|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ | 1|790360| 10|1178084388| 0|1035774529|33261| 8192| 1| 4960|8388616|timing.t |1035774529|102| +-----+------+------+----------+----+----------+-----+-------+---+-----+-------+----------+----------+---+ [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 790338 2 1178084388 0 1178084388 16895 8192 1 512 8388616 . 1178084415 102 5 571047 2 1178084415 0 1178084415 16895 8192 1 512 8388616 .. 1178084415 102 1 790354 2 1178084388 0 1035774529 33261 8192 1 687 8388616 batch.t 1178084407 102 1 790355 4 1178084388 0 1035774529 33261 8192 1 1044 8388616 core.t 1178084409 102 1 790356 14 1178084388 0 1035864543 33261 8192 1 6828 8388616 func.t 1178084412 102 1 790357 6 1178084388 0 1039823183 33261 8192 1 2856 8388616 shell.t 1178084413 102 1 790358 4 1178084388 0 1039823183 33261 8192 1 1562 8388616 spool.t 1039823183 102 1 790359 30 1178084388 0 1038334172 33261 8192 1 14681 8388616 sqlminus.t 1038334172 102 1 790360 10 1178084388 0 1035774529 33261 8192 1 4960 8388616 timing.t 1035774529 102 [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 rdevmtime mode blksizegidsize dev name atime uid
2790338 21178084388 0117808438816895 8192 1 5128388616. 1178084416102
5571047 21178084415 0117808441516895 8192 1 5128388616.. 1178084415102
1790354 21178084388 0103577452933261 8192 1 6878388616batch.t 1178084407102
1790355 41178084388 0103577452933261 8192 1 10448388616core.t 1178084409102
1790356 141178084388 0103586454333261 8192 1 68288388616func.t 1178084412102
1790357 61178084388 0103982318333261 8192 1 28568388616shell.t 1178084413102
1790358 41178084388 0103982318333261 8192 1 15628388616spool.t 1039823183102
1790359 301178084388 0103833417233261 8192 1146818388616sqlminus.t1038334172102
1790360 101178084388 0103577452933261 8192 1 49608388616timing.t 1035774529102
[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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,.,1178084416,102 5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,..,1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,batch.t,1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,core.t,1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,func.t,1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,shell.t,1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,spool.t,1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,sqlminus.t,1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,timing.t,1035774529,102 [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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084416,102 5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102 [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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084416,102 5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102 [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,790338,2,1178084388,0,1178084388,16895,8192,1,512,8388616,'.',1178084416,102 5,571047,2,1178084415,0,1178084415,16895,8192,1,512,8388616,'..',1178084415,102 1,790354,2,1178084388,0,1035774529,33261,8192,1,687,8388616,'batch.t',1178084407,102 1,790355,4,1178084388,0,1035774529,33261,8192,1,1044,8388616,'core.t',1178084409,102 1,790356,14,1178084388,0,1035864543,33261,8192,1,6828,8388616,'func.t',1178084412,102 1,790357,6,1178084388,0,1039823183,33261,8192,1,2856,8388616,'shell.t',1178084413,102 1,790358,4,1178084388,0,1039823183,33261,8192,1,1562,8388616,'spool.t',1039823183,102 1,790359,30,1178084388,0,1038334172,33261,8192,1,14681,8388616,'sqlminus.t',1038334172,102 1,790360,10,1178084388,0,1035774529,33261,8192,1,4960,8388616,'timing.t',1035774529,102 [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 /export/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,790338,2,1178084388,0 5,571047,2,1178084415,0 1,790354,2,1178084388,0 1,790355,4,1178084388,0 1,790356,14,1178084388,0 1,790357,6,1178084388,0 1,790358,4,1178084388,0 1,790359,30,1178084388,0 1,790360,10,1178084388,0 [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,790338,2,1178084388,0 5,571047,2,1178084418,0 1,790354,2,1178084388,0 1,790355,4,1178084388,0 1,790356,14,1178084388,0 1,790357,6,1178084388,0 1,790358,4,1178084388,0 1,790359,30,1178084388,0 1,790360,10,1178084388,0 [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 /export/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 790338 2 1178084388 0 5 571047 2 1178084418 0 1 790354 2 1178084388 0 1 790355 4 1178084388 0 1 790356 14 1178084388 0 1 790357 6 1178084388 0 1 790358 4 1178084388 0 1 790359 30 1178084388 0 1 790360 10 1178084388 0 Page Number: 0 [9 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.06 usr + 0.01 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 790338 2 0 5 571047 2 0 1 790354 2 0 1 790355 4 0 1 790356 14 0 1 790357 6 0 1 790358 4 0 1 790359 30 0 1 790360 10 0 Page Number: 0 [9 rows of 5 fields returned] Elapsed: 1 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/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 790338 2 1178084388 0 5 571047 2 1178084418 0 1 790354 2 1178084388 0 1 790355 4 1178084388 0 1 790356 14 1178084388 0 1 790357 6 1178084388 0 1 790358 4 1178084388 0 1 790359 30 1178084388 0 1 790360 10 1178084388 0 Page Number: 0 [9 rows of 5 fields returned] Elapsed: 0 wallclock secs ( 0.08 usr + 0.00 sys = 0.08 CPU) @ 12.50/s (n=1) ok 24 format cleared ok 25 ok 26 ok 27 ctime ---------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 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 ---------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.04 usr + 0.00 sys = 0.04 CPU) @ 25.00/s (n=1) ok 32 ok 33 ctime ---------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 ---------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 ---------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 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- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 ---------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 ---------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 - -------------------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 1 wallclock secs ( 0.04 usr + 0.00 sys = 0.04 CPU) @ 25.00/s (n=1) ok 56 command: underline underline: null ok 57 - Turn underline off ok 58 Underline test off 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 -------------------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 Page Number: 0 [9 rows of 1 fields returned] Elapsed: 0 wallclock secs ( 0.01 usr + 0.01 sys = 0.02 CPU) @ 50.00/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 -------------------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 -------------------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 88 ctime column_format a20 format ^^^^^^^^^^^^^^^^^^^^ heading Justify center justify c length 20 on 1 type char ok 89 ok 90 Justify off -------------------- 1178084388 1178084418 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 1178084388 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 /export/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' Elapsed: 0 0 0 0 0 1 none [9 rows of 1 fields returned] 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.01 sys + 0.00 cusr 0.00 csys = 0.01 CPU) @ 100.00/s (n=1) 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) @ 99/s (n=1) 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.01 sys + 0 cusr 0 csys = 0.01 CPU) @ 99.9999999999999/s (n=1) 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, 22 wallclock secs ( 9.85 cusr + 1.60 csys = 11.45 CPU) Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell.pm Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Format.pm Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Format/SQLMinus.pm Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/FindSqlFile.pm Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/SQLMinus.pm Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Completion.pm Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Timing.pm Installing /export/home/cpanrun/build/5.6.1/lib/site_perl/5.6.1/DBI/Shell/Spool.pm Installing /export/home/cpanrun/build/5.6.1/man/man1/dbish.1 Installing /export/home/cpanrun/build/5.6.1/man/man3/DBI::Shell.3 Installing /export/home/cpanrun/build/5.6.1/man/man3/DBI::Format.3 Installing /export/home/cpanrun/build/5.6.1/man/man3/DBI::Format::SQLMinus.3 Installing /export/home/cpanrun/build/5.6.1/bin/dbish Appending installation info to /export/home/cpanrun/build/5.6.1/lib/5.6.1/sun4-solaris-thread-multi/perllocal.pod