[Bug 1168882] New: perl-SQL-Abstract-Limit-0.141-17.fc22 FTBFS: t/01.sql.t test fails

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



https://bugzilla.redhat.com/show_bug.cgi?id=1168882

            Bug ID: 1168882
           Summary: perl-SQL-Abstract-Limit-0.141-17.fc22 FTBFS:
                    t/01.sql.t test fails
           Product: Fedora
           Version: rawhide
         Component: perl-SQL-Abstract-Limit
          Assignee: tcallawa@xxxxxxxxxx
          Reporter: ppisar@xxxxxxxxxx
        QA Contact: extras-qa@xxxxxxxxxxxxxxxxx
                CC: perl-devel@xxxxxxxxxxxxxxxxxxxxxxx,
                    tcallawa@xxxxxxxxxx



perl-SQL-Abstract-Limit-0.141-17.fc22 fails to build because test fails:

+ make test
PERL_DL_NONLAZY=1 "/usr/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness"
"-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')"
t/*.t
# Testing SQL::Abstract::Limit 0.141
t/00.load.t ....... ok
#   Failed test 'LimitOffset SQL'
#   at t/01.sql.t line 61.
# SQL expressions differ
#      got: SELECT requestor, worker, colC, colH FROM TheTable WHERE ( (
requestor = ? AND status != ? AND ( worker = ? OR worker = ? OR worker = ? ) )
) ORDER BY pay, age LIMIT 10 OFFSET 70
# expected: SELECT requestor, worker, colC, colH FROM TheTable WHERE (
requestor = ? AND status != ? AND ( ( worker = ? ) OR ( worker = ? ) OR (
worker = ? ) ) ) ORDER BY pay, age LIMIT 10 OFFSET 70
#   Failed test 'LimitXY SQL'
#   at t/01.sql.t line 69.
# SQL expressions differ
#      got: SELECT requestor, worker, colC, colH FROM TheTable WHERE ( (
requestor = ? AND status != ? AND ( worker = ? OR worker = ? OR worker = ? ) )
) ORDER BY pay, age LIMIT 70, 10
# expected: SELECT requestor, worker, colC, colH FROM TheTable WHERE (
requestor = ? AND status != ? AND ( ( worker = ? ) OR ( worker = ? ) OR (
worker = ? ) ) ) ORDER BY pay, age LIMIT 70, 10
#   Failed test 'RowsTo SQL'
#   at t/01.sql.t line 77.
# SQL expressions differ
#      got: SELECT requestor, worker, colC, colH FROM TheTable WHERE ( (
requestor = ? AND status != ? AND ( worker = ? OR worker = ? OR worker = ? ) )
) ORDER BY pay, age ROWS 70 TO 80
# expected: SELECT requestor, worker, colC, colH FROM TheTable WHERE (
requestor = ? AND status != ? AND ( ( worker = ? ) OR ( worker = ? ) OR (
worker = ? ) ) ) ORDER BY pay, age ROWS 70 TO 80
#   Failed test 'Top SQL'
#   at t/01.sql.t line 87.
# SQL expressions differ
#      got: 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
# 
# expected: 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
#   Failed test 'RowNum SQL'
#   at t/01.sql.t line 102.
# SQL expressions differ
#      got: 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
# 
# expected: 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
Use of uninitialized value $asc_desc in uc at
/builddir/build/BUILD/SQL-Abstract-Limit-0.141/blib/lib/SQL/Abstract/Limit.pm
line 872.
#   Failed test 'GenericSubQ SQL'
#   at t/01.sql.t line 118.
# SQL expressions differ
#      got: 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
# 
# expected: 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
#   Failed test 'FetchFirst SQL'
#   at t/01.sql.t line 130.
# SQL expressions differ
#      got: SELECT * FROM (
#     SELECT * FROM (
#         SELECT requestor, worker, colC, colH FROM TheTable WHERE ( (
requestor = ? AND status != ? AND ( worker = ? OR worker = ? OR worker = ? ) )
)
#         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
# 
# expected: SELECT * FROM (SELECT * FROM (SELECT requestor, worker, colC, colH
FROM TheTable WHERE ( requestor = ? AND status != ? AND ( ( worker = ? ) OR (
worker = ? ) OR ( worker = ? ) ) ) 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
#   Failed test 'Skip SQL'
#   at t/01.sql.t line 143.
# SQL expressions differ
#      got: select skip 70 limit 10  requestor, worker, colC, colH FROM
TheTable WHERE ( ( requestor = ? AND status != ? AND ( worker = ? OR worker = ?
OR worker = ? ) ) )  ORDER BY pay, age
# expected: select skip 70 limit 10 requestor, worker, colC, colH FROM TheTable
WHERE ( requestor = ? AND status != ? AND ( ( worker = ? ) OR ( worker = ? ) OR
( worker = ? ) ) ) ORDER BY pay, age
# Looks like you failed 8 tests of 17.
t/01.sql.t ........ 
Dubious, test returned 8 (wstat 2048, 0x800)
Failed 8/17 subtests 

Difference between working and failed build roots:

Removed packages:
    audit-libs-2.4.1
    basesystem-10.0
    bash-4.3.30
    binutils-2.24
    bzip2-1.0.6
    bzip2-libs-1.0.6
    ca-certificates-2014.2.1
    chkconfig-1.3.63
    coreutils-8.23
    cpio-2.11
    cpp-4.9.2
    cracklib-2.9.1
    cracklib-dicts-2.9.1
    crypto-policies-20140905
    curl-7.39.0
    cyrus-sasl-lib-2.1.26
    diffutils-3.3
    dwz-0.11
    elfutils-0.160
    elfutils-libelf-0.160
    elfutils-libs-0.160
    expat-2.1.0
    fedora-release-22
    fedora-release-cloud-22
    fedora-repos-22
    fedora-repos-rawhide-22
    file-5.20
    file-libs-5.20
    filesystem-3.2
    findutils-4.5.14
    gawk-4.1.1
    gcc-4.9.2
    gcc-c++-4.9.2
    gdbm-1.11
    ghc-srpm-macros-1.3
    glib2-2.43.0
    gmp-6.0.0
    gnat-srpm-macros-1
    gnupg2-2.0.25
    grep-2.20
    groff-base-1.22.2
    gzip-1.6
    info-5.2
    keyutils-libs-1.5.9
    krb5-libs-1.13
    libacl-2.2.52
    libarchive-3.1.2
    libassuan-2.1.2
    libattr-2.4.47
    libbabeltrace-1.2.1
    libblkid-2.25.2
    libcap-2.24
    libcap-ng-0.7.4
    libcom_err-1.42.12
    libcurl-7.39.0
    libdb-5.3.28
    libdb-utils-5.3.28
    libffi-3.1
    libgcc-4.9.2
    libgcrypt-1.6.1
    libgomp-4.9.2
    libgpg-error-1.16
    libidn-1.29
    libmetalink-0.1.2
    libmount-2.25.2
    libmpc-1.0.2
    libpwquality-1.2.4
    libselinux-2.3
    libsemanage-2.3
    libsepol-2.3
    libsmartcols-2.25.2
    libssh2-1.4.3
    libstdc++-4.9.2
    libstdc++-devel-4.9.2
    libtasn1-4.2
    libuser-0.60
    libutempter-1.1.6
    libuuid-2.25.2
    libverto-0.2.6
    libxml2-2.9.2
    lua-5.2.2
    lzo-2.08
    make-4.0
    mpfr-3.1.2
    ncurses-5.9
    ncurses-base-5.9
    ncurses-libs-5.9
    nspr-4.10.7
    nss-3.17.2
    nss-softokn-3.17.2
    nss-softokn-freebl-3.17.2
    nss-sysinit-3.17.2
    nss-tools-3.17.2
    nss-util-3.17.2
    ocaml-srpm-macros-2
    openldap-2.4.40
    openssl-libs-1.0.1j
    p11-kit-0.22.1
    p11-kit-trust-0.22.1
    pam-1.1.8
    patch-2.7.1
    pcre-8.36
    perl-5.20.1
    perl-Carp-1.33.01
    perl-Class-Accessor-Grouped-0.10010
    perl-Class-Inspector-1.28
    perl-constant-1.31
    perl-DBI-1.631
    perl-Exporter-5.71
    perl-ExtUtils-MakeMaker-7.00
    perl-ExtUtils-Manifest-1.68
    perl-File-Path-2.09
    perl-File-Temp-0.23.04
    perl-Filter-1.50
    perl-generators-1.00
    perl-Getopt-Long-2.42
    perl-HTTP-Tiny-0.050
    perl-libs-5.20.1
    perl-macros-5.20.1
    perl-parent-0.228
    perl-PathTools-3.48
    perl-Pod-Escapes-1.06
    perl-Pod-Simple-3.28
    perl-Pod-Usage-1.63
    perl-Scalar-List-Utils-1.38
    perl-SQL-Abstract-1.77
    perl-srpm-macros-1
    perl-Test-Deep-0.112
    perl-Test-Harness-3.33
    perl-Text-ParseWords-3.29
    perl-threads-shared-1.46
    perl-Time-HiRes-1.9726
    perl-Time-Local-1.2300
    pinentry-0.8.3
    pkgconfig-0.28
    popt-1.16
    pth-2.0.7
    python-libs-2.7.8
    readline-6.3
    redhat-rpm-config-26
    rpm-4.12.0.1
    rpm-build-4.12.0.1
    rpm-build-libs-4.12.0.1
    rpm-libs-4.12.0.1
    rpm-plugin-selinux-4.12.0.1
    sed-4.2.2
    setup-2.9.2
    shadow-utils-4.1.5.1
    shared-mime-info-1.3
    sqlite-3.8.7
    systemd-libs-217
    tar-1.28
    tzdata-2014i
    unzip-6.0
    ustr-1.0.4
    util-linux-2.25.2
    which-2.20
    xz-5.1.2
    xz-libs-5.1.2
    zip-3.0
    zlib-1.2.8
Added packages:
    ccache-3.1.10
    perl-Class-Accessor-Grouped-0.10012
    perl-DBI-1.632
    perl-ExtUtils-Command-1.18
    perl-ExtUtils-MakeMaker-7.02
    perl-ExtUtils-Manifest-1.69
    perl-generators-1.01
    perl-HTTP-Tiny-0.051
    perl-Pod-Usage-1.64
    perl-Scalar-List-Utils-1.41
    perl-SQL-Abstract-1.81
    perl-Test-Deep-0.113
    perl-Test-Harness-3.34

-- 
You are receiving this mail because:
You are on the CC list for the bug.
Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=Q7Az72lVJg&a=cc_unsubscribe
--
Fedora Extras Perl SIG
http://www.fedoraproject.org/wiki/Extras/SIGs/Perl
perl-devel mailing list
perl-devel@xxxxxxxxxxxxxxxxxxxxxxx
https://admin.fedoraproject.org/mailman/listinfo/perl-devel





[Index of Archives]     [Fedora Announce]     [Fedora Kernel]     [Fedora Testing]     [Fedora Legacy Announce]     [Fedora PHP Devel]     [Kernel Devel]     [Fedora Legacy]     [Fedora Maintainers]     [Fedora Desktop]     [PAM]     [Red Hat Development]     [Big List of Linux Books]     [Gimp]     [Yosemite Information]
  Powered by Linux