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
