Bug #130796 for SQL-SplitStatement: Failing tests

Wed Oct 23 08:36:55 2019 robert [...] interactive.co.uk - Ticket created

Subject:	Failing tests
Date:	Wed, 23 Oct 2019 13:36:13 +0100
To:	bug-sql-SplitStatement [...] rt.cpan.org
From:	Robert Inder <robert [...] interactive.co.uk>

See below. Running on CentOS 7, perl 5.16. So not bleeding edge, but... Don't know what more to say.... [robert@sandpit FIDDLE]$ cpanm --test-only SQL::SplitStatement ! ! Can't write to /usr/local/share/perl5 and /usr/local/bin: Installing modules to /home/robert/perl5 ! To turn off this warning, you have to do one of the following: ! - run me as a root or with --sudo option (to install to /usr/local/share/perl5 and /usr/local/bin) ! - Configure local::lib your existing local::lib in this shell to set PERL_MM_OPT etc. ! - Install local::lib by running the following commands ! ! cpanm --local-lib=~/perl5 local::lib && eval $(perl -I ~/perl5/lib/perl5/ -Mlocal::lib) ! --> Working on SQL::SplitStatement Fetching http://www.cpan.org/authors/id/E/EM/EMAZEP/SQL-SplitStatement-1.00020.tar.gz ... OK Configuring SQL-SplitStatement-1.00020 ... OK ==> Found dependencies: SQL::Tokenizer, Regexp::Common --> Working on SQL::Tokenizer Fetching http://www.cpan.org/authors/id/I/IZ/IZUT/SQL-Tokenizer-0.24.tar.gz ... OK Configuring SQL-Tokenizer-0.24 ... OK Building and testing SQL-Tokenizer-0.24 ... OK Successfully tested SQL-Tokenizer-0.24 --> Working on Regexp::Common Fetching http://www.cpan.org/authors/id/A/AB/ABIGAIL/Regexp-Common-2017060201.tar.gz ... OK Configuring Regexp-Common-2017060201 ... OK Building and testing Regexp-Common-2017060201 ... OK Successfully tested Regexp-Common-2017060201 Building and testing SQL-SplitStatement-1.00020 ... FAIL ! Testing SQL::SplitStatement failed. See /home/robert/.cpanm/work/1571833529.27796/build.log for details. Retry with --force to force install it. -- Robert Inder, 0131 229 1052 / 07808 492 213 Interactive Information Ltd, 3, Lauriston Gardens, Edinburgh EH3 9HH Registered in Scotland, Company no. SC 150689 Interactions speak louder than words

Thu Oct 24 07:41:55 2019 mcgrath.martin [...] gmail.com - Correspondence added

On Wed Oct 23 13:36:55 2019, robert@interactive.co.uk wrote: Show quoted text

> See below. > Running on CentOS 7, perl 5.16. > So not bleeding edge, but... > > Don't know what more to say.... > > [robert@sandpit FIDDLE]$ cpanm --test-only SQL::SplitStatement > ! > ! Can't write to /usr/local/share/perl5 and /usr/local/bin: Installing > modules to /home/robert/perl5 > ! To turn off this warning, you have to do one of the following: > ! - run me as a root or with --sudo option (to install to > /usr/local/share/perl5 and /usr/local/bin) > ! - Configure local::lib your existing local::lib in this shell to set > PERL_MM_OPT etc. > ! - Install local::lib by running the following commands > ! > ! cpanm --local-lib=~/perl5 local::lib && eval $(perl -I > ~/perl5/lib/perl5/ -Mlocal::lib) > ! > --> Working on SQL::SplitStatement > Fetching > http://www.cpan.org/authors/id/E/EM/EMAZEP/SQL-SplitStatement-1.00020.tar.gz > ... OK > Configuring SQL-SplitStatement-1.00020 ... OK > ==> Found dependencies: SQL::Tokenizer, Regexp::Common > --> Working on SQL::Tokenizer > Fetching http://www.cpan.org/authors/id/I/IZ/IZUT/SQL-Tokenizer-0.24.tar.gz > ... OK > Configuring SQL-Tokenizer-0.24 ... OK > Building and testing SQL-Tokenizer-0.24 ... OK > Successfully tested SQL-Tokenizer-0.24 > --> Working on Regexp::Common > Fetching > http://www.cpan.org/authors/id/A/AB/ABIGAIL/Regexp-Common-2017060201.tar.gz > ... OK > Configuring Regexp-Common-2017060201 ... OK > Building and testing Regexp-Common-2017060201 ... OK > Successfully tested Regexp-Common-2017060201 > Building and testing SQL-SplitStatement-1.00020 ... FAIL > ! Testing SQL::SplitStatement failed. See > /home/robert/.cpanm/work/1571833529.27796/build.log for details. Retry with > --force to force install it. >

Show quoted text

> Don't know what more to say....

The contents of the failed build.log would be a good start.

Thu Oct 24 07:41:56 2019 The RT System itself - Status changed from 'new' to 'open'

Thu Oct 24 08:30:32 2019 robert [...] interactive.co.uk - Correspondence added

Subject:	Re: [rt.cpan.org #130796] Failing tests
Date:	Thu, 24 Oct 2019 13:29:58 +0100
To:	bug-SQL-SplitStatement [...] rt.cpan.org
From:	Robert Inder <robert [...] interactive.co.uk>

Sorry: me being dopey.... Should be attached. On Thu, 24 Oct 2019 at 12:41, Martin McGrath via RT <bug-SQL-SplitStatement@rt.cpan.org> wrote: Show quoted text

> > <URL: https://rt.cpan.org/Ticket/Display.html?id=130796 > > > On Wed Oct 23 13:36:55 2019, robert@interactive.co.uk wrote:

> > See below. > > Running on CentOS 7, perl 5.16. > > So not bleeding edge, but... > > > > Don't know what more to say.... > > > > [robert@sandpit FIDDLE]$ cpanm --test-only SQL::SplitStatement > > ! > > ! Can't write to /usr/local/share/perl5 and /usr/local/bin: Installing > > modules to /home/robert/perl5 > > ! To turn off this warning, you have to do one of the following: > > ! - run me as a root or with --sudo option (to install to > > /usr/local/share/perl5 and /usr/local/bin) > > ! - Configure local::lib your existing local::lib in this shell to set > > PERL_MM_OPT etc. > > ! - Install local::lib by running the following commands > > ! > > ! cpanm --local-lib=~/perl5 local::lib && eval $(perl -I > > ~/perl5/lib/perl5/ -Mlocal::lib) > > ! > > --> Working on SQL::SplitStatement > > Fetching > > http://www.cpan.org/authors/id/E/EM/EMAZEP/SQL-SplitStatement-1.00020.tar.gz > > ... OK > > Configuring SQL-SplitStatement-1.00020 ... OK > > ==> Found dependencies: SQL::Tokenizer, Regexp::Common > > --> Working on SQL::Tokenizer > > Fetching http://www.cpan.org/authors/id/I/IZ/IZUT/SQL-Tokenizer-0.24.tar.gz > > ... OK > > Configuring SQL-Tokenizer-0.24 ... OK > > Building and testing SQL-Tokenizer-0.24 ... OK > > Successfully tested SQL-Tokenizer-0.24 > > --> Working on Regexp::Common > > Fetching > > http://www.cpan.org/authors/id/A/AB/ABIGAIL/Regexp-Common-2017060201.tar.gz > > ... OK > > Configuring Regexp-Common-2017060201 ... OK > > Building and testing Regexp-Common-2017060201 ... OK > > Successfully tested Regexp-Common-2017060201 > > Building and testing SQL-SplitStatement-1.00020 ... FAIL > > ! Testing SQL::SplitStatement failed. See > > /home/robert/.cpanm/work/1571833529.27796/build.log for details. Retry with > > --force to force install it. > >

> > Don't know what more to say....

> > The contents of the failed build.log would be a good start. >

-- Robert Inder, 0131 229 1052 / 07808 492 213 Interactive Information Ltd, 3, Lauriston Gardens, Edinburgh EH3 9HH Registered in Scotland, Company no. SC 150689 Interactions speak louder than words

Download splitstatements-build.log
application/octet-stream 20k

Message body not shown because it is not plain text.

Fri Oct 25 07:15:36 2019 mcgrath.martin [...] gmail.com - Correspondence added

On Thu Oct 24 13:30:32 2019, robert@interactive.co.uk wrote: Show quoted text

> Sorry: me being dopey.... > > Should be attached. > > > On Thu, 24 Oct 2019 at 12:41, Martin McGrath via RT > <bug-SQL-SplitStatement@rt.cpan.org> wrote:

> > > > <URL: https://rt.cpan.org/Ticket/Display.html?id=130796 > > > > > On Wed Oct 23 13:36:55 2019, robert@interactive.co.uk wrote:

> > > See below. > > > Running on CentOS 7, perl 5.16. > > > So not bleeding edge, but... > > > > > > Don't know what more to say.... > > > > > > [robert@sandpit FIDDLE]$ cpanm --test-only SQL::SplitStatement > > > ! > > > ! Can't write to /usr/local/share/perl5 and /usr/local/bin: > > > Installing > > > modules to /home/robert/perl5 > > > ! To turn off this warning, you have to do one of the following: > > > ! - run me as a root or with --sudo option (to install to > > > /usr/local/share/perl5 and /usr/local/bin) > > > ! - Configure local::lib your existing local::lib in this shell > > > to set > > > PERL_MM_OPT etc. > > > ! - Install local::lib by running the following commands > > > ! > > > ! cpanm --local-lib=~/perl5 local::lib && eval $(perl -I > > > ~/perl5/lib/perl5/ -Mlocal::lib) > > > ! > > > --> Working on SQL::SplitStatement > > > Fetching > > > http://www.cpan.org/authors/id/E/EM/EMAZEP/SQL-SplitStatement- > > > 1.00020.tar.gz > > > ... OK > > > Configuring SQL-SplitStatement-1.00020 ... OK > > > ==> Found dependencies: SQL::Tokenizer, Regexp::Common > > > --> Working on SQL::Tokenizer > > > Fetching http://www.cpan.org/authors/id/I/IZ/IZUT/SQL-Tokenizer- > > > 0.24.tar.gz > > > ... OK > > > Configuring SQL-Tokenizer-0.24 ... OK > > > Building and testing SQL-Tokenizer-0.24 ... OK > > > Successfully tested SQL-Tokenizer-0.24 > > > --> Working on Regexp::Common > > > Fetching > > > http://www.cpan.org/authors/id/A/AB/ABIGAIL/Regexp-Common- > > > 2017060201.tar.gz > > > ... OK > > > Configuring Regexp-Common-2017060201 ... OK > > > Building and testing Regexp-Common-2017060201 ... OK > > > Successfully tested Regexp-Common-2017060201 > > > Building and testing SQL-SplitStatement-1.00020 ... FAIL > > > ! Testing SQL::SplitStatement failed. See > > > /home/robert/.cpanm/work/1571833529.27796/build.log for details. > > > Retry with > > > --force to force install it. > > >

> >

> > > Don't know what more to say....

> > > > The contents of the failed build.log would be a good start. > >

For context, I'm not the author, and have never used this module. Test 95-script.t skips unless module Test::Script::Run is installed. When I first installed SQL::SplitStatement I didn't have Test::Script::Run installed, so didn't experience the failure you report. Without digging deeper I suspect many of the smokers are in the same boat. See existing ticket: https://rt.cpan.org/Ticket/Display.html?id=125354 script sql-split reports that -E is not a valid option: Unknown Option: E However the manual (sql-split --man) states this should work. Test 95-script.t line 88 (https://metacpan.org/source/EMAZEP/SQL-SplitStatement-1.00020/t/95-script.t#L88), altering this to: [ '-s', $oss, '-f', $ofs, '--empty', @files ], Results in success, however you should probably dig deeper into the root cause (why -E doesn't work), examine the tests and the prerequisites (Test::Script::Run).