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/pa-risc1.1/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/home/cpanrun/pa-risc1.1/build/5.6.1/lib/5.6.1/PA-RISC1.1-thread-multi -I/home/cpanrun/pa-risc1.1/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/pa-risc1.1/build/5.6.1/bin/perl -I/home/cpanrun/pa-risc1.1/build/5.6.1/lib/5.6.1/PA-RISC1.1-thread-multi -I/home/cpanrun/pa-risc1.1/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/pa-risc1.1/build/5.6.1/bin/perl -Iblib/arch -Iblib/lib -I/home/cpanrun/pa-risc1.1/build/5.6.1/lib/5.6.1/PA-RISC1.1-thread-multi -I/home/cpanrun/pa-risc1.1/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.94 using DBI 1.601 in batch mode
Connecting to 'dbi:ExampleP:' as ''...
ok 2 - Create Std handler
Disconnecting from dbi:ExampleP:.
ok 3 - Connect to dbi:ExampleP:
ok 4 - Disconnect from dbi:ExampleP:
ok 5 - Creating second handler
DBI::Shell 11.94 using DBI 1.601 in batch mode
Connecting to 'dbi:ExampleP:' as ''...
ok 6 - Connect second dbi:ExampleP:
Disconnecting from dbi:ExampleP:.
Connecting to 'dbi:ExampleP:' as ''...
ok 7 - Connect again.
Disconnecting from dbi:ExampleP:.
ok 8 - Connect again.
ok 9 - Disconnect second dbi:ExampleP:
ok
t/func........1..50
ok 1 - use DBI::Shell;
ok 2 - Connection
ok 3 - Testing Ping
ok 4 - Ping Tested
ok 5 - Call to get_info with 0 arguements, error expected: DBI get_info: invalid number of arguments: got handle + 0, expected handle + between 1 and 1
# Usage: $h->get_info($info_type) at t/func.t line 60.
#
ok 6 - table_info tested
# Failed test 'column_info tested'
# at t/func.t line 76.
not ok 7 - column_info tested
ok 8 - tables tested
Use of uninitialized value in concatenation (.) or string at t/func.t line 108.
ok 9 - type_info_all tested
ok 10 - type_info(undef)
ok 11 - quote error expected, DBI quote: invalid number of arguments: got handle + 0, expected handle + between 1 and 2
# Usage: $h->quote($string [, $data_type ]) at t/func.t line 105.
#
ok 12 - 0: quote on 1 returned '1'
Use of uninitialized value in concatenation (.) or string at t/func.t line 116.
ok 13 - 1: quote on 2 returned '2'
ok 14 - 2: quote on returned NULL
ok 15 - 3: quote on NULL returned 'NULL'
ok 16 - 4: quote on ThisIsAString returned 'ThisIsAString'
ok 17 - 5: quote on This is Another String returned 'This is Another String'
Use of uninitialized value in concatenation (.) or string at t/func.t line 127.
ok 18 - quote(1, SQL_INTEGER)
ok 19 - quote_identifier error expected DBI quote_identifier: invalid number of arguments: got handle + 0, expected handle + between 1 and 5
# Usage: $h->quote_identifier($name [, ...] [, \%attr ]) at t/func.t line 124.
#
ok 20 - quote_identifier( "link", "schema", "table" )
ok 21 - Ping the current connection ...
ok 22 - get_info(SQL_CATALOG_LOCATION) (114) 1
Use of uninitialized value in concatenation (.) or string at t/func.t line 162.
ok 23 - get_info(SQL_CATALOG_NAME_SEPARATOR) (41) .
# Failed test 'get_info(SQL_DBMS_NAME) (17) '
# at t/func.t line 162.
Use of uninitialized value in concatenation (.) or string at t/func.t line 162.
# Failed test 'get_info(SQL_DBMS_VER) (18) '
not ok 24 - get_info(SQL_DBMS_NAME) (17)
not ok 25 - get_info(SQL_DBMS_VER) (18)
# at t/func.t line 162.
ok 26 - get_info(SQL_IDENTIFIER_QUOTE_CHAR) (29) "
ok 27 - table_info(undef, undef, undef) tested
'.', undef, '.', 'TABLE', undef
'.', undef, '..', 'TABLE', undef
'.', undef, 'lib', 'TABLE', undef
'.', undef, 't', 'TABLE', undef
'.', undef, 'blib', 'TABLE', undef
5 rows
ok 28 - table_info(undef, undef, undef, "VIEW") tested
DBD::ExampleP::db table_info failed: Failed to open directory %: No such file or directory at t/func.t line 177.
undef, 'schema', 'table', 'VIEW', undef
undef, 'sch-ema', 'table', 'VIEW', undef
undef, 'schema', 'ta-ble', 'VIEW', undef
undef, 'sch ema', 'table', 'VIEW', undef
undef, 'schema', 'ta ble', 'VIEW', undef
5 rows
# Failed test 'table_info('%', '', '',) tested'
# at t/func.t line 178.
not ok 29 - table_info('%', '', '',) tested
ok 30 - table_info('', '%', '',) tested
'.', undef, '.', 'TABLE', undef
'.', undef, '..', 'TABLE', undef
'.', undef, 'lib', 'TABLE', undef
'.', undef, 't', 'TABLE', undef
'.', undef, 'blib', 'TABLE', undef
5 rows
ok 31 - table_info('', '', '', '%',) tested
0 rows
ok 32 - table_info('', '', '', '%',) tested
not ok 33 - column_info(undef, undef, undef, undef) tested
# Failed test 'column_info(undef, undef, undef, undef) tested'
# at t/func.t line 211.
ok 34 - Call to primary_key_info with 0 arguements, error expected: DBI primary_key_info: invalid number of arguments: got handle + 0, expected handle + between 3 and 4
# Usage: $h->primary_key_info($catalog, $schema, $table [, \%attr ]) at t/func.t line 222.
#
ok 35 - Call to primary_key with 0 arguements, error expected: DBI primary_key: invalid number of arguments: got handle + 0, expected handle + between 3 and 4
# Usage: $h->primary_key($catalog, $schema, $table [, \%attr ]) at t/func.t line 230.
#
not ok 36 - Call dbh->primary_key_info() ...
# Failed test 'Call dbh->primary_key_info() ... '
# at t/func.t line 240.
# Failed test 'Statement handle defined for primary_key_info()'
# at t/func.t line 241.
# Failed test 'Call dbh->primary_key_info() ... no error message'
# at t/func.t line 256.
not ok 37 - Statement handle defined for primary_key_info()
not ok 38 - Call dbh->primary_key_info() ... no error message
# Failed test 'Statement handle defined for primary_key_info()'
# at t/func.t line 258.
Can't call method "fetchrow_array" on an undefined value at t/func.t line 263.
# Looks like you planned 50 tests but only ran 39.
not ok 39 - Statement handle defined for primary_key_info()
# Looks like you failed 9 tests of 39 run.
# Looks like your test died just after 39.
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 7, 24-25, 29, 33, 36-50
Failed 20/50 tests, 60.00% okay
t/shell.......1..51
ok 1 - use DBI::Shell;
DBI::Shell 11.94 using DBI 1.601 in batch mode
Connecting to 'dbi:ExampleP:' as ''...
ok 2 - Create new handler
Available drivers:
ok 3 - Connect to source
AnyData
CSV
DBM
ExampleP
File
Gofer
LDAP
Log
MVS_FTPSQL
Mock
Ovrimos
PgPP
Proxy
SQLRelay
SQLite2
Sponge
Sprite
Template
TemplateSS
XBase
mysqlPP
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
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
ok 10 - Recall history
ok 11 - Help ...
seperator: ,
sqlpath: .
tmp_dir: undef
tmp_file: dbish20925.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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,'.',1195124397,120
5,72916,1,1195124379,0,1195124379,16895,8192,20,1024,1073741829,'..',1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,'batch.t',1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,'core.t',1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,'func.t',1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,'shell.t',1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,'spool.t',1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,'sqlminus.t',1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,'timing.t',1035774529,120
[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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,'.',1195124397,120
5,72916,1,1195124379,0,1195124379,16895,8192,20,1024,1073741829,'..',1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,'batch.t',1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,'core.t',1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,'func.t',1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,'shell.t',1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,'spool.t',1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,'sqlminus.t',1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,'timing.t',1035774529,120
[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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,'.',1195124397,120
5,72916,1,1195124379,0,1195124379,16895,8192,20,1024,1073741829,'..',1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,'batch.t',1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,'core.t',1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,'func.t',1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,'shell.t',1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,'spool.t',1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,'sqlminus.t',1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,'timing.t',1035774529,120
Current statement buffer:
[9 rows of 14 fields returned]
ok 19 - Execute current buffer
ok 20 - Save current buffer to file testsql.tmp
ok 21 - Does testsql.tmp exists?
Disconnecting from dbi:ExampleP:.
Connecting to 'dbi:ExampleP:' as ''...
ok 22 - Configuration file defined in environment
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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,'.',1195124397,120
5,72916,1,1195124397,0,1195124397,16895,8192,20,1024,1073741829,'..',1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,'batch.t',1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,'core.t',1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,'func.t',1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,'shell.t',1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,'spool.t',1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,'sqlminus.t',1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,'timing.t',1035774529,120
[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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,'.',1195124397,120
5,72916,1,1195124397,0,1195124397,16895,8192,20,1024,1073741829,'..',1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,'batch.t',1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,'core.t',1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,'func.t',1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,'shell.t',1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,'spool.t',1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,'sqlminus.t',1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,'timing.t',1035774529,120
[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|368397| 1|1195124369| 0|1195124369|16895| 8192| 20| 1024|1073741829|. |1195124397|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
| 5| 72916| 1|1195124397| 0|1195124397|16895| 8192| 20| 1024|1073741829|.. |1195124397|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
| 1|368400| 1|1195124369| 0|1035774529|33261| 8192| 20| 687|1073741829|batch.t |1195124387|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
| 1|373522| 2|1195124369| 0|1035774529|33261| 8192| 20| 1044|1073741829|core.t |1195124389|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
| 1|373742| 7|1195124369| 0|1172259515|33261| 8192| 20| 6828|1073741829|func.t |1195124394|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
| 1|374220| 3|1195124369| 0|1039823183|33261| 8192| 20| 2856|1073741829|shell.t |1195124394|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
| 1|374316| 2|1195124369| 0|1039823183|33261| 8192| 20| 1562|1073741829|spool.t |1039823183|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
| 1|374317| 15|1195124369| 0|1038334172|33261| 8192| 20|14681|1073741829|sqlminus.t|1038334172|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
| 1|374318| 5|1195124369| 0|1035774529|33261| 8192| 20| 4960|1073741829|timing.t |1035774529|120|
+-----+------+------+----------+----+----------+-----+-------+---+-----+----------+----------+----------+---+
[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 368397 1 1195124369 0 1195124369 16895 8192 20 1024 1073741829 . 1195124397 120
5 72916 1 1195124397 0 1195124397 16895 8192 20 1024 1073741829 .. 1195124397 120
1 368400 1 1195124369 0 1035774529 33261 8192 20 687 1073741829 batch.t 1195124387 120
1 373522 2 1195124369 0 1035774529 33261 8192 20 1044 1073741829 core.t 1195124389 120
1 373742 7 1195124369 0 1172259515 33261 8192 20 6828 1073741829 func.t 1195124394 120
1 374220 3 1195124369 0 1039823183 33261 8192 20 2856 1073741829 shell.t 1195124394 120
1 374316 2 1195124369 0 1039823183 33261 8192 20 1562 1073741829 spool.t 1039823183 120
1 374317 15 1195124369 0 1038334172 33261 8192 20 14681 1073741829 sqlminus.t 1038334172 120
1 374318 5 1195124369 0 1035774529 33261 8192 20 4960 1073741829 timing.t 1035774529 120
[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
nlink | ino | blocks | ctime | rdev | mtime | mode | blksize | gid | size | dev | name | atime | uid |
2 | 368397 | 1 | 1195124369 | 0 | 1195124369 | 16895 | 8192 | 20 | 1024 | 1073741829 | . | 1195124397 | 120 |
5 | 72916 | 1 | 1195124397 | 0 | 1195124397 | 16895 | 8192 | 20 | 1024 | 1073741829 | .. | 1195124397 | 120 |
1 | 368400 | 1 | 1195124369 | 0 | 1035774529 | 33261 | 8192 | 20 | 687 | 1073741829 | batch.t | 1195124387 | 120 |
1 | 373522 | 2 | 1195124369 | 0 | 1035774529 | 33261 | 8192 | 20 | 1044 | 1073741829 | core.t | 1195124389 | 120 |
1 | 373742 | 7 | 1195124369 | 0 | 1172259515 | 33261 | 8192 | 20 | 6828 | 1073741829 | func.t | 1195124394 | 120 |
1 | 374220 | 3 | 1195124369 | 0 | 1039823183 | 33261 | 8192 | 20 | 2856 | 1073741829 | shell.t | 1195124394 | 120 |
1 | 374316 | 2 | 1195124369 | 0 | 1039823183 | 33261 | 8192 | 20 | 1562 | 1073741829 | spool.t | 1039823183 | 120 |
1 | 374317 | 15 | 1195124369 | 0 | 1038334172 | 33261 | 8192 | 20 | 14681 | 1073741829 | sqlminus.t | 1038334172 | 120 |
1 | 374318 | 5 | 1195124369 | 0 | 1035774529 | 33261 | 8192 | 20 | 4960 | 1073741829 | timing.t | 1035774529 | 120 |
[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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,.,1195124397,120
5,72916,1,1195124397,0,1195124397,16895,8192,20,1024,1073741829,..,1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,batch.t,1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,core.t,1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,func.t,1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,shell.t,1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,spool.t,1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,sqlminus.t,1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,timing.t,1035774529,120
[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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,'.',1195124397,120
5,72916,1,1195124397,0,1195124397,16895,8192,20,1024,1073741829,'..',1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,'batch.t',1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,'core.t',1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,'func.t',1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,'shell.t',1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,'spool.t',1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,'sqlminus.t',1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,'timing.t',1035774529,120
[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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,'.',1195124397,120
5,72916,1,1195124397,0,1195124397,16895,8192,20,1024,1073741829,'..',1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,'batch.t',1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,'core.t',1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,'func.t',1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,'shell.t',1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,'spool.t',1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,'sqlminus.t',1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,'timing.t',1035774529,120
[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,368397,1,1195124369,0,1195124369,16895,8192,20,1024,1073741829,'.',1195124397,120
5,72916,1,1195124397,0,1195124397,16895,8192,20,1024,1073741829,'..',1195124397,120
1,368400,1,1195124369,0,1035774529,33261,8192,20,687,1073741829,'batch.t',1195124387,120
1,373522,2,1195124369,0,1035774529,33261,8192,20,1044,1073741829,'core.t',1195124389,120
1,373742,7,1195124369,0,1172259515,33261,8192,20,6828,1073741829,'func.t',1195124394,120
1,374220,3,1195124369,0,1039823183,33261,8192,20,2856,1073741829,'shell.t',1195124394,120
1,374316,2,1195124369,0,1039823183,33261,8192,20,1562,1073741829,'spool.t',1039823183,120
1,374317,15,1195124369,0,1038334172,33261,8192,20,14681,1073741829,'sqlminus.t',1038334172,120
1,374318,5,1195124369,0,1035774529,33261,8192,20,4960,1073741829,'timing.t',1035774529,120
[9 rows of 14 fields returned]
Disconnecting from dbi:ExampleP:.
ok 50 - Execute current buffer
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.94 using DBI 1.601 in batch mode
commandline history written to /home/cpanrun/.dbish_history
Connecting to 'dbi:ExampleP:' as ''...
ok 3 - Create statement handler
ok 4 - Connecting to source
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 5
nlink,ino,blocks,ctime,rdev
2,368397,1,1195124369,0
5,72916,1,1195124397,0
1,368400,1,1195124369,0
1,373522,2,1195124369,0
1,373742,7,1195124369,0
1,374220,3,1195124369,0
1,374316,2,1195124369,0
1,374317,15,1195124369,0
1,374318,5,1195124369,0
Elapsed: 0 wallclock secs ( 0.02 usr + 0.00 sys = 0.02 CPU) @ 50.00/s (n=1)
[9 rows of 5 fields returned]
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,368397,1,1195124369,0
5,72916,1,1195124400,0
1,368400,1,1195124369,0
1,373522,2,1195124369,0
1,373742,7,1195124369,0
1,374220,3,1195124369,0
1,374316,2,1195124369,0
1,374317,15,1195124369,0
1,374318,5,1195124369,0
Elapsed: 0 wallclock secs ( 0.01 usr + 0.01 sys = 0.02 CPU) @ 50.00/s (n=1)
[9 rows of 5 fields returned]
ok 10 - Execute current buffer
Disconnecting from dbi:ExampleP:.
ok 11 - Spool off
not spooling
ok 12 - Spool is off
ok 13 - Created Spool file
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.94 using DBI 1.601 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
fred: no column format defined.
ok 6 - Change format to sqlminus
ok 7 - List columns defined with formats
nlink: no column format defined.
format cleared
ok 8 - Show column format for fred
ok 9 - Show column format for nlink
ok 10 - Clear all column formats
ok 11
ok 12
ok 13
blocks
ctime
ok 14
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
ino
nlink
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
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 368397 1 1195124369 0
5 72916 1 1195124400 0
1 368400 1 1195124369 0
1 373522 2 1195124369 0
1 373742 7 1195124369 0
1 374220 3 1195124369 0
1 374316 2 1195124369 0
1 374317 15 1195124369 0
1 374318 5 1195124369 0
Page Number: 0
[9 rows of 5 fields returned]
Elapsed: 0 wallclock secs ( 0.14 usr + 0.00 sys = 0.14 CPU) @ 7.14/s (n=1)
ok 17
blocks
ctime
ino
nlink
ok 18
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
noprint 1
on 1
type char
column_format a20
format <<<<<<<<<<<<<<<<<<<<
length 20
on 1
type char
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 368397 1 0
5 72916 1 0
1 368400 1 0
1 373522 2 0
1 373742 7 0
1 374220 3 0
1 374316 2 0
1 374317 15 0
Elapsed: 0 wallclock secs ( 0.12 usr + 0.01 sys = 0.13 CPU) @ 7.69/s (n=1)
1 374318 5 0
Page Number: 0
[9 rows of 5 fields returned]
ok 21
ok 22
Current statement buffer:
select
nlink,ino,blocks,ctime,rdev
from t
ok 23
nlink ino blocks ctime rdev
-------------------- -------------------- -------------------- -------------------- ----------
2 368397 1 1195124369 0
5 72916 1 1195124400 0
1 368400 1 1195124369 0
1 373522 2 1195124369 0
1 373742 7 1195124369 0
1 374220 3 1195124369 0
1 374316 2 1195124369 0
1 374317 15 1195124369 0
Elapsed: 1 wallclock secs ( 0.13 usr + 0.00 sys = 0.13 CPU) @ 7.69/s (n=1)
1 374318 5 1195124369 0
Page Number: 0
[9 rows of 5 fields returned]
ok 24
format cleared
ok 25
ok 26
ok 27
ctime
----------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
Page Number: 0
[9 rows of 1 fields returned]
ok 28
ok 29
Elapsed: 0 wallclock secs ( 0.04 usr + 0.00 sys = 0.04 CPU) @ 25.00/s (n=1)
Page Number: 0
[9 rows of 1 fields returned]
ok 30
ok 31
ctime
----------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 32
ok 33
ctime
----------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
format cleared
ok 34
ok 35
ok 36
ctime
----------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 37
command: heading
heading: undef
ok 38
command: underline
underline: null
ok 39 - turn underline off
ctime
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 40
command: underline
underline: -
ok 41
ctime
----------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 1 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
ok 42
command: underline
underline: undef
ok 43
command: heading
heading: on
ok 44
ctime
ok 45
column_format a10
format <<<<<<<<<<
heading This is my heading
length 10
on 1
type char
ok 46
This is my
undefunde-
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 47
command: underline
underline: -
ok 48
ok 49
New Headi-
----------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
column ctime format:
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 50
column_format a10
format <<<<<<<<<<
heading New Heading
length 10
format cleared
on 1
type char
ok 51
ok 52
ctime
----------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
Page Number: 0
[9 rows of 1 fields returned]
ok 53
command: underline
underline: -
ok 54
ok 55
Underline test -
--------------------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 56
command: underline
underline: null
ok 57 - Turn underline off
ok 58
Underline test off
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 59
command: underline
underline: on
ok 60
ok 61
Underline test on
ononononononononono-
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.01 sys = 0.07 CPU) @ 14.29/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
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
ctime
ok 75
column_format a20
format >>>>>>>>>>>>>>>>>>>>
heading Justify test j r
justify r
length 20
on 1
type char
format cleared
ok 76
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
--------------------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
ctime
Page Number: 0
[9 rows of 1 fields returned]
ok 82
column_format a20
format <<<<<<<<<<<<<<<<<<<<
heading Justify left
justify l
length 20
on 1
type char
ok 83
ok 84
Justify right
--------------------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Page Number: 0
[9 rows of 1 fields returned]
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
ctime
ok 85
column_format a20
format >>>>>>>>>>>>>>>>>>>>
heading Justify right
justify r
length 20
on 1
type char
ok 86
ok 87
Justify center
--------------------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 16.67/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 88
ctime
column_format a20
format ^^^^^^^^^^^^^^^^^^^^
heading Justify center
justify c
length 20
on 1
type char
ok 89
ok 90
Justify off
--------------------
1195124369
1195124400
1195124369
1195124369
1195124369
1195124369
1195124369
1195124369
Elapsed: 0 wallclock secs ( 0.06 usr + 0.01 sys = 0.07 CPU) @ 14.29/s (n=1)
1195124369
Page Number: 0
[9 rows of 1 fields returned]
ok 91
ctime
ctime
column_format a20
format <<<<<<<<<<<<<<<<<<<<
heading Justify off
length 20
on 1
type char
ok 92
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
Disconnecting from dbi:ExampleP:.
last dbi error : 2000000000
last dbi error string : Unknown field names: yuck_error
last dbi error state : S1000
ok 108
ok 109 - Disconnect from source.
ok
t/timing......1..77
ok 1 - use DBI::Shell;
DBI::Shell 11.94 using DBI 1.601 in batch mode
commandline history written to /home/cpanrun/.dbish_history
Connecting to 'dbi:ExampleP:' as ''...
ok 2 - Create shell instance
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'
Elapsed: 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1)
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
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.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1)
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.0100000000000002 0 0 0 1 bad @ 100.00/s (n=1)
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'
Elapsed: 0 wallclock secs ( 0.01 usr + 0.01 sys = 0.02 CPU) @ 50.00/s (n=1)
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
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'
Elapsed: 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) @ 100.00/s (n=1)
'timing.t'
[9 rows of 1 fields returned]
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) @ 100.00/s (n=1)
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'
Elapsed: 0 0.00999999999999979 0 0 0 1 none @ 100.00/s (n=1)
'timing.t'
[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.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.01 CPU) @ 100.00/s (n=1)
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.01 usr 0.00 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'
Elapsed: 0 wallclock secs (0.01000 usr 0.00000 sys + 0.00000 cusr 0.00000 csys = 0.01000 CPU) @ 100.00000/s (n=1)
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
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'
Elapsed: 0 wallclock secs ( 0 usr 0 sys + 0 cusr 0 csys = 0 CPU) @ 49/s (n=1)
[9 rows of 1 fields returned]
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'
Elapsed: 0 wallclock secs (0.0100000000000002 usr 0 sys + 0 cusr 0 csys = 0.0100000000000002 CPU) @ 99.9999999999977/s (n=1)
'spool.t'
'sqlminus.t'
'timing.t'
[9 rows of 1 fields returned]
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'
Disconnecting from dbi:ExampleP:.
ok 76 - Current timing prefix options: timing_prefix, undefined
ok 77 - Disconnect from source.
ok
Failed 1/7 test scripts, 85.71% okay. 20/311 subtests failed, 93.57% okay.
Failed Test Stat Wstat Total Fail Failed List of Failed
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
t/func.t 255 65280 50 31 62.00% 7 24-25 29 33 36-50
make: *** [test_dynamic] Error 11