Diff of the two buildlogs: -- --- b1/build.log 2021-11-18 18:10:25.457909137 +0000 +++ b2/build.log 2021-11-18 18:10:55.292889630 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Thu Nov 18 06:09:39 -12 2021 -I: pbuilder-time-stamp: 1637258979 +I: Current time: Thu Dec 22 14:33:36 +14 2022 +I: pbuilder-time-stamp: 1671669216 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bullseye-reproducible-base.tgz] I: copying local configuration @@ -16,8 +16,8 @@ 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.kCrHZU0E/trustedkeys.kbx': General error -gpgv: Signature made Fri Oct 23 10:56:13 2020 -12 +gpgv: keyblock resource '/tmp/dpkg-verify-sig.OLDvdlpH/trustedkeys.kbx': General error +gpgv: Signature made Sat Oct 24 12:56:13 2020 +14 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 @@ -26,135 +26,169 @@ 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/2176538/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/1915913/tmp/hooks/D01_modify_environment starting +debug: Running on ionos15-amd64. +I: Changing host+domainname to test build reproducibility +I: Adding a custom variable just for the fun of it... +I: Changing /bin/sh to bash +Removing 'diversion of /bin/sh to /bin/sh.distrib by dash' +Adding 'diversion of /bin/sh to /bin/sh.distrib by bash' +Removing 'diversion of /usr/share/man/man1/sh.1.gz to /usr/share/man/man1/sh.distrib.1.gz by dash' +Adding 'diversion of /usr/share/man/man1/sh.1.gz to /usr/share/man/man1/sh.distrib.1.gz by bash' +I: Setting pbuilder2's login shell to /bin/bash +I: Setting pbuilder2's GECOS to second user,second room,second work-phone,second home-phone,second other +I: user script /srv/workspace/pbuilder/1915913/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/1915913/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='amd64' - DEBIAN_FRONTEND='noninteractive' - DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=15' - DISTRIBUTION='' - HOME='/root' - HOST_ARCH='amd64' + BASH=/bin/sh + BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:hostcomplete:interactive_comments:progcomp:promptvars:sourcepath + BASH_ALIASES=() + BASH_ARGC=() + BASH_ARGV=() + BASH_CMDS=() + BASH_LINENO=([0]="12" [1]="0") + BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") + BASH_VERSINFO=([0]="5" [1]="1" [2]="4" [3]="1" [4]="release" [5]="x86_64-pc-linux-gnu") + BASH_VERSION='5.1.4(1)-release' + BUILDDIR=/build + BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' + BUILDUSERNAME=pbuilder2 + BUILD_ARCH=amd64 + DEBIAN_FRONTEND=noninteractive + DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=16' + DIRSTACK=() + DISTRIBUTION= + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=x86_64 + HOST_ARCH=amd64 IFS=' ' - INVOCATION_ID='809a79dff19247e7a58e7ee407f966aa' - 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='2176538' - PS1='# ' - PS2='> ' + INVOCATION_ID=dee1c55a7e1c4287806cc96fd21130f6 + LANG=C + LANGUAGE=et_EE:et + LC_ALL=C + MACHTYPE=x86_64-pc-linux-gnu + MAIL=/var/mail/root + OPTERR=1 + OPTIND=1 + OSTYPE=linux-gnu + PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path + PBCURRENTCOMMANDLINEOPERATION=build + PBUILDER_OPERATION=build + PBUILDER_PKGDATADIR=/usr/share/pbuilder + PBUILDER_PKGLIBDIR=/usr/lib/pbuilder + PBUILDER_SYSCONFDIR=/etc + PIPESTATUS=([0]="0") + POSIXLY_CORRECT=y + PPID=1915913 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.Ba0OO73GYL/pbuilderrc_jztc --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.Ba0OO73GYL/b1 --logfile b1/build.log libsql-statement-perl_1.414-1.dsc' - SUDO_GID='111' - SUDO_UID='106' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - _='/usr/bin/systemd-run' - http_proxy='http://78.137.99.97:3128' + PWD=/ + SHELL=/bin/bash + SHELLOPTS=braceexpand:errexit:hashall:interactive-comments:posix + SHLVL=3 + SUDO_COMMAND='/usr/bin/timeout -k 24.1h 24h /usr/bin/ionice -c 3 /usr/bin/nice -n 11 /usr/bin/unshare --uts -- /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/tmp.Ba0OO73GYL/pbuilderrc_QiIA --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.Ba0OO73GYL/b2 --logfile b2/build.log libsql-statement-perl_1.414-1.dsc' + SUDO_GID=111 + SUDO_UID=106 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + _='I: set' + http_proxy=http://85.184.249.68:3128 I: uname -a - Linux ionos11-amd64 5.10.0-9-amd64 #1 SMP Debian 5.10.70-1 (2021-09-30) x86_64 GNU/Linux + Linux i-capture-the-hostname 5.14.0-0.bpo.2-amd64 #1 SMP Debian 5.14.9-2~bpo11+1 (2021-10-10) x86_64 GNU/Linux I: ls -l /bin total 5476 - -rwxr-xr-x 1 root root 1234376 Aug 4 08:25 bash - -rwxr-xr-x 3 root root 38984 Jul 20 2020 bunzip2 - -rwxr-xr-x 3 root root 38984 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 38984 Jul 20 2020 bzip2 - -rwxr-xr-x 1 root root 18424 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 43936 Sep 23 2020 cat - -rwxr-xr-x 1 root root 72672 Sep 23 2020 chgrp - -rwxr-xr-x 1 root root 64448 Sep 23 2020 chmod - -rwxr-xr-x 1 root root 72672 Sep 23 2020 chown - -rwxr-xr-x 1 root root 151168 Sep 23 2020 cp - -rwxr-xr-x 1 root root 125560 Dec 10 2020 dash - -rwxr-xr-x 1 root root 113664 Sep 23 2020 date - -rwxr-xr-x 1 root root 80968 Sep 23 2020 dd - -rwxr-xr-x 1 root root 93936 Sep 23 2020 df - -rwxr-xr-x 1 root root 147176 Sep 23 2020 dir - -rwxr-xr-x 1 root root 84440 Jul 28 07:09 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 39712 Sep 23 2020 echo - -rwxr-xr-x 1 root root 28 Nov 9 2020 egrep - -rwxr-xr-x 1 root root 39680 Sep 23 2020 false - -rwxr-xr-x 1 root root 28 Nov 9 2020 fgrep - -rwxr-xr-x 1 root root 69032 Jul 28 07:09 findmnt - -rwsr-xr-x 1 root root 34896 Feb 26 2021 fusermount - -rwxr-xr-x 1 root root 203072 Nov 9 2020 grep - -rwxr-xr-x 2 root root 2346 Mar 2 2021 gunzip - -rwxr-xr-x 1 root root 6376 Mar 2 2021 gzexe - -rwxr-xr-x 1 root root 98048 Mar 2 2021 gzip - -rwxr-xr-x 1 root root 22600 Nov 6 2019 hostname - -rwxr-xr-x 1 root root 72840 Sep 23 2020 ln - -rwxr-xr-x 1 root root 56952 Feb 7 2020 login - -rwxr-xr-x 1 root root 147176 Sep 23 2020 ls - -rwxr-xr-x 1 root root 149736 Jul 28 07:09 lsblk - -rwxr-xr-x 1 root root 85184 Sep 23 2020 mkdir - -rwxr-xr-x 1 root root 76896 Sep 23 2020 mknod - -rwxr-xr-x 1 root root 48064 Sep 23 2020 mktemp - -rwxr-xr-x 1 root root 59632 Jul 28 07:09 more - -rwsr-xr-x 1 root root 55528 Jul 28 07:09 mount - -rwxr-xr-x 1 root root 18664 Jul 28 07:09 mountpoint - -rwxr-xr-x 1 root root 147080 Sep 23 2020 mv - lrwxrwxrwx 1 root root 8 Nov 6 2019 nisdomainname -> hostname - lrwxrwxrwx 1 root root 14 Apr 18 2021 pidof -> /sbin/killall5 - -rwxr-xr-x 1 root root 43872 Sep 23 2020 pwd - lrwxrwxrwx 1 root root 4 Aug 4 08:25 rbash -> bash - -rwxr-xr-x 1 root root 52032 Sep 23 2020 readlink - -rwxr-xr-x 1 root root 72704 Sep 23 2020 rm - -rwxr-xr-x 1 root root 52032 Sep 23 2020 rmdir - -rwxr-xr-x 1 root root 27472 Sep 27 2020 run-parts - -rwxr-xr-x 1 root root 122224 Dec 22 2018 sed - lrwxrwxrwx 1 root root 4 Oct 20 23:41 sh -> dash - -rwxr-xr-x 1 root root 43808 Sep 23 2020 sleep - -rwxr-xr-x 1 root root 84928 Sep 23 2020 stty - -rwsr-xr-x 1 root root 71912 Jul 28 07:09 su - -rwxr-xr-x 1 root root 39744 Sep 23 2020 sync - -rwxr-xr-x 1 root root 531928 Feb 16 2021 tar - -rwxr-xr-x 1 root root 14456 Sep 27 2020 tempfile - -rwxr-xr-x 1 root root 101408 Sep 23 2020 touch - -rwxr-xr-x 1 root root 39680 Sep 23 2020 true - -rwxr-xr-x 1 root root 14328 Feb 26 2021 ulockmgr_server - -rwsr-xr-x 1 root root 35040 Jul 28 07:09 umount - -rwxr-xr-x 1 root root 39744 Sep 23 2020 uname - -rwxr-xr-x 2 root root 2346 Mar 2 2021 uncompress - -rwxr-xr-x 1 root root 147176 Sep 23 2020 vdir - -rwxr-xr-x 1 root root 63744 Jul 28 07:09 wdctl - lrwxrwxrwx 1 root root 8 Nov 6 2019 ypdomainname -> hostname - -rwxr-xr-x 1 root root 1984 Mar 2 2021 zcat - -rwxr-xr-x 1 root root 1678 Mar 2 2021 zcmp - -rwxr-xr-x 1 root root 5880 Mar 2 2021 zdiff - -rwxr-xr-x 1 root root 29 Mar 2 2021 zegrep - -rwxr-xr-x 1 root root 29 Mar 2 2021 zfgrep - -rwxr-xr-x 1 root root 2081 Mar 2 2021 zforce - -rwxr-xr-x 1 root root 7585 Mar 2 2021 zgrep - -rwxr-xr-x 1 root root 2206 Mar 2 2021 zless - -rwxr-xr-x 1 root root 1842 Mar 2 2021 zmore - -rwxr-xr-x 1 root root 4553 Mar 2 2021 znew -I: user script /srv/workspace/pbuilder/2176538/tmp/hooks/D02_print_environment finished + -rwxr-xr-x 1 root root 1234376 Aug 5 2021 bash + -rwxr-xr-x 3 root root 38984 Jul 21 2020 bunzip2 + -rwxr-xr-x 3 root root 38984 Jul 21 2020 bzcat + lrwxrwxrwx 1 root root 6 Jul 21 2020 bzcmp -> bzdiff + -rwxr-xr-x 1 root root 2225 Jul 21 2020 bzdiff + lrwxrwxrwx 1 root root 6 Jul 21 2020 bzegrep -> bzgrep + -rwxr-xr-x 1 root root 4877 Sep 5 2019 bzexe + lrwxrwxrwx 1 root root 6 Jul 21 2020 bzfgrep -> bzgrep + -rwxr-xr-x 1 root root 3775 Jul 21 2020 bzgrep + -rwxr-xr-x 3 root root 38984 Jul 21 2020 bzip2 + -rwxr-xr-x 1 root root 18424 Jul 21 2020 bzip2recover + lrwxrwxrwx 1 root root 6 Jul 21 2020 bzless -> bzmore + -rwxr-xr-x 1 root root 1297 Jul 21 2020 bzmore + -rwxr-xr-x 1 root root 43936 Sep 24 2020 cat + -rwxr-xr-x 1 root root 72672 Sep 24 2020 chgrp + -rwxr-xr-x 1 root root 64448 Sep 24 2020 chmod + -rwxr-xr-x 1 root root 72672 Sep 24 2020 chown + -rwxr-xr-x 1 root root 151168 Sep 24 2020 cp + -rwxr-xr-x 1 root root 125560 Dec 11 2020 dash + -rwxr-xr-x 1 root root 113664 Sep 24 2020 date + -rwxr-xr-x 1 root root 80968 Sep 24 2020 dd + -rwxr-xr-x 1 root root 93936 Sep 24 2020 df + -rwxr-xr-x 1 root root 147176 Sep 24 2020 dir + -rwxr-xr-x 1 root root 84440 Jul 29 2021 dmesg + lrwxrwxrwx 1 root root 8 Nov 8 2019 dnsdomainname -> hostname + lrwxrwxrwx 1 root root 8 Nov 8 2019 domainname -> hostname + -rwxr-xr-x 1 root root 39712 Sep 24 2020 echo + -rwxr-xr-x 1 root root 28 Nov 10 2020 egrep + -rwxr-xr-x 1 root root 39680 Sep 24 2020 false + -rwxr-xr-x 1 root root 28 Nov 10 2020 fgrep + -rwxr-xr-x 1 root root 69032 Jul 29 2021 findmnt + -rwsr-xr-x 1 root root 34896 Feb 27 2021 fusermount + -rwxr-xr-x 1 root root 203072 Nov 10 2020 grep + -rwxr-xr-x 2 root root 2346 Mar 3 2021 gunzip + -rwxr-xr-x 1 root root 6376 Mar 3 2021 gzexe + -rwxr-xr-x 1 root root 98048 Mar 3 2021 gzip + -rwxr-xr-x 1 root root 22600 Nov 8 2019 hostname + -rwxr-xr-x 1 root root 72840 Sep 24 2020 ln + -rwxr-xr-x 1 root root 56952 Feb 8 2020 login + -rwxr-xr-x 1 root root 147176 Sep 24 2020 ls + -rwxr-xr-x 1 root root 149736 Jul 29 2021 lsblk + -rwxr-xr-x 1 root root 85184 Sep 24 2020 mkdir + -rwxr-xr-x 1 root root 76896 Sep 24 2020 mknod + -rwxr-xr-x 1 root root 48064 Sep 24 2020 mktemp + -rwxr-xr-x 1 root root 59632 Jul 29 2021 more + -rwsr-xr-x 1 root root 55528 Jul 29 2021 mount + -rwxr-xr-x 1 root root 18664 Jul 29 2021 mountpoint + -rwxr-xr-x 1 root root 147080 Sep 24 2020 mv + lrwxrwxrwx 1 root root 8 Nov 8 2019 nisdomainname -> hostname + lrwxrwxrwx 1 root root 14 Apr 19 2021 pidof -> /sbin/killall5 + -rwxr-xr-x 1 root root 43872 Sep 24 2020 pwd + lrwxrwxrwx 1 root root 4 Aug 5 2021 rbash -> bash + -rwxr-xr-x 1 root root 52032 Sep 24 2020 readlink + -rwxr-xr-x 1 root root 72704 Sep 24 2020 rm + -rwxr-xr-x 1 root root 52032 Sep 24 2020 rmdir + -rwxr-xr-x 1 root root 27472 Sep 28 2020 run-parts + -rwxr-xr-x 1 root root 122224 Dec 23 2018 sed + lrwxrwxrwx 1 root root 4 Dec 22 14:33 sh -> bash + lrwxrwxrwx 1 root root 4 Nov 24 08:05 sh.distrib -> dash + -rwxr-xr-x 1 root root 43808 Sep 24 2020 sleep + -rwxr-xr-x 1 root root 84928 Sep 24 2020 stty + -rwsr-xr-x 1 root root 71912 Jul 29 2021 su + -rwxr-xr-x 1 root root 39744 Sep 24 2020 sync + -rwxr-xr-x 1 root root 531928 Feb 17 2021 tar + -rwxr-xr-x 1 root root 14456 Sep 28 2020 tempfile + -rwxr-xr-x 1 root root 101408 Sep 24 2020 touch + -rwxr-xr-x 1 root root 39680 Sep 24 2020 true + -rwxr-xr-x 1 root root 14328 Feb 27 2021 ulockmgr_server + -rwsr-xr-x 1 root root 35040 Jul 29 2021 umount + -rwxr-xr-x 1 root root 39744 Sep 24 2020 uname + -rwxr-xr-x 2 root root 2346 Mar 3 2021 uncompress + -rwxr-xr-x 1 root root 147176 Sep 24 2020 vdir + -rwxr-xr-x 1 root root 63744 Jul 29 2021 wdctl + lrwxrwxrwx 1 root root 8 Nov 8 2019 ypdomainname -> hostname + -rwxr-xr-x 1 root root 1984 Mar 3 2021 zcat + -rwxr-xr-x 1 root root 1678 Mar 3 2021 zcmp + -rwxr-xr-x 1 root root 5880 Mar 3 2021 zdiff + -rwxr-xr-x 1 root root 29 Mar 3 2021 zegrep + -rwxr-xr-x 1 root root 29 Mar 3 2021 zfgrep + -rwxr-xr-x 1 root root 2081 Mar 3 2021 zforce + -rwxr-xr-x 1 root root 7585 Mar 3 2021 zgrep + -rwxr-xr-x 1 root root 2206 Mar 3 2021 zless + -rwxr-xr-x 1 root root 1842 Mar 3 2021 zmore + -rwxr-xr-x 1 root root 4553 Mar 3 2021 znew +I: user script /srv/workspace/pbuilder/1915913/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -255,7 +289,7 @@ Get: 45 http://deb.debian.org/debian bullseye/main amd64 libtest-pod-coverage-perl all 1.10-2 [14.5 kB] Get: 46 http://deb.debian.org/debian bullseye/main amd64 libtest-pod-perl all 1.52-1 [14.2 kB] Get: 47 http://deb.debian.org/debian bullseye/main amd64 libtext-soundex-perl amd64 3.05-1 [13.8 kB] -Fetched 19.5 MB in 6s (3324 kB/s) +Fetched 19.5 MB in 0s (87.3 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 ... 19655 files and directories currently installed.) @@ -461,7 +495,8 @@ 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 +hostname: Name or service not known +I: Running cd /build/libsql-statement-perl-1.414/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-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 @@ -488,32 +523,32 @@ Writing MYMETA.yml and MYMETA.json make[1]: Leaving directory '/build/libsql-statement-perl-1.414' dh_auto_build - make -j15 + make -j16 make[1]: Entering directory '/build/libsql-statement-perl-1.414' -cp lib/SQL/Statement/RAM.pm blib/lib/SQL/Statement/RAM.pm -cp lib/SQL/Statement.pm blib/lib/SQL/Statement.pm -cp lib/SQL/Statement/Term.pm blib/lib/SQL/Statement/Term.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 -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/Statement/Function.pm blib/lib/SQL/Statement/Function.pm cp lib/SQL/Statement/GetInfo.pm blib/lib/SQL/Statement/GetInfo.pm +cp lib/SQL/Statement/Structure.pod blib/lib/SQL/Statement/Structure.pod cp lib/SQL/Statement/Syntax.pod blib/lib/SQL/Statement/Syntax.pod -cp lib/SQL/Dialects/CSV.pm blib/lib/SQL/Dialects/CSV.pm -cp lib/SQL/Dialects/ANSI.pm blib/lib/SQL/Dialects/ANSI.pm -cp lib/SQL/Statement/Util.pm blib/lib/SQL/Statement/Util.pm +cp lib/SQL/Statement/Placeholder.pm blib/lib/SQL/Statement/Placeholder.pm cp lib/SQL/Statement/Embed.pod blib/lib/SQL/Statement/Embed.pod +cp lib/SQL/Statement/Functions.pm blib/lib/SQL/Statement/Functions.pm +cp lib/SQL/Statement/RAM.pm blib/lib/SQL/Statement/RAM.pm cp lib/SQL/Statement/Operation.pm blib/lib/SQL/Statement/Operation.pm -cp lib/SQL/Statement/Placeholder.pm blib/lib/SQL/Statement/Placeholder.pm -cp lib/SQL/Eval.pm blib/lib/SQL/Eval.pm cp lib/SQL/Statement/TermFactory.pm blib/lib/SQL/Statement/TermFactory.pm -cp lib/SQL/Statement/Structure.pod blib/lib/SQL/Statement/Structure.pod +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/Dialects/CSV.pm blib/lib/SQL/Dialects/CSV.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/Parser.pm blib/lib/SQL/Parser.pm +cp lib/SQL/Dialects/AnyData.pm blib/lib/SQL/Dialects/AnyData.pm +cp lib/SQL/Statement/Util.pm blib/lib/SQL/Statement/Util.pm +cp lib/SQL/Statement/Term.pm blib/lib/SQL/Statement/Term.pm cp lib/SQL/Statement/Roadmap.pod blib/lib/SQL/Statement/Roadmap.pod Manifying 20 pod documents make[1]: Leaving directory '/build/libsql-statement-perl-1.414' dh_auto_test - make -j15 test TEST_VERBOSE=1 + make -j16 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: @@ -843,7 +878,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0x55edecc2d1c0),SQL::Statement::Table=HASH(0x55edecc33358) +# Tables SQL::Statement::Table=HASH(0x55ffe8244a90),SQL::Statement::Table=HASH(0x55ffe823e698) # Where op AND # Limit 2 # Offset 5 @@ -1145,7 +1180,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0x55edecc831d8),SQL::Statement::Table=HASH(0x55edecc33460) +# Tables SQL::Statement::Table=HASH(0x55ffe81dcc80),SQL::Statement::Table=HASH(0x55ffe81dd178) # Where op AND # Limit 2 # Offset 5 @@ -1447,7 +1482,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0x55edebe20f40),SQL::Statement::Table=HASH(0x55edebe20ca0) +# Tables SQL::Statement::Table=HASH(0x55ffe8296c30),SQL::Statement::Table=HASH(0x55ffe82b46c8) # Where op AND # Limit 2 # Offset 5 @@ -1521,28 +1556,28 @@ ok 38 - $stmt->column_names ok 39 - $stmt->order ok 40 - $stmt->fetch -ok 41 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 42 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -ok 43 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) -ok 44 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) -ok 45 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 46 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') -ok 47 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) -ok 48 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) -ok 49 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) -ok 50 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) -ok 51 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) -ok 52 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') -ok 53 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 54 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') -ok 55 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) -ok 56 - SELECT b,c FROM a WHERE b IN (2,3,5,7) -ok 57 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) -ok 58 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) -ok 59 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 60 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -ok 61 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) -ok 62 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 41 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 42 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') +ok 43 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) +ok 44 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) +ok 45 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) +ok 46 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +ok 47 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 48 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') +ok 49 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) +ok 50 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) +ok 51 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 52 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') +ok 53 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) +ok 54 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) +ok 55 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) +ok 56 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) +ok 57 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) +ok 58 - SELECT b,c FROM a WHERE b IN (2,3,5,7) +ok 59 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) +ok 60 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 61 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) +ok 62 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') ok 63 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) ok 64 - SELECT b,c FROM a WHERE b BETWEEN (5,7) ok 65 - CREATE FUNCTION from module @@ -1603,30 +1638,30 @@ ok 108 - $stmt->column_names ok 109 - $stmt->order ok 110 - $stmt->fetch -ok 111 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 112 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -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 b BETWEEN (5,7)" (SELECT) -ok 116 - SELECT b,c FROM a WHERE b BETWEEN (5,7) -ok 117 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 118 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -ok 119 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) -ok 120 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) -ok 121 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) -ok 122 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) +ok 111 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) +ok 112 - SELECT b,c FROM a WHERE b IN (2,3,5,7) +ok 113 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) +ok 114 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) +ok 115 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) +ok 116 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') +ok 117 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) +ok 118 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 119 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) +ok 120 - SELECT b,c FROM a WHERE b BETWEEN (5,7) +ok 121 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 122 - SELECT b,c FROM a WHERE c NOT 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 c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 126 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') +ok 125 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) +ok 126 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') 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 NOT b IN (2,3,5,7)" (SELECT) -ok 130 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) -ok 131 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) -ok 132 - SELECT b,c FROM a WHERE b IN (2,3,5,7) -ok 133 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) -ok 134 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +ok 129 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) +ok 130 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) +ok 131 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) +ok 132 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) +ok 133 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 134 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') ok 135 - CREATE FUNCTION from module ok 136 - CREATE FUNCTION from module with argument ok 137 - LOAD FUNCTIONS @@ -1685,30 +1720,30 @@ ok 178 - $stmt->column_names ok 179 - $stmt->order ok 180 - $stmt->fetch -ok 181 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) -ok 182 - SELECT b,c FROM a WHERE 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 NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 186 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -ok 187 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 188 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') -ok 189 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) -ok 190 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) -ok 191 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) -ok 192 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) -ok 193 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) -ok 194 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') -ok 195 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) -ok 196 - SELECT b,c FROM a WHERE 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 NOT b IN (2,3,5,7)" (SELECT) -ok 200 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) +ok 181 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) +ok 182 - SELECT b,c FROM a WHERE b IN (2,3,5,7) +ok 183 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) +ok 184 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) +ok 185 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) +ok 186 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 187 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) +ok 188 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') +ok 189 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) +ok 190 - SELECT b,c FROM a WHERE b BETWEEN (5,7) +ok 191 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) +ok 192 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +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 c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 196 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') +ok 197 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) +ok 198 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) +ok 199 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 200 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') ok 201 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 202 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -ok 203 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) -ok 204 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) +ok 203 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) +ok 204 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) ok 205 - CREATE FUNCTION from module ok 206 - CREATE FUNCTION from module with argument ok 207 - LOAD FUNCTIONS @@ -1718,8 +1753,8 @@ 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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-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 @@ -1819,7 +1854,7 @@ 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::DBM +# 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 @@ -1860,7 +1895,7 @@ ok 75 - imported table : upper ok 76 - imported table : mixed ok 77 - imported table : asterisked -# Running tests for DBD::File +# 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 @@ -2120,40 +2155,40 @@ ok 30 - execute CREATE TYPE TIMESTAMP on SQL::Statement ok 31 - prepare CREATE TEMP TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP) on SQL::Statement ok 32 - execute CREATE TEMP TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP) on SQL::Statement -ok 33 - prepare INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1637259015) on SQL::Statement -ok 34 - execute INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1637259015) on SQL::Statement -ok 35 - prepare INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1637259015) on SQL::Statement -ok 36 - execute INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1637259015) on SQL::Statement -ok 37 - prepare INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1637259015) on SQL::Statement -ok 38 - execute INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1637259015) on SQL::Statement -ok 39 - prepare INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1637259015) on SQL::Statement -ok 40 - execute INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1637259015) on SQL::Statement -ok 41 - prepare INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1637259015) on SQL::Statement -ok 42 - execute INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1637259015) on SQL::Statement -ok 43 - prepare INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1637259015) on SQL::Statement -ok 44 - execute INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1637259015) on SQL::Statement -ok 45 - prepare INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1637259015) on SQL::Statement -ok 46 - execute INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1637259015) on SQL::Statement -ok 47 - prepare INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1637255415) on SQL::Statement -ok 48 - execute INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1637255415) on SQL::Statement -ok 49 - prepare INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1637251815) on SQL::Statement -ok 50 - execute INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1637251815) on SQL::Statement -ok 51 - prepare INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1637248215) on SQL::Statement -ok 52 - execute INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1637248215) on SQL::Statement -ok 53 - prepare INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1637244615) on SQL::Statement -ok 54 - execute INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1637244615) on SQL::Statement -ok 55 - prepare INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1637241015) on SQL::Statement -ok 56 - execute INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1637241015) on SQL::Statement -ok 57 - prepare INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1637237415) on SQL::Statement -ok 58 - execute INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1637237415) on SQL::Statement -ok 59 - prepare INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1637233815) on SQL::Statement -ok 60 - execute INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1637233815) on SQL::Statement -ok 61 - prepare INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1637230215) on SQL::Statement -ok 62 - execute INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1637230215) on SQL::Statement -ok 63 - prepare INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1637226615) on SQL::Statement -ok 64 - execute INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1637226615) on SQL::Statement -ok 65 - prepare INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1637223015) on SQL::Statement -ok 66 - execute INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1637223015) on SQL::Statement +ok 33 - prepare INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1671669237) on SQL::Statement +ok 34 - execute INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1671669237) on SQL::Statement +ok 35 - prepare INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1671669237) on SQL::Statement +ok 36 - execute INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1671669237) on SQL::Statement +ok 37 - prepare INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1671669237) on SQL::Statement +ok 38 - execute INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1671669237) on SQL::Statement +ok 39 - prepare INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1671669237) on SQL::Statement +ok 40 - execute INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1671669237) on SQL::Statement +ok 41 - prepare INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1671669237) on SQL::Statement +ok 42 - execute INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1671669237) on SQL::Statement +ok 43 - prepare INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1671669237) on SQL::Statement +ok 44 - execute INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1671669237) on SQL::Statement +ok 45 - prepare INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1671669237) on SQL::Statement +ok 46 - execute INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1671669237) on SQL::Statement +ok 47 - prepare INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1671665637) on SQL::Statement +ok 48 - execute INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1671665637) on SQL::Statement +ok 49 - prepare INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1671662037) on SQL::Statement +ok 50 - execute INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1671662037) on SQL::Statement +ok 51 - prepare INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1671658437) on SQL::Statement +ok 52 - execute INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1671658437) on SQL::Statement +ok 53 - prepare INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1671654837) on SQL::Statement +ok 54 - execute INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1671654837) on SQL::Statement +ok 55 - prepare INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1671651237) on SQL::Statement +ok 56 - execute INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1671651237) on SQL::Statement +ok 57 - prepare INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1671647637) on SQL::Statement +ok 58 - execute INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1671647637) on SQL::Statement +ok 59 - prepare INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1671644037) on SQL::Statement +ok 60 - execute INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1671644037) on SQL::Statement +ok 61 - prepare INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1671640437) on SQL::Statement +ok 62 - execute INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1671640437) on SQL::Statement +ok 63 - prepare INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1671636837) on SQL::Statement +ok 64 - execute INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1671636837) on SQL::Statement +ok 65 - prepare INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1671633237) on SQL::Statement +ok 66 - execute INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1671633237) on SQL::Statement ok 67 - prepare SELECT class,SUM(sales) as foo, MAX(sales) FROM biz GROUP BY class using SQL::Statement ok 68 - execute SELECT class,SUM(sales) as foo, MAX(sales) FROM biz GROUP BY class using SQL::Statement ok 69 - GROUP BY one column @@ -2724,17 +2759,17 @@ ok 625 - prepare SELECT USER() using SQL::Statement ok 626 - execute SELECT USER() using SQL::Statement ok 627 - user -ok 628 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp < (1637259015 - ( 4 * 60 )) using SQL::Statement -ok 629 - execute SELECT id,host,signature,message FROM log WHERE time_stamp < (1637259015 - ( 4 * 60 )) using SQL::Statement +ok 628 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp < (1671669237 - ( 4 * 60 )) using SQL::Statement +ok 629 - execute SELECT id,host,signature,message FROM log WHERE time_stamp < (1671669237 - ( 4 * 60 )) using SQL::Statement ok 630 - SELECT with calculation in WHERE CLAUSE -ok 631 - prepare SELECT id,host,signature,message FROM log WHERE (time_stamp > (1637259015 - 5)) AND (time_stamp < (1637259015 + 5)) using SQL::Statement -ok 632 - execute SELECT id,host,signature,message FROM log WHERE (time_stamp > (1637259015 - 5)) AND (time_stamp < (1637259015 + 5)) using SQL::Statement +ok 631 - prepare SELECT id,host,signature,message FROM log WHERE (time_stamp > (1671669237 - 5)) AND (time_stamp < (1671669237 + 5)) using SQL::Statement +ok 632 - execute SELECT id,host,signature,message FROM log WHERE (time_stamp > (1671669237 - 5)) AND (time_stamp < (1671669237 + 5)) using SQL::Statement ok 633 - SELECT with calculation and logical expression in WHERE CLAUSE -ok 634 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1637259015 - 5, 1637259015 + 5) using SQL::Statement -ok 635 - execute SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1637259015 - 5, 1637259015 + 5) using SQL::Statement +ok 634 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1671669237 - 5, 1671669237 + 5) using SQL::Statement +ok 635 - execute SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1671669237 - 5, 1671669237 + 5) using SQL::Statement ok 636 - SELECT with calculated items in BETWEEN in WHERE CLAUSE -ok 637 - prepare SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1637259015 - (2*3600), 1637259015 - (4*3600)) using SQL::Statement -ok 638 - execute SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1637259015 - (2*3600), 1637259015 - (4*3600)) using SQL::Statement +ok 637 - prepare SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1671669237 - (2*3600), 1671669237 - (4*3600)) using SQL::Statement +ok 638 - execute SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1671669237 - (2*3600), 1671669237 - (4*3600)) using SQL::Statement ok 639 - MAX() with calculated WHERE clause ok 640 - prepare SELECT MAX(time_stamp - 3*3600) FROM log using SQL::Statement ok 641 - execute SELECT MAX(time_stamp - 3*3600) FROM log using SQL::Statement @@ -2755,688 +2790,13 @@ ok 653 - prepare SELECT 1 using SQL::Statement ok 654 - execute SELECT 1 using SQL::Statement ok 655 - SELECT not calculated constant -# Running tests for DBD::File -ok 656 - prepare CREATE TEMP TABLE biz (sales INTEGER, class CHAR, color CHAR, BUGNULL CHAR) on DBD::File -ok 657 - execute CREATE TEMP TABLE biz (sales INTEGER, class CHAR, color CHAR, BUGNULL CHAR) on DBD::File -ok 658 - prepare INSERT INTO biz VALUES (1000, 'Car', 'White', NULL) on DBD::File -ok 659 - execute INSERT INTO biz VALUES (1000, 'Car', 'White', NULL) on DBD::File -ok 660 - prepare INSERT INTO biz VALUES ( 500, 'Car', 'Blue', NULL ) on DBD::File -ok 661 - execute INSERT INTO biz VALUES ( 500, 'Car', 'Blue', NULL ) on DBD::File -ok 662 - prepare INSERT INTO biz VALUES ( 400, 'Truck', 'White', NULL ) on DBD::File -ok 663 - execute INSERT INTO biz VALUES ( 400, 'Truck', 'White', NULL ) on DBD::File -ok 664 - prepare INSERT INTO biz VALUES ( 700, 'Car', 'Red', NULL ) on DBD::File -ok 665 - execute INSERT INTO biz VALUES ( 700, 'Car', 'Red', NULL ) on DBD::File -ok 666 - prepare INSERT INTO biz VALUES ( 300, 'Truck', 'White', NULL ) on DBD::File -ok 667 - execute INSERT INTO biz VALUES ( 300, 'Truck', 'White', NULL ) on DBD::File -ok 668 - prepare CREATE TEMP TABLE baz (ordered INTEGER, class CHAR, color CHAR) on DBD::File -ok 669 - execute CREATE TEMP TABLE baz (ordered INTEGER, class CHAR, color CHAR) on DBD::File -ok 670 - prepare INSERT INTO baz VALUES ( 250, 'Car', 'White' ), ( 100, 'Car', 'Blue' ), ( 150, 'Car', 'Red' ) on DBD::File -ok 671 - execute INSERT INTO baz VALUES ( 250, 'Car', 'White' ), ( 100, 'Car', 'Blue' ), ( 150, 'Car', 'Red' ) on DBD::File -ok 672 - prepare INSERT INTO baz VALUES ( 80, 'Truck', 'White' ), ( 60, 'Truck', 'Green' ) -- Yes, we introduce new cars :) on DBD::File -ok 673 - execute INSERT INTO baz VALUES ( 80, 'Truck', 'White' ), ( 60, 'Truck', 'Green' ) -- Yes, we introduce new cars :) on DBD::File -ok 674 - prepare INSERT INTO baz VALUES ( 666, 'Truck', 'Yellow -- no, blue' ) -- Double dash inside quotes does not introduce comment on DBD::File -ok 675 - execute INSERT INTO baz VALUES ( 666, 'Truck', 'Yellow -- no, blue' ) -- Double dash inside quotes does not introduce comment on DBD::File -ok 676 - prepare CREATE TEMP TABLE numbers (c_foo INTEGER, foo CHAR, bar INTEGER) on DBD::File -ok 677 - execute CREATE TEMP TABLE numbers (c_foo INTEGER, foo CHAR, bar INTEGER) on DBD::File -ok 678 - prepare CREATE TEMP TABLE trick (id INTEGER, foo CHAR) on DBD::File -ok 679 - execute CREATE TEMP TABLE trick (id INTEGER, foo CHAR) on DBD::File -ok 680 - prepare INSERT INTO trick VALUES (1, '1foo') on DBD::File -ok 681 - execute INSERT INTO trick VALUES (1, '1foo') on DBD::File -ok 682 - prepare INSERT INTO trick VALUES (11, 'foo') on DBD::File -ok 683 - execute INSERT INTO trick VALUES (11, 'foo') on DBD::File -ok 684 - prepare CREATE TYPE TIMESTAMP on DBD::File -ok 685 - execute CREATE TYPE TIMESTAMP on DBD::File -ok 686 - prepare CREATE TEMP TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP) on DBD::File -ok 687 - execute CREATE TEMP TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP) on DBD::File -ok 688 - prepare INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1637259016) on DBD::File -ok 689 - execute INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1637259016) on DBD::File -ok 690 - prepare INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1637259016) on DBD::File -ok 691 - execute INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1637259016) on DBD::File -ok 692 - prepare INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1637259016) on DBD::File -ok 693 - execute INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1637259016) on DBD::File -ok 694 - prepare INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1637259016) on DBD::File -ok 695 - execute INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1637259016) on DBD::File -ok 696 - prepare INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1637259016) on DBD::File -ok 697 - execute INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1637259016) on DBD::File -ok 698 - prepare INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1637259016) on DBD::File -ok 699 - execute INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1637259016) on DBD::File -ok 700 - prepare INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1637259016) on DBD::File -ok 701 - execute INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.39 (BERT) \#0: Fri Oct 8 06:23:03 CEST 2010', 1637259016) on DBD::File -ok 702 - prepare INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1637255416) on DBD::File -ok 703 - execute INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1637255416) on DBD::File -ok 704 - prepare INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1637251816) on DBD::File -ok 705 - execute INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1637251816) on DBD::File -ok 706 - prepare INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1637248216) on DBD::File -ok 707 - execute INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1637248216) on DBD::File -ok 708 - prepare INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1637244616) on DBD::File -ok 709 - execute INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1637244616) on DBD::File -ok 710 - prepare INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1637241016) on DBD::File -ok 711 - execute INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1637241016) on DBD::File -ok 712 - prepare INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1637237416) on DBD::File -ok 713 - execute INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1637237416) on DBD::File -ok 714 - prepare INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1637233816) on DBD::File -ok 715 - execute INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1637233816) on DBD::File -ok 716 - prepare INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1637230216) on DBD::File -ok 717 - execute INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1637230216) on DBD::File -ok 718 - prepare INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1637226616) on DBD::File -ok 719 - execute INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1637226616) on DBD::File -ok 720 - prepare INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1637223016) on DBD::File -ok 721 - execute INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1637223016) on DBD::File -ok 722 - prepare SELECT class,SUM(sales) as foo, MAX(sales) FROM biz GROUP BY class using DBD::File -ok 723 - execute SELECT class,SUM(sales) as foo, MAX(sales) FROM biz GROUP BY class using DBD::File -ok 724 - GROUP BY one column -ok 725 - prepare SELECT color,class,SUM(sales), MAX(sales) FROM biz GROUP BY color,class using DBD::File -ok 726 - execute SELECT color,class,SUM(sales), MAX(sales) FROM biz GROUP BY color,class using DBD::File -ok 727 - GROUP BY several columns -ok 728 - prepare SELECT SUM(sales), MAX(sales) FROM biz using DBD::File -ok 729 - execute SELECT SUM(sales), MAX(sales) FROM biz using DBD::File -ok 730 - AGGREGATE FUNCTIONS WITHOUT GROUP BY -ok 731 - prepare SELECT COUNT(DISTINCT class) FROM biz using DBD::File -ok 732 - execute SELECT COUNT(DISTINCT class) FROM biz using DBD::File -ok 733 - COUNT(distinct column) WITHOUT GROUP BY -ok 734 - prepare SELECT distinct class, COUNT(distinct color) FROM biz GROUP BY class using DBD::File -ok 735 - execute SELECT distinct class, COUNT(distinct color) FROM biz GROUP BY class using DBD::File -ok 736 - COUNT(distinct column) WITH GROUP BY -ok 737 - prepare SELECT class, COUNT(*) FROM biz GROUP BY class using DBD::File -ok 738 - execute SELECT class, COUNT(*) FROM biz GROUP BY class using DBD::File -ok 739 - COUNT(*) with GROUP BY -ok 740 - prepare SELECT DISTINCT biz.class, baz.color AS foo FROM biz, baz WHERE biz.class = baz.class ORDER BY foo using DBD::File -ok 741 - execute SELECT DISTINCT biz.class, baz.color AS foo FROM biz, baz WHERE biz.class = baz.class ORDER BY foo using DBD::File -ok 742 - ORDER BY on aliased column -ok 743 - prepare SELECT class, COUNT(distinct *) FROM biz GROUP BY class using DBD::File fails -ok 744 - COUNT(DISTINCT *) fails -ok 745 - prepare SELECT class, COUNT(color) FROM biz using DBD::File -ok 746 - execute SELECT class, COUNT(color) FROM biz using DBD::File fails -ok 747 - GROUP BY required -ok 748 - prepare SELECT SUM(bar) FROM numbers using DBD::File -ok 749 - execute SELECT SUM(bar) FROM numbers using DBD::File -ok 750 - SUM(bar) of empty table -ok 751 - prepare SELECT COUNT(bar),c_foo FROM numbers GROUP BY c_foo using DBD::File -ok 752 - execute SELECT COUNT(bar),c_foo FROM numbers GROUP BY c_foo using DBD::File -ok 753 - COUNT(bar) of empty table with GROUP BY -ok 754 - prepare SELECT COUNT(*) FROM numbers using DBD::File -ok 755 - execute SELECT COUNT(*) FROM numbers using DBD::File -ok 756 - COUNT(*) of empty table -ok 757 - prepare INSERT INTO numbers VALUES (?, ?, ?) using DBD::File -ok 758 - 1 .. 3999: execute INSERT INTO numbers VALUES (?, ?, ?) using DBD::File -ok 759 - prepare SELECT foo AS boo, COUNT (*) AS counted FROM numbers GROUP BY boo using DBD::File -ok 760 - execute SELECT foo AS boo, COUNT (*) AS counted FROM numbers GROUP BY boo using DBD::File -ok 761 - Columns in Number of rows in aggregated Table -ok 762 - Number of rows in aggregated Table -ok 763 - SUM(COUNTED) -ok 764 - prepare SELECT MIN(c_foo), MAX(c_foo), AVG(c_foo) FROM numbers using DBD::File -ok 765 - execute SELECT MIN(c_foo), MAX(c_foo), AVG(c_foo) FROM numbers using DBD::File -ok 766 - Aggregate functions MIN, MAX, AVG -ok 767 - prepare SELECT COUNT(*) FROM trick using DBD::File -ok 768 - execute SELECT COUNT(*) FROM trick using DBD::File -ok 769 - COUNT(*) internal for nasty table -ok 770 - prepare SELECT CURRENT_DATE() using DBD::File -ok 771 - execute SELECT CURRENT_DATE() using DBD::File -ok 772 - current_date int -ok 773 - prepare SELECT CURRENT_TIME using DBD::File -ok 774 - execute SELECT CURRENT_TIME using DBD::File -ok 775 - current_time int -ok 776 - prepare SELECT CURRENT_TIMESTAMP() using DBD::File -ok 777 - execute SELECT CURRENT_TIMESTAMP() using DBD::File -ok 778 - current_timestamp int -ok 779 - prepare SELECT CURDATE using DBD::File -ok 780 - execute SELECT CURDATE using DBD::File -ok 781 - curdate int -ok 782 - prepare SELECT CURTIME() using DBD::File -ok 783 - execute SELECT CURTIME() using DBD::File -ok 784 - curtime int -ok 785 - prepare SELECT NOW using DBD::File -ok 786 - execute SELECT NOW using DBD::File -ok 787 - now int -ok 788 - prepare SELECT UNIX_TIMESTAMP() using DBD::File -ok 789 - execute SELECT UNIX_TIMESTAMP() using DBD::File -ok 790 - unix_timestamp int -ok 791 - prepare SELECT CURRENT_TIME (1) using DBD::File -ok 792 - execute SELECT CURRENT_TIME (1) using DBD::File -ok 793 - current_time precision -ok 794 - prepare SELECT CURRENT_TIMESTAMP (2) using DBD::File -ok 795 - execute SELECT CURRENT_TIMESTAMP (2) using DBD::File -ok 796 - current_timestamp precision -ok 797 - prepare SELECT CURTIME (3) using DBD::File -ok 798 - execute SELECT CURTIME (3) using DBD::File -ok 799 - curtime precision -ok 800 - prepare SELECT NOW(4) using DBD::File -ok 801 - execute SELECT NOW(4) using DBD::File -ok 802 - now precision -ok 803 - prepare SELECT UNIX_TIMESTAMP(5) using DBD::File -ok 804 - execute SELECT UNIX_TIMESTAMP(5) using DBD::File -ok 805 - unix_timestamp precision -ok 806 - prepare SELECT ASCII('A') using DBD::File -ok 807 - execute SELECT ASCII('A') using DBD::File -ok 808 - ascii char -ok 809 - prepare SELECT ASCII('ABC') using DBD::File -ok 810 - execute SELECT ASCII('ABC') using DBD::File -ok 811 - ascii str -ok 812 - prepare SELECT CHAR() using DBD::File -ok 813 - execute SELECT CHAR() using DBD::File -ok 814 - char blank -ok 815 - prepare SELECT CHAR(65) using DBD::File -ok 816 - execute SELECT CHAR(65) using DBD::File -ok 817 - char char -ok 818 - prepare SELECT CHAR(CONV('263A', 16)) using DBD::File -ok 819 - execute SELECT CHAR(CONV('263A', 16)) using DBD::File -ok 820 - char char unicode -ok 821 - prepare SELECT CHAR(CONV('263A', 16), 9787, CONV('10011000111100', 2)) using DBD::File -ok 822 - execute SELECT CHAR(CONV('263A', 16), 9787, CONV('10011000111100', 2)) using DBD::File -ok 823 - char str unicode -ok 824 - prepare SELECT CHAR(65,66,67) using DBD::File -ok 825 - execute SELECT CHAR(65,66,67) using DBD::File -ok 826 - char str -ok 827 - prepare SELECT BIT_LENGTH(' oo') using DBD::File -ok 828 - execute SELECT BIT_LENGTH(' oo') using DBD::File -ok 829 - bit_length 6bit -ok 830 - prepare SELECT BIT_LENGTH('foo') using DBD::File -ok 831 - execute SELECT BIT_LENGTH('foo') using DBD::File -ok 832 - bit_length 7bit -ok 833 - prepare SELECT BIT_LENGTH(CHAR(9786, 9787, 9788)) using DBD::File -ok 834 - execute SELECT BIT_LENGTH(CHAR(9786, 9787, 9788)) using DBD::File -ok 835 - bit_length unicode -ok 836 - prepare SELECT CHARACTER_LENGTH('foo') using DBD::File -ok 837 - execute SELECT CHARACTER_LENGTH('foo') using DBD::File -ok 838 - character_length -ok 839 - prepare SELECT CHAR_LENGTH('foo') using DBD::File -ok 840 - execute SELECT CHAR_LENGTH('foo') using DBD::File -ok 841 - char_length -ok 842 - prepare SELECT CHARACTER_LENGTH(CHAR(9786, 9787, 9788)) using DBD::File -ok 843 - execute SELECT CHARACTER_LENGTH(CHAR(9786, 9787, 9788)) using DBD::File -ok 844 - character_length unicode -ok 845 - prepare SELECT CHAR_LENGTH(CHAR(9786, 9787, 9788)) using DBD::File -ok 846 - execute SELECT CHAR_LENGTH(CHAR(9786, 9787, 9788)) using DBD::File -ok 847 - char_length unicode -ok 848 - prepare SELECT COALESCE(NULL,'z') using DBD::File -ok 849 - execute SELECT COALESCE(NULL,'z') using DBD::File -ok 850 - coalesce -ok 851 - prepare SELECT NVL(NULL,'z') using DBD::File -ok 852 - execute SELECT NVL(NULL,'z') using DBD::File -ok 853 - nvl -ok 854 - prepare SELECT IFNULL(NULL,'z') using DBD::File -ok 855 - execute SELECT IFNULL(NULL,'z') using DBD::File -ok 856 - ifnull -ok 857 - prepare SELECT CONCAT('A','B') using DBD::File -ok 858 - execute SELECT CONCAT('A','B') using DBD::File -ok 859 - concat good -ok 860 - prepare SELECT CONCAT('A',NULL) using DBD::File -ok 861 - execute SELECT CONCAT('A',NULL) using DBD::File -ok 862 - concat bad -ok 863 - prepare SELECT CONV('10101001111011101101011', 2, 64) using DBD::File -ok 864 - execute SELECT CONV('10101001111011101101011', 2, 64) using DBD::File -ok 865 - conv 2->64 -ok 866 - prepare SELECT CONV('10101001111011101101011', 2, 16) using DBD::File -ok 867 - execute SELECT CONV('10101001111011101101011', 2, 16) using DBD::File -ok 868 - conv 2->16 -ok 869 - prepare SELECT CONV('10101001111011101101011', 2, 10) using DBD::File -ok 870 - execute SELECT CONV('10101001111011101101011', 2, 10) using DBD::File -ok 871 - conv 2->10 -ok 872 - prepare SELECT CONV('10101001111011101101011', 2, 8) using DBD::File -ok 873 - execute SELECT CONV('10101001111011101101011', 2, 8) using DBD::File -ok 874 - conv 2->8 -ok 875 - prepare SELECT CONV('10101001111011101101011', 2, 2) using DBD::File -ok 876 - execute SELECT CONV('10101001111011101101011', 2, 2) using DBD::File -ok 877 - conv 2->2 -ok 878 - prepare select conv('16', 10, 16) using DBD::File -ok 879 - execute select conv('16', 10, 16) using DBD::File -ok 880 - conv 10->16 integer with trailing 0 -ok 881 - prepare select conv('0', 10, 16) using DBD::File -ok 882 - execute select conv('0', 10, 16) using DBD::File -ok 883 - conv 10->16 integer 0 -ok 884 - prepare SELECT DISTINCT DECODE(color,'White','W','Red','R','B') AS cfc FROM biz ORDER BY cfc using DBD::File -ok 885 - execute SELECT DISTINCT DECODE(color,'White','W','Red','R','B') AS cfc FROM biz ORDER BY cfc using DBD::File -ok 886 - decode -ok 887 - prepare SELECT INSERT('foodieland', 4, 3, 'bar') using DBD::File -ok 888 - execute SELECT INSERT('foodieland', 4, 3, 'bar') using DBD::File -ok 889 - insert good 1:1 -ok 890 - prepare SELECT INSERT('foodland', 4, 1, 'bar') using DBD::File -ok 891 - execute SELECT INSERT('foodland', 4, 1, 'bar') using DBD::File -ok 892 - insert good non-1:1 -ok 893 - prepare SELECT INSERT(NULL, 4, 1, 'bar') using DBD::File -ok 894 - execute SELECT INSERT(NULL, 4, 1, 'bar') using DBD::File -ok 895 - insert bad 1 -ok 896 - prepare SELECT INSERT('foodland', 4, 1, NULL) using DBD::File -ok 897 - execute SELECT INSERT('foodland', 4, 1, NULL) using DBD::File -ok 898 - insert bad 2 -ok 899 - prepare SELECT LEFT('foodland', 4) using DBD::File -ok 900 - execute SELECT LEFT('foodland', 4) using DBD::File -ok 901 - left good -ok 902 - prepare SELECT LEFT(NULL, 4) using DBD::File -ok 903 - execute SELECT LEFT(NULL, 4) using DBD::File -ok 904 - left bad 1 -ok 905 - prepare SELECT LEFT('foodland', NULL) using DBD::File -ok 906 - execute SELECT LEFT('foodland', NULL) using DBD::File -ok 907 - left bad 2 -ok 908 - prepare SELECT RIGHT('foodland', 4) using DBD::File -ok 909 - execute SELECT RIGHT('foodland', 4) using DBD::File -ok 910 - right good -ok 911 - prepare SELECT RIGHT(NULL, 4) using DBD::File -ok 912 - execute SELECT RIGHT(NULL, 4) using DBD::File -ok 913 - right bad 1 -ok 914 - prepare SELECT RIGHT('foodland', NULL) using DBD::File -ok 915 - execute SELECT RIGHT('foodland', NULL) using DBD::File -ok 916 - right bad 2 -ok 917 - prepare SELECT LOCATE('a','bar') using DBD::File -ok 918 - execute SELECT LOCATE('a','bar') using DBD::File -ok 919 - locate 2param -ok 920 - prepare SELECT LOCATE('a','barafa',3) using DBD::File -ok 921 - execute SELECT LOCATE('a','barafa',3) using DBD::File -ok 922 - locate 3param -ok 923 - prepare SELECT POSITION('a','bar') using DBD::File -ok 924 - execute SELECT POSITION('a','bar') using DBD::File -ok 925 - position 2param -ok 926 - prepare SELECT POSITION('a','barafa',3) using DBD::File -ok 927 - execute SELECT POSITION('a','barafa',3) using DBD::File -ok 928 - position 3param -ok 929 - prepare SELECT LOWER('A') using DBD::File -ok 930 - execute SELECT LOWER('A') using DBD::File -ok 931 - lower -ok 932 - prepare SELECT UPPER('a') using DBD::File -ok 933 - execute SELECT UPPER('a') using DBD::File -ok 934 - upper -ok 935 - prepare SELECT LCASE('A') using DBD::File -ok 936 - execute SELECT LCASE('A') using DBD::File -ok 937 - lcase -ok 938 - prepare SELECT UCASE('a') using DBD::File -ok 939 - execute SELECT UCASE('a') using DBD::File -ok 940 - ucase -ok 941 - prepare SELECT LTRIM(' fun ') using DBD::File -ok 942 - execute SELECT LTRIM(' fun ') using DBD::File -ok 943 - ltrim -ok 944 - prepare SELECT RTRIM(' fun ') using DBD::File -ok 945 - execute SELECT RTRIM(' fun ') using DBD::File -ok 946 - rtrim -ok 947 - prepare SELECT OCTET_LENGTH('foo') using DBD::File -ok 948 - execute SELECT OCTET_LENGTH('foo') using DBD::File -ok 949 - octet_length -ok 950 - prepare SELECT OCTET_LENGTH(CHAR(64, 169, 9786, 65572)) using DBD::File -ok 951 - execute SELECT OCTET_LENGTH(CHAR(64, 169, 9786, 65572)) using DBD::File -ok 952 - octet_length unicode -ok 953 - prepare SELECT REGEX('jeff','/EF/i') using DBD::File -ok 954 - execute SELECT REGEX('jeff','/EF/i') using DBD::File -ok 955 - regex match -ok 956 - prepare SELECT REGEX('jeff','/zzz/') using DBD::File -ok 957 - execute SELECT REGEX('jeff','/zzz/') using DBD::File -ok 958 - regex no match -ok 959 - prepare SELECT REPEAT('zfunkY', 3) using DBD::File -ok 960 - execute SELECT REPEAT('zfunkY', 3) using DBD::File -ok 961 - repeat -ok 962 - prepare SELECT REPLACE('zfunkY','s/z(.+)ky/$1/i') using DBD::File -ok 963 - execute SELECT REPLACE('zfunkY','s/z(.+)ky/$1/i') using DBD::File -ok 964 - replace -ok 965 - prepare SELECT SUBSTITUTE('zfunkY','s/z(.+)ky/$1/i') using DBD::File -ok 966 - execute SELECT SUBSTITUTE('zfunkY','s/z(.+)ky/$1/i') using DBD::File -ok 967 - substitute -ok 968 - prepare SELECT SOUNDEX('jeff','jeph') using DBD::File -ok 969 - execute SELECT SOUNDEX('jeff','jeph') using DBD::File -ok 970 - soundex match -ok 971 - prepare SELECT SOUNDEX('jeff','quartz') using DBD::File -ok 972 - execute SELECT SOUNDEX('jeff','quartz') using DBD::File -ok 973 - soundex no match -ok 974 - prepare SELECT SPACE(10) using DBD::File -ok 975 - execute SELECT SPACE(10) using DBD::File -ok 976 - space -ok 977 - prepare SELECT SUBSTR('zfunkY',2,3) using DBD::File -ok 978 - execute SELECT SUBSTR('zfunkY',2,3) using DBD::File -ok 979 - substr -ok 980 - prepare SELECT DISTINCT color FROM biz WHERE SUBSTRING(class FROM 1 FOR 1)='T' using DBD::File -ok 981 - execute SELECT DISTINCT color FROM biz WHERE SUBSTRING(class FROM 1 FOR 1)='T' using DBD::File -ok 982 - substring -ok 983 - prepare SELECT TRANSLATE('foobar forever', 'oae', '0@3') using DBD::File -ok 984 - execute SELECT TRANSLATE('foobar forever', 'oae', '0@3') using DBD::File -ok 985 - translate -ok 986 - prepare SELECT TRIM(' fun ') using DBD::File -ok 987 - execute SELECT TRIM(' fun ') using DBD::File -ok 988 - trim simple -not ok 989 - prepare SELECT TRIM(LEADING FROM ' fun ') using DBD::File # TODO Analyze why this fails; may be thinking FROM keyword is for table specs -# Failed (TODO) test 'prepare SELECT TRIM(LEADING FROM ' fun ') using DBD::File' -# at t/06virtual.t line 1419. -# Unbalanced parentheses! -not ok 990 - prepare SELECT TRIM(TRAILING FROM ' fun ') using DBD::File # TODO Analyze why this fails; may be thinking FROM keyword is for table specs -# Failed (TODO) test 'prepare SELECT TRIM(TRAILING FROM ' fun ') using DBD::File' -# at t/06virtual.t line 1419. -# Unbalanced parentheses! -not ok 991 - prepare SELECT TRIM(LEADING ';' FROM ';;; fun ') using DBD::File # TODO Analyze why this fails; may be thinking FROM keyword is for table specs -# Failed (TODO) test 'prepare SELECT TRIM(LEADING ';' FROM ';;; fun ') using DBD::File' -# at t/06virtual.t line 1419. -# Unbalanced parentheses! -ok 992 - prepare SELECT UNHEX('414243') using DBD::File -ok 993 - execute SELECT UNHEX('414243') using DBD::File -ok 994 - unhex str -ok 995 - prepare SELECT UNHEX('263A' || HEX(9787) || CONV('10011000111100', 2, 16), 'UCS-2') using DBD::File -ok 996 - execute SELECT UNHEX('263A' || HEX(9787) || CONV('10011000111100', 2, 16), 'UCS-2') using DBD::File -ok 997 - unhex str unicode -ok 998 - prepare SELECT BIN('9788') using DBD::File -ok 999 - execute SELECT BIN('9788') using DBD::File -ok 1000 - bin from dec -ok 1001 - prepare SELECT OCT('420') using DBD::File -ok 1002 - execute SELECT OCT('420') using DBD::File -ok 1003 - oct from dec -ok 1004 - prepare SELECT ABS(-4) using DBD::File -ok 1005 - execute SELECT ABS(-4) using DBD::File -ok 1006 - abs -ok 1007 - prepare SELECT CEILING(5) using DBD::File -ok 1008 - execute SELECT CEILING(5) using DBD::File -ok 1009 - ceiling int -ok 1010 - prepare SELECT CEILING(4.1) using DBD::File -ok 1011 - execute SELECT CEILING(4.1) using DBD::File -ok 1012 - ceiling positive -ok 1013 - prepare SELECT CEIL(-4.5) using DBD::File -ok 1014 - execute SELECT CEIL(-4.5) using DBD::File -ok 1015 - ceil negative -ok 1016 - prepare SELECT FLOOR(-5) using DBD::File -ok 1017 - execute SELECT FLOOR(-5) using DBD::File -ok 1018 - floor int -ok 1019 - prepare SELECT FLOOR(4.999999999999) using DBD::File -ok 1020 - execute SELECT FLOOR(4.999999999999) using DBD::File -ok 1021 - floor positive -ok 1022 - prepare SELECT FLOOR(-4.1) using DBD::File -ok 1023 - execute SELECT FLOOR(-4.1) using DBD::File -ok 1024 - floor negative -ok 1025 - prepare SELECT EXP(1) using DBD::File -ok 1026 - execute SELECT EXP(1) using DBD::File -ok 1027 - exp -ok 1028 - prepare SELECT LOG(6) using DBD::File -ok 1029 - execute SELECT LOG(6) using DBD::File -ok 1030 - log as log10 -ok 1031 - prepare SELECT LOG(2, 32) using DBD::File -ok 1032 - execute SELECT LOG(2, 32) using DBD::File -ok 1033 - log as log2 -ok 1034 - prepare SELECT LN(3) using DBD::File -ok 1035 - execute SELECT LN(3) using DBD::File -ok 1036 - ln -ok 1037 - prepare SELECT MOD(8, 5) using DBD::File -ok 1038 - execute SELECT MOD(8, 5) using DBD::File -ok 1039 - mod -ok 1040 - prepare SELECT POWER(2, 4) using DBD::File -ok 1041 - execute SELECT POWER(2, 4) using DBD::File -ok 1042 - power -ok 1043 - prepare SELECT POW(2, 4) using DBD::File -ok 1044 - execute SELECT POW(2, 4) using DBD::File -ok 1045 - pow -ok 1046 - prepare SELECT FLOOR(RAND(4)) using DBD::File -ok 1047 - execute SELECT FLOOR(RAND(4)) using DBD::File -ok 1048 - rand -ok 1049 - prepare SELECT FLOOR(RAND(4), UNIX_TIMESTAMP()) using DBD::File -ok 1050 - execute SELECT FLOOR(RAND(4), UNIX_TIMESTAMP()) using DBD::File -ok 1051 - rand with seed -ok 1052 - prepare SELECT ROUND(4.999999999999) using DBD::File -ok 1053 - execute SELECT ROUND(4.999999999999) using DBD::File -ok 1054 - round int -ok 1055 - prepare SELECT ROUND(4.542222222222, 1) using DBD::File -ok 1056 - execute SELECT ROUND(4.542222222222, 1) using DBD::File -ok 1057 - round tenth -ok 1058 - prepare SELECT SIGN(-25.5) using DBD::File -ok 1059 - execute SELECT SIGN(-25.5) using DBD::File -ok 1060 - sign -1 -ok 1061 - prepare SELECT SIGN(53645) using DBD::File -ok 1062 - execute SELECT SIGN(53645) using DBD::File -ok 1063 - sign 1 -ok 1064 - prepare SELECT SIGN(0) using DBD::File -ok 1065 - execute SELECT SIGN(0) using DBD::File -ok 1066 - sign 0 -ok 1067 - prepare SELECT SIGN(NULL) using DBD::File -ok 1068 - execute SELECT SIGN(NULL) using DBD::File -ok 1069 - sign null -ok 1070 - prepare SELECT SQRT(64) using DBD::File -ok 1071 - execute SELECT SQRT(64) using DBD::File -ok 1072 - sqrt -ok 1073 - prepare SELECT TRUNCATE(4.999999999999) using DBD::File -ok 1074 - execute SELECT TRUNCATE(4.999999999999) using DBD::File -ok 1075 - truncate int -ok 1076 - prepare SELECT TRUNC(-4.9) using DBD::File -ok 1077 - execute SELECT TRUNC(-4.9) using DBD::File -ok 1078 - trunc int -ok 1079 - prepare SELECT TRUNCATE(4.934, 1) using DBD::File -ok 1080 - execute SELECT TRUNCATE(4.934, 1) using DBD::File -ok 1081 - truncate tenth -ok 1082 - prepare SELECT TRUNC(-4.99999, 1) using DBD::File -ok 1083 - execute SELECT TRUNC(-4.99999, 1) using DBD::File -ok 1084 - trunc int -ok 1085 - prepare SELECT SIN(1) using DBD::File -ok 1086 - execute SELECT SIN(1) using DBD::File -ok 1087 - sin(1) => near? 0.841470984807897 ~= 0.841470984807897 -ok 1088 - prepare SELECT COS(1) using DBD::File -ok 1089 - execute SELECT COS(1) using DBD::File -ok 1090 - cos(1) => near? 0.54030230586814 ~= 0.54030230586814 -ok 1091 - prepare SELECT TAN(1) using DBD::File -ok 1092 - execute SELECT TAN(1) using DBD::File -ok 1093 - tan(1) => near? 1.5574077246549 ~= 1.5574077246549 -ok 1094 - prepare SELECT SEC(1) using DBD::File -ok 1095 - execute SELECT SEC(1) using DBD::File -ok 1096 - sec(1) => near? 1.85081571768093 ~= 1.85081571768093 -ok 1097 - prepare SELECT CSC(1) using DBD::File -ok 1098 - execute SELECT CSC(1) using DBD::File -ok 1099 - csc(1) => near? 1.18839510577812 ~= 1.18839510577812 -ok 1100 - prepare SELECT COSEC(1) using DBD::File -ok 1101 - execute SELECT COSEC(1) using DBD::File -ok 1102 - cosec(1) => near? 1.18839510577812 ~= 1.18839510577812 -ok 1103 - prepare SELECT COT(1) using DBD::File -ok 1104 - execute SELECT COT(1) using DBD::File -ok 1105 - cot(1) => near? 0.642092615934331 ~= 0.642092615934331 -ok 1106 - prepare SELECT COTAN(1) using DBD::File -ok 1107 - execute SELECT COTAN(1) using DBD::File -ok 1108 - cotan(1) => near? 0.642092615934331 ~= 0.642092615934331 -ok 1109 - prepare SELECT ASIN(1) using DBD::File -ok 1110 - execute SELECT ASIN(1) using DBD::File -ok 1111 - asin(1) => near? 1.5707963267949 ~= 1.5707963267949 -ok 1112 - prepare SELECT ACOS(1) using DBD::File -ok 1113 - execute SELECT ACOS(1) using DBD::File -ok 1114 - acos(1) => near? 0 ~= 0 -ok 1115 - prepare SELECT ATAN(1) using DBD::File -ok 1116 - execute SELECT ATAN(1) using DBD::File -ok 1117 - atan(1) => near? 0.785398163397448 ~= 0.785398163397448 -ok 1118 - prepare SELECT ASEC(1) using DBD::File -ok 1119 - execute SELECT ASEC(1) using DBD::File -ok 1120 - asec(1) => near? 0 ~= 0 -ok 1121 - prepare SELECT ACSC(1) using DBD::File -ok 1122 - execute SELECT ACSC(1) using DBD::File -ok 1123 - acsc(1) => near? 1.5707963267949 ~= 1.5707963267949 -ok 1124 - prepare SELECT ACOSEC(1) using DBD::File -ok 1125 - execute SELECT ACOSEC(1) using DBD::File -ok 1126 - acosec(1) => near? 1.5707963267949 ~= 1.5707963267949 -ok 1127 - prepare SELECT ACOT(1) using DBD::File -ok 1128 - execute SELECT ACOT(1) using DBD::File -ok 1129 - acot(1) => near? 0.785398163397448 ~= 0.785398163397448 -ok 1130 - prepare SELECT ACOTAN(1) using DBD::File -ok 1131 - execute SELECT ACOTAN(1) using DBD::File -ok 1132 - acotan(1) => near? 0.785398163397448 ~= 0.785398163397448 -ok 1133 - prepare SELECT SINH(1) using DBD::File -ok 1134 - execute SELECT SINH(1) using DBD::File -ok 1135 - sinh(1) => near? 1.1752011936438 ~= 1.1752011936438 -ok 1136 - prepare SELECT COSH(1) using DBD::File -ok 1137 - execute SELECT COSH(1) using DBD::File -ok 1138 - cosh(1) => near? 1.54308063481524 ~= 1.54308063481524 -ok 1139 - prepare SELECT TANH(1) using DBD::File -ok 1140 - execute SELECT TANH(1) using DBD::File -ok 1141 - tanh(1) => near? 0.761594155955765 ~= 0.761594155955765 -ok 1142 - prepare SELECT SECH(1) using DBD::File -ok 1143 - execute SELECT SECH(1) using DBD::File -ok 1144 - sech(1) => near? 0.648054273663885 ~= 0.648054273663885 -ok 1145 - prepare SELECT CSCH(1) using DBD::File -ok 1146 - execute SELECT CSCH(1) using DBD::File -ok 1147 - csch(1) => near? 0.850918128239322 ~= 0.850918128239322 -ok 1148 - prepare SELECT COSECH(1) using DBD::File -ok 1149 - execute SELECT COSECH(1) using DBD::File -ok 1150 - cosech(1) => near? 0.850918128239322 ~= 0.850918128239322 -ok 1151 - prepare SELECT COTH(1) using DBD::File -ok 1152 - execute SELECT COTH(1) using DBD::File -ok 1153 - coth(1) => near? 1.31303528549933 ~= 1.31303528549933 -ok 1154 - prepare SELECT COTANH(1) using DBD::File -ok 1155 - execute SELECT COTANH(1) using DBD::File -ok 1156 - cotanh(1) => near? 1.31303528549933 ~= 1.31303528549933 -ok 1157 - prepare SELECT ASINH(1) using DBD::File -ok 1158 - execute SELECT ASINH(1) using DBD::File -ok 1159 - asinh(1) => near? 0.881373587019543 ~= 0.881373587019543 -ok 1160 - prepare SELECT ACOSH(1) using DBD::File -ok 1161 - execute SELECT ACOSH(1) using DBD::File -ok 1162 - acosh(1) => near? 0 ~= 0 -ok 1163 - prepare SELECT ATANH(0.9) using DBD::File -ok 1164 - execute SELECT ATANH(0.9) using DBD::File -ok 1165 - atanh(0.9) => near? 1.47221948958322 ~= 1.47221948958322 -ok 1166 - prepare SELECT ASECH(0.9) using DBD::File -ok 1167 - execute SELECT ASECH(0.9) using DBD::File -ok 1168 - asech(0.9) => near? 0.467145308103262 ~= 0.467145308103262 -ok 1169 - prepare SELECT ACSCH(2) using DBD::File -ok 1170 - execute SELECT ACSCH(2) using DBD::File -ok 1171 - acsch(2) => near? 0.481211825059603 ~= 0.481211825059603 -ok 1172 - prepare SELECT ACOSECH(2) using DBD::File -ok 1173 - execute SELECT ACOSECH(2) using DBD::File -ok 1174 - acosech(2) => near? 0.481211825059603 ~= 0.481211825059603 -ok 1175 - prepare SELECT ACOTH(2) using DBD::File -ok 1176 - execute SELECT ACOTH(2) using DBD::File -ok 1177 - acoth(2) => near? 0.549306144334055 ~= 0.549306144334055 -ok 1178 - prepare SELECT ACOTANH(2) using DBD::File -ok 1179 - execute SELECT ACOTANH(2) using DBD::File -ok 1180 - acotanh(2) => near? 0.549306144334055 ~= 0.549306144334055 -ok 1181 - prepare SELECT PI using DBD::File -ok 1182 - execute SELECT PI using DBD::File -ok 1183 - pi => near? 3.14159265358979 ~= 3.14159265358979 -ok 1184 - prepare SELECT ATAN2(1, 0) using DBD::File -ok 1185 - execute SELECT ATAN2(1, 0) using DBD::File -ok 1186 - atan2(1, 0) => near? 1.5707963267949 ~= 1.5707963267949 -ok 1187 - prepare SELECT ATAN2(1, 1) using DBD::File -ok 1188 - execute SELECT ATAN2(1, 1) using DBD::File -ok 1189 - atan2(1, 1) => near? 0.785398163397448 ~= 0.785398163397448 -ok 1190 - prepare SELECT ATAN2(-1, -1) using DBD::File -ok 1191 - execute SELECT ATAN2(-1, -1) using DBD::File -ok 1192 - atan2(-1, -1) to -3pi/4 => near? -2.35619449019234 ~= -2.35619449019234 -ok 1193 - prepare SELECT TAN(0.9) using DBD::File -ok 1194 - execute SELECT TAN(0.9) using DBD::File -ok 1195 - tan(0.9) as property sin/cos => near? 1.26015821755034 ~= 1.26015821755034 -ok 1196 - prepare SELECT SINH(2) using DBD::File -ok 1197 - execute SELECT SINH(2) using DBD::File -ok 1198 - sinh(2) => near? 3.62686040784702 ~= 3.62686040784702 -ok 1199 - prepare SELECT ACSCH(0.1) using DBD::File -ok 1200 - execute SELECT ACSCH(0.1) using DBD::File -ok 1201 - acsch 0.1 => near? 2.99822295029797 ~= 2.99822295029797 -ok 1202 - prepare SELECT DEG2RAD(90) using DBD::File -ok 1203 - execute SELECT DEG2RAD(90) using DBD::File -ok 1204 - deg2rad(90) => near? 1.5707963267949 ~= 1.5707963267949 -ok 1205 - prepare SELECT RADIANS(90) using DBD::File -ok 1206 - execute SELECT RADIANS(90) using DBD::File -ok 1207 - radians(90) => near? 1.5707963267949 ~= 1.5707963267949 -ok 1208 - prepare SELECT RAD2DEG(PI) using DBD::File -ok 1209 - execute SELECT RAD2DEG(PI) using DBD::File -ok 1210 - rad2deg(PI) => near? 180 ~= 180 -ok 1211 - prepare SELECT DEGREES(PI()) using DBD::File -ok 1212 - execute SELECT DEGREES(PI()) using DBD::File -ok 1213 - degrees(PI) => near? 180 ~= 180 -ok 1214 - prepare SELECT DEG2GRAD(0.9) using DBD::File -ok 1215 - execute SELECT DEG2GRAD(0.9) using DBD::File -ok 1216 - deg2grad(0.9) => near? 1 ~= 1 -ok 1217 - prepare SELECT GRAD2DEG(50) using DBD::File -ok 1218 - execute SELECT GRAD2DEG(50) using DBD::File -ok 1219 - grad2deg(50) => near? 45 ~= 45 -ok 1220 - prepare SELECT RAD2GRAD(PI/2) using DBD::File # TODO Known limitation. Parser/Engine can not handle properly -ok 1221 - execute SELECT RAD2GRAD(PI/2) using DBD::File # TODO Known limitation. Parser/Engine can not handle properly -ok 1222 - rad2grad(pi/2) => near? 99.9999999999999 ~= 100 # TODO Known limitation. Parser/Engine can not handle properly -ok 1223 - prepare SELECT RAD2GRAD(PI) using DBD::File -ok 1224 - execute SELECT RAD2GRAD(PI) using DBD::File -ok 1225 - rad2grad(pi) => near? 200 ~= 200 -ok 1226 - prepare SELECT GRAD2RAD(200) using DBD::File -ok 1227 - execute SELECT GRAD2RAD(200) using DBD::File -ok 1228 - grad2rad(200) => near? 3.14159265358979 ~= 3.14159265358979 -ok 1229 - prepare SELECT DEG2RAD(10000000000) using DBD::File -ok 1230 - execute SELECT DEG2RAD(10000000000) using DBD::File -ok 1231 - lotta radians - deg2rad(10000000000) => near? 4.88692191243172 ~= 4.88692191243172 -ok 1232 - prepare SELECT RAD2DEG(-10000000000) using DBD::File -ok 1233 - execute SELECT RAD2DEG(-10000000000) using DBD::File -ok 1234 - negative degrees - rad2deg(-10000000000) => near? -330.8232421875 ~= -330.8232421875 -ok 1235 - prepare SELECT RAD2DEG(10000) using DBD::File -ok 1236 - execute SELECT RAD2DEG(10000) using DBD::File -ok 1237 - positive degrees - rad2deg(10000) => near? 197.795130823273 ~= 197.795130823273 -ok 1238 - prepare SELECT TANH(100) using DBD::File -ok 1239 - execute SELECT TANH(100) using DBD::File -ok 1240 - tanh 100 => near? 1 ~= 1 -ok 1241 - prepare SELECT COTH(100) using DBD::File -ok 1242 - execute SELECT COTH(100) using DBD::File -ok 1243 - coth 100 => near? 1 ~= 1 -ok 1244 - prepare SELECT TANH(-100) using DBD::File -ok 1245 - execute SELECT TANH(-100) using DBD::File -ok 1246 - tanh -100 => near? -1 ~= -1 -ok 1247 - prepare SELECT COTH(-100) using DBD::File -ok 1248 - execute SELECT COTH(-100) using DBD::File -ok 1249 - coth -100 => near? -1 ~= -1 -ok 1250 - prepare SELECT SECH(100000) using DBD::File -ok 1251 - execute SELECT SECH(100000) using DBD::File -ok 1252 - sech 1e5 => near? 0 ~= 0 -ok 1253 - prepare SELECT CSCH(100000) using DBD::File -ok 1254 - execute SELECT CSCH(100000) using DBD::File -ok 1255 - csch 1e5 => near? 0 ~= 0 -ok 1256 - prepare SELECT TANH(100000) using DBD::File -ok 1257 - execute SELECT TANH(100000) using DBD::File -ok 1258 - tanh 1e5 => near? 1 ~= 1 -ok 1259 - prepare SELECT COTH(100000) using DBD::File -ok 1260 - execute SELECT COTH(100000) using DBD::File -ok 1261 - coth 1e5 => near? 1 ~= 1 -ok 1262 - prepare SELECT SECH(-100000) using DBD::File -ok 1263 - execute SELECT SECH(-100000) using DBD::File -ok 1264 - sech -1e5 => near? 0 ~= 0 -ok 1265 - prepare SELECT CSCH(-100000) using DBD::File -ok 1266 - execute SELECT CSCH(-100000) using DBD::File -ok 1267 - csch -1e5 => near? 0 ~= 0 -ok 1268 - prepare SELECT TANH(-100000) using DBD::File -ok 1269 - execute SELECT TANH(-100000) using DBD::File -ok 1270 - tanh -1e5 => near? -1 ~= -1 -ok 1271 - prepare SELECT COTH(-100000) using DBD::File -ok 1272 - execute SELECT COTH(-100000) using DBD::File -ok 1273 - coth -1e5 => near? -1 ~= -1 -ok 1274 - prepare SELECT DBNAME() using DBD::File -ok 1275 - execute SELECT DBNAME() using DBD::File -ok 1276 - dbname -ok 1277 - prepare SELECT USERNAME() using DBD::File -ok 1278 - execute SELECT USERNAME() using DBD::File -ok 1279 - username -ok 1280 - prepare SELECT USER() using DBD::File -ok 1281 - execute SELECT USER() using DBD::File -ok 1282 - user -ok 1283 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp < (1637259016 - ( 4 * 60 )) using DBD::File -ok 1284 - execute SELECT id,host,signature,message FROM log WHERE time_stamp < (1637259016 - ( 4 * 60 )) using DBD::File -ok 1285 - SELECT with calculation in WHERE CLAUSE -ok 1286 - prepare SELECT id,host,signature,message FROM log WHERE (time_stamp > (1637259016 - 5)) AND (time_stamp < (1637259016 + 5)) using DBD::File -ok 1287 - execute SELECT id,host,signature,message FROM log WHERE (time_stamp > (1637259016 - 5)) AND (time_stamp < (1637259016 + 5)) using DBD::File -ok 1288 - SELECT with calculation and logical expression in WHERE CLAUSE -ok 1289 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1637259016 - 5, 1637259016 + 5) using DBD::File -ok 1290 - execute SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1637259016 - 5, 1637259016 + 5) using DBD::File -ok 1291 - SELECT with calculated items in BETWEEN in WHERE CLAUSE -ok 1292 - prepare SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1637259016 - (2*3600), 1637259016 - (4*3600)) using DBD::File -ok 1293 - execute SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1637259016 - (2*3600), 1637259016 - (4*3600)) using DBD::File -ok 1294 - MAX() with calculated WHERE clause -ok 1295 - prepare SELECT MAX(time_stamp - 3*3600) FROM log using DBD::File -ok 1296 - execute SELECT MAX(time_stamp - 3*3600) FROM log using DBD::File -ok 1297 - calculation in MAX() -ok 1298 - prepare SELECT MAX(time_stamp) - 3*3600 FROM log using DBD::File -not ok 1299 - execute SELECT MAX(time_stamp) - 3*3600 FROM log using DBD::File # TODO Known limitation. Parser/Engine can not handle properly -# Failed (TODO) test 'execute SELECT MAX(time_stamp) - 3*3600 FROM log using DBD::File' -# at t/06virtual.t line 1468. -# Can't find table containing column named 'max' at /build/libsql-statement-perl-1.414/blib/lib/SQL/Statement/Function.pm line 222. -not ok 1300 - Caclulation outside aggregation # TODO Known limitation. Parser/Engine can not handle properly -# Failed (TODO) test 'Caclulation outside aggregation' -# at t/06virtual.t line 1499. -# Structures begin differing at: -# $got->[0] = Does not exist -# $expected->[0] = ARRAY(0x5558f9f6f120) -ok 1301 - prepare SELECT MAX( CHAR_LENGTH(message) ) FROM log using DBD::File -ok 1302 - execute SELECT MAX( CHAR_LENGTH(message) ) FROM log using DBD::File -ok 1303 - function in MAX() -ok 1304 - prepare SELECT 1+0 from log using DBD::File -ok 1305 - execute SELECT 1+0 from log using DBD::File -ok 1306 - select simple calculated constant from table -ok 1307 - prepare SELECT 1+1*2 using DBD::File -ok 1308 - execute SELECT 1+1*2 using DBD::File -ok 1309 - select calculated constant with preceedence rules -ok 1310 - prepare SELECT 1 using DBD::File -ok 1311 - execute SELECT 1 using DBD::File -ok 1312 - SELECT not calculated constant # Running tests for DBD::DBM -ok 1313 # skip DBD::DBM test runs without MLDBM -1..1313 +ok 656 # skip DBD::DBM test runs without MLDBM +1..656 ok t/08join.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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-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: @@ -3757,7 +3117,7 @@ # at t/08join.t line 675. # Structures begin differing at: # $got->[2] = Does not exist -# $expected->[2] = ARRAY(0x55960e776900) +# $expected->[2] = ARRAY(0x5580a01f4050) ok 297 - prepare SELECT applname, appluniq, version, nodename # FROM APPL, PREC, NODE # WHERE appl_type LIKE '%DB' @@ -3877,9 +3237,443 @@ # ON p.pid = r.pid # using SQL::Statement fails ok 321 - Complex LEFT JOIN # TODO Not supported yet! +# Running tests for DBD::File +ok 322 - prepare CREATE TEMP TABLE Prof (pname CHAR, pid INT) on DBD::File +ok 323 - execute CREATE TEMP TABLE Prof (pname CHAR, pid INT) on DBD::File +ok 324 - prepare INSERT INTO Prof VALUES ('Sue', 1) on DBD::File +ok 325 - execute INSERT INTO Prof VALUES ('Sue', 1) on DBD::File +ok 326 - prepare INSERT INTO Prof VALUES ('Bob', 2) on DBD::File +ok 327 - execute INSERT INTO Prof VALUES ('Bob', 2) on DBD::File +ok 328 - prepare INSERT INTO Prof VALUES ('Tom', 3) on DBD::File +ok 329 - execute INSERT INTO Prof VALUES ('Tom', 3) on DBD::File +ok 330 - prepare CREATE TEMP TABLE Subject (sname CHAR, pid INT) on DBD::File +ok 331 - execute CREATE TEMP TABLE Subject (sname CHAR, pid INT) on DBD::File +ok 332 - prepare INSERT INTO Subject VALUES ('Chem', 1) on DBD::File +ok 333 - execute INSERT INTO Subject VALUES ('Chem', 1) on DBD::File +ok 334 - prepare INSERT INTO Subject VALUES ('Bio', 2) on DBD::File +ok 335 - execute INSERT INTO Subject VALUES ('Bio', 2) on DBD::File +ok 336 - prepare INSERT INTO Subject VALUES ('Math', 2) on DBD::File +ok 337 - execute INSERT INTO Subject VALUES ('Math', 2) on DBD::File +ok 338 - prepare INSERT INTO Subject VALUES ('English', 4) on DBD::File +ok 339 - execute INSERT INTO Subject VALUES ('English', 4) on DBD::File +ok 340 - prepare CREATE TEMP TABLE Room (rname CHAR, pid INT) on DBD::File +ok 341 - execute CREATE TEMP TABLE Room (rname CHAR, pid INT) on DBD::File +ok 342 - prepare INSERT INTO Room VALUES ('1C', 1) on DBD::File +ok 343 - execute INSERT INTO Room VALUES ('1C', 1) on DBD::File +ok 344 - prepare INSERT INTO Room VALUES ('2B', 2) on DBD::File +ok 345 - execute INSERT INTO Room VALUES ('2B', 2) on DBD::File +ok 346 - prepare CREATE TEMP TABLE author (author_name CHAR, author_id INT) on DBD::File +ok 347 - execute CREATE TEMP TABLE author (author_name CHAR, author_id INT) on DBD::File +ok 348 - prepare INSERT INTO author VALUES ('Neal Stephenson',1) on DBD::File +ok 349 - execute INSERT INTO author VALUES ('Neal Stephenson',1) on DBD::File +ok 350 - prepare INSERT INTO author VALUES ('Vernor Vinge',2) on DBD::File +ok 351 - execute INSERT INTO author VALUES ('Vernor Vinge',2) on DBD::File +ok 352 - prepare CREATE TEMP TABLE book (book_title CHAR, author_id INT) on DBD::File +ok 353 - execute CREATE TEMP TABLE book (book_title CHAR, author_id INT) on DBD::File +ok 354 - prepare INSERT INTO book VALUES ('Cryptonomicon',1) on DBD::File +ok 355 - execute INSERT INTO book VALUES ('Cryptonomicon',1) on DBD::File +ok 356 - prepare INSERT INTO book VALUES ('Dahlgren',3) on DBD::File +ok 357 - execute INSERT INTO book VALUES ('Dahlgren',3) on DBD::File +ok 358 - prepare CREATE TEMP TABLE t1 (num INT, name CHAR) on DBD::File +ok 359 - execute CREATE TEMP TABLE t1 (num INT, name CHAR) on DBD::File +ok 360 - prepare INSERT INTO t1 VALUES (1,'a') on DBD::File +ok 361 - execute INSERT INTO t1 VALUES (1,'a') on DBD::File +ok 362 - prepare INSERT INTO t1 VALUES (2,'b') on DBD::File +ok 363 - execute INSERT INTO t1 VALUES (2,'b') on DBD::File +ok 364 - prepare INSERT INTO t1 VALUES (3,'c') on DBD::File +ok 365 - execute INSERT INTO t1 VALUES (3,'c') on DBD::File +ok 366 - prepare CREATE TEMP TABLE t2 (num INT, wert CHAR) on DBD::File +ok 367 - execute CREATE TEMP TABLE t2 (num INT, wert CHAR) on DBD::File +ok 368 - prepare INSERT INTO t2 VALUES (1,'xxx') on DBD::File +ok 369 - execute INSERT INTO t2 VALUES (1,'xxx') on DBD::File +ok 370 - prepare INSERT INTO t2 VALUES (3,'yyy') on DBD::File +ok 371 - execute INSERT INTO t2 VALUES (3,'yyy') on DBD::File +ok 372 - prepare INSERT INTO t2 VALUES (5,'zzz') on DBD::File +ok 373 - execute INSERT INTO t2 VALUES (5,'zzz') on DBD::File +ok 374 - prepare CREATE TEMP TABLE APPL (id INT, applname CHAR, appluniq CHAR, version CHAR, appl_type CHAR) on DBD::File +ok 375 - execute CREATE TEMP TABLE APPL (id INT, applname CHAR, appluniq CHAR, version CHAR, appl_type CHAR) on DBD::File +ok 376 - prepare INSERT INTO APPL VALUES ( 1, 'ZQF', 'ZFQLIN', '10.2.0.4', 'Oracle DB') on DBD::File +ok 377 - execute INSERT INTO APPL VALUES ( 1, 'ZQF', 'ZFQLIN', '10.2.0.4', 'Oracle DB') on DBD::File +ok 378 - prepare INSERT INTO APPL VALUES ( 2, 'YRA', 'YRA-UX', '10.2.0.2', 'Oracle DB') on DBD::File +ok 379 - execute INSERT INTO APPL VALUES ( 2, 'YRA', 'YRA-UX', '10.2.0.2', 'Oracle DB') on DBD::File +ok 380 - prepare INSERT INTO APPL VALUES ( 3, 'PRN1', 'PRN1-4.B2', '1.1.22', 'CUPS' ) on DBD::File +ok 381 - execute INSERT INTO APPL VALUES ( 3, 'PRN1', 'PRN1-4.B2', '1.1.22', 'CUPS' ) on DBD::File +ok 382 - prepare INSERT INTO APPL VALUES ( 4, 'PRN2', 'PRN2-4.B2', '1.1.22', 'CUPS' ) on DBD::File +ok 383 - execute INSERT INTO APPL VALUES ( 4, 'PRN2', 'PRN2-4.B2', '1.1.22', 'CUPS' ) on DBD::File +ok 384 - prepare INSERT INTO APPL VALUES ( 5, 'PRN1', 'PRN1-4.B1', '1.1.22', 'CUPS' ) on DBD::File +ok 385 - execute INSERT INTO APPL VALUES ( 5, 'PRN1', 'PRN1-4.B1', '1.1.22', 'CUPS' ) on DBD::File +ok 386 - prepare INSERT INTO APPL VALUES ( 7, 'PRN2', 'PRN2-4.B1', '1.1.22', 'CUPS' ) on DBD::File +ok 387 - execute INSERT INTO APPL VALUES ( 7, 'PRN2', 'PRN2-4.B1', '1.1.22', 'CUPS' ) on DBD::File +ok 388 - prepare INSERT INTO APPL VALUES ( 8, 'sql-stmt', 'SQL::Statement', '1.21', 'Project Web-Site') on DBD::File +ok 389 - execute INSERT INTO APPL VALUES ( 8, 'sql-stmt', 'SQL::Statement', '1.21', 'Project Web-Site') on DBD::File +ok 390 - prepare INSERT INTO APPL VALUES ( 9, 'cpan.org', 'http://www.cpan.org/', '1.0', 'Web-Site') on DBD::File +ok 391 - execute INSERT INTO APPL VALUES ( 9, 'cpan.org', 'http://www.cpan.org/', '1.0', 'Web-Site') on DBD::File +ok 392 - prepare INSERT INTO APPL VALUES (10, 'httpd', 'cpan-apache', '2.2.13', 'Web-Server') on DBD::File +ok 393 - execute INSERT INTO APPL VALUES (10, 'httpd', 'cpan-apache', '2.2.13', 'Web-Server') on DBD::File +ok 394 - prepare INSERT INTO APPL VALUES (11, 'cpan-mods', 'cpan-mods', '8.4.1', 'PostgreSQL DB') on DBD::File +ok 395 - execute INSERT INTO APPL VALUES (11, 'cpan-mods', 'cpan-mods', '8.4.1', 'PostgreSQL DB') on DBD::File +ok 396 - prepare INSERT INTO APPL VALUES (12, 'cpan-authors', 'cpan-authors', '8.4.1', 'PostgreSQL DB') on DBD::File +ok 397 - execute INSERT INTO APPL VALUES (12, 'cpan-authors', 'cpan-authors', '8.4.1', 'PostgreSQL DB') on DBD::File +ok 398 - prepare CREATE TEMP TABLE NODE (id INT, nodename CHAR, os CHAR, version CHAR) on DBD::File +ok 399 - execute CREATE TEMP TABLE NODE (id INT, nodename CHAR, os CHAR, version CHAR) on DBD::File +ok 400 - prepare INSERT INTO NODE VALUES ( 1, 'ernie', 'RHEL', '5.2') on DBD::File +ok 401 - execute INSERT INTO NODE VALUES ( 1, 'ernie', 'RHEL', '5.2') on DBD::File +ok 402 - prepare INSERT INTO NODE VALUES ( 2, 'bert', 'RHEL', '5.2') on DBD::File +ok 403 - execute INSERT INTO NODE VALUES ( 2, 'bert', 'RHEL', '5.2') on DBD::File +ok 404 - prepare INSERT INTO NODE VALUES ( 3, 'statler', 'FreeBSD', '7.2') on DBD::File +ok 405 - execute INSERT INTO NODE VALUES ( 3, 'statler', 'FreeBSD', '7.2') on DBD::File +ok 406 - prepare INSERT INTO NODE VALUES ( 4, 'waldorf', 'FreeBSD', '7.2') on DBD::File +ok 407 - execute INSERT INTO NODE VALUES ( 4, 'waldorf', 'FreeBSD', '7.2') on DBD::File +ok 408 - prepare INSERT INTO NODE VALUES ( 5, 'piggy', 'NetBSD', '5.0.2') on DBD::File +ok 409 - execute INSERT INTO NODE VALUES ( 5, 'piggy', 'NetBSD', '5.0.2') on DBD::File +ok 410 - prepare INSERT INTO NODE VALUES ( 6, 'kermit', 'NetBSD', '5.0.2') on DBD::File +ok 411 - execute INSERT INTO NODE VALUES ( 6, 'kermit', 'NetBSD', '5.0.2') on DBD::File +ok 412 - prepare INSERT INTO NODE VALUES ( 7, 'samson', 'NetBSD', '5.0.2') on DBD::File +ok 413 - execute INSERT INTO NODE VALUES ( 7, 'samson', 'NetBSD', '5.0.2') on DBD::File +ok 414 - prepare INSERT INTO NODE VALUES ( 8, 'tiffy', 'NetBSD', '5.0.2') on DBD::File +ok 415 - execute INSERT INTO NODE VALUES ( 8, 'tiffy', 'NetBSD', '5.0.2') on DBD::File +ok 416 - prepare INSERT INTO NODE VALUES ( 9, 'rowlf', 'Debian Lenny', '5.0') on DBD::File +ok 417 - execute INSERT INTO NODE VALUES ( 9, 'rowlf', 'Debian Lenny', '5.0') on DBD::File +ok 418 - prepare INSERT INTO NODE VALUES (10, 'fozzy', 'Debian Lenny', '5.0') on DBD::File +ok 419 - execute INSERT INTO NODE VALUES (10, 'fozzy', 'Debian Lenny', '5.0') on DBD::File +ok 420 - prepare CREATE TEMP TABLE PREC (id INT, appl_id INT, node_id INT, precedence INT) on DBD::File +ok 421 - execute CREATE TEMP TABLE PREC (id INT, appl_id INT, node_id INT, precedence INT) on DBD::File +ok 422 - prepare INSERT INTO PREC VALUES ( 1, 1, 1, 1) on DBD::File +ok 423 - execute INSERT INTO PREC VALUES ( 1, 1, 1, 1) on DBD::File +ok 424 - prepare INSERT INTO PREC VALUES ( 2, 1, 2, 2) on DBD::File +ok 425 - execute INSERT INTO PREC VALUES ( 2, 1, 2, 2) on DBD::File +ok 426 - prepare INSERT INTO PREC VALUES ( 3, 2, 2, 1) on DBD::File +ok 427 - execute INSERT INTO PREC VALUES ( 3, 2, 2, 1) on DBD::File +ok 428 - prepare INSERT INTO PREC VALUES ( 4, 2, 1, 2) on DBD::File +ok 429 - execute INSERT INTO PREC VALUES ( 4, 2, 1, 2) on DBD::File +ok 430 - prepare INSERT INTO PREC VALUES ( 5, 3, 5, 1) on DBD::File +ok 431 - execute INSERT INTO PREC VALUES ( 5, 3, 5, 1) on DBD::File +ok 432 - prepare INSERT INTO PREC VALUES ( 6, 3, 7, 2) on DBD::File +ok 433 - execute INSERT INTO PREC VALUES ( 6, 3, 7, 2) on DBD::File +ok 434 - prepare INSERT INTO PREC VALUES ( 7, 4, 6, 1) on DBD::File +ok 435 - execute INSERT INTO PREC VALUES ( 7, 4, 6, 1) on DBD::File +ok 436 - prepare INSERT INTO PREC VALUES ( 8, 4, 8, 2) on DBD::File +ok 437 - execute INSERT INTO PREC VALUES ( 8, 4, 8, 2) on DBD::File +ok 438 - prepare INSERT INTO PREC VALUES ( 9, 5, 7, 1) on DBD::File +ok 439 - execute INSERT INTO PREC VALUES ( 9, 5, 7, 1) on DBD::File +ok 440 - prepare INSERT INTO PREC VALUES (10, 5, 5, 2) on DBD::File +ok 441 - execute INSERT INTO PREC VALUES (10, 5, 5, 2) on DBD::File +ok 442 - prepare INSERT INTO PREC VALUES (11, 6, 8, 1) on DBD::File +ok 443 - execute INSERT INTO PREC VALUES (11, 6, 8, 1) on DBD::File +ok 444 - prepare INSERT INTO PREC VALUES (12, 7, 6, 2) on DBD::File +ok 445 - execute INSERT INTO PREC VALUES (12, 7, 6, 2) on DBD::File +ok 446 - prepare INSERT INTO PREC VALUES (13, 10, 9, 1) on DBD::File +ok 447 - execute INSERT INTO PREC VALUES (13, 10, 9, 1) on DBD::File +ok 448 - prepare INSERT INTO PREC VALUES (14, 10, 10, 1) on DBD::File +ok 449 - execute INSERT INTO PREC VALUES (14, 10, 10, 1) on DBD::File +ok 450 - prepare INSERT INTO PREC VALUES (15, 8, 9, 1) on DBD::File +ok 451 - execute INSERT INTO PREC VALUES (15, 8, 9, 1) on DBD::File +ok 452 - prepare INSERT INTO PREC VALUES (16, 8, 10, 1) on DBD::File +ok 453 - execute INSERT INTO PREC VALUES (16, 8, 10, 1) on DBD::File +ok 454 - prepare INSERT INTO PREC VALUES (17, 9, 9, 1) on DBD::File +ok 455 - execute INSERT INTO PREC VALUES (17, 9, 9, 1) on DBD::File +ok 456 - prepare INSERT INTO PREC VALUES (18, 9, 10, 1) on DBD::File +ok 457 - execute INSERT INTO PREC VALUES (18, 9, 10, 1) on DBD::File +ok 458 - prepare INSERT INTO PREC VALUES (19, 11, 3, 1) on DBD::File +ok 459 - execute INSERT INTO PREC VALUES (19, 11, 3, 1) on DBD::File +ok 460 - prepare INSERT INTO PREC VALUES (20, 11, 4, 2) on DBD::File +ok 461 - execute INSERT INTO PREC VALUES (20, 11, 4, 2) on DBD::File +ok 462 - prepare INSERT INTO PREC VALUES (21, 12, 4, 1) on DBD::File +ok 463 - execute INSERT INTO PREC VALUES (21, 12, 4, 1) on DBD::File +ok 464 - prepare INSERT INTO PREC VALUES (22, 12, 3, 2) on DBD::File +ok 465 - execute INSERT INTO PREC VALUES (22, 12, 3, 2) on DBD::File +ok 466 - prepare CREATE TEMP TABLE LANDSCAPE (id INT, landscapename CHAR) on DBD::File +ok 467 - execute CREATE TEMP TABLE LANDSCAPE (id INT, landscapename CHAR) on DBD::File +ok 468 - prepare INSERT INTO LANDSCAPE VALUES (1, 'Logistic') on DBD::File +ok 469 - execute INSERT INTO LANDSCAPE VALUES (1, 'Logistic') on DBD::File +ok 470 - prepare INSERT INTO LANDSCAPE VALUES (2, 'Infrastructure') on DBD::File +ok 471 - execute INSERT INTO LANDSCAPE VALUES (2, 'Infrastructure') on DBD::File +ok 472 - prepare INSERT INTO LANDSCAPE VALUES (3, 'CPAN') on DBD::File +ok 473 - execute INSERT INTO LANDSCAPE VALUES (3, 'CPAN') on DBD::File +ok 474 - prepare CREATE TEMP TABLE CONTACT (id INT, surname CHAR, familyname CHAR, phone CHAR, userid CHAR, mailaddr CHAR) on DBD::File +ok 475 - execute CREATE TEMP TABLE CONTACT (id INT, surname CHAR, familyname CHAR, phone CHAR, userid CHAR, mailaddr CHAR) on DBD::File +ok 476 - prepare INSERT INTO CONTACT VALUES ( 1, 'Hans Peter', 'Mueller', '12345', 'HPMUE', 'hp-mueller@here.com') on DBD::File +ok 477 - execute INSERT INTO CONTACT VALUES ( 1, 'Hans Peter', 'Mueller', '12345', 'HPMUE', 'hp-mueller@here.com') on DBD::File +ok 478 - prepare INSERT INTO CONTACT VALUES ( 2, 'Knut', 'Inge', '54321', 'KINGE', 'k-inge@here.com') on DBD::File +ok 479 - execute INSERT INTO CONTACT VALUES ( 2, 'Knut', 'Inge', '54321', 'KINGE', 'k-inge@here.com') on DBD::File +ok 480 - prepare INSERT INTO CONTACT VALUES ( 3, 'Lola', 'Nguyen', '+1-123-45678-90', 'LNYUG', 'lola.ngyuen@customer.com') on DBD::File +ok 481 - execute INSERT INTO CONTACT VALUES ( 3, 'Lola', 'Nguyen', '+1-123-45678-90', 'LNYUG', 'lola.ngyuen@customer.com') on DBD::File +ok 482 - prepare INSERT INTO CONTACT VALUES ( 4, 'Helge', 'Brunft', '+41-123-45678-09', 'HBRUN', 'helge.brunft@external-dc.at') on DBD::File +ok 483 - execute INSERT INTO CONTACT VALUES ( 4, 'Helge', 'Brunft', '+41-123-45678-09', 'HBRUN', 'helge.brunft@external-dc.at') on DBD::File +ok 484 - prepare CREATE TEMP TABLE NM_LANDSCAPE (id INT, ls_id INT, obj_id INT, obj_type INT) on DBD::File +ok 485 - execute CREATE TEMP TABLE NM_LANDSCAPE (id INT, ls_id INT, obj_id INT, obj_type INT) on DBD::File +ok 486 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 1, 1, 1, 2) on DBD::File +ok 487 - execute INSERT INTO NM_LANDSCAPE VALUES ( 1, 1, 1, 2) on DBD::File +ok 488 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 2, 1, 2, 2) on DBD::File +ok 489 - execute INSERT INTO NM_LANDSCAPE VALUES ( 2, 1, 2, 2) on DBD::File +ok 490 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 3, 3, 3, 2) on DBD::File +ok 491 - execute INSERT INTO NM_LANDSCAPE VALUES ( 3, 3, 3, 2) on DBD::File +ok 492 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 4, 3, 4, 2) on DBD::File +ok 493 - execute INSERT INTO NM_LANDSCAPE VALUES ( 4, 3, 4, 2) on DBD::File +ok 494 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 5, 2, 5, 2) on DBD::File +ok 495 - execute INSERT INTO NM_LANDSCAPE VALUES ( 5, 2, 5, 2) on DBD::File +ok 496 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 6, 2, 6, 2) on DBD::File +ok 497 - execute INSERT INTO NM_LANDSCAPE VALUES ( 6, 2, 6, 2) on DBD::File +ok 498 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 7, 2, 7, 2) on DBD::File +ok 499 - execute INSERT INTO NM_LANDSCAPE VALUES ( 7, 2, 7, 2) on DBD::File +ok 500 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 8, 2, 8, 2) on DBD::File +ok 501 - execute INSERT INTO NM_LANDSCAPE VALUES ( 8, 2, 8, 2) on DBD::File +ok 502 - prepare INSERT INTO NM_LANDSCAPE VALUES ( 9, 3, 9, 2) on DBD::File +ok 503 - execute INSERT INTO NM_LANDSCAPE VALUES ( 9, 3, 9, 2) on DBD::File +ok 504 - prepare INSERT INTO NM_LANDSCAPE VALUES (10, 3,10, 2) on DBD::File +ok 505 - execute INSERT INTO NM_LANDSCAPE VALUES (10, 3,10, 2) on DBD::File +ok 506 - prepare INSERT INTO NM_LANDSCAPE VALUES (11, 1, 1, 1) on DBD::File +ok 507 - execute INSERT INTO NM_LANDSCAPE VALUES (11, 1, 1, 1) on DBD::File +ok 508 - prepare INSERT INTO NM_LANDSCAPE VALUES (12, 2, 2, 1) on DBD::File +ok 509 - execute INSERT INTO NM_LANDSCAPE VALUES (12, 2, 2, 1) on DBD::File +ok 510 - prepare INSERT INTO NM_LANDSCAPE VALUES (13, 2, 2, 3) on DBD::File +ok 511 - execute INSERT INTO NM_LANDSCAPE VALUES (13, 2, 2, 3) on DBD::File +ok 512 - prepare INSERT INTO NM_LANDSCAPE VALUES (14, 3, 1, 3) on DBD::File +ok 513 - execute INSERT INTO NM_LANDSCAPE VALUES (14, 3, 1, 3) on DBD::File +ok 514 - prepare CREATE TEMP TABLE APPL_CONTACT (id INT, contact_id INT, appl_id INT, contact_type CHAR) on DBD::File +ok 515 - execute CREATE TEMP TABLE APPL_CONTACT (id INT, contact_id INT, appl_id INT, contact_type CHAR) on DBD::File +ok 516 - prepare INSERT INTO APPL_CONTACT VALUES (1, 3, 1, 'OWNER') on DBD::File +ok 517 - execute INSERT INTO APPL_CONTACT VALUES (1, 3, 1, 'OWNER') on DBD::File +ok 518 - prepare INSERT INTO APPL_CONTACT VALUES (2, 3, 2, 'OWNER') on DBD::File +ok 519 - execute INSERT INTO APPL_CONTACT VALUES (2, 3, 2, 'OWNER') on DBD::File +ok 520 - prepare INSERT INTO APPL_CONTACT VALUES (3, 4, 3, 'ADMIN') on DBD::File +ok 521 - execute INSERT INTO APPL_CONTACT VALUES (3, 4, 3, 'ADMIN') on DBD::File +ok 522 - prepare INSERT INTO APPL_CONTACT VALUES (4, 4, 4, 'ADMIN') on DBD::File +ok 523 - execute INSERT INTO APPL_CONTACT VALUES (4, 4, 4, 'ADMIN') on DBD::File +ok 524 - prepare INSERT INTO APPL_CONTACT VALUES (5, 4, 5, 'ADMIN') on DBD::File +ok 525 - execute INSERT INTO APPL_CONTACT VALUES (5, 4, 5, 'ADMIN') on DBD::File +ok 526 - prepare INSERT INTO APPL_CONTACT VALUES (6, 4, 6, 'ADMIN') on DBD::File +ok 527 - execute INSERT INTO APPL_CONTACT VALUES (6, 4, 6, 'ADMIN') on DBD::File +ok 528 - prepare SELECT pname,sname FROM Prof NATURAL JOIN Subject using DBD::File +ok 529 - execute SELECT pname,sname FROM Prof NATURAL JOIN Subject using DBD::File +ok 530 - NATURAL JOIN - with named columns in select list +ok 531 - prepare SELECT * FROM Prof NATURAL JOIN Subject using DBD::File +ok 532 - execute SELECT * FROM Prof NATURAL JOIN Subject using DBD::File +ok 533 - NATURAL JOIN - with select list = * +ok 534 - prepare SELECT UPPER(pname) AS P,Prof.pid,pname,sname FROM Prof NATURAL JOIN Subject using DBD::File +ok 535 - execute SELECT UPPER(pname) AS P,Prof.pid,pname,sname FROM Prof NATURAL JOIN Subject using DBD::File +ok 536 - NATURAL JOIN - with computed columns +ok 537 - prepare SELECT UPPER(pname) AS P,pid,pname,sname FROM Prof NATURAL JOIN Subject using DBD::File +ok 538 - execute SELECT UPPER(pname) AS P,pid,pname,sname FROM Prof NATURAL JOIN Subject using DBD::File +ok 539 - NATURAL JOIN - with no specifier on join column +ok 540 - prepare SELECT UPPER(pname) AS P,pid,pname,sname FROM Prof JOIN Subject using (pid) using DBD::File +ok 541 - execute SELECT UPPER(pname) AS P,pid,pname,sname FROM Prof JOIN Subject using (pid) using DBD::File +ok 542 - INNER JOIN - with no specifier on join column +ok 543 - prepare SELECT * FROM Prof LEFT JOIN Subject USING(pid) using DBD::File +ok 544 - execute SELECT * FROM Prof LEFT JOIN Subject USING(pid) using DBD::File +ok 545 - LEFT JOIN +ok 546 - prepare SELECT pid,pname,sname FROM Prof LEFT JOIN Subject USING(pid) using DBD::File +ok 547 - execute SELECT pid,pname,sname FROM Prof LEFT JOIN Subject USING(pid) using DBD::File +ok 548 - LEFT JOIN - enumerated columns +ok 549 - prepare SELECT subject.pid,pname,sname FROM Prof LEFT JOIN Subject USING(pid) using DBD::File +ok 550 - execute SELECT subject.pid,pname,sname FROM Prof LEFT JOIN Subject USING(pid) using DBD::File +ok 551 - LEFT JOIN - perversely intentionally mis-enumerated columns +ok 552 - prepare SELECT subject.pid, pname, sname FROM prof LEFT JOIN subject USING(pid) using DBD::File +ok 553 - execute SELECT subject.pid, pname, sname FROM prof LEFT JOIN subject USING(pid) using DBD::File +ok 554 - LEFT JOIN - lower case keywords +ok 555 - prepare SELECT * FROM Prof RIGHT JOIN Subject USING(pid) using DBD::File +ok 556 - execute SELECT * FROM Prof RIGHT JOIN Subject USING(pid) using DBD::File +ok 557 - RIGHT JOIN +ok 558 - prepare SELECT pid,sname,pname FROM Prof RIGHT JOIN Subject USING(pid) using DBD::File +ok 559 - execute SELECT pid,sname,pname FROM Prof RIGHT JOIN Subject USING(pid) using DBD::File +ok 560 - RIGHT JOIN - enumerated columns +ok 561 - prepare SELECT * FROM Prof FULL JOIN Subject USING(pid) using DBD::File +ok 562 - execute SELECT * FROM Prof FULL JOIN Subject USING(pid) using DBD::File +ok 563 - FULL JOIN +ok 564 - prepare SELECT * FROM Prof AS P,Subject AS S WHERE P.pid=S.pid using DBD::File +ok 565 - execute SELECT * FROM Prof AS P,Subject AS S WHERE P.pid=S.pid using DBD::File +ok 566 - IMPLICIT JOIN - two tables +ok 567 - prepare SELECT * +# FROM Prof AS P,Subject AS S,Room AS R +# WHERE P.pid=S.pid +# AND P.pid=R.pid using DBD::File +ok 568 - execute SELECT * +# FROM Prof AS P,Subject AS S,Room AS R +# WHERE P.pid=S.pid +# AND P.pid=R.pid using DBD::File +ok 569 - IMPLICIT JOIN - three tables +ok 570 - prepare SELECT * FROM author NATURAL JOIN book using DBD::File +ok 571 - execute SELECT * FROM author NATURAL JOIN book using DBD::File +ok 572 - Columns in NATURAL JOIN - on unique id's with select list = * +ok 573 - NATURAL JOIN - on unique id's with select list = * +ok 574 - prepare SELECT * FROM t1 CROSS JOIN t2 using DBD::File +ok 575 - execute SELECT * FROM t1 CROSS JOIN t2 using DBD::File +ok 576 - Columns in CROSS JOIN with select list = * +ok 577 - CROSS JOIN with select list = * +ok 578 - prepare SELECT * FROM t1 INNER JOIN t2 ON t1.num = t2.num using DBD::File +ok 579 - execute SELECT * FROM t1 INNER JOIN t2 ON t1.num = t2.num using DBD::File +ok 580 - Columns in INNER JOIN with select list = * +ok 581 - INNER JOIN with select list = * +ok 582 - prepare SELECT * FROM t1 INNER JOIN t2 USING (num) using DBD::File +ok 583 - execute SELECT * FROM t1 INNER JOIN t2 USING (num) using DBD::File +ok 584 - Columns in INNER JOINS (USING) with select list = * +ok 585 - INNER JOINS (USING) with select list = * +ok 586 - prepare SELECT * FROM t1 NATURAL INNER JOIN t2 using DBD::File +ok 587 - execute SELECT * FROM t1 NATURAL INNER JOIN t2 using DBD::File +ok 588 - Columns in INNER JOINS (NATURAL) with select list = * +ok 589 - INNER JOINS (NATURAL) with select list = * +ok 590 - prepare SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num using DBD::File +ok 591 - execute SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num using DBD::File +ok 592 - Columns in LEFT JOINS (using ON condition) with select list = * +ok 593 - LEFT JOINS (using ON condition) with select list = * +ok 594 - prepare SELECT * FROM t1 LEFT JOIN t2 USING (num) using DBD::File +ok 595 - execute SELECT * FROM t1 LEFT JOIN t2 USING (num) using DBD::File +ok 596 - Columns in LEFT JOINS (USING (num) condition) with select list = * +ok 597 - LEFT JOINS (USING (num) condition) with select list = * +ok 598 - prepare SELECT * FROM t1 RIGHT JOIN t2 ON t1.num = t2.num using DBD::File +ok 599 - execute SELECT * FROM t1 RIGHT JOIN t2 ON t1.num = t2.num using DBD::File +ok 600 - Columns in Right Joins (using ON condition) with select list = * +ok 601 - Right Joins (using ON condition) with select list = * +ok 602 - prepare SELECT * FROM t2 LEFT JOIN t1 ON t1.num = t2.num using DBD::File +ok 603 - execute SELECT * FROM t2 LEFT JOIN t1 ON t1.num = t2.num using DBD::File +ok 604 - Columns in Left Joins (reverse former Right Join) with select list = * +ok 605 - Left Joins (reverse former Right Join) with select list = * +ok 606 - prepare SELECT * FROM t1 FULL JOIN t2 ON t1.num = t2.num using DBD::File +ok 607 - execute SELECT * FROM t1 FULL JOIN t2 ON t1.num = t2.num using DBD::File +ok 608 - Columns in Full Joins (using ON condition) with select list = * +ok 609 - Full Joins (using ON condition) with select list = * +# break here +ok 610 - prepare SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num AND t2.wert = 'xxx' using DBD::File # TODO Analyze +ok 611 - execute SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num AND t2.wert = 'xxx' using DBD::File # TODO Analyze +ok 612 - Columns in Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") with select list = * # TODO Analyze +not ok 613 - Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") with select list = * # TODO Analyze +# Failed (TODO) test 'Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") with select list = *' +# at t/08join.t line 675. +# Structures begin differing at: +# $got->[2][2] = '3' +# $expected->[2][2] = undef +# break here +ok 614 - prepare SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num WHERE (t2.wert = 'xxx' OR t2.wert IS NULL) using DBD::File # TODO Analyze +ok 615 - execute SELECT * FROM t1 LEFT JOIN t2 ON t1.num = t2.num WHERE (t2.wert = 'xxx' OR t2.wert IS NULL) using DBD::File # TODO Analyze +ok 616 - Columns in Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) with select list = * # TODO Analyze +not ok 617 - Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) with select list = * # TODO Analyze +# Failed (TODO) test 'Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) with select list = *' +# at t/08join.t line 675. +# Structures begin differing at: +# $got->[2] = Does not exist +# $expected->[2] = ARRAY(0x5580a023a198) +ok 618 - prepare SELECT applname, appluniq, version, nodename +# FROM APPL, PREC, NODE +# WHERE appl_type LIKE '%DB' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id using DBD::File +ok 619 - execute SELECT applname, appluniq, version, nodename +# FROM APPL, PREC, NODE +# WHERE appl_type LIKE '%DB' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id using DBD::File +ok 620 - DEFAULT INNER (1) with named columns +ok 621 - prepare SELECT applname, appluniq, version, landscapename, nodename +# FROM APPL, PREC, NODE, LANDSCAPE, NM_LANDSCAPE +# WHERE appl_type LIKE '%DB' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id +# AND NM_LANDSCAPE.obj_id=APPL.id +# AND NM_LANDSCAPE.obj_type=1 +# AND NM_LANDSCAPE.ls_id=LANDSCAPE.id using DBD::File +ok 622 - execute SELECT applname, appluniq, version, landscapename, nodename +# FROM APPL, PREC, NODE, LANDSCAPE, NM_LANDSCAPE +# WHERE appl_type LIKE '%DB' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id +# AND NM_LANDSCAPE.obj_id=APPL.id +# AND NM_LANDSCAPE.obj_type=1 +# AND NM_LANDSCAPE.ls_id=LANDSCAPE.id using DBD::File +ok 623 - DEFAULT INNER (2) with named columns +ok 624 - prepare SELECT applname, appluniq, version, surname, familyname, phone, nodename +# FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT +# WHERE appl_type='CUPS' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id +# AND APPL_CONTACT.appl_id=APPL.id +# AND APPL_CONTACT.contact_id=CONTACT.id +# AND PREC.PRECEDENCE=1 +# ORDER BY appluniq DESC, applname ASC using DBD::File +ok 625 - execute SELECT applname, appluniq, version, surname, familyname, phone, nodename +# FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT +# WHERE appl_type='CUPS' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id +# AND APPL_CONTACT.appl_id=APPL.id +# AND APPL_CONTACT.contact_id=CONTACT.id +# AND PREC.PRECEDENCE=1 +# ORDER BY appluniq DESC, applname ASC using DBD::File +ok 626 - DEFAULT INNER (3) with named columns +ok 627 - prepare SELECT DISTINCT applname, appluniq, version, surname, familyname, phone, nodename +# FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT +# WHERE appl_type='CUPS' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id +# AND APPL_CONTACT.appl_id=APPL.id +# AND APPL_CONTACT.contact_id=CONTACT.id +# ORDER BY applname, appluniq, nodename using DBD::File +ok 628 - execute SELECT DISTINCT applname, appluniq, version, surname, familyname, phone, nodename +# FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT +# WHERE appl_type='CUPS' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id +# AND APPL_CONTACT.appl_id=APPL.id +# AND APPL_CONTACT.contact_id=CONTACT.id +# ORDER BY applname, appluniq, nodename using DBD::File +ok 629 - DEFAULT INNER (4) with named columns +ok 630 - prepare SELECT CONCAT('[% NOW %]') AS "timestamp", applname, appluniq, version, nodename +# FROM APPL, PREC, NODE +# WHERE appl_type LIKE '%DB' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id using DBD::File +ok 631 - execute SELECT CONCAT('[% NOW %]') AS "timestamp", applname, appluniq, version, nodename +# FROM APPL, PREC, NODE +# WHERE appl_type LIKE '%DB' +# AND APPL.id=PREC.appl_id +# AND PREC.node_id=NODE.id using DBD::File +ok 632 - DEFAULT INNER (5) with named columns +# break here +ok 633 - prepare SELECT pname, sname, rname # TODO Not supported yet! +# FROM Prof p +# JOIN Subject s +# ON p.pid = s.pid +# JOIN Room r +# ON p.pid = r.pid +# using DBD::File +ok 634 - execute SELECT pname, sname, rname # TODO Not supported yet! +# FROM Prof p +# JOIN Subject s +# ON p.pid = s.pid +# JOIN Room r +# ON p.pid = r.pid +# using DBD::File fails +ok 635 - Complex INNER JOIN # TODO Not supported yet! +# break here +ok 636 - prepare SELECT pname, sname, rname # TODO Not supported yet! +# FROM Prof p +# JOIN Subject s USING (pid) +# JOIN Room r USING (pid) +# using DBD::File fails +ok 637 - Complex INNER JOIN (using) # TODO Not supported yet! +# break here +ok 638 - prepare SELECT pname, sname, rname # TODO Not supported yet! +# FROM Prof NATURAL JOIN Subject NATURAL JOIN Room +# using DBD::File fails +ok 639 - Complex NATURAL JOIN # TODO Not supported yet! +# break here +ok 640 - prepare SELECT pname, sname, rname # TODO Not supported yet! +# FROM Prof p +# LEFT JOIN Subject s +# ON p.pid = s.pid +# LEFT JOIN Room r +# ON p.pid = r.pid +# using DBD::File +ok 641 - execute SELECT pname, sname, rname # TODO Not supported yet! +# FROM Prof p +# LEFT JOIN Subject s +# ON p.pid = s.pid +# LEFT JOIN Room r +# ON p.pid = r.pid +# using DBD::File fails +ok 642 - Complex LEFT JOIN # TODO Not supported yet! # Running tests for DBD::DBM -ok 322 # skip DBD::DBM test runs without MLDBM -1..322 +ok 643 # skip DBD::DBM test runs without MLDBM +1..643 ok t/09ops.t ....... 1..18 @@ -4043,72 +3837,72 @@ ok 31 - parse 'SELECT * FROM bar WHERE `foo` IN ('aa','ab','ba','bb')' using SQL::Statement ok 32 - parse ' /* BETWEEN */' using SQL::Statement ok 33 - parse 'SELECT * FROM bar WHERE `foo` BETWEEN ('aa','bb')' using SQL::Statement -ok 34 - parse ' /* DROP TABLE */' using DBD::File -ok 35 - parse 'DROP TABLE `foo`' using DBD::File -ok 36 - parse ' /* DELETE */' using DBD::File -ok 37 - parse 'DELETE FROM `foo`' using DBD::File -ok 38 - parse ' /* UPDATE */' using DBD::File -ok 39 - parse 'UPDATE `foo` SET bar = 7' using DBD::File -ok 40 - parse ' /* INSERT */' using DBD::File -ok 41 - parse 'INSERT INTO `foo` (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::File -ok 42 - parse ' /* CREATE TABLE */' using DBD::File -ok 43 - parse 'CREATE TABLE `foo` ( id INT )' using DBD::File -ok 44 - parse 'CREATE LOCAL TEMPORARY TABLE `foo` (id INT)' using DBD::File -ok 45 - parse 'CREATE GLOBAL TEMPORARY TABLE `foo` (id INT)' using DBD::File -ok 46 - parse 'CREATE TABLE `foo` ( phrase NUMERIC(4,6) )' using DBD::File -ok 47 - parse ' /* SELECT COLUMNS */' using DBD::File -ok 48 - parse 'SELECT id, phrase FROM `foo`' using DBD::File -ok 49 - parse 'SELECT * FROM `foo`' using DBD::File -ok 50 - parse ' /* SET FUNCTIONS */' using DBD::File -ok 51 - parse 'SELECT MAX(`foo`) FROM bar' using DBD::File -ok 52 - parse ' /* ORDER BY */' using DBD::File -ok 53 - parse 'SELECT * FROM `foo` ORDER BY bar' using DBD::File -ok 54 - parse 'SELECT * FROM `foo` ORDER BY bar, baz' using DBD::File -ok 55 - parse ' /* LIMIT */' using DBD::File -ok 56 - parse 'SELECT * FROM `foo` LIMIT 5' using DBD::File -ok 57 - parse ' /* TABLE NAME ALIASES */' using DBD::File -ok 58 - parse 'SELECT * FROM `test` as `T1`' using DBD::File -ok 59 - parse ' /* PARENS */' using DBD::File -ok 60 - parse 'SELECT * FROM `ztable` WHERE NOT `data` IN ('one','two')' using DBD::File -ok 61 - parse ' /* NOT */' using DBD::File -ok 62 - parse 'SELECT * FROM `foo` WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::File -ok 63 - parse ' /* IN */' using DBD::File -ok 64 - parse 'SELECT * FROM bar WHERE `foo` IN ('aa','ab','ba','bb')' using DBD::File -ok 65 - parse ' /* BETWEEN */' using DBD::File -ok 66 - parse 'SELECT * FROM bar WHERE `foo` BETWEEN ('aa','bb')' using DBD::File -ok 67 - parse ' /* DROP TABLE */' using DBD::DBM -ok 68 - parse 'DROP TABLE `foo`' using DBD::DBM -ok 69 - parse ' /* DELETE */' using DBD::DBM -ok 70 - parse 'DELETE FROM `foo`' using DBD::DBM -ok 71 - parse ' /* UPDATE */' using DBD::DBM -ok 72 - parse 'UPDATE `foo` SET bar = 7' using DBD::DBM -ok 73 - parse ' /* INSERT */' using DBD::DBM -ok 74 - parse 'INSERT INTO `foo` (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::DBM -ok 75 - parse ' /* CREATE TABLE */' using DBD::DBM -ok 76 - parse 'CREATE TABLE `foo` ( id INT )' using DBD::DBM -ok 77 - parse 'CREATE LOCAL TEMPORARY TABLE `foo` (id INT)' using DBD::DBM -ok 78 - parse 'CREATE GLOBAL TEMPORARY TABLE `foo` (id INT)' using DBD::DBM -ok 79 - parse 'CREATE TABLE `foo` ( phrase NUMERIC(4,6) )' using DBD::DBM -ok 80 - parse ' /* SELECT COLUMNS */' using DBD::DBM -ok 81 - parse 'SELECT id, phrase FROM `foo`' using DBD::DBM -ok 82 - parse 'SELECT * FROM `foo`' using DBD::DBM -ok 83 - parse ' /* SET FUNCTIONS */' using DBD::DBM -ok 84 - parse 'SELECT MAX(`foo`) FROM bar' using DBD::DBM -ok 85 - parse ' /* ORDER BY */' using DBD::DBM -ok 86 - parse 'SELECT * FROM `foo` ORDER BY bar' using DBD::DBM -ok 87 - parse 'SELECT * FROM `foo` ORDER BY bar, baz' using DBD::DBM -ok 88 - parse ' /* LIMIT */' using DBD::DBM -ok 89 - parse 'SELECT * FROM `foo` LIMIT 5' using DBD::DBM -ok 90 - parse ' /* TABLE NAME ALIASES */' using DBD::DBM -ok 91 - parse 'SELECT * FROM `test` as `T1`' using DBD::DBM -ok 92 - parse ' /* PARENS */' using DBD::DBM -ok 93 - parse 'SELECT * FROM `ztable` WHERE NOT `data` IN ('one','two')' using DBD::DBM -ok 94 - parse ' /* NOT */' using DBD::DBM -ok 95 - parse 'SELECT * FROM `foo` WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::DBM -ok 96 - parse ' /* IN */' using DBD::DBM -ok 97 - parse 'SELECT * FROM bar WHERE `foo` IN ('aa','ab','ba','bb')' using DBD::DBM -ok 98 - parse ' /* BETWEEN */' using DBD::DBM -ok 99 - parse 'SELECT * FROM bar WHERE `foo` BETWEEN ('aa','bb')' using DBD::DBM +ok 34 - parse ' /* DROP TABLE */' using DBD::DBM +ok 35 - parse 'DROP TABLE `foo`' using DBD::DBM +ok 36 - parse ' /* DELETE */' using DBD::DBM +ok 37 - parse 'DELETE FROM `foo`' using DBD::DBM +ok 38 - parse ' /* UPDATE */' using DBD::DBM +ok 39 - parse 'UPDATE `foo` SET bar = 7' using DBD::DBM +ok 40 - parse ' /* INSERT */' using DBD::DBM +ok 41 - parse 'INSERT INTO `foo` (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::DBM +ok 42 - parse ' /* CREATE TABLE */' using DBD::DBM +ok 43 - parse 'CREATE TABLE `foo` ( id INT )' using DBD::DBM +ok 44 - parse 'CREATE LOCAL TEMPORARY TABLE `foo` (id INT)' using DBD::DBM +ok 45 - parse 'CREATE GLOBAL TEMPORARY TABLE `foo` (id INT)' using DBD::DBM +ok 46 - parse 'CREATE TABLE `foo` ( phrase NUMERIC(4,6) )' using DBD::DBM +ok 47 - parse ' /* SELECT COLUMNS */' using DBD::DBM +ok 48 - parse 'SELECT id, phrase FROM `foo`' using DBD::DBM +ok 49 - parse 'SELECT * FROM `foo`' using DBD::DBM +ok 50 - parse ' /* SET FUNCTIONS */' using DBD::DBM +ok 51 - parse 'SELECT MAX(`foo`) FROM bar' using DBD::DBM +ok 52 - parse ' /* ORDER BY */' using DBD::DBM +ok 53 - parse 'SELECT * FROM `foo` ORDER BY bar' using DBD::DBM +ok 54 - parse 'SELECT * FROM `foo` ORDER BY bar, baz' using DBD::DBM +ok 55 - parse ' /* LIMIT */' using DBD::DBM +ok 56 - parse 'SELECT * FROM `foo` LIMIT 5' using DBD::DBM +ok 57 - parse ' /* TABLE NAME ALIASES */' using DBD::DBM +ok 58 - parse 'SELECT * FROM `test` as `T1`' using DBD::DBM +ok 59 - parse ' /* PARENS */' using DBD::DBM +ok 60 - parse 'SELECT * FROM `ztable` WHERE NOT `data` IN ('one','two')' using DBD::DBM +ok 61 - parse ' /* NOT */' using DBD::DBM +ok 62 - parse 'SELECT * FROM `foo` WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::DBM +ok 63 - parse ' /* IN */' using DBD::DBM +ok 64 - parse 'SELECT * FROM bar WHERE `foo` IN ('aa','ab','ba','bb')' using DBD::DBM +ok 65 - parse ' /* BETWEEN */' using DBD::DBM +ok 66 - parse 'SELECT * FROM bar WHERE `foo` BETWEEN ('aa','bb')' using DBD::DBM +ok 67 - parse ' /* DROP TABLE */' using DBD::File +ok 68 - parse 'DROP TABLE `foo`' using DBD::File +ok 69 - parse ' /* DELETE */' using DBD::File +ok 70 - parse 'DELETE FROM `foo`' using DBD::File +ok 71 - parse ' /* UPDATE */' using DBD::File +ok 72 - parse 'UPDATE `foo` SET bar = 7' using DBD::File +ok 73 - parse ' /* INSERT */' using DBD::File +ok 74 - parse 'INSERT INTO `foo` (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::File +ok 75 - parse ' /* CREATE TABLE */' using DBD::File +ok 76 - parse 'CREATE TABLE `foo` ( id INT )' using DBD::File +ok 77 - parse 'CREATE LOCAL TEMPORARY TABLE `foo` (id INT)' using DBD::File +ok 78 - parse 'CREATE GLOBAL TEMPORARY TABLE `foo` (id INT)' using DBD::File +ok 79 - parse 'CREATE TABLE `foo` ( phrase NUMERIC(4,6) )' using DBD::File +ok 80 - parse ' /* SELECT COLUMNS */' using DBD::File +ok 81 - parse 'SELECT id, phrase FROM `foo`' using DBD::File +ok 82 - parse 'SELECT * FROM `foo`' using DBD::File +ok 83 - parse ' /* SET FUNCTIONS */' using DBD::File +ok 84 - parse 'SELECT MAX(`foo`) FROM bar' using DBD::File +ok 85 - parse ' /* ORDER BY */' using DBD::File +ok 86 - parse 'SELECT * FROM `foo` ORDER BY bar' using DBD::File +ok 87 - parse 'SELECT * FROM `foo` ORDER BY bar, baz' using DBD::File +ok 88 - parse ' /* LIMIT */' using DBD::File +ok 89 - parse 'SELECT * FROM `foo` LIMIT 5' using DBD::File +ok 90 - parse ' /* TABLE NAME ALIASES */' using DBD::File +ok 91 - parse 'SELECT * FROM `test` as `T1`' using DBD::File +ok 92 - parse ' /* PARENS */' using DBD::File +ok 93 - parse 'SELECT * FROM `ztable` WHERE NOT `data` IN ('one','two')' using DBD::File +ok 94 - parse ' /* NOT */' using DBD::File +ok 95 - parse 'SELECT * FROM `foo` WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::File +ok 96 - parse ' /* IN */' using DBD::File +ok 97 - parse 'SELECT * FROM bar WHERE `foo` IN ('aa','ab','ba','bb')' using DBD::File +ok 98 - parse ' /* BETWEEN */' using DBD::File +ok 99 - parse 'SELECT * FROM bar WHERE `foo` BETWEEN ('aa','bb')' using DBD::File 1..99 ok All tests successful. @@ -4117,11 +3911,12 @@ ------------------- t/01prepare.t (Wstat: 0 Tests: 846 Failed: 0) TODO passed: 264, 546, 828 -t/06virtual.t (Wstat: 0 Tests: 1313 Failed: 0) - TODO passed: 565-567, 1220-1222 -t/08join.t (Wstat: 0 Tests: 322 Failed: 0) - TODO passed: 289-291, 293-295, 312-321 -Files=17, Tests=3220, 8 wallclock secs ( 0.43 usr 0.06 sys + 7.81 cusr 0.73 csys = 9.03 CPU) +t/06virtual.t (Wstat: 0 Tests: 656 Failed: 0) + TODO passed: 565-567 +t/08join.t (Wstat: 0 Tests: 643 Failed: 0) + TODO passed: 289-291, 293-295, 312-321, 610-612, 614-616 + 633-642 +Files=17, Tests=2884, 7 wallclock secs ( 0.41 usr 0.04 sys + 6.30 cusr 0.59 csys = 7.34 CPU) Result: PASS make[1]: Leaving directory '/build/libsql-statement-perl-1.414' create-stamp debian/debhelper-build-stamp @@ -4129,29 +3924,29 @@ debian/rules override_dh_auto_install make[1]: Entering directory '/build/libsql-statement-perl-1.414' dh_auto_install - make -j15 install DESTDIR=/build/libsql-statement-perl-1.414/debian/libsql-statement-perl AM_UPDATE_INFO_DIR=no PREFIX=/usr + make -j16 install DESTDIR=/build/libsql-statement-perl-1.414/debian/libsql-statement-perl AM_UPDATE_INFO_DIR=no PREFIX=/usr make[2]: Entering directory '/build/libsql-statement-perl-1.414' Manifying 20 pod documents -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Eval.pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Parser.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Eval.pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/ANSI.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/CSV.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/AnyData.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/Role.pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Roadmap.pod -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Structure.pod +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Term.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Util.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Function.pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/TermFactory.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Placeholder.pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Operation.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/RAM.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Functions.pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Embed.pod -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Util.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Placeholder.pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Syntax.pod +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Structure.pod Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/GetInfo.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Function.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Functions.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Term.pm -Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/RAM.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/AnyData.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/CSV.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/ANSI.pm +Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/Role.pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/man/man3/SQL::Statement::Util.3pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/man/man3/SQL::Statement::TermFactory.3pm Installing /build/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/man/man3/SQL::Statement::Term.3pm @@ -4203,12 +3998,14 @@ dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: including full source code in upload I: copying local configuration +I: user script /srv/workspace/pbuilder/1915913/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/1915913/tmp/hooks/B01_cleanup finished I: unmounting dev/ptmx filesystem I: unmounting dev/pts filesystem I: unmounting dev/shm filesystem I: unmounting proc filesystem I: unmounting sys filesystem I: cleaning the build env -I: removing directory /srv/workspace/pbuilder/2176538 and its subdirectories -I: Current time: Thu Nov 18 06:10:25 -12 2021 -I: pbuilder-time-stamp: 1637259025 +I: removing directory /srv/workspace/pbuilder/1915913 and its subdirectories +I: Current time: Thu Dec 22 14:34:04 +14 2022 +I: pbuilder-time-stamp: 1671669244