Diff of the two buildlogs: -- --- b1/build.log 2024-05-04 06:15:39.515485214 +0000 +++ b2/build.log 2024-05-04 06:22:22.918306532 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Fri May 3 18:11:46 -12 2024 -I: pbuilder-time-stamp: 1714803106 +I: Current time: Sat May 4 20:16:00 +14 2024 +I: pbuilder-time-stamp: 1714803360 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/trixie-reproducible-base.tgz] I: copying local configuration @@ -25,52 +25,84 @@ 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/24468/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/13012/tmp/hooks/D01_modify_environment starting +debug: Running on cbxi4a. +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 May 4 06:16 /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/13012/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/13012/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='armhf' - DEBIAN_FRONTEND='noninteractive' - DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=3 ' - DISTRIBUTION='trixie' - HOME='/root' - HOST_ARCH='armhf' + 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]="21" [3]="1" [4]="release" [5]="arm-unknown-linux-gnueabihf") + BASH_VERSION='5.2.21(1)-release' + BUILDDIR=/build/reproducible-path + BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' + BUILDUSERNAME=pbuilder2 + BUILD_ARCH=armhf + DEBIAN_FRONTEND=noninteractive + DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=4 ' + DIRSTACK=() + DISTRIBUTION=trixie + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=arm + HOST_ARCH=armhf IFS=' ' - INVOCATION_ID='fecf5a3a4af349b7854d69f2d31a6b34' - 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='24468' - PS1='# ' - PS2='> ' + INVOCATION_ID=ff83989015f04721b926fb6508eb0508 + LANG=C + LANGUAGE=it_CH:it + LC_ALL=C + MACHTYPE=arm-unknown-linux-gnueabihf + MAIL=/var/mail/root + OPTERR=1 + OPTIND=1 + OSTYPE=linux-gnueabihf + 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=13012 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.VLtsJucw/pbuilderrc_ZxUV --distribution trixie --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/trixie-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.VLtsJucw/b1 --logfile b1/build.log libsql-statement-perl_1.414-1.dsc' - SUDO_GID='113' - SUDO_UID='107' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - _='/usr/bin/systemd-run' - http_proxy='http://10.0.0.15:3142/' + 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.VLtsJucw/pbuilderrc_1nA2 --distribution trixie --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/trixie-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.VLtsJucw/b2 --logfile b2/build.log libsql-statement-perl_1.414-1.dsc' + SUDO_GID=113 + SUDO_UID=107 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + _='I: set' + http_proxy=http://10.0.0.15:3142/ I: uname -a - Linux virt64b 6.1.0-20-arm64 #1 SMP Debian 6.1.85-1 (2024-04-11) aarch64 GNU/Linux + Linux i-capture-the-hostname 6.1.0-20-armmp #1 SMP Debian 6.1.85-1 (2024-04-11) armv7l GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 May 2 11:24 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/24468/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Apr 27 11:27 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/13012/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -170,7 +202,7 @@ Get: 44 http://deb.debian.org/debian trixie/main armhf libtest-pod-coverage-perl all 1.10-3 [14.9 kB] Get: 45 http://deb.debian.org/debian trixie/main armhf libtest-pod-perl all 1.52-3 [12.6 kB] Get: 46 http://deb.debian.org/debian trixie/main armhf libtext-soundex-perl armhf 3.05-2+b3 [13.5 kB] -Fetched 19.5 MB in 1s (29.0 MB/s) +Fetched 19.5 MB in 4s (5485 kB/s) debconf: delaying package configuration, since apt-utils is not installed 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 ... 19441 files and directories currently installed.) @@ -371,7 +403,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/13012/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for trixie +I: user script /srv/workspace/pbuilder/13012/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 @@ -398,32 +434,32 @@ Writing MYMETA.yml and MYMETA.json make[1]: Leaving directory '/build/reproducible-path/libsql-statement-perl-1.414' dh_auto_build - make -j3 + make -j4 make[1]: Entering directory '/build/reproducible-path/libsql-statement-perl-1.414' -cp lib/SQL/Statement/Embed.pod blib/lib/SQL/Statement/Embed.pod -cp lib/SQL/Statement/Util.pm blib/lib/SQL/Statement/Util.pm -cp lib/SQL/Eval.pm blib/lib/SQL/Eval.pm -cp lib/SQL/Statement/Placeholder.pm blib/lib/SQL/Statement/Placeholder.pm -cp lib/SQL/Statement/Operation.pm blib/lib/SQL/Statement/Operation.pm -cp lib/SQL/Parser.pm blib/lib/SQL/Parser.pm -cp lib/SQL/Statement/Syntax.pod blib/lib/SQL/Statement/Syntax.pod -cp lib/SQL/Dialects/Role.pm blib/lib/SQL/Dialects/Role.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/Dialects/ANSI.pm blib/lib/SQL/Dialects/ANSI.pm +cp lib/SQL/Dialects/Role.pm blib/lib/SQL/Dialects/Role.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/RAM.pm blib/lib/SQL/Statement/RAM.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.pm blib/lib/SQL/Statement.pm +cp lib/SQL/Statement/Util.pm blib/lib/SQL/Statement/Util.pm cp lib/SQL/Statement/GetInfo.pm blib/lib/SQL/Statement/GetInfo.pm cp lib/SQL/Statement/Function.pm blib/lib/SQL/Statement/Function.pm -cp lib/SQL/Dialects/AnyData.pm blib/lib/SQL/Dialects/AnyData.pm -cp lib/SQL/Statement.pm blib/lib/SQL/Statement.pm -cp lib/SQL/Statement/Term.pm blib/lib/SQL/Statement/Term.pm cp lib/SQL/Statement/Functions.pm blib/lib/SQL/Statement/Functions.pm +cp lib/SQL/Dialects/CSV.pm blib/lib/SQL/Dialects/CSV.pm +cp lib/SQL/Statement/Syntax.pod blib/lib/SQL/Statement/Syntax.pod +cp lib/SQL/Statement/Roadmap.pod blib/lib/SQL/Statement/Roadmap.pod +cp lib/SQL/Statement/Operation.pm blib/lib/SQL/Statement/Operation.pm +cp lib/SQL/Statement/Placeholder.pm blib/lib/SQL/Statement/Placeholder.pm +cp lib/SQL/Eval.pm blib/lib/SQL/Eval.pm +cp lib/SQL/Statement/Embed.pod blib/lib/SQL/Statement/Embed.pod +cp lib/SQL/Statement/Term.pm blib/lib/SQL/Statement/Term.pm +cp lib/SQL/Statement/RAM.pm blib/lib/SQL/Statement/RAM.pm +cp lib/SQL/Parser.pm blib/lib/SQL/Parser.pm Manifying 20 pod documents make[1]: Leaving directory '/build/reproducible-path/libsql-statement-perl-1.414' dh_auto_test - make -j3 test TEST_VERBOSE=1 + make -j4 test TEST_VERBOSE=1 make[1]: Entering directory '/build/reproducible-path/libsql-statement-perl-1.414' PERL_DL_NONLAZY=1 "/usr/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(1, 'blib/lib', 'blib/arch')" t/*.t xt/*.t # # Using required: @@ -442,7 +478,7 @@ ok 5 - Parse "Junk" RaiseError=1 ok 6 - Execute RaiseError=1 ok 7 - Execute "SELECT * FROM nonexistant" has errstr -# Running tests for DBD::File +# Running tests for DBD::DBM ok 8 - Parse "Junk" RaiseError=0 (default) ok 9 - Execute function succeeded ok 10 - Execute function no errstr @@ -450,7 +486,7 @@ ok 12 - Parse "Junk" RaiseError=1 ok 13 - Execute RaiseError=1 ok 14 - Execute "SELECT * FROM nonexistant" has errstr -# Running tests for DBD::DBM +# Running tests for DBD::File ok 15 - Parse "Junk" RaiseError=0 (default) ok 16 - Execute function succeeded ok 17 - Execute function no errstr @@ -885,7 +921,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0x306adc0),SQL::Statement::Table=HASH(0x3079330) +# Tables SQL::Statement::Table=HASH(0x166e898),SQL::Statement::Table=HASH(0x1666220) # Where op AND # Limit 2 # Offset 5 @@ -1187,7 +1223,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0x302eda0),SQL::Statement::Table=HASH(0x302ea70) +# Tables SQL::Statement::Table=HASH(0x16e9990),SQL::Statement::Table=HASH(0x16bf5e8) # Where op AND # Limit 2 # Offset 5 @@ -1489,7 +1525,7 @@ # Command SELECT # Num Pholders 1 # Columns -# Tables SQL::Statement::Table=HASH(0x30d9660),SQL::Statement::Table=HASH(0x30b3fb8) +# Tables SQL::Statement::Table=HASH(0x16f1c20),SQL::Statement::Table=HASH(0x16f1c80) # Where op AND # Limit 2 # Offset 5 @@ -1631,8 +1667,8 @@ Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. t/02execute.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/arm-linux-gnueabihf/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/arm-linux-gnueabihf/perl5/5.38 /usr/share/perl5 /usr/lib/arm-linux-gnueabihf/perl-base /usr/lib/arm-linux-gnueabihf/perl/5.38 /usr/share/perl/5.38 /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/arm-linux-gnueabihf/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/arm-linux-gnueabihf/perl5/5.38 /usr/share/perl5 /usr/lib/arm-linux-gnueabihf/perl-base /usr/lib/arm-linux-gnueabihf/perl/5.38 /usr/share/perl/5.38 /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/arm-linux-gnueabihf/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/arm-linux-gnueabihf/perl5/5.38 /usr/share/perl5 /usr/lib/arm-linux-gnueabihf/perl-base /usr/lib/arm-linux-gnueabihf/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. # # Using required: # # SQL::Statement: 1.414 # # Using recommended: @@ -1691,37 +1727,37 @@ ok 38 - $stmt->column_names ok 39 - $stmt->order ok 40 - $stmt->fetch -ok 41 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 42 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') -ok 43 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) -ok 44 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) -ok 45 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) -ok 46 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') -ok 47 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 48 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') -ok 49 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) -ok 50 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) -ok 51 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) -ok 52 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) -ok 53 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) -ok 54 - SELECT b,c FROM a WHERE b IN (2,3,5,7) -ok 55 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) -ok 56 - SELECT b,c FROM a WHERE b BETWEEN (5,7) -ok 57 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) -ok 58 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) +ok 41 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) +ok 42 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) +ok 43 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) +ok 44 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) +ok 45 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) +ok 46 - SELECT b,c FROM a WHERE b BETWEEN (5,7) +ok 47 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 48 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') +ok 49 - $stmt->execute "SELECT b,c FROM a WHERE 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 c NOT BETWEEN ('abc','nmo')" (SELECT) +ok 52 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +ok 53 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) +ok 54 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 55 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) +ok 56 - SELECT b,c FROM a WHERE b IN (2,3,5,7) +ok 57 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) +ok 58 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') ok 59 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 60 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -ok 61 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 62 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -ok 63 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) -ok 64 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +ok 61 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 62 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') +ok 63 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) +ok 64 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) ok 65 - CREATE FUNCTION from module ok 66 - CREATE FUNCTION from module with argument ok 67 - LOAD FUNCTIONS ok 68 - CREATE pauli test table ok 69 - UPDATE with placeholders ok 70 - UPDATE with placeholder updates correct -# Running tests for DBD::File +# Running tests for DBD::DBM ok 71 - CREATE Tmp ok 72 - placeholder insert with named cols ok 73 - placeholder insert without named cols @@ -1743,11 +1779,11 @@ ok 89 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' ok 90 - SELECT ok 91 - COUNT * -ok 92 - DROP TEMP TABLE +ok 92 - DROP TABLE ok 93 - COMPUTED COLUMNS IN SELECT LIST ok 94 - CREATE FUNCTION from script -# < CREATE TEMP TABLE a (b INT, c CHAR)> -ok 95 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE) +# < CREATE TABLE a (b INT, c CHAR)> +ok 95 - $stmt->execute " CREATE TABLE a (b INT, c CHAR)" (CREATE) # < INSERT INTO a VALUES(1,'abc')> ok 96 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) # < INSERT INTO a VALUES(2,'efg')> @@ -1773,37 +1809,37 @@ ok 108 - $stmt->column_names ok 109 - $stmt->order ok 110 - $stmt->fetch -ok 111 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 112 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -ok 113 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) -ok 114 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') -ok 115 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 116 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -ok 117 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) -ok 118 - SELECT b,c FROM a WHERE b BETWEEN (5,7) -ok 119 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) -ok 120 - SELECT b,c FROM a WHERE NOT b BETWEEN (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 b IN (2,3,5,7)" (SELECT) -ok 124 - SELECT b,c FROM a WHERE b IN (2,3,5,7) -ok 125 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 126 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') -ok 127 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) -ok 128 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) -ok 129 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) -ok 130 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) -ok 131 - $stmt->execute "SELECT b,c FROM a WHERE 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 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 NOT BETWEEN (5,7)" (SELECT) +ok 114 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) +ok 115 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) +ok 116 - SELECT b,c FROM a WHERE b BETWEEN (5,7) +ok 117 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 118 - SELECT b,c FROM a WHERE NOT c 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 c NOT BETWEEN ('abc','nmo')" (SELECT) +ok 122 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +ok 123 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) +ok 124 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 125 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) +ok 126 - SELECT b,c FROM a WHERE b IN (2,3,5,7) +ok 127 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) +ok 128 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') +ok 129 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 130 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') +ok 131 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 132 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') +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 -ok 138 - CREATE pauli test table -ok 139 - UPDATE with placeholders -ok 140 - UPDATE with placeholder updates correct -# Running tests for DBD::DBM +ok 138 # skip DBD::DBM Update test won't run without MLDBM +ok 139 # skip DBD::DBM Update test won't run without MLDBM +ok 140 # skip DBD::DBM Update test won't run without MLDBM +# Running tests for DBD::File ok 141 - CREATE Tmp ok 142 - placeholder insert with named cols ok 143 - placeholder insert without named cols @@ -1825,11 +1861,11 @@ ok 159 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' ok 160 - SELECT ok 161 - COUNT * -ok 162 - DROP TABLE +ok 162 - DROP TEMP TABLE ok 163 - COMPUTED COLUMNS IN SELECT LIST ok 164 - CREATE FUNCTION from script -# < CREATE TABLE a (b INT, c CHAR)> -ok 165 - $stmt->execute " CREATE TABLE a (b INT, c CHAR)" (CREATE) +# < CREATE TEMP TABLE a (b INT, c CHAR)> +ok 165 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE) # < INSERT INTO a VALUES(1,'abc')> ok 166 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) # < INSERT INTO a VALUES(2,'efg')> @@ -1855,36 +1891,36 @@ ok 178 - $stmt->column_names ok 179 - $stmt->order ok 180 - $stmt->fetch -ok 181 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) -ok 182 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) +ok 181 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) +ok 182 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) ok 183 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) ok 184 - SELECT b,c FROM a WHERE b BETWEEN (5,7) -ok 185 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) -ok 186 - SELECT b,c FROM a WHERE b IN (2,3,5,7) -ok 187 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) -ok 188 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) -ok 189 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) -ok 190 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') -ok 191 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) -ok 192 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') -ok 193 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 194 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') -ok 195 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) -ok 196 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') -ok 197 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) -ok 198 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) -ok 199 - $stmt->execute "SELECT b,c FROM a WHERE 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 c BETWEEN ('abc','nmo')" (SELECT) -ok 202 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 185 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) +ok 186 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) +ok 187 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 188 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') +ok 189 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) +ok 190 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') +ok 191 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 192 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') +ok 193 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) +ok 194 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) +ok 195 - $stmt->execute "SELECT b,c FROM a WHERE 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 NOT BETWEEN ('abc','nmo')" (SELECT) +ok 198 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') +ok 199 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) +ok 200 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') +ok 201 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) +ok 202 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') ok 203 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) ok 204 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) ok 205 - CREATE FUNCTION from module ok 206 - CREATE FUNCTION from module with argument ok 207 - LOAD FUNCTIONS -ok 208 # skip DBD::DBM Update test won't run without MLDBM -ok 209 # skip DBD::DBM Update test won't run without MLDBM -ok 210 # skip DBD::DBM Update test won't run without MLDBM +ok 208 - CREATE pauli test table +ok 209 - UPDATE with placeholders +ok 210 - UPDATE with placeholder updates correct 1..210 ok Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. @@ -1920,7 +1956,7 @@ ok 10 - SELECT IMPORT($external_sth) ok 11 # skip Need DBI statement handle - can't use when executing direct ok 12 # skip Need DBI statement handle - can't use when executing direct -# Running tests for DBD::File +# Running tests for DBD::DBM ok 13 - IMPORT($AoA) ok 14 - IMPORT($AoH) ok 15 - CREATE AS IMPORT($aoh) @@ -1935,7 +1971,7 @@ ok 24 - SELECT IMPORT($external_sth) ok 25 - CREATE AS IMPORT($sth) ok 26 - SELECT FROM IMPORTED ($external_sth) -# Running tests for DBD::DBM +# Running tests for DBD::File ok 27 - IMPORT($AoA) ok 28 - IMPORT($AoH) ok 29 - CREATE AS IMPORT($aoh) @@ -2027,7 +2063,7 @@ ok 35 - execute for 'mixed/asterisked' ok 36 - mixed/asterisked ok 37 # skip Need DBI statement handle - can't use when executing direct -# Running tests for DBD::DBM +# Running tests for DBD::File ok 38 - Column Names: select list = * ok 39 - Column Names: select list = named ok 40 - Column Names: select list = aliased @@ -2068,7 +2104,7 @@ ok 75 - imported table : upper ok 76 - imported table : mixed ok 77 - imported table : asterisked -# Running tests for DBD::File +# Running tests for DBD::DBM ok 78 - Column Names: select list = * ok 79 - Column Names: select list = named ok 80 - Column Names: select list = aliased @@ -2149,44 +2185,6 @@ Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. -Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. t/05simple.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/arm-linux-gnueabihf/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/arm-linux-gnueabihf/perl5/5.38 /usr/share/perl5 /usr/lib/arm-linux-gnueabihf/perl-base /usr/lib/arm-linux-gnueabihf/perl/5.38 /usr/share/perl/5.38 /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/arm-linux-gnueabihf/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/arm-linux-gnueabihf/perl5/5.38 /usr/share/perl5 /usr/lib/arm-linux-gnueabihf/perl-base /usr/lib/arm-linux-gnueabihf/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl .) at t/TestLib.pm line 42. @@ -2357,170 +2355,9 @@ ok 158 - prepare using 'SQL::Statement' ok 159 - execute using 'SQL::Statement' ok 160 - execute(DROP TABLE test_tbl) == -1 using 'SQL::Statement' -# Running tests for DBD::File -ok 161 - prepare using 'DBD::File' -ok 181 - execute using 'DBD::File' 2nd time -ok 184 - execute using 'DBD::File' -ok 190 - execute using 'DBD::File' 2nd time -ok 193 - execute using 'DBD::File' -ok 209 - execute using 'DBD::File' 2nd time -ok 212 - execute using 'DBD::File' -ok 227 - execute using 'DBD::File' 2nd time -ok 230 - execute using 'DBD::File' -ok 237 - execute == 1 using 'DBD::File' -ok 239 - SELECT results for SELECT COUNT(*) FROM multi_fruit using DBD::File -ok 240 - execute == 1 using 'DBD::File' -ok 242 - SELECT results for SELECT COUNT(*) FROM multi_fruit using 'DBD::File' 2nd time -ok 243 - prepare using 'DBD::File' -ok 244 - execute using 'DBD::File' -ok 245 - execute(DROP TABLE multi_fruit) == -1 using 'DBD::File' -ok 246 - prepare using 'DBD::File' -ok 247 - prepare using 'DBD::File' -ok 257 - execute using 'DBD::File' 2nd time -ok 260 - execute using 'DBD::File' -ok 265 - execute using 'DBD::File' 2nd time -ok 268 - execute using 'DBD::File' -ok 273 - execute using 'DBD::File' 2nd time -ok 276 - execute using 'DBD::File' -ok 281 - execute using 'DBD::File' 2nd time -ok 284 - execute using 'DBD::File' -ok 289 - execute using 'DBD::File' 2nd time -ok 292 - execute using 'DBD::File' -ok 297 - execute using 'DBD::File' 2nd time -ok 300 - execute using 'DBD::File' -ok 305 - execute using 'DBD::File' 2nd time -ok 308 - execute using 'DBD::File' -ok 313 - execute using 'DBD::File' 2nd time -ok 316 - execute