PASS SQL-Abstract-Limit-0.12 MSWin32-x86-multi-thread 5.1

This distribution has been tested as part of the cpan-testers
effort to test as many new uploads to CPAN as possible.  See
http://testers.cpan.org/


--
Dear David R. Baird,
    
This is a computer-generated report for SQL-Abstract-Limit-0.12
on perl 5.11.0 patch 34101, created by CPAN-Reporter-1.1556. 

Thank you for uploading your work to CPAN.  Congratulations!
All tests were successful.

Sections of this report:

    * Tester comments
    * Program output
    * Prerequisites
    * Environment and other context

------------------------------
TESTER COMMENTS
------------------------------

Additional comments from tester: 

this report is from an automated smoke testing program
and was not reviewed by a human for accuracy

------------------------------
PROGRAM OUTPUT
------------------------------

Output from 'C:\perl\bin\perl.exe ./Build test':

t\00.load.........
1..1
# Testing SQL::Abstract::Limit 0.12
ok 1 - use SQL::Abstract::Limit;
ok
t\01.sql..........
1..22
ok 1 - survives constructor
ok 2 - select LimitOffset
ok 3 - base SQL
ok 4 - complete SQL
ok 5 - select LimitXY
ok 6 - base SQL
ok 7 - complete SQL
ok 8 - select LimitXY
ok 9 - base SQL
ok 10 - complete SQL
ok 11 - select Top
ok 12 - base SQL
not ok 13 - complete SQL # TODO need regex for complex query

#   Failed (TODO) test 'complete SQL'
#   at t\01.sql.t line 75.
#                   'SELECT * FROM
# (
#     SELECT TOP 10 * FROM
#     (
#         SELECT TOP 80  requestor, worker, colC, colH FROM TheTable WHERE ( requestor = ? AND status != ? AND ( ( worker = ? ) OR ( worker = ? ) OR ( worker = ? ) ) ) ORDER BY pay ASC, age ASC
#     ) AS foo
#     ORDER BY pay DESC, age DESC
# ) AS bar
# ORDER BY pay ASC, age ASC
# '
#     doesn't match '(?-xism:^complete\ SQL$)'
ok 14 - select RowNum
ok 15 - base SQL
not ok 16 - complete SQL # TODO need regex for complex query

#   Failed (TODO) test 'complete SQL'
#   at t\01.sql.t line 84.
#                   'SELECT * FROM
# (
#     SELECT A.*, ROWNUM r FROM
#     (
#         SELECT requestor, worker, colC, colH FROM TheTable WHERE ( requestor = ? AND status != ? AND ( ( worker = ? ) OR ( worker = ? ) OR ( worker = ? ) ) )  ORDER BY pay, age
#     ) A
#     WHERE ROWNUM < 81
# ) B
# WHERE r >= 71
# '
#     doesn't match '(?-xism:^complete\ SQL$)'
Use of uninitialized value $asc_desc in uc at C:\.cpan\build\SQL-Abstract-Limit-0.12-F8dvkD\blib\lib/SQL/Abstract/Limit.pm line 872.
ok 17 - select GenericSubQ
ok 18 - GenericSubQ SQL
not ok 19 - complete SQL # TODO need regex for complex query

#   Failed (TODO) test 'complete SQL'
#   at t\01.sql.t line 95.
#                   'SELECT requestor, worker, colC, colH FROM TheTable X WHERE ( requestor = ? AND status != ? AND ( ( worker = ? ) OR ( worker = ? ) OR ( worker = ? ) ) ) AND
# (
#     SELECT COUNT(*) FROM TheTable WHERE requestor > X.requestor
# )
# BETWEEN 70 AND 80
# ORDER BY requestor DESC
# '
#     doesn't match '(?-xism:^complete\ SQL$)'
ok 20 - select GenericSubQ
ok 21 - base SQL
not ok 22 - complete SQL # TODO need regex for complex query

#   Failed (TODO) test 'complete SQL'
#   at t\01.sql.t line 104.
#                   'SELECT * FROM (
#     SELECT * FROM (
#         SELECT requestor, worker, colC, colH FROM TheTable WHERE ( requestor = ? AND status != ? AND ( ( worker = ? ) OR ( worker = ? ) OR ( worker = ? ) ) )
 *** not yet testing subquery LIMIT emulations
#         ORDER BY pay ASC, age ASC
#         FETCH FIRST 80 ROWS ONLY
#     ) foo
#     ORDER BY pay DESC, age DESC
#     FETCH FIRST 10 ROWS ONLY
# ) bar
# ORDER BY pay ASC, age ASC
# '
#     doesn't match '(?-xism:^complete\ SQL$)'
ok
t\02.syntax.......
1..7
ok 1 # SKIP need DBD::AnyData and Class::DBI to test syntax auto-detection
ok 2 # SKIP need DBD::AnyData and Class::DBI to test syntax auto-detection
ok 3 # SKIP need DBD::AnyData and Class::DBI to test syntax auto-detection
ok 4 # SKIP need DBD::AnyData and Class::DBI to test syntax auto-detection
ok 5 # SKIP need DBD::AnyData and Class::DBI to test syntax auto-detection
ok 6 # SKIP need DBD::AnyData and Class::DBI to test syntax auto-detection
ok 7 # SKIP need DBD::AnyData and Class::DBI to test syntax auto-detection
ok
t\03.subclass.....
1..3
ok 1 - my own limit
ok 2 - custom LIMIT
ok 3 - SQL::Abstract - no limit
ok
t\04.args.........
1..3
ok 1 - no-LIMIT with ORDER BY
ok 2 - SQL::Abstract base stmt
ok 3 - got an order_by clause
ok
t\pod-coverage....
1..1
ok 1 - Pod coverage on SQL::Abstract::Limit
ok
t\pod.............
1..1
ok 1 - blib\lib\SQL\Abstract\Limit.pm
ok
All tests successful.
Files=7, Tests=38,  3 wallclock secs ( 0.17 usr +  0.03 sys =  0.20 CPU)
Result: PASS

------------------------------
PREREQUISITES
------------------------------

Prerequisite modules loaded:

requires:

    Module          Need Have 
    --------------- ---- -----
    DBI             0    1.604
    SQL::Abstract   1.2  1.22 
    Test::Exception 0    0.27 
    Test::More      0    0.80 

------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------

Environment variables:

    AUTOMATED_TESTING = 1
    COMSPEC = C:\WINDOWS\system32\cmd.exe
    NUMBER_OF_PROCESSORS = 1
    PATH = C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Graphviz2.18\Bin;C:\Program Files\Bakefile;C:\Program Files\TortoiseSVN\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Subversion\bin;C:\MinGW\bin\;C:\perl\bin\;C:\bin\
    PERL5LIB = \.cpan\build\SQL-Abstract-1.22-gbwgZ7/blib/arch;\.cpan\build\SQL-Abstract-1.22-gbwgZ7/blib/lib;\.cpan\build\MRO-Compat-0.09-8kVGps/blib/arch;\.cpan\build\MRO-Compat-0.09-8kVGps/blib/lib;\.cpan\build\JSON-Any-1.16-z4hVV4/blib/arch;\.cpan\build\JSON-Any-1.16-z4hVV4/blib/lib;\.cpan\build\Class-C3-0.19-t8NVjf/blib/arch;\.cpan\build\Class-C3-0.19-t8NVjf/blib/lib;\.cpan\build\UNIVERSAL-require-0.11-us8js_/blib/arch;\.cpan\build\UNIVERSAL-require-0.11-us8js_/blib/lib
    PERL5OPT = 
    PERL5_CPANPLUS_IS_RUNNING = 3720
    PERL5_CPAN_IS_RUNNING = 3720
    PERL5_CPAN_IS_RUNNING_IN_RECURSION = 1932,3720
    PERL_CR_SMOKER_CURRENT = Catalyst-Plugin-Authentication-Store-DBIC-0.10
    PERL_MM_USE_DEFAULT = 1
    PROCESSOR_IDENTIFIER = x86 Family 15 Model 3 Stepping 3, GenuineIntel
    TEMP = C:\DOCUME~1\SANKOR~1\LOCALS~1\Temp

Perl special variables (and OS-specific diagnostics, for MSWin32):

    $^X = C:\perl\bin\perl.exe
    $UID/$EUID = 0 / 0
    $GID = 0
    $EGID = 0
    Win32::GetOSName = WinXP/.Net
    Win32::GetOSVersion = Service Pack 3, v.3311, 5, 1, 2600, 2, 3, 0, 0, 1
    Win32::FsType = NTFS
    Win32::IsAdminUser = 1

Perl module toolchain versions installed:

    Module              Have     
    ------------------- ---------
    CPAN                1.92_63  
    Cwd                 3.2701   
    ExtUtils::CBuilder  0.23     
    ExtUtils::Command   1.14     
    ExtUtils::Install   1.50_01  
    ExtUtils::MakeMaker 6.44     
    ExtUtils::Manifest  1.54     
    ExtUtils::ParseXS   2.19_01  
    File::Spec          3.2701   
    Module::Build       0.2808_02
    Module::Signature   n/a      
    Test::Harness       3.12     
    Test::More          0.80     
    YAML                0.66     
    YAML::Syck          n/a      
    version             0.7501   


--

Summary of my perl5 (revision 5 version 11 subversion 0 patch 34101) configuration:
  Platform:
    osname=MSWin32, osvers=5.1, archname=MSWin32-x86-multi-thread
    uname=''
    config_args='undef'
    hint=recommended, useposix=true, d_sigaction=undef
    useithreads=define, usemultiplicity=define
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
    use64bitint=undef, use64bitall=undef, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='gcc', ccflags =' -s -O2 -DWIN32 -DHAVE_DES_FCRYPT  -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fno-strict-aliasing -mms-bitfields -DPERL_MSVCRT_READFIX',
    optimize='-s -O2',
    cppflags='-DWIN32'
    ccversion='', gccversion='3.4.5', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='long long', lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='g++', ldflags ='-s -L"c:\perl\lib\CORE" -L"C:\MinGW\lib"'
    libpth=C:\MinGW\lib
    libs=-lmsvcrt -lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32 -ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr -lwinmm -lversion -lodbc32 -lodbccp32
    perllibs=-lmsvcrt -lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32 -ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr -lwinmm -lversion -lodbc32 -lodbccp32
    libc=-lmsvcrt, so=dll, useshrplib=true, libperl=libperl511.a
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
    cccdlflags=' ', lddlflags='-mdll -s -L"c:\perl\lib\CORE" -L"C:\MinGW\lib"'

• PASS SQL-Abstract-Limit-0.12 MSWin32-x86-multi-thread 5.1 by sanko