Thu Jul 22 07:09:29 UTC 2021 I: starting to build libsql-statement-perl/bullseye/arm64 on jenkins on '2021-07-22 07:09' Thu Jul 22 07:09:29 UTC 2021 I: The jenkins build log is/was available at https://jenkins.debian.net/userContent/reproducible/debian/build_service/arm64_23/23574/console.log Thu Jul 22 07:09:29 UTC 2021 I: Downloading source for bullseye/libsql-statement-perl=1.414-1 --2021-07-22 07:09:29-- http://cdn-fastly.deb.debian.org/debian/pool/main/libs/libsql-statement-perl/libsql-statement-perl_1.414-1.dsc Connecting to 78.137.99.97:3128... connected. Proxy request sent, awaiting response... 200 OK Length: 2762 (2.7K) Saving to: ‘libsql-statement-perl_1.414-1.dsc’ 0K .. 100% 182M=0s 2021-07-22 07:09:29 (182 MB/s) - ‘libsql-statement-perl_1.414-1.dsc’ saved [2762/2762] Thu Jul 22 07:09:29 UTC 2021 I: libsql-statement-perl_1.414-1.dsc -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Format: 3.0 (quilt) Source: libsql-statement-perl Binary: libsql-statement-perl Architecture: all Version: 1.414-1 Maintainer: Debian Perl Group Uploaders: gregor herrmann , Ansgar Burchardt , Xavier Guimard Homepage: https://metacpan.org/release/SQL-Statement Standards-Version: 4.5.0 Vcs-Browser: https://salsa.debian.org/perl-team/modules/packages/libsql-statement-perl Vcs-Git: https://salsa.debian.org/perl-team/modules/packages/libsql-statement-perl.git Testsuite: autopkgtest-pkg-perl Build-Depends: debhelper-compat (= 13) Build-Depends-Indep: libclone-perl , libdbi-perl , libmath-base-convert-perl , libmodule-runtime-perl , libparams-util-perl , libtest-deep-perl , libtest-pod-coverage-perl , libtest-pod-perl , libtext-soundex-perl , perl Package-List: libsql-statement-perl deb perl optional arch=all Checksums-Sha1: 2fef0bff3aff7e02c6866d9fb60da77743bb37ed 159512 libsql-statement-perl_1.414.orig.tar.gz f1b6784a3dc1aae2f0f0b37d403206c8b284765b 6548 libsql-statement-perl_1.414-1.debian.tar.xz Checksums-Sha256: dde8bdcfa6a136eedda06519ba0f3efaec085c39db0df9c472dc0ec6cd781a49 159512 libsql-statement-perl_1.414.orig.tar.gz 24fdd8950a384460f9def29af33b547ef28b4f5c8e632d37081fe561f78590e1 6548 libsql-statement-perl_1.414-1.debian.tar.xz Files: f93b655aef646b478ccac8d08a7115dd 159512 libsql-statement-perl_1.414.orig.tar.gz 059b0dd2f59dbdc4eb304bfac45845dc 6548 libsql-statement-perl_1.414-1.debian.tar.xz Dgit: 6527e6b15723a714cccc8dadcc33a9c39a293195 debian archive/debian/1.414-1 https://git.dgit.debian.org/libsql-statement-perl -----BEGIN PGP SIGNATURE----- iQKTBAEBCgB9FiEE0eExbpOnYKgQTYX6uzpoAYZJqgYFAl+TX41fFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldEQx RTEzMTZFOTNBNzYwQTgxMDREODVGQUJCM0E2ODAxODY0OUFBMDYACgkQuzpoAYZJ qgZfPRAAkLB0gb15ZU54anjIhdceyQPPlVVXaRW6VAyPkicOQRWizIXSLxACVCfb 8qhQT5n0h33UxhnCCzPZ2I5IAf6sryhE+ge2pduoe8A4LHRUAHNtz/MTATHMscpM 5h4GsSi3egv3jV1EUWhvhKj/etFHQltL/MvVunz9YEIx1vmK87ScdExLySeUdEXt JTp1/gMw1HNky34mU9QbFlKi19cVXtXMvAlT37/KATTMLzbfN9WmrGpacyqyggFt kJNJ/EN/V8Ra/l/gkiPpN9v960y32pWyTk6gpJy7qpX54CenHkU4hHgCgq5Bevgc cxlocyFH+el/lSXrItTBVzWYUjUZXVExV2GhWCnG+Xa++kek/pS51lqCqroDyuI2 KVQ9LvfP/qze6MBxTnlBfykgYhu0uaBRxv1kX7VrtSzD2GhnVnn75gsiic6GvkwZ GyMqaS5FUaxOXL55kRu1lCBy7fO9tYh/R+4e2K1ZONtG6y++YR5JUGz3lOtGvc3+ VZfUPuw/Gvbu8KQrx3sNL+xQXZmgP0O+LB+ATDOxhaENQD6/wbUmDe6tgE+AyJis jv7prCPhU2qWkZ/vMtvAAaHp5jFYTlg3/NiOcja5QBBsn19KyNW974q07tfN5RR1 3tzURGrklkbDfPHZN5Yqo/1xcu8S0m/R/vvC+7YWvFIRmYKitmE= =P+a4 -----END PGP SIGNATURE----- Thu Jul 22 07:09:29 UTC 2021 I: Checking whether the package is not for us Thu Jul 22 07:09:29 UTC 2021 I: Starting 1st build on remote node codethink14-arm64.debian.net. Thu Jul 22 07:09:29 UTC 2021 I: Preparing to do remote build '1' on codethink14-arm64.debian.net. Thu Jul 22 07:10:15 UTC 2021 I: Deleting $TMPDIR on codethink14-arm64.debian.net. I: pbuilder: network access will be disabled during build I: Current time: Wed Jul 21 19:09:31 -12 2021 I: pbuilder-time-stamp: 1626937771 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bullseye-reproducible-base.tgz] I: copying local configuration I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [libsql-statement-perl_1.414-1.dsc] I: copying [./libsql-statement-perl_1.414.orig.tar.gz] I: copying [./libsql-statement-perl_1.414-1.debian.tar.xz] I: Extracting source gpgv: unknown type of key resource 'trustedkeys.kbx' gpgv: keyblock resource '/tmp/dpkg-verify-sig.1tUTJqdO/trustedkeys.kbx': General error gpgv: Signature made Fri Oct 23 10:56:13 2020 -12 gpgv: using RSA key D1E1316E93A760A8104D85FABB3A68018649AA06 gpgv: Can't check signature: No public key dpkg-source: warning: failed to verify signature on ./libsql-statement-perl_1.414-1.dsc dpkg-source: info: extracting libsql-statement-perl in libsql-statement-perl-1.414 dpkg-source: info: unpacking libsql-statement-perl_1.414.orig.tar.gz dpkg-source: info: unpacking libsql-statement-perl_1.414-1.debian.tar.xz I: Not using root during the build. I: Installing the build-deps I: user script /srv/workspace/pbuilder/6207/tmp/hooks/D02_print_environment starting I: set BUILDDIR='/build' BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' BUILDUSERNAME='pbuilder1' BUILD_ARCH='arm64' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=8' DISTRIBUTION='' HOME='/var/lib/jenkins' HOST_ARCH='arm64' IFS=' ' LANG='C' LANGUAGE='en_US:en' LC_ALL='C' MAIL='/var/mail/root' OPTIND='1' PATH='/usr/sbin:/usr/bin:/sbin:/bin:/usr/games' PBCURRENTCOMMANDLINEOPERATION='build' PBUILDER_OPERATION='build' PBUILDER_PKGDATADIR='/usr/share/pbuilder' PBUILDER_PKGLIBDIR='/usr/lib/pbuilder' PBUILDER_SYSCONFDIR='/etc' PPID='6207' PS1='# ' PS2='> ' PS4='+ ' PWD='/' SHELL='/bin/bash' SHLVL='2' SUDO_COMMAND='/usr/bin/timeout -k 18.1h 18h /usr/bin/ionice -c 3 /usr/bin/nice /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/tmp.GUbsCGEWx3/pbuilderrc_kwL0 --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.GUbsCGEWx3/b1 --logfile b1/build.log libsql-statement-perl_1.414-1.dsc' SUDO_GID='117' SUDO_UID='110' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' USERNAME='root' _='/usr/bin/systemd-run' http_proxy='http://192.168.101.16:3128' I: uname -a Linux codethink14-arm64 4.15.0-151-generic #157-Ubuntu SMP Fri Jul 9 21:03:48 UTC 2021 aarch64 GNU/Linux I: ls -l /bin total 5252 -rwxr-xr-x 1 root root 1282512 Jun 21 14:26 bash -rwxr-xr-x 3 root root 34808 Jul 20 2020 bunzip2 -rwxr-xr-x 3 root root 34808 Jul 20 2020 bzcat lrwxrwxrwx 1 root root 6 Jul 20 2020 bzcmp -> bzdiff -rwxr-xr-x 1 root root 2225 Jul 20 2020 bzdiff lrwxrwxrwx 1 root root 6 Jul 20 2020 bzegrep -> bzgrep -rwxr-xr-x 1 root root 4877 Sep 4 2019 bzexe lrwxrwxrwx 1 root root 6 Jul 20 2020 bzfgrep -> bzgrep -rwxr-xr-x 1 root root 3775 Jul 20 2020 bzgrep -rwxr-xr-x 3 root root 34808 Jul 20 2020 bzip2 -rwxr-xr-x 1 root root 14264 Jul 20 2020 bzip2recover lrwxrwxrwx 1 root root 6 Jul 20 2020 bzless -> bzmore -rwxr-xr-x 1 root root 1297 Jul 20 2020 bzmore -rwxr-xr-x 1 root root 39832 Sep 22 2020 cat -rwxr-xr-x 1 root root 64512 Sep 22 2020 chgrp -rwxr-xr-x 1 root root 60368 Sep 22 2020 chmod -rwxr-xr-x 1 root root 64528 Sep 22 2020 chown -rwxr-xr-x 1 root root 138896 Sep 22 2020 cp -rwxr-xr-x 1 root root 129544 Dec 10 2020 dash -rwxr-xr-x 1 root root 101384 Sep 22 2020 date -rwxr-xr-x 1 root root 80984 Sep 22 2020 dd -rwxr-xr-x 1 root root 89824 Sep 22 2020 df -rwxr-xr-x 1 root root 143088 Sep 22 2020 dir -rwxr-xr-x 1 root root 76152 Feb 7 02:38 dmesg lrwxrwxrwx 1 root root 8 Nov 6 2019 dnsdomainname -> hostname lrwxrwxrwx 1 root root 8 Nov 6 2019 domainname -> hostname -rwxr-xr-x 1 root root 35632 Sep 22 2020 echo -rwxr-xr-x 1 root root 28 Nov 9 2020 egrep -rwxr-xr-x 1 root root 31512 Sep 22 2020 false -rwxr-xr-x 1 root root 28 Nov 9 2020 fgrep -rwxr-xr-x 1 root root 64856 Feb 7 02:38 findmnt -rwsr-xr-x 1 root root 34824 Feb 26 04:12 fusermount -rwxr-xr-x 1 root root 178400 Nov 9 2020 grep -rwxr-xr-x 2 root root 2346 Mar 2 11:30 gunzip -rwxr-xr-x 1 root root 6376 Mar 2 11:30 gzexe -rwxr-xr-x 1 root root 93744 Mar 2 11:30 gzip -rwxr-xr-x 1 root root 18440 Nov 6 2019 hostname -rwxr-xr-x 1 root root 68720 Sep 22 2020 ln -rwxr-xr-x 1 root root 52720 Feb 7 2020 login -rwxr-xr-x 1 root root 143088 Sep 22 2020 ls -rwxr-xr-x 1 root root 161960 Feb 7 02:38 lsblk -rwxr-xr-x 1 root root 85200 Sep 22 2020 mkdir -rwxr-xr-x 1 root root 68744 Sep 22 2020 mknod -rwxr-xr-x 1 root root 43976 Sep 22 2020 mktemp -rwxr-xr-x 1 root root 51368 Feb 7 02:38 more -rwsr-xr-x 1 root root 51360 Feb 7 02:38 mount -rwxr-xr-x 1 root root 14496 Feb 7 02:38 mountpoint -rwxr-xr-x 1 root root 134808 Sep 22 2020 mv lrwxrwxrwx 1 root root 8 Nov 6 2019 nisdomainname -> hostname lrwxrwxrwx 1 root root 14 Apr 18 03:38 pidof -> /sbin/killall5 -rwxr-xr-x 1 root root 35720 Sep 22 2020 pwd lrwxrwxrwx 1 root root 4 Jun 21 14:26 rbash -> bash -rwxr-xr-x 1 root root 43872 Sep 22 2020 readlink -rwxr-xr-x 1 root root 68592 Sep 22 2020 rm -rwxr-xr-x 1 root root 43880 Sep 22 2020 rmdir -rwxr-xr-x 1 root root 19208 Sep 27 2020 run-parts -rwxr-xr-x 1 root root 114016 Dec 22 2018 sed lrwxrwxrwx 1 root root 4 Jul 19 21:26 sh -> dash -rwxr-xr-x 1 root root 35656 Sep 22 2020 sleep -rwxr-xr-x 1 root root 72640 Sep 22 2020 stty -rwsr-xr-x 1 root root 67776 Feb 7 02:38 su -rwxr-xr-x 1 root root 35672 Sep 22 2020 sync -rwxr-xr-x 1 root root 535768 Feb 16 21:55 tar -rwxr-xr-x 1 root root 10568 Sep 27 2020 tempfile -rwxr-xr-x 1 root root 89120 Sep 22 2020 touch -rwxr-xr-x 1 root root 31512 Sep 22 2020 true -rwxr-xr-x 1 root root 14264 Feb 26 04:12 ulockmgr_server -rwsr-xr-x 1 root root 30880 Feb 7 02:38 umount -rwxr-xr-x 1 root root 35640 Sep 22 2020 uname -rwxr-xr-x 2 root root 2346 Mar 2 11:30 uncompress -rwxr-xr-x 1 root root 143088 Sep 22 2020 vdir -rwxr-xr-x 1 root root 59584 Feb 7 02:38 wdctl lrwxrwxrwx 1 root root 8 Nov 6 2019 ypdomainname -> hostname -rwxr-xr-x 1 root root 1984 Mar 2 11:30 zcat -rwxr-xr-x 1 root root 1678 Mar 2 11:30 zcmp -rwxr-xr-x 1 root root 5880 Mar 2 11:30 zdiff -rwxr-xr-x 1 root root 29 Mar 2 11:30 zegrep -rwxr-xr-x 1 root root 29 Mar 2 11:30 zfgrep -rwxr-xr-x 1 root root 2081 Mar 2 11:30 zforce -rwxr-xr-x 1 root root 7585 Mar 2 11:30 zgrep -rwxr-xr-x 1 root root 2206 Mar 2 11:30 zless -rwxr-xr-x 1 root root 1842 Mar 2 11:30 zmore -rwxr-xr-x 1 root root 4553 Mar 2 11:30 znew I: user script /srv/workspace/pbuilder/6207/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: arm64 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 13), libclone-perl, libdbi-perl, libmath-base-convert-perl, libmodule-runtime-perl, libparams-util-perl, libtest-deep-perl, libtest-pod-coverage-perl, libtest-pod-perl, libtext-soundex-perl, perl dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19646 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 13); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on libclone-perl; however: Package libclone-perl is not installed. pbuilder-satisfydepends-dummy depends on libdbi-perl; however: Package libdbi-perl is not installed. pbuilder-satisfydepends-dummy depends on libmath-base-convert-perl; however: Package libmath-base-convert-perl is not installed. pbuilder-satisfydepends-dummy depends on libmodule-runtime-perl; however: Package libmodule-runtime-perl is not installed. pbuilder-satisfydepends-dummy depends on libparams-util-perl; however: Package libparams-util-perl is not installed. pbuilder-satisfydepends-dummy depends on libtest-deep-perl; however: Package libtest-deep-perl is not installed. pbuilder-satisfydepends-dummy depends on libtest-pod-coverage-perl; however: Package libtest-pod-coverage-perl is not installed. pbuilder-satisfydepends-dummy depends on libtest-pod-perl; however: Package libtest-pod-perl is not installed. pbuilder-satisfydepends-dummy depends on libtext-soundex-perl; however: Package libtext-soundex-perl is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libb-hooks-op-check-perl{a} libclone-perl{a} libdbi-perl{a} libdebhelper-perl{a} libdevel-callchecker-perl{a} libdevel-symdump-perl{a} libdynaloader-functions-perl{a} libelf1{a} libfile-stripnondeterminism-perl{a} libicu67{a} libmagic-mgc{a} libmagic1{a} libmath-base-convert-perl{a} libmodule-runtime-perl{a} libparams-classify-perl{a} libparams-util-perl{a} libpipeline1{a} libpod-coverage-perl{a} libpod-parser-perl{a} libsigsegv2{a} libsub-override-perl{a} libtest-deep-perl{a} libtest-pod-coverage-perl{a} libtest-pod-perl{a} libtext-soundex-perl{a} libtool{a} libuchardet0{a} libxml2{a} m4{a} man-db{a} po-debconf{a} sensible-utils{a} The following packages are RECOMMENDED but will NOT be installed: curl libarchive-cpio-perl libltdl-dev libmail-sendmail-perl lynx wget 0 packages upgraded, 47 newly installed, 0 to remove and 0 not upgraded. Need to get 19.1 MB of archives. After unpacking 70.6 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bullseye/main arm64 bsdextrautils arm64 2.36.1-7 [141 kB] Get: 2 http://deb.debian.org/debian bullseye/main arm64 libuchardet0 arm64 0.0.7-1 [67.9 kB] Get: 3 http://deb.debian.org/debian bullseye/main arm64 groff-base arm64 1.22.4-6 [883 kB] Get: 4 http://deb.debian.org/debian bullseye/main arm64 libpipeline1 arm64 1.5.3-1 [33.0 kB] Get: 5 http://deb.debian.org/debian bullseye/main arm64 man-db arm64 2.9.4-2 [1336 kB] Get: 6 http://deb.debian.org/debian bullseye/main arm64 sensible-utils all 0.0.14 [14.8 kB] Get: 7 http://deb.debian.org/debian bullseye/main arm64 libmagic-mgc arm64 1:5.39-3 [273 kB] Get: 8 http://deb.debian.org/debian bullseye/main arm64 libmagic1 arm64 1:5.39-3 [121 kB] Get: 9 http://deb.debian.org/debian bullseye/main arm64 file arm64 1:5.39-3 [69.1 kB] Get: 10 http://deb.debian.org/debian bullseye/main arm64 gettext-base arm64 0.21-4 [173 kB] Get: 11 http://deb.debian.org/debian bullseye/main arm64 libsigsegv2 arm64 2.13-1 [34.7 kB] Get: 12 http://deb.debian.org/debian bullseye/main arm64 m4 arm64 1.4.18-5 [199 kB] Get: 13 http://deb.debian.org/debian bullseye/main arm64 autoconf all 2.69-14 [313 kB] Get: 14 http://deb.debian.org/debian bullseye/main arm64 autotools-dev all 20180224.1+nmu1 [77.1 kB] Get: 15 http://deb.debian.org/debian bullseye/main arm64 automake all 1:1.16.3-2 [814 kB] Get: 16 http://deb.debian.org/debian bullseye/main arm64 autopoint all 0.21-4 [510 kB] Get: 17 http://deb.debian.org/debian bullseye/main arm64 libdebhelper-perl all 13.3.4 [189 kB] Get: 18 http://deb.debian.org/debian bullseye/main arm64 libtool all 2.4.6-15 [513 kB] Get: 19 http://deb.debian.org/debian bullseye/main arm64 dh-autoreconf all 20 [17.1 kB] Get: 20 http://deb.debian.org/debian bullseye/main arm64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 21 http://deb.debian.org/debian bullseye/main arm64 libsub-override-perl all 0.09-2 [10.2 kB] Get: 22 http://deb.debian.org/debian bullseye/main arm64 libfile-stripnondeterminism-perl all 1.12.0-1 [26.3 kB] Get: 23 http://deb.debian.org/debian bullseye/main arm64 dh-strip-nondeterminism all 1.12.0-1 [15.4 kB] Get: 24 http://deb.debian.org/debian bullseye/main arm64 libelf1 arm64 0.183-1 [164 kB] Get: 25 http://deb.debian.org/debian bullseye/main arm64 dwz arm64 0.13+20210201-1 [155 kB] Get: 26 http://deb.debian.org/debian bullseye/main arm64 libicu67 arm64 67.1-7 [8467 kB] Get: 27 http://deb.debian.org/debian bullseye/main arm64 libxml2 arm64 2.9.10+dfsg-6.7 [629 kB] Get: 28 http://deb.debian.org/debian bullseye/main arm64 gettext arm64 0.21-4 [1261 kB] Get: 29 http://deb.debian.org/debian bullseye/main arm64 intltool-debian all 0.35.0+20060710.5 [26.8 kB] Get: 30 http://deb.debian.org/debian bullseye/main arm64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 31 http://deb.debian.org/debian bullseye/main arm64 debhelper all 13.3.4 [1049 kB] Get: 32 http://deb.debian.org/debian bullseye/main arm64 libb-hooks-op-check-perl arm64 0.22-1+b3 [11.2 kB] Get: 33 http://deb.debian.org/debian bullseye/main arm64 libclone-perl arm64 0.45-1+b1 [15.3 kB] Get: 34 http://deb.debian.org/debian bullseye/main arm64 libdbi-perl arm64 1.643-3+b1 [774 kB] Get: 35 http://deb.debian.org/debian bullseye/main arm64 libdynaloader-functions-perl all 0.003-1.1 [12.7 kB] Get: 36 http://deb.debian.org/debian bullseye/main arm64 libdevel-callchecker-perl arm64 0.008-1+b2 [15.8 kB] Get: 37 http://deb.debian.org/debian bullseye/main arm64 libdevel-symdump-perl all 2.18-4 [17.5 kB] Get: 38 http://deb.debian.org/debian bullseye/main arm64 libmath-base-convert-perl all 0.11-2 [32.3 kB] Get: 39 http://deb.debian.org/debian bullseye/main arm64 libparams-classify-perl arm64 0.015-1+b3 [25.5 kB] Get: 40 http://deb.debian.org/debian bullseye/main arm64 libmodule-runtime-perl all 0.016-1 [19.4 kB] Get: 41 http://deb.debian.org/debian bullseye/main arm64 libparams-util-perl arm64 1.102-1+b1 [25.3 kB] Get: 42 http://deb.debian.org/debian bullseye/main arm64 libpod-parser-perl all 1.63-2 [96.1 kB] Get: 43 http://deb.debian.org/debian bullseye/main arm64 libpod-coverage-perl all 0.23-2 [22.1 kB] Get: 44 http://deb.debian.org/debian bullseye/main arm64 libtest-deep-perl all 1.130-1 [49.3 kB] Get: 45 http://deb.debian.org/debian bullseye/main arm64 libtest-pod-coverage-perl all 1.10-2 [14.5 kB] Get: 46 http://deb.debian.org/debian bullseye/main arm64 libtest-pod-perl all 1.52-1 [14.2 kB] Get: 47 http://deb.debian.org/debian bullseye/main arm64 libtext-soundex-perl arm64 3.05-1 [13.8 kB] Fetched 19.1 MB in 0s (42.8 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package bsdextrautils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19646 files and directories currently installed.) Preparing to unpack .../00-bsdextrautils_2.36.1-7_arm64.deb ... Unpacking bsdextrautils (2.36.1-7) ... Selecting previously unselected package libuchardet0:arm64. Preparing to unpack .../01-libuchardet0_0.0.7-1_arm64.deb ... Unpacking libuchardet0:arm64 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../02-groff-base_1.22.4-6_arm64.deb ... Unpacking groff-base (1.22.4-6) ... Selecting previously unselected package libpipeline1:arm64. Preparing to unpack .../03-libpipeline1_1.5.3-1_arm64.deb ... Unpacking libpipeline1:arm64 (1.5.3-1) ... Selecting previously unselected package man-db. Preparing to unpack .../04-man-db_2.9.4-2_arm64.deb ... Unpacking man-db (2.9.4-2) ... Selecting previously unselected package sensible-utils. Preparing to unpack .../05-sensible-utils_0.0.14_all.deb ... Unpacking sensible-utils (0.0.14) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../06-libmagic-mgc_1%3a5.39-3_arm64.deb ... Unpacking libmagic-mgc (1:5.39-3) ... Selecting previously unselected package libmagic1:arm64. Preparing to unpack .../07-libmagic1_1%3a5.39-3_arm64.deb ... Unpacking libmagic1:arm64 (1:5.39-3) ... Selecting previously unselected package file. Preparing to unpack .../08-file_1%3a5.39-3_arm64.deb ... Unpacking file (1:5.39-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../09-gettext-base_0.21-4_arm64.deb ... Unpacking gettext-base (0.21-4) ... Selecting previously unselected package libsigsegv2:arm64. Preparing to unpack .../10-libsigsegv2_2.13-1_arm64.deb ... Unpacking libsigsegv2:arm64 (2.13-1) ... Selecting previously unselected package m4. Preparing to unpack .../11-m4_1.4.18-5_arm64.deb ... Unpacking m4 (1.4.18-5) ... Selecting previously unselected package autoconf. Preparing to unpack .../12-autoconf_2.69-14_all.deb ... Unpacking autoconf (2.69-14) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../13-autotools-dev_20180224.1+nmu1_all.deb ... Unpacking autotools-dev (20180224.1+nmu1) ... Selecting previously unselected package automake. Preparing to unpack .../14-automake_1%3a1.16.3-2_all.deb ... Unpacking automake (1:1.16.3-2) ... Selecting previously unselected package autopoint. Preparing to unpack .../15-autopoint_0.21-4_all.deb ... Unpacking autopoint (0.21-4) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../16-libdebhelper-perl_13.3.4_all.deb ... Unpacking libdebhelper-perl (13.3.4) ... Selecting previously unselected package libtool. Preparing to unpack .../17-libtool_2.4.6-15_all.deb ... Unpacking libtool (2.4.6-15) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../18-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../19-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libsub-override-perl. Preparing to unpack .../20-libsub-override-perl_0.09-2_all.deb ... Unpacking libsub-override-perl (0.09-2) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../21-libfile-stripnondeterminism-perl_1.12.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.12.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../22-dh-strip-nondeterminism_1.12.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.12.0-1) ... Selecting previously unselected package libelf1:arm64. Preparing to unpack .../23-libelf1_0.183-1_arm64.deb ... Unpacking libelf1:arm64 (0.183-1) ... Selecting previously unselected package dwz. Preparing to unpack .../24-dwz_0.13+20210201-1_arm64.deb ... Unpacking dwz (0.13+20210201-1) ... Selecting previously unselected package libicu67:arm64. Preparing to unpack .../25-libicu67_67.1-7_arm64.deb ... Unpacking libicu67:arm64 (67.1-7) ... Selecting previously unselected package libxml2:arm64. Preparing to unpack .../26-libxml2_2.9.10+dfsg-6.7_arm64.deb ... Unpacking libxml2:arm64 (2.9.10+dfsg-6.7) ... Selecting previously unselected package gettext. Preparing to unpack .../27-gettext_0.21-4_arm64.deb ... Unpacking gettext (0.21-4) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../28-intltool-debian_0.35.0+20060710.5_all.deb ... Unpacking intltool-debian (0.35.0+20060710.5) ... Selecting previously unselected package po-debconf. Preparing to unpack .../29-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../30-debhelper_13.3.4_all.deb ... Unpacking debhelper (13.3.4) ... Selecting previously unselected package libb-hooks-op-check-perl. Preparing to unpack .../31-libb-hooks-op-check-perl_0.22-1+b3_arm64.deb ... Unpacking libb-hooks-op-check-perl (0.22-1+b3) ... Selecting previously unselected package libclone-perl. Preparing to unpack .../32-libclone-perl_0.45-1+b1_arm64.deb ... Unpacking libclone-perl (0.45-1+b1) ... Selecting previously unselected package libdbi-perl:arm64. Preparing to unpack .../33-libdbi-perl_1.643-3+b1_arm64.deb ... Unpacking libdbi-perl:arm64 (1.643-3+b1) ... Selecting previously unselected package libdynaloader-functions-perl. Preparing to unpack .../34-libdynaloader-functions-perl_0.003-1.1_all.deb ... Unpacking libdynaloader-functions-perl (0.003-1.1) ... Selecting previously unselected package libdevel-callchecker-perl. Preparing to unpack .../35-libdevel-callchecker-perl_0.008-1+b2_arm64.deb ... Unpacking libdevel-callchecker-perl (0.008-1+b2) ... Selecting previously unselected package libdevel-symdump-perl. Preparing to unpack .../36-libdevel-symdump-perl_2.18-4_all.deb ... Unpacking libdevel-symdump-perl (2.18-4) ... Selecting previously unselected package libmath-base-convert-perl. Preparing to unpack .../37-libmath-base-convert-perl_0.11-2_all.deb ... Unpacking libmath-base-convert-perl (0.11-2) ... Selecting previously unselected package libparams-classify-perl. Preparing to unpack .../38-libparams-classify-perl_0.015-1+b3_arm64.deb ... Unpacking libparams-classify-perl (0.015-1+b3) ... Selecting previously unselected package libmodule-runtime-perl. Preparing to unpack .../39-libmodule-runtime-perl_0.016-1_all.deb ... Unpacking libmodule-runtime-perl (0.016-1) ... Selecting previously unselected package libparams-util-perl. Preparing to unpack .../40-libparams-util-perl_1.102-1+b1_arm64.deb ... Unpacking libparams-util-perl (1.102-1+b1) ... Selecting previously unselected package libpod-parser-perl. Preparing to unpack .../41-libpod-parser-perl_1.63-2_all.deb ... Adding 'diversion of /usr/bin/podselect to /usr/bin/podselect.bundled by libpod-parser-perl' Adding 'diversion of /usr/share/man/man1/podselect.1.gz to /usr/share/man/man1/podselect.bundled.1.gz by libpod-parser-perl' Unpacking libpod-parser-perl (1.63-2) ... Selecting previously unselected package libpod-coverage-perl. Preparing to unpack .../42-libpod-coverage-perl_0.23-2_all.deb ... Unpacking libpod-coverage-perl (0.23-2) ... Selecting previously unselected package libtest-deep-perl. Preparing to unpack .../43-libtest-deep-perl_1.130-1_all.deb ... Unpacking libtest-deep-perl (1.130-1) ... Selecting previously unselected package libtest-pod-coverage-perl. Preparing to unpack .../44-libtest-pod-coverage-perl_1.10-2_all.deb ... Unpacking libtest-pod-coverage-perl (1.10-2) ... Selecting previously unselected package libtest-pod-perl. Preparing to unpack .../45-libtest-pod-perl_1.52-1_all.deb ... Unpacking libtest-pod-perl (1.52-1) ... Selecting previously unselected package libtext-soundex-perl:arm64. Preparing to unpack .../46-libtext-soundex-perl_3.05-1_arm64.deb ... Unpacking libtext-soundex-perl:arm64 (3.05-1) ... Setting up libpipeline1:arm64 (1.5.3-1) ... Setting up bsdextrautils (2.36.1-7) ... update-alternatives: using /usr/bin/write.ul to provide /usr/bin/write (write) in auto mode Setting up libicu67:arm64 (67.1-7) ... Setting up libdynaloader-functions-perl (0.003-1.1) ... Setting up libtest-deep-perl (1.130-1) ... Setting up libmagic-mgc (1:5.39-3) ... Setting up libclone-perl (0.45-1+b1) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up libdebhelper-perl (13.3.4) ... Setting up libtest-pod-perl (1.52-1) ... Setting up libmagic1:arm64 (1:5.39-3) ... Setting up gettext-base (0.21-4) ... Setting up file (1:5.39-3) ... Setting up autotools-dev (20180224.1+nmu1) ... Setting up libsigsegv2:arm64 (2.13-1) ... Setting up libpod-parser-perl (1.63-2) ... Setting up autopoint (0.21-4) ... Setting up libb-hooks-op-check-perl (0.22-1+b3) ... Setting up libparams-util-perl (1.102-1+b1) ... Setting up sensible-utils (0.0.14) ... Setting up libuchardet0:arm64 (0.0.7-1) ... Setting up libsub-override-perl (0.09-2) ... Setting up libtext-soundex-perl:arm64 (3.05-1) ... Setting up libdevel-symdump-perl (2.18-4) ... Setting up libmath-base-convert-perl (0.11-2) ... Setting up libelf1:arm64 (0.183-1) ... Setting up libxml2:arm64 (2.9.10+dfsg-6.7) ... Setting up libdbi-perl:arm64 (1.643-3+b1) ... Setting up libfile-stripnondeterminism-perl (1.12.0-1) ... Setting up gettext (0.21-4) ... Setting up libtool (2.4.6-15) ... Setting up libpod-coverage-perl (0.23-2) ... Setting up m4 (1.4.18-5) ... Setting up libdevel-callchecker-perl (0.008-1+b2) ... Setting up intltool-debian (0.35.0+20060710.5) ... Setting up autoconf (2.69-14) ... Setting up dh-strip-nondeterminism (1.12.0-1) ... Setting up dwz (0.13+20210201-1) ... Setting up groff-base (1.22.4-6) ... Setting up libtest-pod-coverage-perl (1.10-2) ... Setting up automake (1:1.16.3-2) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up po-debconf (1.0.21+nmu1) ... Setting up libparams-classify-perl (0.015-1+b3) ... Setting up man-db (2.9.4-2) ... Not building database; man-db/auto-update is not 'true'. Setting up dh-autoreconf (20) ... Setting up libmodule-runtime-perl (0.016-1) ... Setting up debhelper (13.3.4) ... Processing triggers for libc-bin (2.31-12) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps I: Building the package I: Running cd /build/libsql-statement-perl-1.414/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-genchanges -S > ../libsql-statement-perl_1.414-1_source.changes dpkg-buildpackage: info: source package libsql-statement-perl dpkg-buildpackage: info: source version 1.414-1 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by gregor herrmann dpkg-source --before-build . dpkg-buildpackage: info: host architecture arm64 debian/rules clean dh clean dh_clean debian/rules binary dh binary dh_update_autotools_config dh_autoreconf debian/rules override_dh_auto_configure make[1]: Entering directory '/build/libsql-statement-perl-1.414' # libdbd-csv-perl pulls in the older version of libsql-statement-perl # not in Build-Depends-Indep anymore, but might be installed locally SQL_STATEMENT_WARN_UPDATE=sure dh_auto_configure perl Makefile.PL INSTALLDIRS=vendor "OPTIMIZE=-g -O2 -fdebug-prefix-map=/build/libsql-statement-perl-1.414=. -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time -D_FORTIFY_SOURCE=2" "LD=aarch64-linux-gnu-gcc -g -O2 -fdebug-prefix-map=/build/libsql-statement-perl-1.414=. -fstack-protector-strong -Wformat -Werror=format-security -Wl,-z,relro" Checking if your kit is complete... Looks good Generating a Unix-style Makefile Writing Makefile for SQL::Statement Writing MYMETA.yml and MYMETA.json make[1]: Leaving directory '/build/libsql-statement-perl-1.414' dh_auto_build make -j8 make[1]: Entering directory '/build/libsql-statement-perl-1.414' cp lib/SQL/Dialects/AnyData.pm blib/lib/SQL/Dialects/AnyData.pm cp lib/SQL/Parser.pm blib/lib/SQL/Parser.pm cp lib/SQL/Dialects/ANSI.pm blib/lib/SQL/Dialects/ANSI.pm cp lib/SQL/Statement.pm blib/lib/SQL/Statement.pm cp lib/SQL/Statement/Util.pm blib/lib/SQL/Statement/Util.pm cp lib/SQL/Statement/Roadmap.pod blib/lib/SQL/Statement/Roadmap.pod cp lib/SQL/Statement/Syntax.pod blib/lib/SQL/Statement/Syntax.pod cp lib/SQL/Statement/Placeholder.pm blib/lib/SQL/Statement/Placeholder.pm cp lib/SQL/Statement/TermFactory.pm blib/lib/SQL/Statement/TermFactory.pm cp lib/SQL/Statement/Term.pm blib/lib/SQL/Statement/Term.pm cp lib/SQL/Statement/Structure.pod blib/lib/SQL/Statement/Structure.pod cp lib/SQL/Statement/GetInfo.pm blib/lib/SQL/Statement/GetInfo.pm cp lib/SQL/Statement/Operation.pm blib/lib/SQL/Statement/Operation.pm cp lib/SQL/Dialects/CSV.pm blib/lib/SQL/Dialects/CSV.pm cp lib/SQL/Statement/Embed.pod blib/lib/SQL/Statement/Embed.pod cp lib/SQL/Statement/RAM.pm blib/lib/SQL/Statement/RAM.pm cp lib/SQL/Eval.pm blib/lib/SQL/Eval.pm cp lib/SQL/Statement/Function.pm blib/lib/SQL/Statement/Function.pm cp lib/SQL/Dialects/Role.pm blib/lib/SQL/Dialects/Role.pm cp lib/SQL/Statement/Functions.pm blib/lib/SQL/Statement/Functions.pm Manifying 20 pod documents make[1]: Leaving directory '/build/libsql-statement-perl-1.414' dh_auto_test make -j8 test TEST_VERBOSE=1 make[1]: Entering directory '/build/libsql-statement-perl-1.414' PERL_DL_NONLAZY=1 "/usr/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(1, 'blib/lib', 'blib/arch')" t/*.t xt/*.t # # Using required: # # SQL::Statement: 1.414 # # Using recommended: # # DBD::DBM: 0.08 # # DBD::File: 0.44 # # DBI: 1.643 t/00error.t ..... # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # Running tests for SQL::Statement ok 1 - Parse "Junk" RaiseError=0 (default) ok 2 - Execute function succeeded ok 3 - Execute function no errstr ok 4 - Execute RaiseError=0 ok 5 - Parse "Junk" RaiseError=1 ok 6 - Execute RaiseError=1 ok 7 - Execute "SELECT * FROM nonexistant" has errstr # Running tests for DBD::File ok 8 - Parse "Junk" RaiseError=0 (default) ok 9 - Execute function succeeded ok 10 - Execute function no errstr ok 11 - Execute RaiseError=0 ok 12 - Parse "Junk" RaiseError=1 ok 13 - Execute RaiseError=1 ok 14 - Execute "SELECT * FROM nonexistant" has errstr # Running tests for DBD::DBM ok 15 - Parse "Junk" RaiseError=0 (default) ok 16 - Execute function succeeded ok 17 - Execute function no errstr ok 18 - Execute RaiseError=0 ok 19 - Parse "Junk" RaiseError=1 ok 20 - Execute RaiseError=1 ok 21 - Execute "SELECT * FROM nonexistant" has errstr 1..21 ok t/01prepare.t ... # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. ok 1 - parse ' /* DROP TABLE */' using SQL::Statement ok 2 - parse 'DROP TABLE foo' using SQL::Statement ok 3 - parse 'DROP TABLE foo CASCADE' using SQL::Statement ok 4 - parse 'DROP TABLE foo RESTRICT' using SQL::Statement ok 5 - parse ' /* DELETE */' using SQL::Statement ok 6 - parse 'DELETE FROM foo' using SQL::Statement ok 7 - parse 'DELETE FROM foo WHERE id < 7' using SQL::Statement ok 8 - parse ' /* UPDATE */' using SQL::Statement ok 9 - parse 'UPDATE foo SET bar = 7' using SQL::Statement ok 10 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using SQL::Statement ok 11 - parse ' /* INSERT */' using SQL::Statement ok 12 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using SQL::Statement ok 13 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using SQL::Statement ok 14 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using SQL::Statement ok 15 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using SQL::Statement ok 16 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using SQL::Statement ok 17 - parse ' /* CREATE TABLE */' using SQL::Statement ok 18 - parse 'CREATE TABLE foo ( id INT )' using SQL::Statement ok 19 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using SQL::Statement ok 20 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using SQL::Statement ok 21 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using SQL::Statement ok 22 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using SQL::Statement ok 23 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using SQL::Statement ok 24 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using SQL::Statement ok 25 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using SQL::Statement ok 26 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using SQL::Statement ok 27 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using SQL::Statement ok 28 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using SQL::Statement ok 29 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using SQL::Statement ok 30 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using SQL::Statement ok 31 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using SQL::Statement ok 32 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using SQL::Statement ok 33 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using SQL::Statement ok 34 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using SQL::Statement ok 35 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using SQL::Statement ok 36 - parse ' /* JOINS */' using SQL::Statement ok 37 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using SQL::Statement ok 38 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using SQL::Statement ok 39 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using SQL::Statement ok 40 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using SQL::Statement ok 41 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 42 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 43 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 44 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 45 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using SQL::Statement ok 46 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using SQL::Statement ok 47 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using SQL::Statement ok 48 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using SQL::Statement ok 49 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using SQL::Statement ok 50 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using SQL::Statement ok 51 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using SQL::Statement ok 52 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using SQL::Statement ok 53 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using SQL::Statement ok 54 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 55 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 56 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 57 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using SQL::Statement ok 58 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using SQL::Statement ok 59 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using SQL::Statement ok 60 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using SQL::Statement ok 61 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using SQL::Statement ok 62 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using SQL::Statement ok 63 - parse ' /* SELECT COLUMNS */' using SQL::Statement ok 64 - parse 'SELECT id, phrase FROM foo' using SQL::Statement ok 65 - parse 'SELECT * FROM foo' using SQL::Statement ok 66 - parse 'SELECT DISTINCT * FROM foo' using SQL::Statement ok 67 - parse 'SELECT ALL * FROM foo' using SQL::Statement ok 68 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using SQL::Statement ok 69 - parse ' /* SET FUNCTIONS */' using SQL::Statement ok 70 - parse 'SELECT MAX(foo) FROM bar' using SQL::Statement ok 71 - parse 'SELECT MIN(foo) FROM bar' using SQL::Statement ok 72 - parse 'SELECT AVG(foo) FROM bar' using SQL::Statement ok 73 - parse 'SELECT SUM(foo) FROM bar' using SQL::Statement ok 74 - parse 'SELECT COUNT(foo) FROM foo' using SQL::Statement ok 75 - parse 'SELECT COUNT(*) FROM foo' using SQL::Statement ok 76 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using SQL::Statement ok 77 - parse 'SELECT SUM(ALL foo) FROM bar' using SQL::Statement ok 78 - parse ' /* ORDER BY */' using SQL::Statement ok 79 - parse 'SELECT * FROM foo ORDER BY bar' using SQL::Statement ok 80 - parse 'SELECT * FROM foo ORDER BY bar, baz' using SQL::Statement ok 81 - parse 'SELECT * FROM foo ORDER BY bar DESC' using SQL::Statement ok 82 - parse 'SELECT * FROM foo ORDER BY bar ASC' using SQL::Statement ok 83 - parse ' /* LIMIT */' using SQL::Statement ok 84 - parse 'SELECT * FROM foo LIMIT 5' using SQL::Statement ok 85 - parse 'SELECT * FROM foo LIMIT 0, 5' using SQL::Statement ok 86 - parse 'SELECT * FROM foo LIMIT 5, 10' using SQL::Statement ok 87 - parse '/* DATE/TIME FUNCTIONS */' using SQL::Statement ok 88 - parse 'SELECT CURRENT_DATE()' using SQL::Statement ok 89 - parse 'SELECT CURRENT_TIME()' using SQL::Statement ok 90 - parse 'SELECT CURRENT_TIMESTAMP()' using SQL::Statement ok 91 - parse 'SELECT CURDATE()' using SQL::Statement ok 92 - parse 'SELECT CURTIME()' using SQL::Statement ok 93 - parse 'SELECT NOW()' using SQL::Statement ok 94 - parse 'SELECT UNIX_TIMESTAMP() ' using SQL::Statement ok 95 - parse 'SELECT CURRENT_TIME(2)' using SQL::Statement ok 96 - parse 'SELECT CURRENT_TIMESTAMP(2)' using SQL::Statement ok 97 - parse 'SELECT CURTIME(2)' using SQL::Statement ok 98 - parse 'SELECT NOW(2)' using SQL::Statement ok 99 - parse 'SELECT UNIX_TIMESTAMP(2)' using SQL::Statement ok 100 - parse ' /* STRING FUNCTIONS */' using SQL::Statement ok 101 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using SQL::Statement ok 102 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using SQL::Statement ok 103 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using SQL::Statement ok 104 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using SQL::Statement ok 105 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using SQL::Statement ok 106 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using SQL::Statement ok 107 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using SQL::Statement ok 108 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using SQL::Statement ok 109 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using SQL::Statement ok 110 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using SQL::Statement ok 111 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using SQL::Statement ok 112 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using SQL::Statement ok 113 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using SQL::Statement ok 114 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using SQL::Statement ok 115 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using SQL::Statement ok 116 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using SQL::Statement ok 117 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using SQL::Statement ok 118 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using SQL::Statement ok 119 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using SQL::Statement ok 120 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using SQL::Statement ok 121 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using SQL::Statement ok 122 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using SQL::Statement ok 123 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using SQL::Statement ok 124 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using SQL::Statement ok 125 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using SQL::Statement ok 126 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using SQL::Statement ok 127 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using SQL::Statement ok 128 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using SQL::Statement ok 129 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using SQL::Statement ok 130 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using SQL::Statement ok 131 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using SQL::Statement ok 132 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using SQL::Statement ok 133 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using SQL::Statement ok 134 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using SQL::Statement ok 135 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using SQL::Statement ok 136 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using SQL::Statement ok 137 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using SQL::Statement ok 138 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using SQL::Statement ok 139 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using SQL::Statement ok 140 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using SQL::Statement ok 141 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using SQL::Statement ok 142 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using SQL::Statement ok 143 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using SQL::Statement ok 144 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using SQL::Statement ok 145 - parse ' /* NUMERIC FUNCTIONS */' using SQL::Statement ok 146 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using SQL::Statement ok 147 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using SQL::Statement ok 148 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using SQL::Statement ok 149 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using SQL::Statement ok 150 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using SQL::Statement ok 151 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using SQL::Statement ok 152 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using SQL::Statement ok 153 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using SQL::Statement ok 154 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using SQL::Statement ok 155 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using SQL::Statement ok 156 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using SQL::Statement ok 157 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using SQL::Statement ok 158 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using SQL::Statement ok 159 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using SQL::Statement ok 160 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using SQL::Statement ok 161 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using SQL::Statement ok 162 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using SQL::Statement ok 163 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using SQL::Statement ok 164 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using SQL::Statement ok 165 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using SQL::Statement ok 166 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using SQL::Statement ok 167 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using SQL::Statement ok 168 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using SQL::Statement ok 169 - parse 'SELECT * FROM test WHERE ACOS(x)' using SQL::Statement ok 170 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using SQL::Statement ok 171 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using SQL::Statement ok 172 - parse 'SELECT * FROM test WHERE ACOSH(x)' using SQL::Statement ok 173 - parse 'SELECT * FROM test WHERE ACOT(x)' using SQL::Statement ok 174 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using SQL::Statement ok 175 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using SQL::Statement ok 176 - parse 'SELECT * FROM test WHERE ACOTH(x)' using SQL::Statement ok 177 - parse 'SELECT * FROM test WHERE ACSC(x)' using SQL::Statement ok 178 - parse 'SELECT * FROM test WHERE ACSCH(x)' using SQL::Statement ok 179 - parse 'SELECT * FROM test WHERE ASEC(x)' using SQL::Statement ok 180 - parse 'SELECT * FROM test WHERE ASECH(x)' using SQL::Statement ok 181 - parse 'SELECT * FROM test WHERE ASIN(x)' using SQL::Statement ok 182 - parse 'SELECT * FROM test WHERE ASINH(x)' using SQL::Statement ok 183 - parse 'SELECT * FROM test WHERE ATAN(x)' using SQL::Statement ok 184 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using SQL::Statement ok 185 - parse 'SELECT * FROM test WHERE ATANH(x)' using SQL::Statement ok 186 - parse 'SELECT * FROM test WHERE COS(x)' using SQL::Statement ok 187 - parse 'SELECT * FROM test WHERE COSEC(x)' using SQL::Statement ok 188 - parse 'SELECT * FROM test WHERE COSECH(x)' using SQL::Statement ok 189 - parse 'SELECT * FROM test WHERE COSH(x)' using SQL::Statement ok 190 - parse 'SELECT * FROM test WHERE COT(x)' using SQL::Statement ok 191 - parse 'SELECT * FROM test WHERE COTAN(x)' using SQL::Statement ok 192 - parse 'SELECT * FROM test WHERE COTANH(x)' using SQL::Statement ok 193 - parse 'SELECT * FROM test WHERE COTH(x)' using SQL::Statement ok 194 - parse 'SELECT * FROM test WHERE CSC(x)' using SQL::Statement ok 195 - parse 'SELECT * FROM test WHERE CSCH(x)' using SQL::Statement ok 196 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using SQL::Statement ok 197 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using SQL::Statement ok 198 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using SQL::Statement ok 199 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using SQL::Statement ok 200 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using SQL::Statement ok 201 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using SQL::Statement ok 202 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using SQL::Statement ok 203 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using SQL::Statement ok 204 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using SQL::Statement ok 205 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using SQL::Statement ok 206 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using SQL::Statement ok 207 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using SQL::Statement ok 208 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using SQL::Statement ok 209 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using SQL::Statement ok 210 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using SQL::Statement ok 211 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using SQL::Statement ok 212 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using SQL::Statement ok 213 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using SQL::Statement ok 214 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using SQL::Statement ok 215 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using SQL::Statement ok 216 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using SQL::Statement ok 217 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using SQL::Statement ok 218 - parse 'SELECT * FROM test WHERE PI()' using SQL::Statement ok 219 - parse 'SELECT * FROM test WHERE SEC(x)' using SQL::Statement ok 220 - parse 'SELECT * FROM test WHERE SECH(x)' using SQL::Statement ok 221 - parse 'SELECT * FROM test WHERE SIN(x)' using SQL::Statement ok 222 - parse 'SELECT * FROM test WHERE SINH(x)' using SQL::Statement ok 223 - parse 'SELECT * FROM test WHERE TAN(x)' using SQL::Statement ok 224 - parse 'SELECT * FROM test WHERE TANH(x)' using SQL::Statement ok 225 - parse ' /* SYSTEM FUNCTIONS */' using SQL::Statement ok 226 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using SQL::Statement ok 227 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using SQL::Statement ok 228 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using SQL::Statement ok 229 - parse ' /* TABLE NAME ALIASES */' using SQL::Statement ok 230 - parse 'SELECT * FROM test as T1' using SQL::Statement ok 231 - parse 'SELECT * FROM test T1' using SQL::Statement ok 232 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using SQL::Statement ok 233 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using SQL::Statement ok 234 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using SQL::Statement ok 235 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using SQL::Statement ok 236 - parse ' /* NUMERIC EXPRESSIONS */' using SQL::Statement ok 237 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using SQL::Statement ok 238 - parse ' /* CASE OF IDENTIFIERS */' using SQL::Statement ok 239 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using SQL::Statement ok 240 - parse ' /* PARENS */' using SQL::Statement ok 241 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using SQL::Statement ok 242 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using SQL::Statement ok 243 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using SQL::Statement ok 244 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using SQL::Statement ok 245 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using SQL::Statement ok 246 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using SQL::Statement ok 247 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using SQL::Statement ok 248 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using SQL::Statement ok 249 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using SQL::Statement ok 250 - parse ' /* NOT */' using SQL::Statement ok 251 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using SQL::Statement ok 252 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using SQL::Statement ok 253 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using SQL::Statement ok 254 - parse ' /* IN */' using SQL::Statement ok 255 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using SQL::Statement ok 256 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using SQL::Statement ok 257 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using SQL::Statement ok 258 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using SQL::Statement ok 259 - parse ' /* BETWEEN */' using SQL::Statement ok 260 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using SQL::Statement ok 261 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using SQL::Statement ok 262 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using SQL::Statement ok 263 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using SQL::Statement ok 264 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using SQL::Statement # TODO Analyze failures not ok 265 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using SQL::Statement # TODO Analyze failures # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using SQL::Statement' # at t/01prepare.t line 312. # # Execution ERROR: Unknown predicate '{$VAR1 = {}; # }' called from t/TestLib.pm at 190. # not ok 266 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using SQL::Statement # TODO Analyze failures # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using SQL::Statement' # at t/01prepare.t line 312. # # Execution ERROR: Unknown predicate '{$VAR1 = {}; # }' called from t/TestLib.pm at 190. # ok 267 - $sth->new ok 268 - $sth->command ok 269 - $sth->params ok 270 - $sth->tables ok 271 - $sth->where()->op ok 272 - $sth->where()->left ok 273 - $sth->where()->left->left ok 274 - $sth->where()->left->right ok 275 - $sth->limit ok 276 - $sth->offset # Command SELECT # Num Pholders 1 # Columns # Tables SQL::Statement::Table=HASH(0xaaaad1acb190),SQL::Statement::Table=HASH(0xaaaad1acb070) # Where op AND # Limit 2 # Offset 5 # Order Cols f,g ok 277 - $stmt->row_values() ok 278 - $stmt->row_values(0) ok 279 - $stmt->row_values(0,1) ok 280 - structure ok 281 - command ok 282 - distinct ok 283 - parse ' /* DROP TABLE */' using DBD::File ok 284 - parse 'DROP TABLE foo' using DBD::File ok 285 - parse 'DROP TABLE foo CASCADE' using DBD::File ok 286 - parse 'DROP TABLE foo RESTRICT' using DBD::File ok 287 - parse ' /* DELETE */' using DBD::File ok 288 - parse 'DELETE FROM foo' using DBD::File ok 289 - parse 'DELETE FROM foo WHERE id < 7' using DBD::File ok 290 - parse ' /* UPDATE */' using DBD::File ok 291 - parse 'UPDATE foo SET bar = 7' using DBD::File ok 292 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using DBD::File ok 293 - parse ' /* INSERT */' using DBD::File ok 294 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using DBD::File ok 295 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::File ok 296 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using DBD::File ok 297 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using DBD::File ok 298 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using DBD::File ok 299 - parse ' /* CREATE TABLE */' using DBD::File ok 300 - parse 'CREATE TABLE foo ( id INT )' using DBD::File ok 301 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using DBD::File ok 302 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::File ok 303 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::File ok 304 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using DBD::File ok 305 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::File ok 306 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::File ok 307 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using DBD::File ok 308 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using DBD::File ok 309 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using DBD::File ok 310 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using DBD::File ok 311 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using DBD::File ok 312 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using DBD::File ok 313 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using DBD::File ok 314 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using DBD::File ok 315 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using DBD::File ok 316 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using DBD::File ok 317 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using DBD::File ok 318 - parse ' /* JOINS */' using DBD::File ok 319 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using DBD::File ok 320 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using DBD::File ok 321 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::File ok 322 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using DBD::File ok 323 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::File ok 324 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::File ok 325 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::File ok 326 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::File ok 327 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using DBD::File ok 328 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using DBD::File ok 329 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::File ok 330 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using DBD::File ok 331 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using DBD::File ok 332 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using DBD::File ok 333 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using DBD::File ok 334 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::File ok 335 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using DBD::File ok 336 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::File ok 337 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::File ok 338 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::File ok 339 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::File ok 340 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using DBD::File ok 341 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using DBD::File ok 342 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::File ok 343 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using DBD::File ok 344 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using DBD::File ok 345 - parse ' /* SELECT COLUMNS */' using DBD::File ok 346 - parse 'SELECT id, phrase FROM foo' using DBD::File ok 347 - parse 'SELECT * FROM foo' using DBD::File ok 348 - parse 'SELECT DISTINCT * FROM foo' using DBD::File ok 349 - parse 'SELECT ALL * FROM foo' using DBD::File ok 350 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using DBD::File ok 351 - parse ' /* SET FUNCTIONS */' using DBD::File ok 352 - parse 'SELECT MAX(foo) FROM bar' using DBD::File ok 353 - parse 'SELECT MIN(foo) FROM bar' using DBD::File ok 354 - parse 'SELECT AVG(foo) FROM bar' using DBD::File ok 355 - parse 'SELECT SUM(foo) FROM bar' using DBD::File ok 356 - parse 'SELECT COUNT(foo) FROM foo' using DBD::File ok 357 - parse 'SELECT COUNT(*) FROM foo' using DBD::File ok 358 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using DBD::File ok 359 - parse 'SELECT SUM(ALL foo) FROM bar' using DBD::File ok 360 - parse ' /* ORDER BY */' using DBD::File ok 361 - parse 'SELECT * FROM foo ORDER BY bar' using DBD::File ok 362 - parse 'SELECT * FROM foo ORDER BY bar, baz' using DBD::File ok 363 - parse 'SELECT * FROM foo ORDER BY bar DESC' using DBD::File ok 364 - parse 'SELECT * FROM foo ORDER BY bar ASC' using DBD::File ok 365 - parse ' /* LIMIT */' using DBD::File ok 366 - parse 'SELECT * FROM foo LIMIT 5' using DBD::File ok 367 - parse 'SELECT * FROM foo LIMIT 0, 5' using DBD::File ok 368 - parse 'SELECT * FROM foo LIMIT 5, 10' using DBD::File ok 369 - parse '/* DATE/TIME FUNCTIONS */' using DBD::File ok 370 - parse 'SELECT CURRENT_DATE()' using DBD::File ok 371 - parse 'SELECT CURRENT_TIME()' using DBD::File ok 372 - parse 'SELECT CURRENT_TIMESTAMP()' using DBD::File ok 373 - parse 'SELECT CURDATE()' using DBD::File ok 374 - parse 'SELECT CURTIME()' using DBD::File ok 375 - parse 'SELECT NOW()' using DBD::File ok 376 - parse 'SELECT UNIX_TIMESTAMP() ' using DBD::File ok 377 - parse 'SELECT CURRENT_TIME(2)' using DBD::File ok 378 - parse 'SELECT CURRENT_TIMESTAMP(2)' using DBD::File ok 379 - parse 'SELECT CURTIME(2)' using DBD::File ok 380 - parse 'SELECT NOW(2)' using DBD::File ok 381 - parse 'SELECT UNIX_TIMESTAMP(2)' using DBD::File ok 382 - parse ' /* STRING FUNCTIONS */' using DBD::File ok 383 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using DBD::File ok 384 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using DBD::File ok 385 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using DBD::File ok 386 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using DBD::File ok 387 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using DBD::File ok 388 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using DBD::File ok 389 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using DBD::File ok 390 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using DBD::File ok 391 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using DBD::File ok 392 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using DBD::File ok 393 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using DBD::File ok 394 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using DBD::File ok 395 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using DBD::File ok 396 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using DBD::File ok 397 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using DBD::File ok 398 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using DBD::File ok 399 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using DBD::File ok 400 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using DBD::File ok 401 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using DBD::File ok 402 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using DBD::File ok 403 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using DBD::File ok 404 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using DBD::File ok 405 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using DBD::File ok 406 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using DBD::File ok 407 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using DBD::File ok 408 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using DBD::File ok 409 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using DBD::File ok 410 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::File ok 411 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::File ok 412 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using DBD::File ok 413 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using DBD::File ok 414 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using DBD::File ok 415 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using DBD::File ok 416 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using DBD::File ok 417 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using DBD::File ok 418 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using DBD::File ok 419 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using DBD::File ok 420 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using DBD::File ok 421 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using DBD::File ok 422 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using DBD::File ok 423 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using DBD::File ok 424 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using DBD::File ok 425 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using DBD::File ok 426 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using DBD::File ok 427 - parse ' /* NUMERIC FUNCTIONS */' using DBD::File ok 428 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using DBD::File ok 429 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using DBD::File ok 430 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using DBD::File ok 431 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using DBD::File ok 432 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using DBD::File ok 433 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using DBD::File ok 434 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using DBD::File ok 435 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using DBD::File ok 436 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using DBD::File ok 437 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using DBD::File ok 438 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using DBD::File ok 439 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using DBD::File ok 440 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using DBD::File ok 441 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using DBD::File ok 442 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using DBD::File ok 443 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using DBD::File ok 444 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using DBD::File ok 445 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using DBD::File ok 446 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using DBD::File ok 447 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using DBD::File ok 448 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using DBD::File ok 449 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using DBD::File ok 450 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using DBD::File ok 451 - parse 'SELECT * FROM test WHERE ACOS(x)' using DBD::File ok 452 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using DBD::File ok 453 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using DBD::File ok 454 - parse 'SELECT * FROM test WHERE ACOSH(x)' using DBD::File ok 455 - parse 'SELECT * FROM test WHERE ACOT(x)' using DBD::File ok 456 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using DBD::File ok 457 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using DBD::File ok 458 - parse 'SELECT * FROM test WHERE ACOTH(x)' using DBD::File ok 459 - parse 'SELECT * FROM test WHERE ACSC(x)' using DBD::File ok 460 - parse 'SELECT * FROM test WHERE ACSCH(x)' using DBD::File ok 461 - parse 'SELECT * FROM test WHERE ASEC(x)' using DBD::File ok 462 - parse 'SELECT * FROM test WHERE ASECH(x)' using DBD::File ok 463 - parse 'SELECT * FROM test WHERE ASIN(x)' using DBD::File ok 464 - parse 'SELECT * FROM test WHERE ASINH(x)' using DBD::File ok 465 - parse 'SELECT * FROM test WHERE ATAN(x)' using DBD::File ok 466 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using DBD::File ok 467 - parse 'SELECT * FROM test WHERE ATANH(x)' using DBD::File ok 468 - parse 'SELECT * FROM test WHERE COS(x)' using DBD::File ok 469 - parse 'SELECT * FROM test WHERE COSEC(x)' using DBD::File ok 470 - parse 'SELECT * FROM test WHERE COSECH(x)' using DBD::File ok 471 - parse 'SELECT * FROM test WHERE COSH(x)' using DBD::File ok 472 - parse 'SELECT * FROM test WHERE COT(x)' using DBD::File ok 473 - parse 'SELECT * FROM test WHERE COTAN(x)' using DBD::File ok 474 - parse 'SELECT * FROM test WHERE COTANH(x)' using DBD::File ok 475 - parse 'SELECT * FROM test WHERE COTH(x)' using DBD::File ok 476 - parse 'SELECT * FROM test WHERE CSC(x)' using DBD::File ok 477 - parse 'SELECT * FROM test WHERE CSCH(x)' using DBD::File ok 478 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using DBD::File ok 479 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using DBD::File ok 480 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using DBD::File ok 481 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using DBD::File ok 482 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using DBD::File ok 483 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using DBD::File ok 484 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using DBD::File ok 485 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using DBD::File ok 486 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using DBD::File ok 487 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using DBD::File ok 488 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using DBD::File ok 489 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using DBD::File ok 490 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using DBD::File ok 491 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using DBD::File ok 492 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using DBD::File ok 493 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using DBD::File ok 494 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using DBD::File ok 495 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using DBD::File ok 496 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using DBD::File ok 497 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using DBD::File ok 498 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using DBD::File ok 499 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using DBD::File ok 500 - parse 'SELECT * FROM test WHERE PI()' using DBD::File ok 501 - parse 'SELECT * FROM test WHERE SEC(x)' using DBD::File ok 502 - parse 'SELECT * FROM test WHERE SECH(x)' using DBD::File ok 503 - parse 'SELECT * FROM test WHERE SIN(x)' using DBD::File ok 504 - parse 'SELECT * FROM test WHERE SINH(x)' using DBD::File ok 505 - parse 'SELECT * FROM test WHERE TAN(x)' using DBD::File ok 506 - parse 'SELECT * FROM test WHERE TANH(x)' using DBD::File ok 507 - parse ' /* SYSTEM FUNCTIONS */' using DBD::File ok 508 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using DBD::File ok 509 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using DBD::File ok 510 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using DBD::File ok 511 - parse ' /* TABLE NAME ALIASES */' using DBD::File ok 512 - parse 'SELECT * FROM test as T1' using DBD::File ok 513 - parse 'SELECT * FROM test T1' using DBD::File ok 514 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using DBD::File ok 515 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using DBD::File ok 516 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using DBD::File ok 517 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using DBD::File ok 518 - parse ' /* NUMERIC EXPRESSIONS */' using DBD::File ok 519 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using DBD::File ok 520 - parse ' /* CASE OF IDENTIFIERS */' using DBD::File ok 521 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using DBD::File ok 522 - parse ' /* PARENS */' using DBD::File ok 523 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using DBD::File ok 524 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using DBD::File ok 525 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using DBD::File ok 526 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using DBD::File ok 527 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using DBD::File ok 528 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using DBD::File ok 529 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using DBD::File ok 530 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using DBD::File ok 531 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using DBD::File ok 532 - parse ' /* NOT */' using DBD::File ok 533 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::File ok 534 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using DBD::File ok 535 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using DBD::File ok 536 - parse ' /* IN */' using DBD::File ok 537 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using DBD::File ok 538 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using DBD::File ok 539 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using DBD::File ok 540 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using DBD::File ok 541 - parse ' /* BETWEEN */' using DBD::File ok 542 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using DBD::File ok 543 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using DBD::File ok 544 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using DBD::File ok 545 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using DBD::File ok 546 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::File # TODO Analyze failures not ok 547 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::File # TODO Analyze failures # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::File' # at t/01prepare.t line 312. # # Execution ERROR: Unknown predicate '{$VAR1 = {}; # }' called from /usr/lib/aarch64-linux-gnu/perl5/5.32/DBI/DBD/SqlEngine.pm at 335. # not ok 548 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::File # TODO Analyze failures # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::File' # at t/01prepare.t line 312. # # Execution ERROR: Unknown predicate '{$VAR1 = {}; # }' called from /usr/lib/aarch64-linux-gnu/perl5/5.32/DBI/DBD/SqlEngine.pm at 335. # ok 549 - $sth->new ok 550 - $sth->command ok 551 - $sth->params ok 552 - $sth->tables ok 553 - $sth->where()->op ok 554 - $sth->where()->left ok 555 - $sth->where()->left->left ok 556 - $sth->where()->left->right ok 557 - $sth->limit ok 558 - $sth->offset # Command SELECT # Num Pholders 1 # Columns # Tables SQL::Statement::Table=HASH(0xaaaad1a68690),SQL::Statement::Table=HASH(0xaaaad1ae6468) # Where op AND # Limit 2 # Offset 5 # Order Cols f,g ok 559 - $stmt->row_values() ok 560 - $stmt->row_values(0) ok 561 - $stmt->row_values(0,1) ok 562 - structure ok 563 - command ok 564 - distinct ok 565 - parse ' /* DROP TABLE */' using DBD::DBM ok 566 - parse 'DROP TABLE foo' using DBD::DBM ok 567 - parse 'DROP TABLE foo CASCADE' using DBD::DBM ok 568 - parse 'DROP TABLE foo RESTRICT' using DBD::DBM ok 569 - parse ' /* DELETE */' using DBD::DBM ok 570 - parse 'DELETE FROM foo' using DBD::DBM ok 571 - parse 'DELETE FROM foo WHERE id < 7' using DBD::DBM ok 572 - parse ' /* UPDATE */' using DBD::DBM ok 573 - parse 'UPDATE foo SET bar = 7' using DBD::DBM ok 574 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using DBD::DBM ok 575 - parse ' /* INSERT */' using DBD::DBM ok 576 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using DBD::DBM ok 577 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::DBM ok 578 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using DBD::DBM ok 579 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using DBD::DBM ok 580 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using DBD::DBM ok 581 - parse ' /* CREATE TABLE */' using DBD::DBM ok 582 - parse 'CREATE TABLE foo ( id INT )' using DBD::DBM ok 583 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using DBD::DBM ok 584 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::DBM ok 585 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::DBM ok 586 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using DBD::DBM ok 587 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::DBM ok 588 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::DBM ok 589 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using DBD::DBM ok 590 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using DBD::DBM ok 591 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using DBD::DBM ok 592 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using DBD::DBM ok 593 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using DBD::DBM ok 594 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using DBD::DBM ok 595 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using DBD::DBM ok 596 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using DBD::DBM ok 597 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using DBD::DBM ok 598 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using DBD::DBM ok 599 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using DBD::DBM ok 600 - parse ' /* JOINS */' using DBD::DBM ok 601 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using DBD::DBM ok 602 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using DBD::DBM ok 603 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::DBM ok 604 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using DBD::DBM ok 605 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::DBM ok 606 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::DBM ok 607 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::DBM ok 608 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::DBM ok 609 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using DBD::DBM ok 610 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using DBD::DBM ok 611 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::DBM ok 612 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using DBD::DBM ok 613 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using DBD::DBM ok 614 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using DBD::DBM ok 615 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using DBD::DBM ok 616 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::DBM ok 617 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using DBD::DBM ok 618 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::DBM ok 619 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::DBM ok 620 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::DBM ok 621 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::DBM ok 622 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using DBD::DBM ok 623 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using DBD::DBM ok 624 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::DBM ok 625 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using DBD::DBM ok 626 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using DBD::DBM ok 627 - parse ' /* SELECT COLUMNS */' using DBD::DBM ok 628 - parse 'SELECT id, phrase FROM foo' using DBD::DBM ok 629 - parse 'SELECT * FROM foo' using DBD::DBM ok 630 - parse 'SELECT DISTINCT * FROM foo' using DBD::DBM ok 631 - parse 'SELECT ALL * FROM foo' using DBD::DBM ok 632 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using DBD::DBM ok 633 - parse ' /* SET FUNCTIONS */' using DBD::DBM ok 634 - parse 'SELECT MAX(foo) FROM bar' using DBD::DBM ok 635 - parse 'SELECT MIN(foo) FROM bar' using DBD::DBM ok 636 - parse 'SELECT AVG(foo) FROM bar' using DBD::DBM ok 637 - parse 'SELECT SUM(foo) FROM bar' using DBD::DBM ok 638 - parse 'SELECT COUNT(foo) FROM foo' using DBD::DBM ok 639 - parse 'SELECT COUNT(*) FROM foo' using DBD::DBM ok 640 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using DBD::DBM ok 641 - parse 'SELECT SUM(ALL foo) FROM bar' using DBD::DBM ok 642 - parse ' /* ORDER BY */' using DBD::DBM ok 643 - parse 'SELECT * FROM foo ORDER BY bar' using DBD::DBM ok 644 - parse 'SELECT * FROM foo ORDER BY bar, baz' using DBD::DBM ok 645 - parse 'SELECT * FROM foo ORDER BY bar DESC' using DBD::DBM ok 646 - parse 'SELECT * FROM foo ORDER BY bar ASC' using DBD::DBM ok 647 - parse ' /* LIMIT */' using DBD::DBM ok 648 - parse 'SELECT * FROM foo LIMIT 5' using DBD::DBM ok 649 - parse 'SELECT * FROM foo LIMIT 0, 5' using DBD::DBM ok 650 - parse 'SELECT * FROM foo LIMIT 5, 10' using DBD::DBM ok 651 - parse '/* DATE/TIME FUNCTIONS */' using DBD::DBM ok 652 - parse 'SELECT CURRENT_DATE()' using DBD::DBM ok 653 - parse 'SELECT CURRENT_TIME()' using DBD::DBM ok 654 - parse 'SELECT CURRENT_TIMESTAMP()' using DBD::DBM ok 655 - parse 'SELECT CURDATE()' using DBD::DBM ok 656 - parse 'SELECT CURTIME()' using DBD::DBM ok 657 - parse 'SELECT NOW()' using DBD::DBM ok 658 - parse 'SELECT UNIX_TIMESTAMP() ' using DBD::DBM ok 659 - parse 'SELECT CURRENT_TIME(2)' using DBD::DBM ok 660 - parse 'SELECT CURRENT_TIMESTAMP(2)' using DBD::DBM ok 661 - parse 'SELECT CURTIME(2)' using DBD::DBM ok 662 - parse 'SELECT NOW(2)' using DBD::DBM ok 663 - parse 'SELECT UNIX_TIMESTAMP(2)' using DBD::DBM ok 664 - parse ' /* STRING FUNCTIONS */' using DBD::DBM ok 665 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using DBD::DBM ok 666 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using DBD::DBM ok 667 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using DBD::DBM ok 668 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using DBD::DBM ok 669 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using DBD::DBM ok 670 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using DBD::DBM ok 671 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using DBD::DBM ok 672 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using DBD::DBM ok 673 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using DBD::DBM ok 674 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using DBD::DBM ok 675 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using DBD::DBM ok 676 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using DBD::DBM ok 677 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using DBD::DBM ok 678 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using DBD::DBM ok 679 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using DBD::DBM ok 680 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using DBD::DBM ok 681 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using DBD::DBM ok 682 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using DBD::DBM ok 683 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using DBD::DBM ok 684 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using DBD::DBM ok 685 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using DBD::DBM ok 686 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using DBD::DBM ok 687 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using DBD::DBM ok 688 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using DBD::DBM ok 689 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using DBD::DBM ok 690 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using DBD::DBM ok 691 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using DBD::DBM ok 692 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::DBM ok 693 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::DBM ok 694 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using DBD::DBM ok 695 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using DBD::DBM ok 696 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using DBD::DBM ok 697 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using DBD::DBM ok 698 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using DBD::DBM ok 699 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using DBD::DBM ok 700 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using DBD::DBM ok 701 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using DBD::DBM ok 702 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using DBD::DBM ok 703 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using DBD::DBM ok 704 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using DBD::DBM ok 705 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using DBD::DBM ok 706 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using DBD::DBM ok 707 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using DBD::DBM ok 708 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using DBD::DBM ok 709 - parse ' /* NUMERIC FUNCTIONS */' using DBD::DBM ok 710 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using DBD::DBM ok 711 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using DBD::DBM ok 712 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using DBD::DBM ok 713 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using DBD::DBM ok 714 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using DBD::DBM ok 715 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using DBD::DBM ok 716 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using DBD::DBM ok 717 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using DBD::DBM ok 718 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using DBD::DBM ok 719 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using DBD::DBM ok 720 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using DBD::DBM ok 721 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using DBD::DBM ok 722 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using DBD::DBM ok 723 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using DBD::DBM ok 724 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using DBD::DBM ok 725 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using DBD::DBM ok 726 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using DBD::DBM ok 727 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using DBD::DBM ok 728 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using DBD::DBM ok 729 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using DBD::DBM ok 730 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using DBD::DBM ok 731 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using DBD::DBM ok 732 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using DBD::DBM ok 733 - parse 'SELECT * FROM test WHERE ACOS(x)' using DBD::DBM ok 734 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using DBD::DBM ok 735 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using DBD::DBM ok 736 - parse 'SELECT * FROM test WHERE ACOSH(x)' using DBD::DBM ok 737 - parse 'SELECT * FROM test WHERE ACOT(x)' using DBD::DBM ok 738 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using DBD::DBM ok 739 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using DBD::DBM ok 740 - parse 'SELECT * FROM test WHERE ACOTH(x)' using DBD::DBM ok 741 - parse 'SELECT * FROM test WHERE ACSC(x)' using DBD::DBM ok 742 - parse 'SELECT * FROM test WHERE ACSCH(x)' using DBD::DBM ok 743 - parse 'SELECT * FROM test WHERE ASEC(x)' using DBD::DBM ok 744 - parse 'SELECT * FROM test WHERE ASECH(x)' using DBD::DBM ok 745 - parse 'SELECT * FROM test WHERE ASIN(x)' using DBD::DBM ok 746 - parse 'SELECT * FROM test WHERE ASINH(x)' using DBD::DBM ok 747 - parse 'SELECT * FROM test WHERE ATAN(x)' using DBD::DBM ok 748 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using DBD::DBM ok 749 - parse 'SELECT * FROM test WHERE ATANH(x)' using DBD::DBM ok 750 - parse 'SELECT * FROM test WHERE COS(x)' using DBD::DBM ok 751 - parse 'SELECT * FROM test WHERE COSEC(x)' using DBD::DBM ok 752 - parse 'SELECT * FROM test WHERE COSECH(x)' using DBD::DBM ok 753 - parse 'SELECT * FROM test WHERE COSH(x)' using DBD::DBM ok 754 - parse 'SELECT * FROM test WHERE COT(x)' using DBD::DBM ok 755 - parse 'SELECT * FROM test WHERE COTAN(x)' using DBD::DBM ok 756 - parse 'SELECT * FROM test WHERE COTANH(x)' using DBD::DBM ok 757 - parse 'SELECT * FROM test WHERE COTH(x)' using DBD::DBM ok 758 - parse 'SELECT * FROM test WHERE CSC(x)' using DBD::DBM ok 759 - parse 'SELECT * FROM test WHERE CSCH(x)' using DBD::DBM ok 760 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using DBD::DBM ok 761 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using DBD::DBM ok 762 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using DBD::DBM ok 763 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using DBD::DBM ok 764 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using DBD::DBM ok 765 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using DBD::DBM ok 766 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using DBD::DBM ok 767 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using DBD::DBM ok 768 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using DBD::DBM ok 769 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using DBD::DBM ok 770 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using DBD::DBM ok 771 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using DBD::DBM ok 772 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using DBD::DBM ok 773 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using DBD::DBM ok 774 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using DBD::DBM ok 775 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using DBD::DBM ok 776 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using DBD::DBM ok 777 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using DBD::DBM ok 778 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using DBD::DBM ok 779 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using DBD::DBM ok 780 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using DBD::DBM ok 781 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using DBD::DBM ok 782 - parse 'SELECT * FROM test WHERE PI()' using DBD::DBM ok 783 - parse 'SELECT * FROM test WHERE SEC(x)' using DBD::DBM ok 784 - parse 'SELECT * FROM test WHERE SECH(x)' using DBD::DBM ok 785 - parse 'SELECT * FROM test WHERE SIN(x)' using DBD::DBM ok 786 - parse 'SELECT * FROM test WHERE SINH(x)' using DBD::DBM ok 787 - parse 'SELECT * FROM test WHERE TAN(x)' using DBD::DBM ok 788 - parse 'SELECT * FROM test WHERE TANH(x)' using DBD::DBM ok 789 - parse ' /* SYSTEM FUNCTIONS */' using DBD::DBM ok 790 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using DBD::DBM ok 791 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using DBD::DBM ok 792 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using DBD::DBM ok 793 - parse ' /* TABLE NAME ALIASES */' using DBD::DBM ok 794 - parse 'SELECT * FROM test as T1' using DBD::DBM ok 795 - parse 'SELECT * FROM test T1' using DBD::DBM ok 796 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using DBD::DBM ok 797 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using DBD::DBM ok 798 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using DBD::DBM ok 799 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using DBD::DBM ok 800 - parse ' /* NUMERIC EXPRESSIONS */' using DBD::DBM ok 801 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using DBD::DBM ok 802 - parse ' /* CASE OF IDENTIFIERS */' using DBD::DBM ok 803 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using DBD::DBM ok 804 - parse ' /* PARENS */' using DBD::DBM ok 805 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using DBD::DBM ok 806 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using DBD::DBM ok 807 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using DBD::DBM ok 808 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using DBD::DBM ok 809 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using DBD::DBM ok 810 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using DBD::DBM ok 811 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using DBD::DBM ok 812 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using DBD::DBM ok 813 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using DBD::DBM ok 814 - parse ' /* NOT */' using DBD::DBM ok 815 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::DBM ok 816 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using DBD::DBM ok 817 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using DBD::DBM ok 818 - parse ' /* IN */' using DBD::DBM ok 819 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using DBD::DBM ok 820 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using DBD::DBM ok 821 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using DBD::DBM ok 822 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using DBD::DBM ok 823 - parse ' /* BETWEEN */' using DBD::DBM ok 824 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using DBD::DBM ok 825 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using DBD::DBM ok 826 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using DBD::DBM ok 827 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using DBD::DBM ok 828 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::DBM # TODO Analyze failures not ok 829 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::DBM # TODO Analyze failures # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::DBM' # at t/01prepare.t line 312. # # Execution ERROR: Unknown predicate '{$VAR1 = {}; # }' called from /usr/lib/aarch64-linux-gnu/perl5/5.32/DBI/DBD/SqlEngine.pm at 335. # not ok 830 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::DBM # TODO Analyze failures # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::DBM' # at t/01prepare.t line 312. # # Execution ERROR: Unknown predicate '{$VAR1 = {}; # }' called from /usr/lib/aarch64-linux-gnu/perl5/5.32/DBI/DBD/SqlEngine.pm at 335. # ok 831 - $sth->new ok 832 - $sth->command ok 833 - $sth->params ok 834 - $sth->tables ok 835 - $sth->where()->op ok 836 - $sth->where()->left ok 837 - $sth->where()->left->left ok 838 - $sth->where()->left->right ok 839 - $sth->limit ok 840 - $sth->offset # Command SELECT # Num Pholders 1 # Columns # Tables SQL::Statement::Table=HASH(0xaaaad1b39160),SQL::Statement::Table=HASH(0xaaaad0c543f8) # Where op AND # Limit 2 # Offset 5 # Order Cols f,g ok 841 - $stmt->row_values() ok 842 - $stmt->row_values(0) ok 843 - $stmt->row_values(0,1) ok 844 - structure ok 845 - command ok 846 - distinct 1..846 ok t/02execute.t ... # Can't locate MLDBM.pm in @INC (you may need to install the MLDBM module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.414 # # Using recommended: # # DBD::DBM: 0.08 # # DBD::File: 0.44 # # DBI: 1.643 # Running tests for SQL::Statement ok 1 - CREATE Tmp ok 2 - placeholder insert with named cols ok 3 - placeholder insert without named cols ok 4 - placeholder delete ok 5 - placeholder update ok 6 - placeholder update ok 7 - multiline insert ok 8 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id' ok 9 - verify table contents ok 10 - prepare 'SELECT id,phrase FROM Tmp WHERE (id?) and phrase LIKE ? ORDER BY id' ok 11 - verify placeholder processing ok 12 - DROP TABLE ok 13 - CREATE ok 14 - INSERT ok 15 - INSERT ok 16 - INSERT ok 17 - UPDATE ok 18 - DELETE ok 19 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' ok 20 - SELECT ok 21 - COUNT * ok 22 - DROP TEMP TABLE ok 23 - COMPUTED COLUMNS IN SELECT LIST ok 24 - CREATE FUNCTION from script # < CREATE TEMP TABLE a (b INT, c CHAR)> ok 25 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE) # < INSERT INTO a VALUES(1,'abc')> ok 26 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) # < INSERT INTO a VALUES(2,'efg')> ok 27 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT) # < INSERT INTO a VALUES(3,'hij')> ok 28 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT) # < INSERT INTO a VALUES(4,'klm')> ok 29 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT) # < INSERT INTO a VALUES(5,'nmo')> ok 30 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT) # < INSERT INTO a VALUES(6,'pqr')> ok 31 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT) # < INSERT INTO a VALUES(7,'stu')> ok 32 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT) # < INSERT INTO a VALUES(8,'vwx')> ok 33 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT) # < INSERT INTO a VALUES(9,'yz')> ok 34 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT) # < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"> ok 35 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT) ok 36 - $stmt->where_hash ok 37 - $stmt->columns ok 38 - $stmt->column_names ok 39 - $stmt->order ok 40 - $stmt->fetch ok 41 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) ok 42 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') ok 43 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) ok 44 - SELECT b,c FROM a WHERE b BETWEEN (5,7) ok 45 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) ok 46 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) ok 47 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) ok 48 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) ok 49 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 50 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') ok 51 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) ok 52 - SELECT b,c FROM a WHERE b IN (2,3,5,7) ok 53 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) ok 54 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') ok 55 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) ok 56 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) ok 57 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 58 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') ok 59 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 60 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') ok 61 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) ok 62 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) ok 63 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) ok 64 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') ok 65 - CREATE FUNCTION from module ok 66 - CREATE FUNCTION from module with argument ok 67 - LOAD FUNCTIONS ok 68 - CREATE pauli test table ok 69 - UPDATE with placeholders ok 70 - UPDATE with placeholder updates correct # Running tests for DBD::File ok 71 - CREATE Tmp ok 72 - placeholder insert with named cols ok 73 - placeholder insert without named cols ok 74 - placeholder delete ok 75 - placeholder update ok 76 - placeholder update ok 77 - multiline insert ok 78 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id' ok 79 - verify table contents ok 80 - prepare 'SELECT id,phrase FROM Tmp WHERE (id?) and phrase LIKE ? ORDER BY id' ok 81 - verify placeholder processing ok 82 - DROP TABLE ok 83 - CREATE ok 84 - INSERT ok 85 - INSERT ok 86 - INSERT ok 87 - UPDATE ok 88 - DELETE ok 89 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' ok 90 - SELECT ok 91 - COUNT * ok 92 - DROP TEMP TABLE ok 93 - COMPUTED COLUMNS IN SELECT LIST ok 94 - CREATE FUNCTION from script # < CREATE TEMP TABLE a (b INT, c CHAR)> ok 95 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE) # < INSERT INTO a VALUES(1,'abc')> ok 96 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) # < INSERT INTO a VALUES(2,'efg')> ok 97 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT) # < INSERT INTO a VALUES(3,'hij')> ok 98 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT) # < INSERT INTO a VALUES(4,'klm')> ok 99 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT) # < INSERT INTO a VALUES(5,'nmo')> ok 100 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT) # < INSERT INTO a VALUES(6,'pqr')> ok 101 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT) # < INSERT INTO a VALUES(7,'stu')> ok 102 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT) # < INSERT INTO a VALUES(8,'vwx')> ok 103 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT) # < INSERT INTO a VALUES(9,'yz')> ok 104 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT) # < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"> ok 105 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT) ok 106 - $stmt->where_hash ok 107 - $stmt->columns ok 108 - $stmt->column_names ok 109 - $stmt->order ok 110 - $stmt->fetch ok 111 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) ok 112 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) ok 113 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) ok 114 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') ok 115 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 116 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') ok 117 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) ok 118 - SELECT b,c FROM a WHERE b IN (2,3,5,7) ok 119 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) ok 120 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') ok 121 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 122 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') ok 123 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) ok 124 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) ok 125 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) ok 126 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) ok 127 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 128 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') ok 129 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) ok 130 - SELECT b,c FROM a WHERE b BETWEEN (5,7) ok 131 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) ok 132 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) ok 133 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) ok 134 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') ok 135 - CREATE FUNCTION from module ok 136 - CREATE FUNCTION from module with argument ok 137 - LOAD FUNCTIONS ok 138 - CREATE pauli test table ok 139 - UPDATE with placeholders ok 140 - UPDATE with placeholder updates correct # Running tests for DBD::DBM ok 141 - CREATE Tmp ok 142 - placeholder insert with named cols ok 143 - placeholder insert without named cols ok 144 - placeholder delete ok 145 - placeholder update ok 146 - placeholder update ok 147 - multiline insert ok 148 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id' ok 149 - verify table contents ok 150 - prepare 'SELECT id,phrase FROM Tmp WHERE (id?) and phrase LIKE ? ORDER BY id' ok 151 - verify placeholder processing ok 152 - DROP TABLE ok 153 - CREATE ok 154 - INSERT ok 155 - INSERT ok 156 - INSERT ok 157 - UPDATE ok 158 - DELETE ok 159 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' ok 160 - SELECT ok 161 - COUNT * ok 162 - DROP TABLE ok 163 - COMPUTED COLUMNS IN SELECT LIST ok 164 - CREATE FUNCTION from script # < CREATE TABLE a (b INT, c CHAR)> ok 165 - $stmt->execute " CREATE TABLE a (b INT, c CHAR)" (CREATE) # < INSERT INTO a VALUES(1,'abc')> ok 166 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) # < INSERT INTO a VALUES(2,'efg')> ok 167 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT) # < INSERT INTO a VALUES(3,'hij')> ok 168 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT) # < INSERT INTO a VALUES(4,'klm')> ok 169 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT) # < INSERT INTO a VALUES(5,'nmo')> ok 170 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT) # < INSERT INTO a VALUES(6,'pqr')> ok 171 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT) # < INSERT INTO a VALUES(7,'stu')> ok 172 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT) # < INSERT INTO a VALUES(8,'vwx')> ok 173 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT) # < INSERT INTO a VALUES(9,'yz')> ok 174 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT) # < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"> ok 175 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT) ok 176 - $stmt->where_hash ok 177 - $stmt->columns ok 178 - $stmt->column_names ok 179 - $stmt->order ok 180 - $stmt->fetch ok 181 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) ok 182 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') ok 183 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) ok 184 - SELECT b,c FROM a WHERE b BETWEEN (5,7) ok 185 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) ok 186 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) ok 187 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) ok 188 - SELECT b,c FROM a WHERE b IN (2,3,5,7) ok 189 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) ok 190 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') ok 191 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 192 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') ok 193 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) ok 194 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) ok 195 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) ok 196 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) ok 197 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 198 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') ok 199 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) ok 200 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) ok 201 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) ok 202 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') ok 203 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 204 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') ok 205 - CREATE FUNCTION from module ok 206 - CREATE FUNCTION from module with argument ok 207 - LOAD FUNCTIONS ok 208 # skip DBD::DBM Update test won't run without MLDBM ok 209 # skip DBD::DBM Update test won't run without MLDBM ok 210 # skip DBD::DBM Update test won't run without MLDBM 1..210 ok t/03import.t .... # Can't locate MLDBM.pm in @INC (you may need to install the MLDBM module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # Can't locate DBD/SQLite.pm in @INC (you may need to install the DBD::SQLite module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.414 # # Using recommended: # # DBD::DBM: 0.08 # # DBD::File: 0.44 # # DBI: 1.643 # Running tests for SQL::Statement ok 1 - IMPORT($AoA) ok 2 - IMPORT($AoH) ok 3 # skip Need DBI statement handle - can't use when executing direct ok 4 # skip Need DBI statement handle - can't use when executing direct ok 5 # skip Need DBI statement handle - can't use when executing direct ok 6 # skip Need DBI statement handle - can't use when executing direct ok 7 # skip Need DBI statement handle - can't use when executing direct ok 8 # skip Need DBI statement handle - can't use when executing direct ok 9 # skip Need DBI statement handle - can't use when executing direct ok 10 - SELECT IMPORT($external_sth) ok 11 # skip Need DBI statement handle - can't use when executing direct ok 12 # skip Need DBI statement handle - can't use when executing direct # Running tests for DBD::File ok 13 - IMPORT($AoA) ok 14 - IMPORT($AoH) ok 15 - CREATE AS IMPORT($aoh) ok 16 - SELECT FROM IMPORTED($AoH) ok 17 - CREATE AS IMPORT($aoa) ok 18 - SELECT FROM IMPORTED($AoA) ok 19 - CREATE AS SELECT * ok 20 - SELECT FROM "SELECTED(*)" tbl_copy ok 21 - CREATE AS SELECT * with quoted restriction ok 22 - SELECT FROM "SELECTED(*)" tbl_extract ok 23 - IMPORT($internal_sth) ok 24 - SELECT IMPORT($external_sth) ok 25 - CREATE AS IMPORT($sth) ok 26 - SELECT FROM IMPORTED ($external_sth) # Running tests for DBD::DBM ok 27 - IMPORT($AoA) ok 28 - IMPORT($AoH) ok 29 - CREATE AS IMPORT($aoh) ok 30 - SELECT FROM IMPORTED($AoH) ok 31 - CREATE AS IMPORT($aoa) ok 32 - SELECT FROM IMPORTED($AoA) ok 33 - CREATE AS SELECT * ok 34 - SELECT FROM "SELECTED(*)" tbl_copy ok 35 - CREATE AS SELECT * with quoted restriction ok 36 - SELECT FROM "SELECTED(*)" tbl_extract ok 37 - IMPORT($internal_sth) ok 38 - SELECT IMPORT($external_sth) ok 39 - CREATE AS IMPORT($sth) ok 40 - SELECT FROM IMPORTED ($external_sth) 1..40 ok t/04idents.t .... # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # Can't locate DBD/SQLite.pm in @INC (you may need to install the DBD::SQLite module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.414 # # Using recommended: # # DBD::DBM: 0.08 # # DBD::File: 0.44 # # DBI: 1.643 # Running tests for SQL::Statement ok 1 - Column Names: select list = * ok 2 - Column Names: select list = named ok 3 - Column Names: select list = aliased ok 4 - Column Names: select list with function ok 5 - Column Names: select list with function = aliased ok 6 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased) ok 7 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased) ok 8 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names) ok 9 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names) ok 10 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted) ok 11 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted) ok 12 - ->{all_cols} structure does not grow beyond control ok 13 - execute for 'lower/lower' ok 14 - lower/lower ok 15 - execute for 'lower/upper' ok 16 - lower/upper ok 17 - execute for 'lower/mixed' ok 18 - lower/mixed ok 19 - execute for 'lower/asterisked' ok 20 - lower/asterisked ok 21 - execute for 'upper/lower' ok 22 - upper/lower ok 23 - execute for 'upper/upper' ok 24 - upper/upper ok 25 - execute for 'upper/mixed' ok 26 - upper/mixed ok 27 - execute for 'upper/asterisked' ok 28 - upper/asterisked ok 29 - execute for 'mixed/lower' ok 30 - mixed/lower ok 31 - execute for 'mixed/upper' ok 32 - mixed/upper ok 33 - execute for 'mixed/mixed' ok 34 - mixed/mixed ok 35 - execute for 'mixed/asterisked' ok 36 - mixed/asterisked ok 37 # skip Need DBI statement handle - can't use when executing direct # Running tests for DBD::File ok 38 - Column Names: select list = * ok 39 - Column Names: select list = named ok 40 - Column Names: select list = aliased ok 41 - Column Names: select list with function ok 42 - Column Names: select list with function = aliased ok 43 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased) ok 44 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased) ok 45 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names) ok 46 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names) ok 47 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted) ok 48 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted) ok 49 - ->{all_cols} structure does not grow beyond control ok 50 - execute for 'lower/lower' ok 51 - lower/lower ok 52 - execute for 'lower/upper' ok 53 - lower/upper ok 54 - execute for 'lower/mixed' ok 55 - lower/mixed ok 56 - execute for 'lower/asterisked' ok 57 - lower/asterisked ok 58 - execute for 'upper/lower' ok 59 - upper/lower ok 60 - execute for 'upper/upper' ok 61 - upper/upper ok 62 - execute for 'upper/mixed' ok 63 - upper/mixed ok 64 - execute for 'upper/asterisked' ok 65 - upper/asterisked ok 66 - execute for 'mixed/lower' ok 67 - mixed/lower ok 68 - execute for 'mixed/upper' ok 69 - mixed/upper ok 70 - execute for 'mixed/mixed' ok 71 - mixed/mixed ok 72 - execute for 'mixed/asterisked' ok 73 - mixed/asterisked ok 74 - imported table : lower ok 75 - imported table : upper ok 76 - imported table : mixed ok 77 - imported table : asterisked # Running tests for DBD::DBM ok 78 - Column Names: select list = * ok 79 - Column Names: select list = named ok 80 - Column Names: select list = aliased ok 81 - Column Names: select list with function ok 82 - Column Names: select list with function = aliased ok 83 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased) ok 84 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased) ok 85 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names) ok 86 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names) ok 87 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted) ok 88 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted) ok 89 - ->{all_cols} structure does not grow beyond control ok 90 - execute for 'lower/lower' ok 91 - lower/lower ok 92 - execute for 'lower/upper' ok 93 - lower/upper ok 94 - execute for 'lower/mixed' ok 95 - lower/mixed ok 96 - execute for 'lower/asterisked' ok 97 - lower/asterisked ok 98 - execute for 'upper/lower' ok 99 - upper/lower ok 100 - execute for 'upper/upper' ok 101 - upper/upper ok 102 - execute for 'upper/mixed' ok 103 - upper/mixed ok 104 - execute for 'upper/asterisked' ok 105 - upper/asterisked ok 106 - execute for 'mixed/lower' ok 107 - mixed/lower ok 108 - execute for 'mixed/upper' ok 109 - mixed/upper ok 110 - execute for 'mixed/mixed' ok 111 - mixed/mixed ok 112 - execute for 'mixed/asterisked' ok 113 - mixed/asterisked ok 114 - imported table : lower ok 115 - imported table : upper ok 116 - imported table : mixed ok 117 - imported table : asterisked 1..117 ok t/05simple.t .... # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # Can't locate MLDBM.pm in @INC (you may need to install the MLDBM module) (@INC contains: t /build/libsql-statement-perl-1.414/blib/lib /build/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/aarch64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.414 # # Using recommended: # # DBD::DBM: 0.08 # # DBD::File: 0.44 # # DBI: 1.643 # Running tests for SQL::Statement ok 1 - prepare using 'SQL::Statement' ok 21 - execute using 'SQL::Statement' 2nd time ok 24 - execute using 'SQL::Statement' ok 30 - execute using 'SQL::Statement' 2nd time ok 33 - execute using 'SQL::Statement' ok 49 - execute using 'SQL::Statement' 2nd time ok 52 - execute using 'SQL::Statement' ok 67 - execute using 'SQL::Statement' 2nd time ok 70 - execute using 'SQL::Statement' ok 77 - execute == 1 using 'SQL::Statement' ok 79 - SELECT results for SELECT COUNT(*) FROM multi_fruit using SQL::Statement ok 80 - execute == 1 using 'SQL::Statement' ok 82 - SELECT results for SELECT COUNT(*) FROM multi_fruit using 'SQL::Statement' 2nd time ok 83 - prepare using 'SQL::Statement' ok 84 - execute using 'SQL::Statement' ok 85 - execute(DROP TABLE multi_fruit) == -1 using 'SQL::Statement' ok 86 - prepare using 'SQL::Statement' ok 87 - prepare using 'SQL::Statement' ok 97 - execute using 'SQL::Statement' 2nd time ok 100 - execute using 'SQL::Statement' ok 105 - execute using 'SQL::Statement' 2nd time ok 108 - execute using 'SQL::Statement' ok 113 - execute using 'SQL::Statement' 2nd time ok 116 - execute using 'SQL::Statement' ok 121 - execute using 'SQL::Statement' 2nd time ok 124 - execute using 'SQL::Statement' ok 129 - execute using 'SQL::Statement' 2nd time ok 132 - execute using 'SQL::Statement' ok 137 - execute using 'SQL::Statement' 2nd time ok 140 - execute using 'SQL::Statement' ok 145 - execute using 'SQL::Statement' 2nd time ok 148 - execute using 'SQL::Statement' ok 153 - execute using 'SQL::Statement' 2nd time ok 156 - execute