Diff of the two buildlogs: -- --- b1/build.log 2025-08-21 21:20:56.580526870 +0000 +++ b2/build.log 2025-08-21 21:21:23.068561086 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Wed Sep 23 15:43:34 -12 2026 -I: pbuilder-time-stamp: 1790221414 +I: Current time: Fri Aug 22 11:20:58 +14 2025 +I: pbuilder-time-stamp: 1755811258 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/forky-reproducible-base.tgz] I: copying local configuration @@ -22,53 +22,85 @@ 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/1750011/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/3503767/tmp/hooks/D01_modify_environment starting +debug: Running on codethink04-arm64. +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 +'/bin/sh' -> '/bin/bash' +lrwxrwxrwx 1 root root 9 Aug 21 21:21 /bin/sh -> /bin/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/3503767/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/3503767/tmp/hooks/D02_print_environment starting I: set - BUILDDIR='/build/reproducible-path' - BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' - BUILDUSERNAME='pbuilder1' - BUILD_ARCH='arm64' - DEBIAN_FRONTEND='noninteractive' + BASH=/bin/sh + BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:globskipdots:hostcomplete:interactive_comments:patsub_replacement:progcomp:promptvars:sourcepath + BASH_ALIASES=() + BASH_ARGC=() + BASH_ARGV=() + BASH_CMDS=() + BASH_LINENO=([0]="12" [1]="0") + BASH_LOADABLES_PATH=/usr/local/lib/bash:/usr/lib/bash:/opt/local/lib/bash:/usr/pkg/lib/bash:/opt/pkg/lib/bash:. + BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") + BASH_VERSINFO=([0]="5" [1]="2" [2]="37" [3]="1" [4]="release" [5]="aarch64-unknown-linux-gnu") + BASH_VERSION='5.2.37(1)-release' + BUILDDIR=/build/reproducible-path + BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' + BUILDUSERNAME=pbuilder2 + BUILD_ARCH=arm64 + DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=12 ' - DISTRIBUTION='forky' - HOME='/root' - HOST_ARCH='arm64' + DIRSTACK=() + DISTRIBUTION=forky + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=aarch64 + HOST_ARCH=arm64 IFS=' ' - INVOCATION_ID='b058db9948664ef3a08dd408253e0293' - 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='1750011' - PS1='# ' - PS2='> ' + INVOCATION_ID=e4e5edf57b05424cadeb792f4cd61e12 + LANG=C + LANGUAGE=nl_BE:nl + LC_ALL=C + MACHTYPE=aarch64-unknown-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=3503767 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/r-b-build.6FOBvRBW/pbuilderrc_tfi4 --distribution forky --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/forky-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.6FOBvRBW/b1 --logfile b1/build.log libsql-statement-perl_1.414-1.dsc' - SUDO_GID='109' - SUDO_HOME='/var/lib/jenkins' - SUDO_UID='104' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - _='/usr/bin/systemd-run' - http_proxy='http://192.168.101.4: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/r-b-build.6FOBvRBW/pbuilderrc_Oxos --distribution forky --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/forky-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.6FOBvRBW/b2 --logfile b2/build.log libsql-statement-perl_1.414-1.dsc' + SUDO_GID=109 + SUDO_HOME=/var/lib/jenkins + SUDO_UID=104 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + _='I: set' + http_proxy=http://192.168.101.4:3128 I: uname -a - Linux codethink03-arm64 6.12.41+deb13-cloud-arm64 #1 SMP Debian 6.12.41-1 (2025-08-12) aarch64 GNU/Linux + Linux i-capture-the-hostname 6.12.41+deb13-cloud-arm64 #1 SMP Debian 6.12.41-1 (2025-08-12) aarch64 GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 Aug 10 2025 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/1750011/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Aug 10 12:30 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/3503767/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -167,7 +199,7 @@ Get: 43 http://deb.debian.org/debian forky/main arm64 libtest-pod-coverage-perl all 1.10-3 [14.9 kB] Get: 44 http://deb.debian.org/debian forky/main arm64 libtest-pod-perl all 1.52-3 [12.6 kB] Get: 45 http://deb.debian.org/debian forky/main arm64 libtext-soundex-perl arm64 3.05-2+b4 [14.0 kB] -Fetched 12.2 MB in 0s (74.5 MB/s) +Fetched 12.2 MB in 0s (112 MB/s) Preconfiguring packages ... Selecting previously unselected package sensible-utils. (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 ... 20003 files and directories currently installed.) @@ -364,7 +396,11 @@ Building tag database... -> Finished parsing the build-deps I: Building the package -I: Running cd /build/reproducible-path/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 +I: user script /srv/workspace/pbuilder/3503767/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for forky +I: user script /srv/workspace/pbuilder/3503767/tmp/hooks/A99_set_merged_usr finished +hostname: Name or service not known +I: Running cd /build/reproducible-path/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 @@ -393,26 +429,26 @@ dh_auto_build make -j12 make[1]: Entering directory '/build/reproducible-path/libsql-statement-perl-1.414' -cp lib/SQL/Statement/Util.pm blib/lib/SQL/Statement/Util.pm cp lib/SQL/Dialects/AnyData.pm blib/lib/SQL/Dialects/AnyData.pm +cp lib/SQL/Statement/Structure.pod blib/lib/SQL/Statement/Structure.pod cp lib/SQL/Statement/Embed.pod blib/lib/SQL/Statement/Embed.pod -cp lib/SQL/Parser.pm blib/lib/SQL/Parser.pm +cp lib/SQL/Statement/TermFactory.pm blib/lib/SQL/Statement/TermFactory.pm cp lib/SQL/Statement/Term.pm blib/lib/SQL/Statement/Term.pm cp lib/SQL/Statement/Syntax.pod blib/lib/SQL/Statement/Syntax.pod -cp lib/SQL/Dialects/ANSI.pm blib/lib/SQL/Dialects/ANSI.pm cp lib/SQL/Statement/RAM.pm blib/lib/SQL/Statement/RAM.pm -cp lib/SQL/Statement/Placeholder.pm blib/lib/SQL/Statement/Placeholder.pm +cp lib/SQL/Statement/Util.pm blib/lib/SQL/Statement/Util.pm +cp lib/SQL/Dialects/CSV.pm blib/lib/SQL/Dialects/CSV.pm +cp lib/SQL/Parser.pm blib/lib/SQL/Parser.pm +cp lib/SQL/Statement/GetInfo.pm blib/lib/SQL/Statement/GetInfo.pm +cp lib/SQL/Statement/Roadmap.pod blib/lib/SQL/Statement/Roadmap.pod +cp lib/SQL/Dialects/ANSI.pm blib/lib/SQL/Dialects/ANSI.pm +cp lib/SQL/Statement/Function.pm blib/lib/SQL/Statement/Function.pm cp lib/SQL/Statement/Operation.pm blib/lib/SQL/Statement/Operation.pm +cp lib/SQL/Eval.pm blib/lib/SQL/Eval.pm cp lib/SQL/Dialects/Role.pm blib/lib/SQL/Dialects/Role.pm +cp lib/SQL/Statement/Placeholder.pm blib/lib/SQL/Statement/Placeholder.pm cp lib/SQL/Statement.pm blib/lib/SQL/Statement.pm -cp lib/SQL/Statement/Structure.pod blib/lib/SQL/Statement/Structure.pod -cp lib/SQL/Statement/Roadmap.pod blib/lib/SQL/Statement/Roadmap.pod -cp lib/SQL/Statement/Function.pm blib/lib/SQL/Statement/Function.pm -cp lib/SQL/Statement/TermFactory.pm blib/lib/SQL/Statement/TermFactory.pm -cp lib/SQL/Dialects/CSV.pm blib/lib/SQL/Dialects/CSV.pm cp lib/SQL/Statement/Functions.pm blib/lib/SQL/Statement/Functions.pm -cp lib/SQL/Statement/GetInfo.pm blib/lib/SQL/Statement/GetInfo.pm -cp lib/SQL/Eval.pm blib/lib/SQL/Eval.pm Manifying 20 pod documents make[1]: Leaving directory '/build/reproducible-path/libsql-statement-perl-1.414' dh_auto_test @@ -878,7 +914,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0xaaab091f0938),SQL::Statement::Table=HASH(0xaaab0919b348) +# Tables SQL::Statement::Table=HASH(0xaaab0619efa8),SQL::Statement::Table=HASH(0xaaab0619a958) # Where op AND # Limit 2 # Offset 5 @@ -1180,7 +1216,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0xaaab091f0aa0),SQL::Statement::Table=HASH(0xaaab09192748) +# Tables SQL::Statement::Table=HASH(0xaaab0619a430),SQL::Statement::Table=HASH(0xaaab061a4b50) # Where op AND # Limit 2 # Offset 5 @@ -1482,7 +1518,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0xaaab0925c4c0),SQL::Statement::Table=HASH(0xaaab09202178) +# Tables SQL::Statement::Table=HASH(0xaaab057fcb20),SQL::Statement::Table=HASH(0xaaab057fc700) # Where op AND # Limit 2 # Offset 5 @@ -1624,8 +1660,8 @@ Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. t/02execute.t ... -# Can't locate MLDBM.pm in @INC (you may need to install the MLDBM module) (@INC entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /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 entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /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 entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.414 # # Using recommended: @@ -1684,30 +1720,30 @@ ok 38 - $stmt->column_names ok 39 - $stmt->order ok 40 - $stmt->fetch -ok 41 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) -ok 42 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) -ok 43 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 44 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') -ok 45 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) -ok 46 - SELECT b,c FROM a WHERE b IN (2,3,5,7) -ok 47 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) -ok 48 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 41 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) +ok 42 - SELECT b,c FROM a WHERE b IN (2,3,5,7) +ok 43 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) +ok 44 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 45 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) +ok 46 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) +ok 47 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) +ok 48 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') ok 49 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) ok 50 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) -ok 51 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 52 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -ok 53 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) -ok 54 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) -ok 55 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) -ok 56 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') -ok 57 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 58 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -ok 59 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) -ok 60 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) -ok 61 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) -ok 62 - SELECT b,c FROM a WHERE b BETWEEN (5,7) -ok 63 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 64 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') +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 c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 54 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') +ok 55 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) +ok 56 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) +ok 57 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) +ok 58 - SELECT b,c FROM a WHERE b BETWEEN (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 NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 62 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') +ok 63 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) +ok 64 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) ok 65 - CREATE FUNCTION from module ok 66 - CREATE FUNCTION from module with argument ok 67 - LOAD FUNCTIONS @@ -1766,30 +1802,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 b BETWEEN (5,7)" (SELECT) -ok 112 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) -ok 113 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) -ok 114 - SELECT b,c FROM a WHERE b IN (2,3,5,7) -ok 115 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) -ok 116 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') -ok 117 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 118 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') -ok 119 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) -ok 120 - SELECT b,c FROM a WHERE NOT b 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 123 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 124 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -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 c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 128 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -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 b BETWEEN (5,7)" (SELECT) -ok 132 - SELECT b,c FROM a WHERE b BETWEEN (5,7) -ok 133 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 134 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') +ok 111 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) +ok 112 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) +ok 113 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) +ok 114 - SELECT b,c FROM a WHERE b BETWEEN (5,7) +ok 115 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 116 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') +ok 117 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) +ok 118 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') +ok 119 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) +ok 120 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) +ok 121 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) +ok 122 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) +ok 123 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 124 - 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 IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 126 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') +ok 127 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) +ok 128 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +ok 129 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) +ok 130 - SELECT b,c FROM a WHERE b IN (2,3,5,7) +ok 131 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) +ok 132 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 133 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) +ok 134 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) ok 135 - CREATE FUNCTION from module ok 136 - CREATE FUNCTION from module with argument ok 137 - LOAD FUNCTIONS @@ -1848,30 +1884,30 @@ ok 178 - $stmt->column_names ok 179 - $stmt->order ok 180 - $stmt->fetch -ok 181 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 182 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') -ok 183 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 184 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -ok 185 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) -ok 186 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) -ok 187 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 188 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -ok 189 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) -ok 190 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') -ok 191 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) -ok 192 - SELECT b,c FROM a WHERE b BETWEEN (5,7) -ok 193 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) -ok 194 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) -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 c BETWEEN ('abc','nmo')" (SELECT) -ok 198 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') -ok 199 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 200 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') -ok 201 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) -ok 202 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) -ok 203 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) -ok 204 - SELECT b,c FROM a WHERE NOT b BETWEEN (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 NOT b BETWEEN (5,7)" (SELECT) +ok 184 - SELECT b,c FROM a WHERE NOT b 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 c NOT BETWEEN ('abc','nmo')" (SELECT) +ok 188 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +ok 189 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 190 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') +ok 191 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 192 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') +ok 193 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) +ok 194 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) +ok 195 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) +ok 196 - SELECT b,c FROM a WHERE b BETWEEN (5,7) +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 b NOT BETWEEN (5,7)" (SELECT) +ok 200 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) +ok 201 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) +ok 202 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') +ok 203 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 204 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') ok 205 - CREATE FUNCTION from module ok 206 - CREATE FUNCTION from module with argument ok 207 - LOAD FUNCTIONS @@ -2020,7 +2056,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::File +# Running tests for DBD::DBM ok 38 - Column Names: select list = * ok 39 - Column Names: select list = named ok 40 - Column Names: select list = aliased @@ -2061,7 +2097,7 @@ ok 75 - imported table : upper ok 76 - imported table : mixed ok 77 - imported table : asterisked -# Running tests for DBD::DBM +# Running tests for DBD::File ok 78 - Column Names: select list = * ok 79 - Column Names: select list = named ok 80 - Column Names: select list = aliased @@ -2515,8 +2551,8 @@ Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. t/06virtual.t ... -# Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /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 entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /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 entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.414 # # Using recommended: @@ -2557,40 +2593,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,', 1790221431) 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,', 1790221431) on SQL::Statement -ok 35 - prepare INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1790221431) on SQL::Statement -ok 36 - execute INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1790221431) on SQL::Statement -ok 37 - prepare INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1790221431) on SQL::Statement -ok 38 - execute INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1790221431) on SQL::Statement -ok 39 - prepare INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1790221431) on SQL::Statement -ok 40 - execute INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1790221431) on SQL::Statement -ok 41 - prepare INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1790221431) on SQL::Statement -ok 42 - execute INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1790221431) on SQL::Statement -ok 43 - prepare INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1790221431) on SQL::Statement -ok 44 - execute INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1790221431) 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', 1790221431) 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', 1790221431) on SQL::Statement -ok 47 - prepare INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1790217831) on SQL::Statement -ok 48 - execute INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1790217831) on SQL::Statement -ok 49 - prepare INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1790214231) on SQL::Statement -ok 50 - execute INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1790214231) on SQL::Statement -ok 51 - prepare INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1790210631) on SQL::Statement -ok 52 - execute INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1790210631) on SQL::Statement -ok 53 - prepare INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1790207031) on SQL::Statement -ok 54 - execute INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1790207031) on SQL::Statement -ok 55 - prepare INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1790203431) on SQL::Statement -ok 56 - execute INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1790203431) on SQL::Statement -ok 57 - prepare INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1790199831) on SQL::Statement -ok 58 - execute INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1790199831) on SQL::Statement -ok 59 - prepare INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1790196231) on SQL::Statement -ok 60 - execute INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1790196231) on SQL::Statement -ok 61 - prepare INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1790192631) on SQL::Statement -ok 62 - execute INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1790192631) on SQL::Statement -ok 63 - prepare INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1790189031) on SQL::Statement -ok 64 - execute INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1790189031) on SQL::Statement -ok 65 - prepare INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1790185431) on SQL::Statement -ok 66 - execute INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1790185431) 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,', 1755811278) 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,', 1755811278) on SQL::Statement +ok 35 - prepare INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1755811278) on SQL::Statement +ok 36 - execute INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009, 2010', 1755811278) on SQL::Statement +ok 37 - prepare INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1755811278) on SQL::Statement +ok 38 - execute INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1755811278) on SQL::Statement +ok 39 - prepare INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1755811278) on SQL::Statement +ok 40 - execute INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1755811278) on SQL::Statement +ok 41 - prepare INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1755811278) on SQL::Statement +ok 42 - execute INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1755811278) on SQL::Statement +ok 43 - prepare INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1755811278) on SQL::Statement +ok 44 - execute INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1755811278) 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', 1755811278) 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', 1755811278) on SQL::Statement +ok 47 - prepare INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1755807678) on SQL::Statement +ok 48 - execute INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1755807678) on SQL::Statement +ok 49 - prepare INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1755804078) on SQL::Statement +ok 50 - execute INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1755804078) on SQL::Statement +ok 51 - prepare INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1755800478) on SQL::Statement +ok 52 - execute INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1755800478) on SQL::Statement +ok 53 - prepare INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1755796878) on SQL::Statement +ok 54 - execute INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1755796878) on SQL::Statement +ok 55 - prepare INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1755793278) on SQL::Statement +ok 56 - execute INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1755793278) on SQL::Statement +ok 57 - prepare INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1755789678) on SQL::Statement +ok 58 - execute INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1755789678) on SQL::Statement +ok 59 - prepare INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1755786078) on SQL::Statement +ok 60 - execute INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1755786078) on SQL::Statement +ok 61 - prepare INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1755782478) on SQL::Statement +ok 62 - execute INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1755782478) on SQL::Statement +ok 63 - prepare INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1755778878) on SQL::Statement +ok 64 - execute INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1755778878) on SQL::Statement +ok 65 - prepare INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1755775278) on SQL::Statement +ok 66 - execute INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1755775278) 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 @@ -3161,17 +3197,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 < (1790221431 - ( 4 * 60 )) using SQL::Statement -ok 629 - execute SELECT id,host,signature,message FROM log WHERE time_stamp < (1790221431 - ( 4 * 60 )) using SQL::Statement +ok 628 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp < (1755811278 - ( 4 * 60 )) using SQL::Statement +ok 629 - execute SELECT id,host,signature,message FROM log WHERE time_stamp < (1755811278 - ( 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 > (1790221431 - 5)) AND (time_stamp < (1790221431 + 5)) using SQL::Statement -ok 632 - execute SELECT id,host,signature,message FROM log WHERE (time_stamp > (1790221431 - 5)) AND (time_stamp < (1790221431 + 5)) using SQL::Statement +ok 631 - prepare SELECT id,host,signature,message FROM log WHERE (time_stamp > (1755811278 - 5)) AND (time_stamp < (1755811278 + 5)) using SQL::Statement +ok 632 - execute SELECT id,host,signature,message FROM log WHERE (time_stamp > (1755811278 - 5)) AND (time_stamp < (1755811278 + 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 ( 1790221431 - 5, 1790221431 + 5) using SQL::Statement -ok 635 - execute SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1790221431 - 5, 1790221431 + 5) using SQL::Statement +ok 634 - prepare SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1755811278 - 5, 1755811278 + 5) using SQL::Statement +ok 635 - execute SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1755811278 - 5, 1755811278 + 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 (1790221431 - (2*3600), 1790221431 - (4*3600)) using SQL::Statement -ok 638 - execute SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1790221431 - (2*3600), 1790221431 - (4*3600)) using SQL::Statement +ok 637 - prepare SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1755811278 - (2*3600), 1755811278 - (4*3600)) using SQL::Statement +ok 638 - execute SELECT MAX(time_stamp) FROM log WHERE time_stamp IN (1755811278 - (2*3600), 1755811278 - (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 @@ -3680,493 +3716,9 @@ Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.40/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.40/Text/Balanced.pm line 1008. t/08join.t ...... -# Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /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 entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /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 entries checked: t /build/reproducible-path/libsql-statement-perl-1.414/blib/lib /build/reproducible-path/libsql-statement-perl-1.414/blib/arch /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.40.1 /usr/local/share/perl/5.40.1 /usr/lib/aarch64-linux-gnu/perl5/5.40 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.40 /usr/share/perl/5.40 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.414 # # Using recommended: @@ -4487,7 +4039,7 @@ # at t/08join.t line 675. # Structures begin differing at: # $got->[2] = Does not exist -# $expected->[2] = ARRAY(0xaaaab8b9c0b0) +# $expected->[2] = ARRAY(0xaaaaf702b560) ok 297 - prepare SELECT applname, appluniq, version, nodename # FROM APPL, PREC, NODE # WHERE appl_type LIKE '%DB' @@ -4607,443 +4159,9 @@ # 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(0xaaaab8bf2768) -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 643 # skip DBD::DBM test runs without MLDBM -1..643 +ok 322 # skip DBD::DBM test runs without MLDBM +1..322 ok t/09ops.t ....... 1..18 @@ -5303,10 +4421,9 @@ TODO passed: 264, 546, 828 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, 4 wallclock secs ( 0.33 usr 0.04 sys + 3.47 cusr 0.40 csys = 4.24 CPU) +t/08join.t (Wstat: 0 Tests: 322 Failed: 0) + TODO passed: 289-291, 293-295, 312-321 +Files=17, Tests=2563, 4 wallclock secs ( 0.24 usr 0.05 sys + 3.08 cusr 0.34 csys = 3.71 CPU) Result: PASS make[1]: Leaving directory '/build/reproducible-path/libsql-statement-perl-1.414' create-stamp debian/debhelper-build-stamp @@ -5317,26 +4434,26 @@ make -j12 install DESTDIR=/build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl AM_UPDATE_INFO_DIR=no PREFIX=/usr make[2]: Entering directory '/build/reproducible-path/libsql-statement-perl-1.414' Manifying 20 pod documents -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Eval.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Eval.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Parser.pm -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/CSV.pm -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/Role.pm -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/ANSI.pm -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/AnyData.pm -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/GetInfo.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Functions.pm -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/TermFactory.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Placeholder.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Operation.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Function.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Roadmap.pod -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Structure.pod -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Operation.pm -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Placeholder.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/GetInfo.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Util.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/RAM.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Syntax.pod Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Term.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/TermFactory.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Embed.pod -Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Util.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Statement/Structure.pod +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/Role.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/ANSI.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/CSV.pm +Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/perl5/SQL/Dialects/AnyData.pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/man/man3/SQL::Statement::Util.3pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/man/man3/SQL::Statement::TermFactory.3pm Installing /build/reproducible-path/libsql-statement-perl-1.414/debian/libsql-statement-perl/usr/share/man/man3/SQL::Statement::Term.3pm @@ -5388,12 +4505,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/3503767/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/3503767/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/1750011 and its subdirectories -I: Current time: Wed Sep 23 15:43:55 -12 2026 -I: pbuilder-time-stamp: 1790221435 +I: removing directory /srv/workspace/pbuilder/3503767 and its subdirectories +I: Current time: Fri Aug 22 11:21:22 +14 2025 +I: pbuilder-time-stamp: 1755811282