[Bug 1168882] New: perl-SQL-Abstract-Limit-0.141-17.fc22 FTBFS: t/01.sql.t test fails
bugzilla at redhat.com
bugzilla at redhat.com
Fri Nov 28 10:05:32 UTC 2014
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 at redhat.com
Reporter: ppisar at redhat.com
QA Contact: extras-qa at fedoraproject.org
CC: perl-devel at lists.fedoraproject.org,
tcallawa at redhat.com
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
More information about the perl-devel
mailing list