Skip Menu |

This queue is for tickets about the DBI-Shell CPAN distribution.

Report information
The Basics
Id: 26469
Status: resolved
Priority: 0/
Queue: DBI-Shell

People
Owner: talowery [...] gmail.com
Requestors: Marek.Rouchal [...] gmx.net
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: (no value)
Fixed in: 11.95



Subject: func.t does not work with perl-5.8.8 and latest modules (in 11.94)
This is to report a test failure of DBI-Shell-11.94 on perl-5.8.8, Solaris 8 (Sparc), built with gcc-4.0.3 and latest module versions from CPAN (DBI: 1.54). The func.t shows test failures, see details below. Please let me know if you need any additional details to fix the problem; sorry, but myself I do not know DBI well enough to fix it myself and provide a patch - I am "just maintaining" our company-wide Perl installation... Cheers, Marek $ prove -b -v t/func.t 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 not ok 7 - column_info tested # Failed test 'column_info tested' # at t/func.t line 76. ok 8 - tables tested ok 9 - type_info_all tested ok 10 - type_info(undef) Use of uninitialized value in concatenation (.) or string at t/func.t line 108. 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' ok 13 - 1: quote on 2 returned '2' Use of uninitialized value in concatenation (.) or string at t/func.t line 116. 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' ok 18 - quote(1, SQL_INTEGER) Use of uninitialized value in concatenation (.) or string at t/func.t line 127. 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 ok 23 - get_info(SQL_CATALOG_NAME_SEPARATOR) (41) . Use of uninitialized value in concatenation (.) or string at t/func.t line 162. not ok 24 - get_info(SQL_DBMS_NAME) (17) # 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. not ok 25 - get_info(SQL_DBMS_VER) (18) # Failed test '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 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 DBD::ExampleP::db table_info failed: Failed to open directory %: No such file or directory at t/func.t line 177. not ok 29 - table_info('%', '', '',) tested # Failed test 'table_info('%', '', '',) tested' # at t/func.t line 178. 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. not ok 37 - Statement handle defined for primary_key_info() # Failed test 'Statement handle defined for primary_key_info()' # at t/func.t line 241. not ok 38 - Call dbh->primary_key_info() ... no error message # Failed test 'Call dbh->primary_key_info() ... no error message' # at t/func.t line 256. not ok 39 - Statement handle defined for primary_key_info() # 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. # 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 Failed Test Stat Wstat Total Fail List of Failed ----------------------------------------------------------------------- --------------------------------- t/func.t 255 65280 50 31 7 24-25 29 33 36-50 Failed 1/1 test scripts. 20/50 subtests failed. Files=1, Tests=50, 0 wallclock secs ( 0.21 cusr + 0.03 csys = 0.24 CPU) Failed 1/1 test programs. 20/50 subtests failed.
Le Mer. Avr. 18 04:23:47 2007, MAREKR a écrit : Show quoted text
> This is to report a test failure of DBI-Shell-11.94 on perl-5.8.8, > Solaris 8 (Sparc), built with gcc-4.0.3 and latest module versions > from CPAN (DBI: 1.54).
Same issue on Mandriva Linux, with DBI 1.59 and perl 5.8.8.
Downgrading to TLOWERY/DBI-Shell-11.93.tar.gz seems to work. The cpantesters page shows that 11.94 has never worked: http://cpantesters.perl.org/show/DBI-Shell.html
Also fails similarly on AIX 5.3.
From: JACOB [...] cpan.org
On Wed Sep 26 02:37:13 2007, ANDK wrote: Show quoted text
> Downgrading to TLOWERY/DBI-Shell-11.93.tar.gz seems to work.
No need to downgrade, there are only two changes between 11.93 and 11.94: #1 is an added eval{} and #2 is that the func.t test is not skipped but executed. So just force the installation...
On Wed Apr 18 04:23:47 2007, MAREKR wrote: Show quoted text
> This is to report a test failure of DBI-Shell-11.94 on perl-5.8.8, > Solaris 8 (Sparc), built with gcc-4.0.3 and latest module versions > from CPAN (DBI: 1.54). The func.t shows test failures, see details > below. Please let me know if you need any additional details to fix > the problem; sorry, but myself I do not know DBI well enough to fix it > myself and provide a patch - I am "just maintaining" our company-wide > Perl installation... > > Cheers, > > Marek > > > $ prove -b -v t/func.t > 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 > not ok 7 - column_info tested > > # Failed test 'column_info tested' > # at t/func.t line 76. > ok 8 - tables tested > ok 9 - type_info_all tested > ok 10 - type_info(undef) > Use of uninitialized value in concatenation (.) or string at t/func.t > line 108. > 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' > ok 13 - 1: quote on 2 returned '2' > Use of uninitialized value in concatenation (.) or string at t/func.t > line 116. > 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' > ok 18 - quote(1, SQL_INTEGER) > Use of uninitialized value in concatenation (.) or string at t/func.t > line 127. > 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 > ok 23 - get_info(SQL_CATALOG_NAME_SEPARATOR) (41) . > Use of uninitialized value in concatenation (.) or string at t/func.t > line 162. > not ok 24 - get_info(SQL_DBMS_NAME) (17) > > # 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. > not ok 25 - get_info(SQL_DBMS_VER) (18) > > # Failed test '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 > 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 > DBD::ExampleP::db table_info failed: Failed to open directory %: No > such file or directory at t/func.t line 177. > not ok 29 - table_info('%', '', '',) tested > > # Failed test 'table_info('%', '', '',) tested' > # at t/func.t line 178. > 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. > not ok 37 - Statement handle defined for primary_key_info() > > # Failed test 'Statement handle defined for primary_key_info()' > # at t/func.t line 241. > not ok 38 - Call dbh->primary_key_info() ... no error message > > # Failed test 'Call dbh->primary_key_info() ... no error message' > # at t/func.t line 256. > not ok 39 - Statement handle defined for primary_key_info() > > # 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. > # 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 > Failed Test Stat Wstat Total Fail List of Failed > ----------------------------------------------------------------------- > --------------------------------- > t/func.t 255 65280 50 31 7 24-25 29 33 36-50 > Failed 1/1 test scripts. 20/50 subtests failed. > Files=1, Tests=50, 0 wallclock secs ( 0.21 cusr + 0.03 csys = 0.24 > CPU) > Failed 1/1 test programs. 20/50 subtests failed.
Is this still a problem? CPAN Testers shows 11.95 version working on Solaris.
On Fri Nov 08 19:31:57 2019, DLAMBLEY wrote: Show quoted text
> On Wed Apr 18 04:23:47 2007, MAREKR wrote:
> > This is to report a test failure of DBI-Shell-11.94 on perl-5.8.8, > > Solaris 8 (Sparc), built with gcc-4.0.3 and latest module versions > > from CPAN (DBI: 1.54). The func.t shows test failures, see details > > below. Please let me know if you need any additional details to fix > > the problem; sorry, but myself I do not know DBI well enough to fix > > it > > myself and provide a patch - I am "just maintaining" our company-wide > > Perl installation... > > > > Cheers, > > > > Marek > > > > > > $ prove -b -v t/func.t > > 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 > > not ok 7 - column_info tested > > > > # Failed test 'column_info tested' > > # at t/func.t line 76. > > ok 8 - tables tested > > ok 9 - type_info_all tested > > ok 10 - type_info(undef) > > Use of uninitialized value in concatenation (.) or string at > > t/func.t > > line 108. > > 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' > > ok 13 - 1: quote on 2 returned '2' > > Use of uninitialized value in concatenation (.) or string at > > t/func.t > > line 116. > > 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' > > ok 18 - quote(1, SQL_INTEGER) > > Use of uninitialized value in concatenation (.) or string at > > t/func.t > > line 127. > > 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 > > ok 23 - get_info(SQL_CATALOG_NAME_SEPARATOR) (41) . > > Use of uninitialized value in concatenation (.) or string at > > t/func.t > > line 162. > > not ok 24 - get_info(SQL_DBMS_NAME) (17) > > > > # 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. > > not ok 25 - get_info(SQL_DBMS_VER) (18) > > > > # Failed test '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 > > 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 > > DBD::ExampleP::db table_info failed: Failed to open directory %: No > > such file or directory at t/func.t line 177. > > not ok 29 - table_info('%', '', '',) tested > > > > # Failed test 'table_info('%', '', '',) tested' > > # at t/func.t line 178. > > 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. > > not ok 37 - Statement handle defined for primary_key_info() > > > > # Failed test 'Statement handle defined for primary_key_info()' > > # at t/func.t line 241. > > not ok 38 - Call dbh->primary_key_info() ... no error message > > > > # Failed test 'Call dbh->primary_key_info() ... no error message' > > # at t/func.t line 256. > > not ok 39 - Statement handle defined for primary_key_info() > > > > # 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. > > # 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 > > Failed Test Stat Wstat Total Fail List of Failed > > ----------------------------------------------------------------------- > > --------------------------------- > > t/func.t 255 65280 50 31 7 24-25 29 33 36-50 > > Failed 1/1 test scripts. 20/50 subtests failed. > > Files=1, Tests=50, 0 wallclock secs ( 0.21 cusr + 0.03 csys = > > 0.24 > > CPU) > > Failed 1/1 test programs. 20/50 subtests failed.
> > Is this still a problem? CPAN Testers shows 11.95 version working on > Solaris.
Closing, cpantesters says this is currently working on Solaris. (Although perhaps not on a 13 year old version?)