Microsoft (R) Program Maintenance Utility Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Format.pm
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell.pm
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\Completion.pm
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\FindSqlFile.pm
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\Spool.pm
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\SQLMinus.pm
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Shell\Timing.pm
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Format\CSV.pm
Installing C:\cpanrun-5.8\build\5-8-0\site\lib\DBI\Format\SQLMinus.pm
Installing C:\cpanrun-5.8\build\5-8-0\bin\dbish
Installing C:\cpanrun-5.8\build\5-8-0\bin\dbish.bat
Writing C:\cpanrun-5.8\build\5-8-0\site\lib\auto\DBI\Shell\.packlist
Appending installation info to C:\cpanrun-5.8\build\5-8-0\lib/perllocal.pod
DBI::Shell;
ok 2 - require Text::Reform;
ok 3 - Testing CSV plugin for dbish. Configuration file dbish_config.
DBI::Shell 11.95 using DBI 1.601
/option editor=vim (was vi)
/option sqlpath=.:C:\cpanrun-5.8/sql (was .)
/option tmp_dir=/tmp (was undef)
/option tmp_file=dbish2032.sql (was dbish2032.sql)
Loaded plugins DBI::Shell::Timing
Loaded plugins DBI::Shell::Completion
Loaded plugins DBI::Shell::Spool
commandline history written to C:\cpanrun-5.8/.dbish_history
ok 4 - Create statement handler
Connecting to 'dbi:ExampleP:' as ''...
/option format=sqlm (was neat)
Loaded plugins DBI::Shell::SQLMinus
ok 5 - Connecting to source
ok 6 - Change format to csv
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 7
"nlink","ino","blocks","ctime","rdev"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
"1","0","","1204130140","2"
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 8
/option seperator=^ (was ,)
ok 9
@dbi:ExampleP:> select
nlink,ino,blocks,ctime,rdev
from t
"nlink"^"ino"^"blocks"^"ctime"^"rdev"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
"1"^"0"^""^"1204130140"^"2"
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 10
/option seperator=| (was ^)
ok 11
@dbi:ExampleP:> select
nlink,ino,blocks,ctime,rdev
from t
"nlink"|"ino"|"blocks"|"ctime"|"rdev"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
"1"|"0"|""|"1204130140"|"2"
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 12
Disconnecting from dbi:ExampleP:.
ok 13 - Disconnect from source.
ok
t/func........1..0 # Skip Function tests not completed
skipped
all skipped: Function tests not completed
t/shell.......1..51
ok 1 - use DBI::Shell;
DBI::Shell 11.95 using DBI 1.601
ok 2 - Create new handler
Connecting to 'dbi:ExampleP:' as ''...
ok 3 - Connect to source
Available drivers:
DBM
ExampleP
File
Gofer
Mimer
Multiplex
Proxy
Sponge
ok 4 - Do drivers
TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,REMARKS
'.',undef,'.','TABLE',undef
'.',undef,'..','TABLE',undef
'.',undef,'blib','TABLE',undef
'.',undef,'lib','TABLE',undef
'.',undef,'t','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
Defined commands, in alphabetical order:
[/;]chistory display command history
[/;]clear erase the current statement
[/;]col_info display columns that exist in current database
[/;]commit commit changes to the database
[/;]connect connect to another data source/DSN
[/;]count execute 'select count(*) from table' (on each table listed).
[/;]current display current statement
[/;]describe display information about a table (columns, data types).
[/;]do execute the current (non-select) statement
[/;]drivers display available DBI drivers
[/;]edit edit current statement in an external editor
[/;]exit exit
[/;]format set display format for selected data (Neat|Box)
[/;]get make a previous statement current again
[/;]go execute the current statement
[/;]help display this list of commands
[/;]history display combined command and result history
[/;]load load a file from disk to the current buffer.
[/;]option display or set an option value
[/;]perl evaluate the current statement as perl code
[/;]ping ping the current connection
[/;]primary_key_info display primary keys that exist in current database
[/;]prompt change the displayed prompt
[/;]quit exit
[/;]redo re-execute the previously executed statement
[/;]rhistory display result history
[/;]rollback rollback changes to the database
[/;]run load a file from disk to current buffer, then executes.
[/;]save save the current buffer to a disk file.
[/;]spool send all output to a disk file. usage: spool file name or spool off.
[/;]table_info display tables that exist in current database
[/;]trace set DBI trace level for current database
[/;]type_info display data types supported by current server
ok 11 - Help ...
batch: 0
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: C:\cpanrun-5.8
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: dbish2032.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
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
'',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130143,16895,'..',0,1,1204130143,0,0
'',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0
[10 rows of 14 fields returned]
ok 15 - Execute current buffer
@dbi:ExampleP:> select * from t
ok 16 - Get last command executed
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
'',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130143,16895,'..',0,1,1204130143,0,0
'',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0
[10 rows of 14 fields returned]
ok 17 - Execute current buffer
@dbi:ExampleP:> select * from t
ok 18 - Get first command executed
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
'',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130143,16895,'..',0,1,1204130143,0,0
'',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0
[10 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
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
'',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0
'',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0
[10 rows of 14 fields returned]
ok 25 - Execute current buffer
ok 26 - Do commit
ok 27 - Do rollback
ok 28 - Set format to neat
@dbi:ExampleP:> select * from t
ok 29 - Last executed command
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
'',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0
'',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0
[10 rows of 14 fields returned]
ok 30 - Execute current buffer
ok 31 - Set format to box
@dbi:ExampleP:> select * from t
ok 32 - Last executed command
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
|blksize|ctime |rdev|blocks|uid|dev|mtime |mode |name |size |nlink|atime |ino|gid|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|16895|. | 0| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130146|16895|.. | 0| 1|1204130146| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|33206|batch.t | 731| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|33206|core.t | 1099| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|33206|csv.t | 1555| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|33206|func.t | 7117| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|33206|shell.t | 2977| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|33206|spool.t | 1640| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|33206|sqlminus.t|15187| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
| |1204130140| 2| | 0| 2|1204130140|33206|timing.t | 5111| 1|1204130140| 0| 0|
+-------+----------+----+------+---+---+----------+-----+----------+-----+-----+----------+---+---+
[10 rows of 14 fields returned]
ok 33 - Execute current buffer
ok 34 - Set format to string
@dbi:ExampleP:> select * from t
ok 35 - Last executed command
blksize ctime rdev blocks uid dev mtime mode name size nlink atime ino gid
1204130140 2 0 2 1204130140 16895 . 0 1 1204130140 0 0
1204130140 2 0 2 1204130146 16895 .. 0 1 1204130146 0 0
1204130140 2 0 2 1204130140 33206 batch.t 731 1 1204130140 0 0
1204130140 2 0 2 1204130140 33206 core.t 1099 1 1204130140 0 0
1204130140 2 0 2 1204130140 33206 csv.t 1555 1 1204130140 0 0
1204130140 2 0 2 1204130140 33206 func.t 7117 1 1204130140 0 0
1204130140 2 0 2 1204130140 33206 shell.t 2977 1 1204130140 0 0
1204130140 2 0 2 1204130140 33206 spool.t 1640 1 1204130140 0 0
1204130140 2 0 2 1204130140 33206 sqlminus.t 15187 1 1204130140 0 0
1204130140 2 0 2 1204130140 33206 timing.t 5111 1 1204130140 0 0
[10 rows of 14 fields returned]
ok 36 - Execute current buffer
ok 37 - Set format to html
@dbi:ExampleP:> select * from t
ok 38 - Last executed command
blksize | ctime | rdev | blocks | uid | dev | mtime | mode | name | size | nlink | atime | ino | gid |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 16895 | . | 0 | 1 | 1204130140 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130146 | 16895 | .. | 0 | 1 | 1204130146 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 33206 | batch.t | 731 | 1 | 1204130140 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 33206 | core.t | 1099 | 1 | 1204130140 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 33206 | csv.t | 1555 | 1 | 1204130140 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 33206 | func.t | 7117 | 1 | 1204130140 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 33206 | shell.t | 2977 | 1 | 1204130140 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 33206 | spool.t | 1640 | 1 | 1204130140 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 33206 | sqlminus.t | 15187 | 1 | 1204130140 | 0 | 0 |
| 1204130140 | 2 | | 0 | 2 | 1204130140 | 33206 | timing.t | 5111 | 1 | 1204130140 | 0 | 0 |
[10 rows of 14 fields returned]
ok 39 - Execute current buffer
ok 40 - Set format to raw
@dbi:ExampleP:> select * from t
ok 41 - Last executed command
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
,1204130140,2,,0,2,1204130140,16895,.,0,1,1204130140,0,0
,1204130140,2,,0,2,1204130146,16895,..,0,1,1204130146,0,0
,1204130140,2,,0,2,1204130140,33206,batch.t,731,1,1204130140,0,0
,1204130140,2,,0,2,1204130140,33206,core.t,1099,1,1204130140,0,0
,1204130140,2,,0,2,1204130140,33206,csv.t,1555,1,1204130140,0,0
,1204130140,2,,0,2,1204130140,33206,func.t,7117,1,1204130140,0,0
,1204130140,2,,0,2,1204130140,33206,shell.t,2977,1,1204130140,0,0
,1204130140,2,,0,2,1204130140,33206,spool.t,1640,1,1204130140,0,0
,1204130140,2,,0,2,1204130140,33206,sqlminus.t,15187,1,1204130140,0,0
,1204130140,2,,0,2,1204130140,33206,timing.t,5111,1,1204130140,0,0
[10 rows of 14 fields returned]
ok 42 - Execute current buffer
ok 43 - Set format to neat
@dbi:ExampleP:> select * from t
ok 44 - Last executed command
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
'',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0
'',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0
[10 rows of 14 fields returned]
ok 45 - Execute current buffer
ok 46 - Set format to neat
Negative number -1:
Changed number 9:
@dbi:ExampleP:> select * from t
ok 47 - Get with -1 command
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
'',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0
'',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0
[10 rows of 14 fields returned]
ok 48 - Execute current buffer
Negative number -2:
Changed number 9:
@dbi:ExampleP:> select * from t
ok 49 - Get with -2 command
blksize,ctime,rdev,blocks,uid,dev,mtime,mode,name,size,nlink,atime,ino,gid
'',1204130140,2,'',0,2,1204130140,16895,'.',0,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130146,16895,'..',0,1,1204130146,0,0
'',1204130140,2,'',0,2,1204130140,33206,'batch.t',731,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'core.t',1099,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'csv.t',1555,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'func.t',7117,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'shell.t',2977,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'spool.t',1640,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'sqlminus.t',15187,1,1204130140,0,0
'',1204130140,2,'',0,2,1204130140,33206,'timing.t',5111,1,1204130140,0,0
[10 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.95 using DBI 1.601
/option editor=vim (was vi)
/option sqlpath=.:C:\cpanrun-5.8/sql (was .)
/option tmp_dir=/tmp (was undef)
/option tmp_file=dbish2776.sql (was dbish2776.sql)
Loaded plugins DBI::Shell::Timing
Loaded plugins DBI::Shell::Completion
Loaded plugins DBI::Shell::Spool
commandline history written to C:\cpanrun-5.8/.dbish_history
ok 3 - Create statement handler
Connecting to 'dbi:ExampleP:' as ''...
/option format=sqlm (was neat)
Loaded plugins DBI::Shell::SQLMinus
ok 4 - Connecting to source
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 5
nlink,ino,blocks,ctime,rdev
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
[10 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 6
@dbi:ExampleP:> spooling testspool.tmp
ok 7 - Spooling testspool.tmp
@dbi:ExampleP:> spooling output to file: testspool.tmp
ok 8 - Spooling to testspool.tmp
@dbi:ExampleP:> select
nlink,ino,blocks,ctime,rdev
from t
ok 9 - Get command
nlink,ino,blocks,ctime,rdev
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
1,0,'',1204130140,2
[10 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 10 - Execute current buffer
ok 11 - Spool off
@dbi:ExampleP:> 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.95 using DBI 1.601
/option editor=vim (was vi)
/option sqlpath=.:C:\cpanrun-5.8/sql (was .)
/option tmp_dir=/tmp (was undef)
/option tmp_file=dbish2032.sql (was dbish2032.sql)
Loaded plugins DBI::Shell::Timing
Loaded plugins DBI::Shell::Completion
Loaded plugins DBI::Shell::Spool
commandline history written to C:\cpanrun-5.8/.dbish_history
ok 4 - Create statement handler
Connecting to 'dbi:ExampleP:' as ''...
/option format=sqlm (was neat)
Loaded plugins DBI::Shell::SQLMinus
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
-------------------- -------------------- -------------------- -------------------- ----------
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
Page Number: 0
[10 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.02 usr + 0.00 sys = 0.02 CPU) @ 66.67/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
-------------------- -------------------- -------------------- ----
1 0 2
1 0 2
1 0 2
1 0 2
1 0 2
1 0 2
1 0 2
1 0 2
1 0 2
1 0 2
Page Number: 0
[10 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 21
ok 22
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 23
nlink ino blocks ctime rdev
-------------------- -------------------- -------------------- -------------------- ----------
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
1 0 1204130140 2
Page Number: 0
[10 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 24
format cleared
ok 25
ok 26
ok 27
ctime
----------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 28
ok 29
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 30
ok 31
ctime
----------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 32
ok 33
ctime
----------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 34
format cleared
ok 35
ok 36
ctime
----------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 37
command: heading
@dbi:ExampleP:> heading: undef
ok 38
command: underline
@dbi:ExampleP:> underline: null
ok 39 - turn underline off
ctime
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 40
command: underline
@dbi:ExampleP:> underline: -
ok 41
ctime
----------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 42
command: underline
@dbi:ExampleP:> underline: undef
ok 43
command: heading
@dbi:ExampleP:> 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-
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 47
command: underline
@dbi:ExampleP:> underline: -
ok 48
ok 49
New Headi-
----------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
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
----------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 53
command: underline
@dbi:ExampleP:> underline: -
ok 54
ok 55
Underline test -
--------------------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 56
command: underline
@dbi:ExampleP:> underline: null
ok 57 - Turn underline off
ok 58
Underline test off
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 59
command: underline
@dbi:ExampleP:> underline: on
ok 60
ok 61
Underline test on
ononononononononono-
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
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
@dbi:ExampleP:> underline: -
ok 78
command: heading
@dbi:ExampleP:> heading: null
ok 79 - Turn heading off
command: heading
@dbi:ExampleP:> heading: on
ok 80
ok 81
Justify left
--------------------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 82
ctime
column_format a20
format <<<<<<<<<<<<<<<<<<<<
heading Justify left
justify l
length 20
on 1
type char
ok 83
ok 84
Justify right
--------------------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 85
ctime
column_format a20
format >>>>>>>>>>>>>>>>>>>>
heading Justify right
justify r
length 20
on 1
type char
ok 86
ok 87
Justify center
--------------------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 88
ctime
column_format a20
format ^^^^^^^^^^^^^^^^^^^^
heading Justify center
justify c
length 20
on 1
type char
ok 89
ok 90
Justify off
--------------------
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
1204130140
Page Number: 0
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
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
@dbi:ExampleP:> null: 'stuff'
ok 95 - Null value text tests
command: null
@dbi:ExampleP:> null: 'null
ok 96
command: null
@dbi:ExampleP:> null: ""
ok 97
command: null
@dbi:ExampleP:> null: &localtime()
ok 98
command: null
@dbi:ExampleP:> null: null
ok 99 - set null off
command: pagesize
@dbi:ExampleP:> pagesize: null
ok 100 - pagesize off
command: pagesize
@dbi:ExampleP:> pagesize: 10
ok 101 - set pagesize 10
command: pagesize
@dbi:ExampleP:> pagesize: 10
ok 102 - is pagesize 10
command: limit
@dbi:ExampleP:> limit: null
ok 103 - row limit undef
command: limit
@dbi:ExampleP:> limit: 100
ok 104 - set row limit 100
command: limit
@dbi:ExampleP:> limit: 100
ok 105 - row limit is 100
command: limit
@dbi:ExampleP:> 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 : 2000000000
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.95 using DBI 1.601
/option editor=vim (was vi)
/option sqlpath=.:C:\cpanrun-5.8/sql (was .)
/option tmp_dir=/tmp (was undef)
/option tmp_file=dbish2776.sql (was dbish2776.sql)
Loaded plugins DBI::Shell::Timing
Loaded plugins DBI::Shell::Completion
Loaded plugins DBI::Shell::Spool
commandline history written to C:\cpanrun-5.8/.dbish_history
ok 2 - Create shell instance
Connecting to 'dbi:ExampleP:' as ''...
/option format=sqlm (was neat)
Loaded plugins DBI::Shell::SQLMinus
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'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 5 - Execute loaded statement
ok 6 - Change output format to neat
@dbi:ExampleP:> timing: off
ok 7 - Turn timing OFF
@dbi:ExampleP:> timing: off
ok 8 - Timing is OFF
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 9 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 rows of 1 fields returned]
ok 10 - Execute statement in buffer
@dbi:ExampleP:> timing: on
ok 11 - Turn timing ON
@dbi:ExampleP:> timing: on
ok 12 - Timing is ON
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 13 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 14 - Execute statement in buffer
@dbi:ExampleP:> timing: on
ok 15 - Display timing status
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 16 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 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
/option timing_timing=1 (was 1)
ok 19 - Check options: timing_timing=1
/option timing_timing=0 (was 1)
ok 20 - Check options: timing_timing=0
@dbi:ExampleP:> timing: off
ok 21 - Timing is OFF
/option timing_timing=1 (was 0)
ok 22 - Check options: timing_timing=1
@dbi:ExampleP:> timing: on
ok 23 - Timing is ON
@dbi:ExampleP:> timing: off
ok 24 - Turn timing OFF
@dbi:ExampleP:> timing: off
ok 25 - Test timing is OFF
@dbi:ExampleP:> timing: on
ok 26 - Turn timing ON
@dbi:ExampleP:> timing: on
ok 27 - Test timing is ON
@dbi:ExampleP:> timing: off
ok 28 - Turn timing stop
@dbi:ExampleP:> timing: off
ok 29 - Test timing is OFF
@dbi:ExampleP:> timing: on
ok 30 - Turn timing start
@dbi:ExampleP:> timing: on
ok 31 - Test timing is ON
@dbi:ExampleP:> timing: off
ok 32 - Turn timing end
@dbi:ExampleP:> timing: off
ok 33 - Test timing is OFF
@dbi:ExampleP:> timing: on
ok 34 - Turn timing begin
@dbi:ExampleP:> timing: on
ok 35 - Test timing is ON
/option timing_style=auto
ok 36 - Current timing style options: timing_style
/option timing_style=bad (was auto)
ok 37 - Current timing style options: timing_style=bad
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 38 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 rows of 1 fields returned]
Elapsed: 0 0 0 0 0 1 bad
ok 39 - Execute statement in buffer
/option timing_style=auto (was bad)
ok 40 - Current timing style options: timing_style=auto
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 41 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 42 - Execute statement in buffer
/option timing_style=noc (was auto)
ok 43 - Current timing style options: timing_style=noc
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 44 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
ok 45 - Execute statement in buffer
/option timing_style=nop (was noc)
ok 46 - Current timing style options: timing_style=nop
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 47 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU)
ok 48 - Execute statement in buffer
/option timing_style=none (was nop)
ok 49 - Current timing style options: timing_style=none
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 50 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 rows of 1 fields returned]
Elapsed:
ok 51 - Execute statement in buffer
/option timing_style=all (was none)
ok 52 - Current timing style options: timing_style=all
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 53 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 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
/option timing_format=5.2f (was 5.2f)
ok 56 - Current timing style options: timing_style=5.2f
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 57 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 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
/option timing_format=5.5f (was 5.2f)
ok 59 - Current timing style options: timing_style=5.5f
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 60 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 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
/option timing_format=5d (was 5.5f)
ok 62 - Current timing style options: timing_style=5d
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 63 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 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
/option timing_format=1s (was 5d)
ok 65 - Current timing style options: timing_style=1s
@dbi:ExampleP:> select name from t where name = 'timing.t'
ok 66 - Get the last statement executed
name
'.'
'..'
'batch.t'
'core.t'
'csv.t'
'func.t'
'shell.t'
'spool.t'
'sqlminus.t'
'timing.t'
[10 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
/option timing_format=5.2f (was 1s)
ok 68 - Resetting current timing_format=5.2f
/option timing_prefix=Elapsed:
ok 69 - Current timing prefix options: timing_prefix, Default
/option timing_prefix="Timing: " (was Elapsed: )
ok 70 - Current timing prefix options: timing_prefix="Timing: "
/option timing_prefix=\"Timing: \" (was "Timing: ")
ok 71 - Current timing prefix options: timing_prefix=\"Timing: \"
/option timing_prefix="Timing: " (was \"Timing: \")
ok 72 - Current timing prefix options: timing_prefix="Timing: "
/option timing_prefix=Timing: (was "Timing: ")
ok 73 - Current timing prefix options: timing_prefix=Timing:
/option timing_prefix=Timing: (was Timing:)
ok 74 - Current timing prefix options: timing_prefix=Timing:
/option timing_prefix='undef' (was 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=8, Tests=274, 5 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU)