Comment 49 for bug 2002043

RELEASE=focal
TRIGGER=python2.7/2.7.18-1~20.04.4

sqlite3 autopkgtest.db -column -header \
"SELECT test.release, test.arch, test.package, "\
" result.version, result.exitcode, "\
" result.triggers, result.requester "\
"FROM test, result "\
"WHERE test.id = result.test_id "\
"AND test.release = '${RELEASE}' "\
"AND result.triggers LIKE '%${TRIGGER}%' "\
"ORDER BY test.release, test.package, test.arch"

release arch package version exitcode triggers requester
------- ------- --------------------- ---------------------------- -------- -------------------------- ---------
focal amd64 dbus-python 1.2.16-1build1 0 python2.7/2.7.18-1~20.04.4
focal arm64 dbus-python 1.2.16-1build1 0 python2.7/2.7.18-1~20.04.4
focal armhf dbus-python 1.2.16-1build1 0 python2.7/2.7.18-1~20.04.4
focal i386 dbus-python 1.2.16-1build1 14 python2.7/2.7.18-1~20.04.4
focal ppc64el dbus-python 1.2.16-1build1 0 python2.7/2.7.18-1~20.04.4
focal s390x dbus-python 1.2.16-1build1 0 python2.7/2.7.18-1~20.04.4
focal amd64 kodi 2:18.6+dfsg1-2ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal arm64 kodi 2:18.6+dfsg1-2ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal armhf kodi 2:18.6+dfsg1-2ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal ppc64el kodi 2:18.6+dfsg1-2ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal amd64 libapache2-mod-python 3.3.1-11ubuntu5 0 python2.7/2.7.18-1~20.04.4
focal arm64 libapache2-mod-python 3.3.1-11ubuntu5 0 python2.7/2.7.18-1~20.04.4
focal armhf libapache2-mod-python 3.3.1-11ubuntu5 0 python2.7/2.7.18-1~20.04.4
focal ppc64el libapache2-mod-python 3.3.1-11ubuntu5 0 python2.7/2.7.18-1~20.04.4
focal s390x libapache2-mod-python 3.3.1-11ubuntu5 0 python2.7/2.7.18-1~20.04.4
focal amd64 libgnatcoll-bindings 19-2 0 python2.7/2.7.18-1~20.04.4
focal arm64 libgnatcoll-bindings 19-2 0 python2.7/2.7.18-1~20.04.4
focal armhf libgnatcoll-bindings 19-2 0 python2.7/2.7.18-1~20.04.4
focal ppc64el libgnatcoll-bindings 19-2 0 python2.7/2.7.18-1~20.04.4
focal s390x libgnatcoll-bindings 19-2 0 python2.7/2.7.18-1~20.04.4
focal amd64 libxml2 2.9.10+dfsg-5ubuntu0.20.04.6 0 python2.7/2.7.18-1~20.04.4
focal arm64 libxml2 2.9.10+dfsg-5ubuntu0.20.04.6 0 python2.7/2.7.18-1~20.04.4
focal armhf libxml2 2.9.10+dfsg-5ubuntu0.20.04.6 0 python2.7/2.7.18-1~20.04.4
focal i386 libxml2 2.9.10+dfsg-5ubuntu0.20.04.6 12 python2.7/2.7.18-1~20.04.4
focal ppc64el libxml2 2.9.10+dfsg-5ubuntu0.20.04.6 0 python2.7/2.7.18-1~20.04.4
focal s390x libxml2 2.9.10+dfsg-5ubuntu0.20.04.6 0 python2.7/2.7.18-1~20.04.4
focal amd64 llvm-toolchain-7 1:7.0.1-12 0 python2.7/2.7.18-1~20.04.4
focal arm64 llvm-toolchain-7 1:7.0.1-12 4 python2.7/2.7.18-1~20.04.4
focal armhf llvm-toolchain-7 1:7.0.1-12 4 python2.7/2.7.18-1~20.04.4
focal ppc64el llvm-toolchain-7 1:7.0.1-12 4 python2.7/2.7.18-1~20.04.4
focal amd64 mercurial 5.3.1-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal arm64 mercurial 5.3.1-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal armhf mercurial 5.3.1-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal i386 mercurial 5.3.1-1ubuntu1 12 python2.7/2.7.18-1~20.04.4
focal ppc64el mercurial 5.3.1-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal s390x mercurial 5.3.1-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal amd64 mod-wsgi 4.6.8-1ubuntu3.1 0 python2.7/2.7.18-1~20.04.4
focal arm64 mod-wsgi 4.6.8-1ubuntu3.1 0 python2.7/2.7.18-1~20.04.4
focal armhf mod-wsgi 4.6.8-1ubuntu3.1 0 python2.7/2.7.18-1~20.04.4
focal ppc64el mod-wsgi 4.6.8-1ubuntu3.1 0 python2.7/2.7.18-1~20.04.4
focal s390x mod-wsgi 4.6.8-1ubuntu3.1 0 python2.7/2.7.18-1~20.04.4
focal amd64 pam-python 1.0.7-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal arm64 pam-python 1.0.7-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal armhf pam-python 1.0.7-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal ppc64el pam-python 1.0.7-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal s390x pam-python 1.0.7-1ubuntu1 4 python2.7/2.7.18-1~20.04.4
focal amd64 python-debian 0.1.36ubuntu1.1 0 python2.7/2.7.18-1~20.04.4
focal arm64 python-debian 0.1.36ubuntu1.1 0 python2.7/2.7.18-1~20.04.4
focal armhf python-debian 0.1.36ubuntu1.1 0 python2.7/2.7.18-1~20.04.4
focal i386 python-debian 0.1.36ubuntu1.1 12 python2.7/2.7.18-1~20.04.4
focal ppc64el python-debian 0.1.36ubuntu1.1 0 python2.7/2.7.18-1~20.04.4
focal s390x python-debian 0.1.36ubuntu1.1 0 python2.7/2.7.18-1~20.04.4
focal amd64 python-numpy 1:1.16.5-2ubuntu7 0 python2.7/2.7.18-1~20.04.4
focal arm64 python-numpy 1:1.16.5-2ubuntu7 0 python2.7/2.7.18-1~20.04.4
focal armhf python-numpy 1:1.16.5-2ubuntu7 0 python2.7/2.7.18-1~20.04.4
focal ppc64el python-numpy 1:1.16.5-2ubuntu7 0 python2.7/2.7.18-1~20.04.4
focal s390x python-numpy 1:1.16.5-2ubuntu7 0 python2.7/2.7.18-1~20.04.4
focal amd64 python-pbr 5.4.5-0ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal arm64 python-pbr 5.4.5-0ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal armhf python-pbr 5.4.5-0ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal i386 python-pbr 5.4.5-0ubuntu1 12 python2.7/2.7.18-1~20.04.4
focal ppc64el python-pbr 5.4.5-0ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal s390x python-pbr 5.4.5-0ubuntu1 0 python2.7/2.7.18-1~20.04.4
focal amd64 python2.7 2.7.18-1~20.04.4 4 python2.7/2.7.18-1~20.04.4
focal arm64 python2.7 2.7.18-1~20.04.4 4 python2.7/2.7.18-1~20.04.4
focal armhf python2.7 2.7.18-1~20.04.4 4 python2.7/2.7.18-1~20.04.4
focal i386 python2.7 2.7.18-1~20.04.4 4 python2.7/2.7.18-1~20.04.4
focal ppc64el python2.7 2.7.18-1~20.04.4 4 python2.7/2.7.18-1~20.04.4
focal s390x python2.7 2.7.18-1~20.04.4 4 python2.7/2.7.18-1~20.04.4