0s autopkgtest [21:23:15]: starting date: 2024-03-10 0s autopkgtest [21:23:15]: git checkout: d9c0295 adt_testbed.py: supress warnings from apt using a shell pipeline 0s autopkgtest [21:23:15]: host juju-7f2275-prod-proposed-migration-environment-3; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.i39_j0sd/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed=src:perl,src:db5.3,src:gdbm,src:mmdebstrap --apt-upgrade libsql-statement-perl --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=perl/5.38.2-3.2 db5.3/5.3.28+dfsg2-5 gdbm/1.23-5.1 mmdebstrap/1.4.3-6' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-3@bos03-arm64-8.secgroup --name adt-noble-arm64-libsql-statement-perl-20240310-212315-juju-7f2275-prod-proposed-migration-environment-3 --image adt/ubuntu-noble-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-3 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 92s autopkgtest [21:24:47]: @@@@@@@@@@@@@@@@@@@@ test bed setup 92s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 92s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [37.3 kB] 92s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [3976 B] 92s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [432 kB] 93s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [2621 kB] 93s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [580 kB] 93s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [3144 B] 93s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [20.3 kB] 93s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 93s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [2967 kB] 93s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [8528 B] 93s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [39.6 kB] 93s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 94s Fetched 6830 kB in 2s (4384 kB/s) 95s Reading package lists... 97s Reading package lists... 97s Building dependency tree... 97s Reading state information... 98s Calculating upgrade... 98s The following packages were automatically installed and are no longer required: 98s libgdbm-compat4t64 libperl5.38 lto-disabled-list make perl-modules-5.38 98s ubuntu-advantage-tools 98s Use 'sudo apt autoremove' to remove them. 98s The following packages will be REMOVED: 98s dpkg-dev libdpkg-perl libgdbm-compat4 libgdbm6 perl 98s The following NEW packages will be installed: 98s libgdbm-compat4t64 libgdbm6t64 libnuma1 libsensors-config libsensors5 98s numactl sysstat 98s The following packages have been kept back: 98s libperl5.38 98s The following packages will be upgraded: 98s efibootmgr perl-base perl-modules-5.38 python3-attr ubuntu-minimal 98s ubuntu-standard 98s 6 upgraded, 7 newly installed, 5 to remove and 1 not upgraded. 98s Need to get 5605 kB of archives. 98s After this operation, 1944 kB disk space will be freed. 98s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl-base arm64 5.38.2-3.2 [1777 kB] 99s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libgdbm6t64 arm64 1.23-5.1 [34.3 kB] 99s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libgdbm-compat4t64 arm64 1.23-5.1 [6576 B] 99s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl-modules-5.38 all 5.38.2-3.2 [3110 kB] 99s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 ubuntu-minimal arm64 1.535 [10.5 kB] 99s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 libnuma1 arm64 2.0.18-1 [23.5 kB] 99s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 ubuntu-standard arm64 1.535 [10.5 kB] 99s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 efibootmgr arm64 18-1build1 [31.5 kB] 99s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 libsensors-config all 1:3.6.0-9 [5458 B] 99s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 libsensors5 arm64 1:3.6.0-9 [26.9 kB] 99s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 numactl arm64 2.0.18-1 [39.5 kB] 99s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 python3-attr all 23.2.0-2 [48.6 kB] 99s Get:13 http://ftpmaster.internal/ubuntu noble/main arm64 sysstat arm64 12.6.1-1ubuntu1 [480 kB] 99s Preconfiguring packages ... 99s Fetched 5605 kB in 1s (6980 kB/s) 100s (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 ... 74662 files and directories currently installed.) 100s Removing dpkg-dev (1.22.4ubuntu5) ... 100s Removing libdpkg-perl (1.22.4ubuntu5) ... 100s Removing perl (5.38.2-3) ... 100s (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 ... 74081 files and directories currently installed.) 100s Preparing to unpack .../perl-base_5.38.2-3.2_arm64.deb ... 100s Unpacking perl-base (5.38.2-3.2) over (5.38.2-3) ... 100s Setting up perl-base (5.38.2-3.2) ... 100s dpkg: libgdbm6:arm64: dependency problems, but removing anyway as you requested: 100s python3-gdbm:arm64 depends on libgdbm6 (>= 1.16). 100s man-db depends on libgdbm6 (>= 1.16). 100s libperl5.38:arm64 depends on libgdbm6 (>= 1.21). 100s libgdbm-compat4:arm64 depends on libgdbm6 (>= 1.16). 100s 100s (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 ... 74081 files and directories currently installed.) 100s Removing libgdbm6:arm64 (1.23-5) ... 100s Selecting previously unselected package libgdbm6t64:arm64. 100s (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 ... 74076 files and directories currently installed.) 100s Preparing to unpack .../libgdbm6t64_1.23-5.1_arm64.deb ... 100s Unpacking libgdbm6t64:arm64 (1.23-5.1) ... 100s dpkg: libgdbm-compat4:arm64: dependency problems, but removing anyway as you requested: 100s libperl5.38:arm64 depends on libgdbm-compat4 (>= 1.18-3). 100s 100s (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 ... 74082 files and directories currently installed.) 100s Removing libgdbm-compat4:arm64 (1.23-5) ... 101s Selecting previously unselected package libgdbm-compat4t64:arm64. 101s (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 ... 74077 files and directories currently installed.) 101s Preparing to unpack .../00-libgdbm-compat4t64_1.23-5.1_arm64.deb ... 101s Unpacking libgdbm-compat4t64:arm64 (1.23-5.1) ... 101s Preparing to unpack .../01-perl-modules-5.38_5.38.2-3.2_all.deb ... 101s Unpacking perl-modules-5.38 (5.38.2-3.2) over (5.38.2-3) ... 102s Preparing to unpack .../02-ubuntu-minimal_1.535_arm64.deb ... 102s Unpacking ubuntu-minimal (1.535) over (1.534) ... 102s Selecting previously unselected package libnuma1:arm64. 102s Preparing to unpack .../03-libnuma1_2.0.18-1_arm64.deb ... 102s Unpacking libnuma1:arm64 (2.0.18-1) ... 102s Preparing to unpack .../04-ubuntu-standard_1.535_arm64.deb ... 102s Unpacking ubuntu-standard (1.535) over (1.534) ... 103s Preparing to unpack .../05-efibootmgr_18-1build1_arm64.deb ... 103s Unpacking efibootmgr (18-1build1) over (18-1) ... 103s Selecting previously unselected package libsensors-config. 103s Preparing to unpack .../06-libsensors-config_1%3a3.6.0-9_all.deb ... 103s Unpacking libsensors-config (1:3.6.0-9) ... 103s Selecting previously unselected package libsensors5:arm64. 103s Preparing to unpack .../07-libsensors5_1%3a3.6.0-9_arm64.deb ... 103s Unpacking libsensors5:arm64 (1:3.6.0-9) ... 103s Selecting previously unselected package numactl. 104s Preparing to unpack .../08-numactl_2.0.18-1_arm64.deb ... 104s Unpacking numactl (2.0.18-1) ... 104s Preparing to unpack .../09-python3-attr_23.2.0-2_all.deb ... 104s Unpacking python3-attr (23.2.0-2) over (23.2.0-1) ... 104s Selecting previously unselected package sysstat. 104s Preparing to unpack .../10-sysstat_12.6.1-1ubuntu1_arm64.deb ... 104s Unpacking sysstat (12.6.1-1ubuntu1) ... 104s Setting up python3-attr (23.2.0-2) ... 104s Setting up efibootmgr (18-1build1) ... 104s Setting up libgdbm6t64:arm64 (1.23-5.1) ... 104s Setting up ubuntu-minimal (1.535) ... 104s Setting up libgdbm-compat4t64:arm64 (1.23-5.1) ... 104s Setting up libsensors-config (1:3.6.0-9) ... 104s Setting up ubuntu-standard (1.535) ... 104s Setting up perl-modules-5.38 (5.38.2-3.2) ... 104s Setting up libsensors5:arm64 (1:3.6.0-9) ... 104s Setting up libnuma1:arm64 (2.0.18-1) ... 104s Setting up sysstat (12.6.1-1ubuntu1) ... 104s 104s Creating config file /etc/default/sysstat with new version 105s update-alternatives: using /usr/bin/sar.sysstat to provide /usr/bin/sar (sar) in auto mode 105s Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-collect.timer → /usr/lib/systemd/system/sysstat-collect.timer. 105s Created symlink /etc/systemd/system/sysstat.service.wants/sysstat-summary.timer → /usr/lib/systemd/system/sysstat-summary.timer. 105s Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /usr/lib/systemd/system/sysstat.service. 107s Setting up numactl (2.0.18-1) ... 107s Processing triggers for man-db (2.12.0-3) ... 108s Processing triggers for libc-bin (2.39-0ubuntu2) ... 109s Reading package lists... 109s Building dependency tree... 109s Reading state information... 109s The following packages will be REMOVED: 109s libgdbm-compat4t64* libperl5.38* lto-disabled-list* make* perl-modules-5.38* 109s ubuntu-advantage-tools* 110s 0 upgraded, 0 newly installed, 6 to remove and 0 not upgraded. 110s After this operation, 52.0 MB disk space will be freed. 110s (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 ... 74176 files and directories currently installed.) 110s Removing libperl5.38:arm64 (5.38.2-3) ... 110s Removing libgdbm-compat4t64:arm64 (1.23-5.1) ... 110s Removing lto-disabled-list (47) ... 110s Removing make (4.3-4.1build1) ... 110s Removing perl-modules-5.38 (5.38.2-3.2) ... 110s Removing ubuntu-advantage-tools (31.1) ... 110s Processing triggers for man-db (2.12.0-3) ... 110s Processing triggers for libc-bin (2.39-0ubuntu2) ... 110s (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 ... 72199 files and directories currently installed.) 110s Purging configuration files for ubuntu-advantage-tools (31.1) ... 111s sh: Attempting to set up Debian/Ubuntu apt sources automatically 111s sh: Distribution appears to be Ubuntu 111s Reading package lists... 112s Building dependency tree... 112s Reading state information... 112s eatmydata is already the newest version (131-1). 112s dbus is already the newest version (1.14.10-4ubuntu1). 112s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 112s Reading package lists... 113s Building dependency tree... 113s Reading state information... 113s rng-tools-debian is already the newest version (2.4). 113s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 113s Reading package lists... 113s Building dependency tree... 113s Reading state information... 114s haveged is already the newest version (1.9.14-1ubuntu1). 114s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 115s The following additional packages will be installed: 115s libdb5.3t64 libdpkg-perl libgdbm-compat4t64 libperl5.38t64 lto-disabled-list 115s make perl perl-modules-5.38 115s Suggested packages: 115s debian-keyring gcc | c-compiler git bzr make-doc perl-doc 115s libterm-readline-gnu-perl | libterm-readline-perl-perl 115s libtap-harness-archive-perl 115s Recommended packages: 115s build-essential gcc | c-compiler fakeroot libalgorithm-merge-perl 115s libfile-fcntllock-perl 115s The following packages will be REMOVED: 115s libdb5.3 115s The following NEW packages will be installed: 115s dpkg-dev libdb5.3t64 libdpkg-perl libgdbm-compat4t64 libperl5.38t64 115s lto-disabled-list make perl perl-modules-5.38 115s 0 upgraded, 9 newly installed, 1 to remove and 0 not upgraded. 115s Need to get 7257 kB/10.4 MB of archives. 115s After this operation, 56.1 MB of additional disk space will be used. 115s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libdb5.3t64 arm64 5.3.28+dfsg2-5 [719 kB] 115s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 libperl5.38t64 arm64 5.38.2-3.2 [4771 kB] 115s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 perl arm64 5.38.2-3.2 [231 kB] 115s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 libdpkg-perl all 1.22.4ubuntu5 [268 kB] 115s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 make arm64 4.3-4.1build1 [177 kB] 115s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 lto-disabled-list all 47 [12.4 kB] 115s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 dpkg-dev all 1.22.4ubuntu5 [1078 kB] 116s Fetched 7257 kB in 1s (9476 kB/s) 116s dpkg: libdb5.3:arm64: dependency problems, but removing anyway as you requested: 116s libsasl2-modules-db:arm64 depends on libdb5.3. 116s libpython3.12-stdlib:arm64 depends on libdb5.3. 116s libpam-modules:arm64 depends on libdb5.3. 116s iproute2 depends on libdb5.3. 116s apt-utils depends on libdb5.3. 116s 116s (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 ... 72198 files and directories currently installed.) 116s Removing libdb5.3:arm64 (5.3.28+dfsg2-4) ... 116s Selecting previously unselected package libdb5.3t64:arm64. 116s (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 ... 72192 files and directories currently installed.) 116s Preparing to unpack .../libdb5.3t64_5.3.28+dfsg2-5_arm64.deb ... 116s Unpacking libdb5.3t64:arm64 (5.3.28+dfsg2-5) ... 116s Setting up libdb5.3t64:arm64 (5.3.28+dfsg2-5) ... 116s Selecting previously unselected package perl-modules-5.38. 116s (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 ... 72198 files and directories currently installed.) 116s Preparing to unpack .../0-perl-modules-5.38_5.38.2-3.2_all.deb ... 116s Unpacking perl-modules-5.38 (5.38.2-3.2) ... 117s Selecting previously unselected package libgdbm-compat4t64:arm64. 117s Preparing to unpack .../1-libgdbm-compat4t64_1.23-5.1_arm64.deb ... 117s Unpacking libgdbm-compat4t64:arm64 (1.23-5.1) ... 117s Selecting previously unselected package libperl5.38t64:arm64. 117s Preparing to unpack .../2-libperl5.38t64_5.38.2-3.2_arm64.deb ... 117s Unpacking libperl5.38t64:arm64 (5.38.2-3.2) ... 117s Selecting previously unselected package perl. 117s Preparing to unpack .../3-perl_5.38.2-3.2_arm64.deb ... 117s Unpacking perl (5.38.2-3.2) ... 117s Selecting previously unselected package libdpkg-perl. 117s Preparing to unpack .../4-libdpkg-perl_1.22.4ubuntu5_all.deb ... 117s Unpacking libdpkg-perl (1.22.4ubuntu5) ... 117s Selecting previously unselected package make. 117s Preparing to unpack .../5-make_4.3-4.1build1_arm64.deb ... 117s Unpacking make (4.3-4.1build1) ... 117s Selecting previously unselected package lto-disabled-list. 117s Preparing to unpack .../6-lto-disabled-list_47_all.deb ... 117s Unpacking lto-disabled-list (47) ... 117s Selecting previously unselected package dpkg-dev. 117s Preparing to unpack .../7-dpkg-dev_1.22.4ubuntu5_all.deb ... 117s Unpacking dpkg-dev (1.22.4ubuntu5) ... 117s Setting up lto-disabled-list (47) ... 117s Setting up libgdbm-compat4t64:arm64 (1.23-5.1) ... 117s Setting up make (4.3-4.1build1) ... 117s Setting up perl-modules-5.38 (5.38.2-3.2) ... 117s Setting up libperl5.38t64:arm64 (5.38.2-3.2) ... 117s Setting up perl (5.38.2-3.2) ... 117s Setting up libdpkg-perl (1.22.4ubuntu5) ... 117s Setting up dpkg-dev (1.22.4ubuntu5) ... 117s Processing triggers for man-db (2.12.0-3) ... 118s Processing triggers for libc-bin (2.39-0ubuntu2) ... 119s Reading package lists... 119s Building dependency tree... 119s Reading state information... 120s The following packages will be REMOVED: 120s cloud-init* python3-configobj* python3-debconf* 120s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 120s After this operation, 3248 kB disk space will be freed. 120s (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 ... 74750 files and directories currently installed.) 120s Removing cloud-init (24.1-0ubuntu1) ... 121s Removing python3-configobj (5.0.8-3) ... 121s Removing python3-debconf (1.5.86) ... 121s Processing triggers for man-db (2.12.0-3) ... 121s (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 ... 74361 files and directories currently installed.) 121s Purging configuration files for cloud-init (24.1-0ubuntu1) ... 122s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 122s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 122s Reading package lists... 122s Building dependency tree... 122s Reading state information... 123s linux-generic is already the newest version (6.8.0-11.11+1). 123s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 123s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 123s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 123s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 123s Hit:4 http://ftpmaster.internal/ubuntu noble-proposed InRelease 124s Reading package lists... 124s Reading package lists... 124s Building dependency tree... 124s Reading state information... 125s Calculating upgrade... 125s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 125s Reading package lists... 125s Building dependency tree... 125s Reading state information... 126s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 126s autopkgtest [21:25:21]: rebooting testbed after setup commands that affected boot 149s autopkgtest [21:25:44]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 14 02:53:31 UTC 2024 149s autopkgtest [21:25:44]: testbed dpkg architecture: arm64 151s autopkgtest [21:25:46]: @@@@@@@@@@@@@@@@@@@@ apt-source libsql-statement-perl 153s Get:1 http://ftpmaster.internal/ubuntu noble/universe libsql-statement-perl 1.414-1 (dsc) [2762 B] 153s Get:2 http://ftpmaster.internal/ubuntu noble/universe libsql-statement-perl 1.414-1 (tar) [160 kB] 153s Get:3 http://ftpmaster.internal/ubuntu noble/universe libsql-statement-perl 1.414-1 (diff) [6548 B] 154s gpgv: Signature made Fri Oct 23 22:56:13 2020 UTC 154s gpgv: using RSA key D1E1316E93A760A8104D85FABB3A68018649AA06 154s gpgv: Can't check signature: No public key 154s dpkg-source: warning: cannot verify inline signature for ./libsql-statement-perl_1.414-1.dsc: no acceptable signature found 154s autopkgtest [21:25:49]: testing package libsql-statement-perl version 1.414-1 154s autopkgtest [21:25:49]: build not needed 154s autopkgtest [21:25:49]: test autodep8-perl-build-deps: preparing testbed 157s Reading package lists... 157s Building dependency tree... 157s Reading state information... 157s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 157s Starting 2 pkgProblemResolver with broken count: 0 157s Done 158s Done 158s Starting pkgProblemResolver with broken count: 0 158s Starting 2 pkgProblemResolver with broken count: 0 158s Done 159s The following additional packages will be installed: 159s autoconf autodep8 automake autopoint autotools-dev build-essential cpp 159s cpp-13 cpp-13-aarch64-linux-gnu cpp-aarch64-linux-gnu dctrl-tools debhelper 159s debugedit dh-autoreconf dh-strip-nondeterminism dwz g++ g++-13 159s g++-13-aarch64-linux-gnu g++-aarch64-linux-gnu gcc gcc-13 159s gcc-13-aarch64-linux-gnu gcc-aarch64-linux-gnu gettext intltool-debian 159s libarchive-zip-perl libasan8 libatomic1 libb-hooks-op-check-perl 159s libc-dev-bin libc6-dev libcc1-0 libclone-perl libcrypt-dev libdbi-perl 159s libdebhelper-perl libdevel-callchecker-perl libdevel-symdump-perl libdw1 159s libdynaloader-functions-perl libfile-stripnondeterminism-perl libgcc-13-dev 159s libgomp1 libhwasan0 libisl23 libitm1 liblsan0 libmath-base-convert-perl 159s libmodule-runtime-perl libmpc3 libnsl-dev libparams-classify-perl 159s libparams-util-perl libpod-coverage-perl libpod-parser-perl 159s libsql-statement-perl libstdc++-13-dev libsub-override-perl 159s libtest-deep-perl libtest-pod-coverage-perl libtest-pod-perl 159s libtext-soundex-perl libtirpc-dev libtool libtsan2 libubsan1 linux-libc-dev 159s m4 pkg-perl-autopkgtest po-debconf rpcsvc-proto 159s Suggested packages: 159s autoconf-archive gnu-standards autoconf-doc cpp-doc gcc-13-locales 159s cpp-13-doc debtags dh-make gcc-13-doc gcc-multilib manpages-dev flex bison 159s gdb gcc-doc gdb-aarch64-linux-gnu gettext-doc libasprintf-dev 159s libgettextpo-dev glibc-doc libmldbm-perl libnet-daemon-perl 159s libscalar-number-perl libstdc++-13-doc libtool-doc gfortran 159s | fortran95-compiler gcj-jdk m4-doc libmail-box-perl 159s Recommended packages: 159s manpages manpages-dev libc-devtools libarchive-cpio-perl libltdl-dev 159s libmail-sendmail-perl 159s The following NEW packages will be installed: 159s autoconf autodep8 automake autopoint autotools-dev build-essential cpp 159s cpp-13 cpp-13-aarch64-linux-gnu cpp-aarch64-linux-gnu dctrl-tools debhelper 159s debugedit dh-autoreconf dh-strip-nondeterminism dwz g++ g++-13 159s g++-13-aarch64-linux-gnu g++-aarch64-linux-gnu gcc gcc-13 159s gcc-13-aarch64-linux-gnu gcc-aarch64-linux-gnu gettext intltool-debian 159s libarchive-zip-perl libasan8 libatomic1 libb-hooks-op-check-perl 159s libc-dev-bin libc6-dev libcc1-0 libclone-perl libcrypt-dev libdbi-perl 159s libdebhelper-perl libdevel-callchecker-perl libdevel-symdump-perl libdw1 159s libdynaloader-functions-perl libfile-stripnondeterminism-perl libgcc-13-dev 159s libgomp1 libhwasan0 libisl23 libitm1 liblsan0 libmath-base-convert-perl 159s libmodule-runtime-perl libmpc3 libnsl-dev libparams-classify-perl 159s libparams-util-perl libpod-coverage-perl libpod-parser-perl 159s libsql-statement-perl libstdc++-13-dev libsub-override-perl 159s libtest-deep-perl libtest-pod-coverage-perl libtest-pod-perl 159s libtext-soundex-perl libtirpc-dev libtool libtsan2 libubsan1 linux-libc-dev 159s m4 pkg-perl-autopkgtest po-debconf rpcsvc-proto 159s 0 upgraded, 72 newly installed, 0 to remove and 0 not upgraded. 159s 1 not fully installed or removed. 159s Need to get 67.4 MB of archives. 159s After this operation, 239 MB of additional disk space will be used. 159s Get:1 http://ftpmaster.internal/ubuntu noble/main arm64 libclone-perl arm64 0.46-1build1 [10.4 kB] 159s Get:2 http://ftpmaster.internal/ubuntu noble/main arm64 libb-hooks-op-check-perl arm64 0.22-2build2 [9220 B] 159s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 libdynaloader-functions-perl all 0.003-3 [12.1 kB] 159s Get:4 http://ftpmaster.internal/ubuntu noble/main arm64 libdevel-callchecker-perl arm64 0.008-2build1 [13.7 kB] 159s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 libparams-classify-perl arm64 0.015-2build3 [19.6 kB] 159s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 libmodule-runtime-perl all 0.016-2 [16.4 kB] 159s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 libparams-util-perl arm64 1.102-2build1 [20.5 kB] 159s Get:8 http://ftpmaster.internal/ubuntu noble/universe arm64 libsql-statement-perl all 1.414-1 [153 kB] 159s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 autotools-dev all 20220109.1 [44.9 kB] 159s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 m4 arm64 1.4.19-4 [240 kB] 159s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 autoconf all 2.71-3 [339 kB] 159s Get:12 http://ftpmaster.internal/ubuntu noble/main arm64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 159s Get:13 http://ftpmaster.internal/ubuntu noble/main arm64 autopoint all 0.21-14ubuntu1 [422 kB] 159s Get:14 http://ftpmaster.internal/ubuntu noble/main arm64 libdebhelper-perl all 13.14.1ubuntu1 [89.5 kB] 159s Get:15 http://ftpmaster.internal/ubuntu noble/main arm64 libisl23 arm64 0.26-3 [713 kB] 159s Get:16 http://ftpmaster.internal/ubuntu noble/main arm64 libmpc3 arm64 1.3.1-1 [55.3 kB] 159s Get:17 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [10.3 MB] 160s Get:18 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-13 arm64 13.2.0-17ubuntu2 [1028 B] 160s Get:19 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [5316 B] 160s Get:20 http://ftpmaster.internal/ubuntu noble/main arm64 cpp arm64 4:13.2.0-7ubuntu1 [22.4 kB] 160s Get:21 http://ftpmaster.internal/ubuntu noble/main arm64 libcc1-0 arm64 14-20240303-1ubuntu1 [44.7 kB] 160s Get:22 http://ftpmaster.internal/ubuntu noble/main arm64 libgomp1 arm64 14-20240303-1ubuntu1 [144 kB] 160s Get:23 http://ftpmaster.internal/ubuntu noble/main arm64 libitm1 arm64 14-20240303-1ubuntu1 [27.7 kB] 160s Get:24 http://ftpmaster.internal/ubuntu noble/main arm64 libatomic1 arm64 14-20240303-1ubuntu1 [11.4 kB] 160s Get:25 http://ftpmaster.internal/ubuntu noble/main arm64 libasan8 arm64 14-20240303-1ubuntu1 [2919 kB] 160s Get:26 http://ftpmaster.internal/ubuntu noble/main arm64 liblsan0 arm64 14-20240303-1ubuntu1 [1282 kB] 160s Get:27 http://ftpmaster.internal/ubuntu noble/main arm64 libtsan2 arm64 14-20240303-1ubuntu1 [2687 kB] 160s Get:28 http://ftpmaster.internal/ubuntu noble/main arm64 libubsan1 arm64 14-20240303-1ubuntu1 [1151 kB] 160s Get:29 http://ftpmaster.internal/ubuntu noble/main arm64 libhwasan0 arm64 14-20240303-1ubuntu1 [1597 kB] 160s Get:30 http://ftpmaster.internal/ubuntu noble/main arm64 libgcc-13-dev arm64 13.2.0-17ubuntu2 [2464 kB] 160s Get:31 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [20.1 MB] 160s Get:32 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-13 arm64 13.2.0-17ubuntu2 [467 kB] 160s Get:33 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [1198 B] 160s Get:34 http://ftpmaster.internal/ubuntu noble/main arm64 gcc arm64 4:13.2.0-7ubuntu1 [5018 B] 160s Get:35 http://ftpmaster.internal/ubuntu noble/main arm64 libc-dev-bin arm64 2.39-0ubuntu2 [19.7 kB] 160s Get:36 http://ftpmaster.internal/ubuntu noble/main arm64 linux-libc-dev arm64 6.8.0-11.11 [1569 kB] 160s Get:37 http://ftpmaster.internal/ubuntu noble/main arm64 libcrypt-dev arm64 1:4.4.36-4 [136 kB] 160s Get:38 http://ftpmaster.internal/ubuntu noble/main arm64 libtirpc-dev arm64 1.3.4+ds-1build1 [232 kB] 160s Get:39 http://ftpmaster.internal/ubuntu noble/main arm64 libnsl-dev arm64 1.3.0-3 [71.9 kB] 160s Get:40 http://ftpmaster.internal/ubuntu noble/main arm64 rpcsvc-proto arm64 1.4.2-0ubuntu6 [65.4 kB] 160s Get:41 http://ftpmaster.internal/ubuntu noble/main arm64 libc6-dev arm64 2.39-0ubuntu2 [1596 kB] 160s Get:42 http://ftpmaster.internal/ubuntu noble/main arm64 libtool all 2.4.7-7 [166 kB] 160s Get:43 http://ftpmaster.internal/ubuntu noble/main arm64 dh-autoreconf all 20 [16.1 kB] 160s Get:44 http://ftpmaster.internal/ubuntu noble/main arm64 libarchive-zip-perl all 1.68-1 [90.2 kB] 160s Get:45 http://ftpmaster.internal/ubuntu noble/main arm64 libsub-override-perl all 0.10-1 [10.0 kB] 160s Get:46 http://ftpmaster.internal/ubuntu noble/main arm64 libfile-stripnondeterminism-perl all 1.13.1-1 [18.1 kB] 160s Get:47 http://ftpmaster.internal/ubuntu noble/main arm64 dh-strip-nondeterminism all 1.13.1-1 [5362 B] 160s Get:48 http://ftpmaster.internal/ubuntu noble/main arm64 libdw1 arm64 0.190-1 [254 kB] 160s Get:49 http://ftpmaster.internal/ubuntu noble/main arm64 debugedit arm64 1:5.0-5 [45.9 kB] 160s Get:50 http://ftpmaster.internal/ubuntu noble/main arm64 dwz arm64 0.15-1 [110 kB] 161s Get:51 http://ftpmaster.internal/ubuntu noble/main arm64 gettext arm64 0.21-14ubuntu1 [846 kB] 161s Get:52 http://ftpmaster.internal/ubuntu noble/main arm64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 161s Get:53 http://ftpmaster.internal/ubuntu noble/main arm64 po-debconf all 1.0.21+nmu1 [233 kB] 161s Get:54 http://ftpmaster.internal/ubuntu noble/main arm64 debhelper all 13.14.1ubuntu1 [869 kB] 161s Get:55 http://ftpmaster.internal/ubuntu noble/main arm64 libdbi-perl arm64 1.643-4build1 [718 kB] 161s Get:56 http://ftpmaster.internal/ubuntu noble/universe arm64 libmath-base-convert-perl all 0.11-4 [29.1 kB] 161s Get:57 http://ftpmaster.internal/ubuntu noble/universe arm64 libtest-deep-perl all 1.204-1 [47.1 kB] 161s Get:58 http://ftpmaster.internal/ubuntu noble/main arm64 libdevel-symdump-perl all 2.18-5 [12.6 kB] 161s Get:59 http://ftpmaster.internal/ubuntu noble/main arm64 libpod-parser-perl all 1.67-1 [80.6 kB] 161s Get:60 http://ftpmaster.internal/ubuntu noble/universe arm64 libpod-coverage-perl all 0.23-2 [19.3 kB] 161s Get:61 http://ftpmaster.internal/ubuntu noble/universe arm64 libtest-pod-coverage-perl all 1.10-3 [13.6 kB] 161s Get:62 http://ftpmaster.internal/ubuntu noble/universe arm64 libtest-pod-perl all 1.52-2 [8720 B] 161s Get:63 http://ftpmaster.internal/ubuntu noble/universe arm64 libtext-soundex-perl arm64 3.05-2build1 [12.8 kB] 161s Get:64 http://ftpmaster.internal/ubuntu noble/main arm64 libstdc++-13-dev arm64 13.2.0-17ubuntu2 [2322 kB] 161s Get:65 http://ftpmaster.internal/ubuntu noble/main arm64 g++-13-aarch64-linux-gnu arm64 13.2.0-17ubuntu2 [11.7 MB] 161s Get:66 http://ftpmaster.internal/ubuntu noble/main arm64 g++-13 arm64 13.2.0-17ubuntu2 [14.4 kB] 161s Get:67 http://ftpmaster.internal/ubuntu noble/main arm64 g++-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [962 B] 161s Get:68 http://ftpmaster.internal/ubuntu noble/main arm64 g++ arm64 4:13.2.0-7ubuntu1 [1082 B] 161s Get:69 http://ftpmaster.internal/ubuntu noble/main arm64 build-essential arm64 12.10ubuntu1 [4932 B] 161s Get:70 http://ftpmaster.internal/ubuntu noble/main arm64 dctrl-tools arm64 2.24-3build2 [65.2 kB] 161s Get:71 http://ftpmaster.internal/ubuntu noble/main arm64 autodep8 all 0.28 [13.2 kB] 161s Get:72 http://ftpmaster.internal/ubuntu noble/universe arm64 pkg-perl-autopkgtest all 0.77 [18.0 kB] 162s Fetched 67.4 MB in 2s (30.1 MB/s) 162s Selecting previously unselected package libclone-perl:arm64. 162s (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 ... 74306 files and directories currently installed.) 162s Preparing to unpack .../00-libclone-perl_0.46-1build1_arm64.deb ... 162s Unpacking libclone-perl:arm64 (0.46-1build1) ... 162s Selecting previously unselected package libb-hooks-op-check-perl:arm64. 162s Preparing to unpack .../01-libb-hooks-op-check-perl_0.22-2build2_arm64.deb ... 162s Unpacking libb-hooks-op-check-perl:arm64 (0.22-2build2) ... 162s Selecting previously unselected package libdynaloader-functions-perl. 162s Preparing to unpack .../02-libdynaloader-functions-perl_0.003-3_all.deb ... 162s Unpacking libdynaloader-functions-perl (0.003-3) ... 162s Selecting previously unselected package libdevel-callchecker-perl:arm64. 162s Preparing to unpack .../03-libdevel-callchecker-perl_0.008-2build1_arm64.deb ... 162s Unpacking libdevel-callchecker-perl:arm64 (0.008-2build1) ... 162s Selecting previously unselected package libparams-classify-perl:arm64. 162s Preparing to unpack .../04-libparams-classify-perl_0.015-2build3_arm64.deb ... 162s Unpacking libparams-classify-perl:arm64 (0.015-2build3) ... 162s Selecting previously unselected package libmodule-runtime-perl. 162s Preparing to unpack .../05-libmodule-runtime-perl_0.016-2_all.deb ... 162s Unpacking libmodule-runtime-perl (0.016-2) ... 162s Selecting previously unselected package libparams-util-perl. 162s Preparing to unpack .../06-libparams-util-perl_1.102-2build1_arm64.deb ... 162s Unpacking libparams-util-perl (1.102-2build1) ... 162s Selecting previously unselected package libsql-statement-perl. 162s Preparing to unpack .../07-libsql-statement-perl_1.414-1_all.deb ... 162s Unpacking libsql-statement-perl (1.414-1) ... 162s Selecting previously unselected package autotools-dev. 162s Preparing to unpack .../08-autotools-dev_20220109.1_all.deb ... 162s Unpacking autotools-dev (20220109.1) ... 162s Selecting previously unselected package m4. 162s Preparing to unpack .../09-m4_1.4.19-4_arm64.deb ... 162s Unpacking m4 (1.4.19-4) ... 162s Selecting previously unselected package autoconf. 162s Preparing to unpack .../10-autoconf_2.71-3_all.deb ... 162s Unpacking autoconf (2.71-3) ... 162s Selecting previously unselected package automake. 162s Preparing to unpack .../11-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 162s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 162s Selecting previously unselected package autopoint. 162s Preparing to unpack .../12-autopoint_0.21-14ubuntu1_all.deb ... 162s Unpacking autopoint (0.21-14ubuntu1) ... 162s Selecting previously unselected package libdebhelper-perl. 162s Preparing to unpack .../13-libdebhelper-perl_13.14.1ubuntu1_all.deb ... 162s Unpacking libdebhelper-perl (13.14.1ubuntu1) ... 162s Selecting previously unselected package libisl23:arm64. 162s Preparing to unpack .../14-libisl23_0.26-3_arm64.deb ... 162s Unpacking libisl23:arm64 (0.26-3) ... 162s Selecting previously unselected package libmpc3:arm64. 162s Preparing to unpack .../15-libmpc3_1.3.1-1_arm64.deb ... 162s Unpacking libmpc3:arm64 (1.3.1-1) ... 162s Selecting previously unselected package cpp-13-aarch64-linux-gnu. 163s Preparing to unpack .../16-cpp-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 163s Unpacking cpp-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 163s Selecting previously unselected package cpp-13. 163s Preparing to unpack .../17-cpp-13_13.2.0-17ubuntu2_arm64.deb ... 163s Unpacking cpp-13 (13.2.0-17ubuntu2) ... 163s Selecting previously unselected package cpp-aarch64-linux-gnu. 163s Preparing to unpack .../18-cpp-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 163s Unpacking cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 163s Selecting previously unselected package cpp. 163s Preparing to unpack .../19-cpp_4%3a13.2.0-7ubuntu1_arm64.deb ... 163s Unpacking cpp (4:13.2.0-7ubuntu1) ... 163s Selecting previously unselected package libcc1-0:arm64. 163s Preparing to unpack .../20-libcc1-0_14-20240303-1ubuntu1_arm64.deb ... 163s Unpacking libcc1-0:arm64 (14-20240303-1ubuntu1) ... 163s Selecting previously unselected package libgomp1:arm64. 163s Preparing to unpack .../21-libgomp1_14-20240303-1ubuntu1_arm64.deb ... 163s Unpacking libgomp1:arm64 (14-20240303-1ubuntu1) ... 163s Selecting previously unselected package libitm1:arm64. 163s Preparing to unpack .../22-libitm1_14-20240303-1ubuntu1_arm64.deb ... 163s Unpacking libitm1:arm64 (14-20240303-1ubuntu1) ... 163s Selecting previously unselected package libatomic1:arm64. 163s Preparing to unpack .../23-libatomic1_14-20240303-1ubuntu1_arm64.deb ... 163s Unpacking libatomic1:arm64 (14-20240303-1ubuntu1) ... 163s Selecting previously unselected package libasan8:arm64. 163s Preparing to unpack .../24-libasan8_14-20240303-1ubuntu1_arm64.deb ... 163s Unpacking libasan8:arm64 (14-20240303-1ubuntu1) ... 163s Selecting previously unselected package liblsan0:arm64. 163s Preparing to unpack .../25-liblsan0_14-20240303-1ubuntu1_arm64.deb ... 163s Unpacking liblsan0:arm64 (14-20240303-1ubuntu1) ... 163s Selecting previously unselected package libtsan2:arm64. 163s Preparing to unpack .../26-libtsan2_14-20240303-1ubuntu1_arm64.deb ... 163s Unpacking libtsan2:arm64 (14-20240303-1ubuntu1) ... 164s Selecting previously unselected package libubsan1:arm64. 164s Preparing to unpack .../27-libubsan1_14-20240303-1ubuntu1_arm64.deb ... 164s Unpacking libubsan1:arm64 (14-20240303-1ubuntu1) ... 164s Selecting previously unselected package libhwasan0:arm64. 164s Preparing to unpack .../28-libhwasan0_14-20240303-1ubuntu1_arm64.deb ... 164s Unpacking libhwasan0:arm64 (14-20240303-1ubuntu1) ... 164s Selecting previously unselected package libgcc-13-dev:arm64. 164s Preparing to unpack .../29-libgcc-13-dev_13.2.0-17ubuntu2_arm64.deb ... 164s Unpacking libgcc-13-dev:arm64 (13.2.0-17ubuntu2) ... 164s Selecting previously unselected package gcc-13-aarch64-linux-gnu. 164s Preparing to unpack .../30-gcc-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 164s Unpacking gcc-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 164s Selecting previously unselected package gcc-13. 165s Preparing to unpack .../31-gcc-13_13.2.0-17ubuntu2_arm64.deb ... 165s Unpacking gcc-13 (13.2.0-17ubuntu2) ... 165s Selecting previously unselected package gcc-aarch64-linux-gnu. 165s Preparing to unpack .../32-gcc-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 165s Unpacking gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 165s Selecting previously unselected package gcc. 165s Preparing to unpack .../33-gcc_4%3a13.2.0-7ubuntu1_arm64.deb ... 165s Unpacking gcc (4:13.2.0-7ubuntu1) ... 165s Selecting previously unselected package libc-dev-bin. 166s Preparing to unpack .../34-libc-dev-bin_2.39-0ubuntu2_arm64.deb ... 166s Unpacking libc-dev-bin (2.39-0ubuntu2) ... 166s Selecting previously unselected package linux-libc-dev:arm64. 166s Preparing to unpack .../35-linux-libc-dev_6.8.0-11.11_arm64.deb ... 166s Unpacking linux-libc-dev:arm64 (6.8.0-11.11) ... 166s Selecting previously unselected package libcrypt-dev:arm64. 166s Preparing to unpack .../36-libcrypt-dev_1%3a4.4.36-4_arm64.deb ... 166s Unpacking libcrypt-dev:arm64 (1:4.4.36-4) ... 166s Selecting previously unselected package libtirpc-dev:arm64. 166s Preparing to unpack .../37-libtirpc-dev_1.3.4+ds-1build1_arm64.deb ... 166s Unpacking libtirpc-dev:arm64 (1.3.4+ds-1build1) ... 166s Selecting previously unselected package libnsl-dev:arm64. 166s Preparing to unpack .../38-libnsl-dev_1.3.0-3_arm64.deb ... 166s Unpacking libnsl-dev:arm64 (1.3.0-3) ... 166s Selecting previously unselected package rpcsvc-proto. 167s Preparing to unpack .../39-rpcsvc-proto_1.4.2-0ubuntu6_arm64.deb ... 167s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 167s Selecting previously unselected package libc6-dev:arm64. 167s Preparing to unpack .../40-libc6-dev_2.39-0ubuntu2_arm64.deb ... 167s Unpacking libc6-dev:arm64 (2.39-0ubuntu2) ... 167s Selecting previously unselected package libtool. 167s Preparing to unpack .../41-libtool_2.4.7-7_all.deb ... 167s Unpacking libtool (2.4.7-7) ... 167s Selecting previously unselected package dh-autoreconf. 167s Preparing to unpack .../42-dh-autoreconf_20_all.deb ... 167s Unpacking dh-autoreconf (20) ... 167s Selecting previously unselected package libarchive-zip-perl. 167s Preparing to unpack .../43-libarchive-zip-perl_1.68-1_all.deb ... 167s Unpacking libarchive-zip-perl (1.68-1) ... 167s Selecting previously unselected package libsub-override-perl. 167s Preparing to unpack .../44-libsub-override-perl_0.10-1_all.deb ... 167s Unpacking libsub-override-perl (0.10-1) ... 168s Selecting previously unselected package libfile-stripnondeterminism-perl. 168s Preparing to unpack .../45-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... 168s Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... 168s Selecting previously unselected package dh-strip-nondeterminism. 168s Preparing to unpack .../46-dh-strip-nondeterminism_1.13.1-1_all.deb ... 168s Unpacking dh-strip-nondeterminism (1.13.1-1) ... 168s Selecting previously unselected package libdw1:arm64. 168s Preparing to unpack .../47-libdw1_0.190-1_arm64.deb ... 168s Unpacking libdw1:arm64 (0.190-1) ... 168s Selecting previously unselected package debugedit. 168s Preparing to unpack .../48-debugedit_1%3a5.0-5_arm64.deb ... 168s Unpacking debugedit (1:5.0-5) ... 169s Selecting previously unselected package dwz. 169s Preparing to unpack .../49-dwz_0.15-1_arm64.deb ... 169s Unpacking dwz (0.15-1) ... 169s Selecting previously unselected package gettext. 169s Preparing to unpack .../50-gettext_0.21-14ubuntu1_arm64.deb ... 169s Unpacking gettext (0.21-14ubuntu1) ... 169s Selecting previously unselected package intltool-debian. 169s Preparing to unpack .../51-intltool-debian_0.35.0+20060710.6_all.deb ... 169s Unpacking intltool-debian (0.35.0+20060710.6) ... 169s Selecting previously unselected package po-debconf. 169s Preparing to unpack .../52-po-debconf_1.0.21+nmu1_all.deb ... 169s Unpacking po-debconf (1.0.21+nmu1) ... 169s Selecting previously unselected package debhelper. 169s Preparing to unpack .../53-debhelper_13.14.1ubuntu1_all.deb ... 169s Unpacking debhelper (13.14.1ubuntu1) ... 169s Selecting previously unselected package libdbi-perl:arm64. 169s Preparing to unpack .../54-libdbi-perl_1.643-4build1_arm64.deb ... 169s Unpacking libdbi-perl:arm64 (1.643-4build1) ... 169s Selecting previously unselected package libmath-base-convert-perl. 169s Preparing to unpack .../55-libmath-base-convert-perl_0.11-4_all.deb ... 169s Unpacking libmath-base-convert-perl (0.11-4) ... 169s Selecting previously unselected package libtest-deep-perl. 169s Preparing to unpack .../56-libtest-deep-perl_1.204-1_all.deb ... 169s Unpacking libtest-deep-perl (1.204-1) ... 169s Selecting previously unselected package libdevel-symdump-perl. 169s Preparing to unpack .../57-libdevel-symdump-perl_2.18-5_all.deb ... 169s Unpacking libdevel-symdump-perl (2.18-5) ... 169s Selecting previously unselected package libpod-parser-perl. 169s Preparing to unpack .../58-libpod-parser-perl_1.67-1_all.deb ... 169s Adding 'diversion of /usr/bin/podselect to /usr/bin/podselect.bundled by libpod-parser-perl' 169s Adding 'diversion of /usr/share/man/man1/podselect.1.gz to /usr/share/man/man1/podselect.bundled.1.gz by libpod-parser-perl' 169s Unpacking libpod-parser-perl (1.67-1) ... 169s Selecting previously unselected package libpod-coverage-perl. 169s Preparing to unpack .../59-libpod-coverage-perl_0.23-2_all.deb ... 169s Unpacking libpod-coverage-perl (0.23-2) ... 169s Selecting previously unselected package libtest-pod-coverage-perl. 169s Preparing to unpack .../60-libtest-pod-coverage-perl_1.10-3_all.deb ... 169s Unpacking libtest-pod-coverage-perl (1.10-3) ... 169s Selecting previously unselected package libtest-pod-perl. 169s Preparing to unpack .../61-libtest-pod-perl_1.52-2_all.deb ... 169s Unpacking libtest-pod-perl (1.52-2) ... 169s Selecting previously unselected package libtext-soundex-perl. 169s Preparing to unpack .../62-libtext-soundex-perl_3.05-2build1_arm64.deb ... 169s Unpacking libtext-soundex-perl (3.05-2build1) ... 169s Selecting previously unselected package libstdc++-13-dev:arm64. 169s Preparing to unpack .../63-libstdc++-13-dev_13.2.0-17ubuntu2_arm64.deb ... 169s Unpacking libstdc++-13-dev:arm64 (13.2.0-17ubuntu2) ... 170s Selecting previously unselected package g++-13-aarch64-linux-gnu. 170s Preparing to unpack .../64-g++-13-aarch64-linux-gnu_13.2.0-17ubuntu2_arm64.deb ... 170s Unpacking g++-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 170s Selecting previously unselected package g++-13. 170s Preparing to unpack .../65-g++-13_13.2.0-17ubuntu2_arm64.deb ... 170s Unpacking g++-13 (13.2.0-17ubuntu2) ... 170s Selecting previously unselected package g++-aarch64-linux-gnu. 170s Preparing to unpack .../66-g++-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 170s Unpacking g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 170s Selecting previously unselected package g++. 170s Preparing to unpack .../67-g++_4%3a13.2.0-7ubuntu1_arm64.deb ... 170s Unpacking g++ (4:13.2.0-7ubuntu1) ... 170s Selecting previously unselected package build-essential. 170s Preparing to unpack .../68-build-essential_12.10ubuntu1_arm64.deb ... 170s Unpacking build-essential (12.10ubuntu1) ... 170s Selecting previously unselected package dctrl-tools. 170s Preparing to unpack .../69-dctrl-tools_2.24-3build2_arm64.deb ... 170s Unpacking dctrl-tools (2.24-3build2) ... 170s Selecting previously unselected package autodep8. 170s Preparing to unpack .../70-autodep8_0.28_all.deb ... 170s Unpacking autodep8 (0.28) ... 170s Selecting previously unselected package pkg-perl-autopkgtest. 170s Preparing to unpack .../71-pkg-perl-autopkgtest_0.77_all.deb ... 170s Unpacking pkg-perl-autopkgtest (0.77) ... 170s Setting up libdw1:arm64 (0.190-1) ... 170s Setting up libdynaloader-functions-perl (0.003-3) ... 170s Setting up libtest-deep-perl (1.204-1) ... 170s Setting up libclone-perl:arm64 (0.46-1build1) ... 170s Setting up libarchive-zip-perl (1.68-1) ... 170s Setting up libdebhelper-perl (13.14.1ubuntu1) ... 170s Setting up libtest-pod-perl (1.52-2) ... 170s Setting up linux-libc-dev:arm64 (6.8.0-11.11) ... 170s Setting up m4 (1.4.19-4) ... 170s Setting up libgomp1:arm64 (14-20240303-1ubuntu1) ... 170s Setting up autotools-dev (20220109.1) ... 170s Setting up libtirpc-dev:arm64 (1.3.4+ds-1build1) ... 170s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 170s Setting up libmpc3:arm64 (1.3.1-1) ... 170s Setting up libatomic1:arm64 (14-20240303-1ubuntu1) ... 170s Setting up libpod-parser-perl (1.67-1) ... 170s Setting up autopoint (0.21-14ubuntu1) ... 170s Setting up libb-hooks-op-check-perl:arm64 (0.22-2build2) ... 170s Setting up libparams-util-perl (1.102-2build1) ... 170s Setting up autoconf (2.71-3) ... 170s Setting up libubsan1:arm64 (14-20240303-1ubuntu1) ... 170s Setting up dwz (0.15-1) ... 170s Setting up libnsl-dev:arm64 (1.3.0-3) ... 170s Setting up libhwasan0:arm64 (14-20240303-1ubuntu1) ... 170s Setting up libcrypt-dev:arm64 (1:4.4.36-4) ... 170s Setting up libasan8:arm64 (14-20240303-1ubuntu1) ... 170s Setting up debugedit (1:5.0-5) ... 170s Setting up libsub-override-perl (0.10-1) ... 170s Setting up libtext-soundex-perl (3.05-2build1) ... 170s Setting up libdevel-symdump-perl (2.18-5) ... 170s Setting up libtsan2:arm64 (14-20240303-1ubuntu1) ... 170s Setting up libisl23:arm64 (0.26-3) ... 170s Setting up libc-dev-bin (2.39-0ubuntu2) ... 170s Setting up libmath-base-convert-perl (0.11-4) ... 170s Setting up libcc1-0:arm64 (14-20240303-1ubuntu1) ... 170s Setting up libdbi-perl:arm64 (1.643-4build1) ... 170s Setting up liblsan0:arm64 (14-20240303-1ubuntu1) ... 170s Setting up dctrl-tools (2.24-3build2) ... 170s Setting up libitm1:arm64 (14-20240303-1ubuntu1) ... 170s Setting up autodep8 (0.28) ... 170s Setting up automake (1:1.16.5-1.3ubuntu1) ... 170s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 170s Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... 170s Setting up gettext (0.21-14ubuntu1) ... 170s Setting up cpp-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 170s Setting up libpod-coverage-perl (0.23-2) ... 170s Setting up libdevel-callchecker-perl:arm64 (0.008-2build1) ... 170s Setting up intltool-debian (0.35.0+20060710.6) ... 170s Setting up cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 170s Setting up pkg-perl-autopkgtest (0.77) ... 170s Setting up dh-strip-nondeterminism (1.13.1-1) ... 170s Setting up libgcc-13-dev:arm64 (13.2.0-17ubuntu2) ... 170s Setting up libc6-dev:arm64 (2.39-0ubuntu2) ... 170s Setting up libtest-pod-coverage-perl (1.10-3) ... 170s Setting up libstdc++-13-dev:arm64 (13.2.0-17ubuntu2) ... 170s Setting up cpp-13 (13.2.0-17ubuntu2) ... 170s Setting up po-debconf (1.0.21+nmu1) ... 170s Setting up libparams-classify-perl:arm64 (0.015-2build3) ... 170s Setting up gcc-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 170s Setting up libmodule-runtime-perl (0.016-2) ... 170s Setting up gcc-13 (13.2.0-17ubuntu2) ... 170s Setting up cpp (4:13.2.0-7ubuntu1) ... 170s Setting up g++-13-aarch64-linux-gnu (13.2.0-17ubuntu2) ... 170s Setting up gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 170s Setting up g++-13 (13.2.0-17ubuntu2) ... 170s Setting up libsql-statement-perl (1.414-1) ... 170s Setting up libtool (2.4.7-7) ... 170s Setting up gcc (4:13.2.0-7ubuntu1) ... 170s Setting up dh-autoreconf (20) ... 170s Setting up g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 170s Setting up debhelper (13.14.1ubuntu1) ... 170s Setting up g++ (4:13.2.0-7ubuntu1) ... 170s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 170s Setting up build-essential (12.10ubuntu1) ... 170s Setting up autopkgtest-satdep (0) ... 170s Processing triggers for man-db (2.12.0-3) ... 172s Processing triggers for install-info (7.1-3) ... 172s Processing triggers for libc-bin (2.39-0ubuntu2) ... 176s (Reading database ... 78717 files and directories currently installed.) 176s Removing autopkgtest-satdep (0) ... 177s autopkgtest [21:26:12]: test autodep8-perl-build-deps: /usr/share/pkg-perl-autopkgtest/runner build-deps 177s autopkgtest [21:26:12]: test autodep8-perl-build-deps: [----------------------- 178s t/00error.t ..... 178s # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 178s # # Using required: 178s # # SQL::Statement: 1.414 178s # # Using recommended: 178s # # DBD::DBM: 0.08 178s # # DBD::File: 0.44 178s # # DBI: 1.643 178s # Running tests for SQL::Statement 178s ok 1 - Parse "Junk" RaiseError=0 (default) 178s ok 2 - Execute function succeeded 178s ok 3 - Execute function no errstr 178s ok 4 - Execute RaiseError=0 178s ok 5 - Parse "Junk" RaiseError=1 178s ok 6 - Execute RaiseError=1 178s ok 7 - Execute "SELECT * FROM nonexistant" has errstr 178s # Running tests for DBD::DBM 178s ok 8 - Parse "Junk" RaiseError=0 (default) 178s ok 9 - Execute function succeeded 178s ok 10 - Execute function no errstr 178s ok 11 - Execute RaiseError=0 178s ok 12 - Parse "Junk" RaiseError=1 178s ok 13 - Execute RaiseError=1 178s ok 14 - Execute "SELECT * FROM nonexistant" has errstr 178s # Running tests for DBD::File 178s ok 15 - Parse "Junk" RaiseError=0 (default) 178s ok 16 - Execute function succeeded 178s ok 17 - Execute function no errstr 178s ok 18 - Execute RaiseError=0 178s ok 19 - Parse "Junk" RaiseError=1 178s ok 20 - Execute RaiseError=1 178s ok 21 - Execute "SELECT * FROM nonexistant" has errstr 178s 1..21 178s ok 178s t/01prepare.t ... 178s # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 178s ok 1 - parse ' /* DROP TABLE */' using SQL::Statement 178s ok 2 - parse 'DROP TABLE foo' using SQL::Statement 178s ok 3 - parse 'DROP TABLE foo CASCADE' using SQL::Statement 178s ok 4 - parse 'DROP TABLE foo RESTRICT' using SQL::Statement 178s ok 5 - parse ' /* DELETE */' using SQL::Statement 178s ok 6 - parse 'DELETE FROM foo' using SQL::Statement 178s ok 7 - parse 'DELETE FROM foo WHERE id < 7' using SQL::Statement 178s ok 8 - parse ' /* UPDATE */' using SQL::Statement 178s ok 9 - parse 'UPDATE foo SET bar = 7' using SQL::Statement 178s ok 10 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using SQL::Statement 178s ok 11 - parse ' /* INSERT */' using SQL::Statement 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 12 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using SQL::Statement 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 13 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using SQL::Statement 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 14 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using SQL::Statement 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 15 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using SQL::Statement 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 16 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using SQL::Statement 178s ok 17 - parse ' /* CREATE TABLE */' using SQL::Statement 178s ok 18 - parse 'CREATE TABLE foo ( id INT )' using SQL::Statement 178s ok 19 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using SQL::Statement 178s ok 20 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using SQL::Statement 178s ok 21 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using SQL::Statement 178s ok 22 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using SQL::Statement 178s ok 23 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using SQL::Statement 178s ok 24 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using SQL::Statement 178s ok 25 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using SQL::Statement 178s ok 26 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using SQL::Statement 178s ok 27 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using SQL::Statement 178s ok 28 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using SQL::Statement 178s ok 29 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using SQL::Statement 178s ok 30 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using SQL::Statement 178s ok 31 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using SQL::Statement 178s ok 32 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using SQL::Statement 178s ok 33 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using SQL::Statement 178s ok 34 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using SQL::Statement 178s ok 35 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using SQL::Statement 178s ok 36 - parse ' /* JOINS */' using SQL::Statement 178s ok 37 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using SQL::Statement 178s ok 38 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using SQL::Statement 178s ok 39 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using SQL::Statement 178s ok 40 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using SQL::Statement 178s ok 41 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using SQL::Statement 178s ok 42 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using SQL::Statement 178s ok 43 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using SQL::Statement 178s ok 44 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using SQL::Statement 178s ok 45 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using SQL::Statement 178s ok 46 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using SQL::Statement 178s ok 47 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using SQL::Statement 178s ok 48 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using SQL::Statement 178s ok 49 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using SQL::Statement 178s ok 50 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using SQL::Statement 178s ok 51 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using SQL::Statement 178s ok 52 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using SQL::Statement 178s ok 53 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using SQL::Statement 178s ok 54 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using SQL::Statement 178s ok 55 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using SQL::Statement 178s ok 56 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using SQL::Statement 178s ok 57 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using SQL::Statement 178s ok 58 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using SQL::Statement 178s ok 59 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using SQL::Statement 178s ok 60 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using SQL::Statement 178s ok 61 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using SQL::Statement 178s ok 62 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using SQL::Statement 178s ok 63 - parse ' /* SELECT COLUMNS */' using SQL::Statement 178s ok 64 - parse 'SELECT id, phrase FROM foo' using SQL::Statement 178s ok 65 - parse 'SELECT * FROM foo' using SQL::Statement 178s ok 66 - parse 'SELECT DISTINCT * FROM foo' using SQL::Statement 178s ok 67 - parse 'SELECT ALL * FROM foo' using SQL::Statement 178s ok 68 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using SQL::Statement 178s ok 69 - parse ' /* SET FUNCTIONS */' using SQL::Statement 178s ok 70 - parse 'SELECT MAX(foo) FROM bar' using SQL::Statement 178s ok 71 - parse 'SELECT MIN(foo) FROM bar' using SQL::Statement 178s ok 72 - parse 'SELECT AVG(foo) FROM bar' using SQL::Statement 178s ok 73 - parse 'SELECT SUM(foo) FROM bar' using SQL::Statement 178s ok 74 - parse 'SELECT COUNT(foo) FROM foo' using SQL::Statement 178s ok 75 - parse 'SELECT COUNT(*) FROM foo' using SQL::Statement 178s ok 76 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using SQL::Statement 178s ok 77 - parse 'SELECT SUM(ALL foo) FROM bar' using SQL::Statement 178s ok 78 - parse ' /* ORDER BY */' using SQL::Statement 178s ok 79 - parse 'SELECT * FROM foo ORDER BY bar' using SQL::Statement 178s ok 80 - parse 'SELECT * FROM foo ORDER BY bar, baz' using SQL::Statement 178s ok 81 - parse 'SELECT * FROM foo ORDER BY bar DESC' using SQL::Statement 178s ok 82 - parse 'SELECT * FROM foo ORDER BY bar ASC' using SQL::Statement 178s ok 83 - parse ' /* LIMIT */' using SQL::Statement 178s ok 84 - parse 'SELECT * FROM foo LIMIT 5' using SQL::Statement 178s ok 85 - parse 'SELECT * FROM foo LIMIT 0, 5' using SQL::Statement 178s ok 86 - parse 'SELECT * FROM foo LIMIT 5, 10' using SQL::Statement 178s ok 87 - parse '/* DATE/TIME FUNCTIONS */' using SQL::Statement 178s ok 88 - parse 'SELECT CURRENT_DATE()' using SQL::Statement 178s ok 89 - parse 'SELECT CURRENT_TIME()' using SQL::Statement 178s ok 90 - parse 'SELECT CURRENT_TIMESTAMP()' using SQL::Statement 178s ok 91 - parse 'SELECT CURDATE()' using SQL::Statement 178s ok 92 - parse 'SELECT CURTIME()' using SQL::Statement 178s ok 93 - parse 'SELECT NOW()' using SQL::Statement 178s ok 94 - parse 'SELECT UNIX_TIMESTAMP() ' using SQL::Statement 178s ok 95 - parse 'SELECT CURRENT_TIME(2)' using SQL::Statement 178s ok 96 - parse 'SELECT CURRENT_TIMESTAMP(2)' using SQL::Statement 178s ok 97 - parse 'SELECT CURTIME(2)' using SQL::Statement 178s ok 98 - parse 'SELECT NOW(2)' using SQL::Statement 178s ok 99 - parse 'SELECT UNIX_TIMESTAMP(2)' using SQL::Statement 178s ok 100 - parse ' /* STRING FUNCTIONS */' using SQL::Statement 178s ok 101 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using SQL::Statement 178s ok 102 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using SQL::Statement 178s ok 103 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using SQL::Statement 178s ok 104 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using SQL::Statement 178s ok 105 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using SQL::Statement 178s ok 106 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using SQL::Statement 178s ok 107 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using SQL::Statement 178s ok 108 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using SQL::Statement 178s ok 109 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using SQL::Statement 178s ok 110 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using SQL::Statement 178s ok 111 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using SQL::Statement 178s ok 112 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using SQL::Statement 178s ok 113 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using SQL::Statement 178s ok 114 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using SQL::Statement 178s ok 115 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using SQL::Statement 178s ok 116 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using SQL::Statement 178s ok 117 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using SQL::Statement 178s ok 118 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using SQL::Statement 178s ok 119 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using SQL::Statement 178s ok 120 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using SQL::Statement 178s ok 121 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using SQL::Statement 178s ok 122 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using SQL::Statement 178s ok 123 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using SQL::Statement 178s ok 124 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using SQL::Statement 178s ok 125 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using SQL::Statement 178s ok 126 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using SQL::Statement 178s ok 127 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using SQL::Statement 178s ok 128 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using SQL::Statement 178s ok 129 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using SQL::Statement 178s ok 130 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using SQL::Statement 178s ok 131 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using SQL::Statement 178s ok 132 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using SQL::Statement 178s ok 133 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using SQL::Statement 178s ok 134 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using SQL::Statement 178s ok 135 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using SQL::Statement 178s ok 136 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using SQL::Statement 178s ok 137 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using SQL::Statement 178s ok 138 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using SQL::Statement 178s ok 139 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using SQL::Statement 178s ok 140 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using SQL::Statement 178s ok 141 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using SQL::Statement 178s ok 142 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using SQL::Statement 178s ok 143 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using SQL::Statement 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 144 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using SQL::Statement 178s ok 145 - parse ' /* NUMERIC FUNCTIONS */' using SQL::Statement 178s ok 146 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using SQL::Statement 178s ok 147 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using SQL::Statement 178s ok 148 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using SQL::Statement 178s ok 149 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using SQL::Statement 178s ok 150 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using SQL::Statement 178s ok 151 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using SQL::Statement 178s ok 152 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using SQL::Statement 178s ok 153 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using SQL::Statement 178s ok 154 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using SQL::Statement 178s ok 155 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using SQL::Statement 178s ok 156 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using SQL::Statement 178s ok 157 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using SQL::Statement 178s ok 158 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using SQL::Statement 178s ok 159 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using SQL::Statement 178s ok 160 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using SQL::Statement 178s ok 161 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using SQL::Statement 178s ok 162 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using SQL::Statement 178s ok 163 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using SQL::Statement 178s ok 164 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using SQL::Statement 178s ok 165 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using SQL::Statement 178s ok 166 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using SQL::Statement 178s ok 167 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using SQL::Statement 178s ok 168 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using SQL::Statement 178s ok 169 - parse 'SELECT * FROM test WHERE ACOS(x)' using SQL::Statement 178s ok 170 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using SQL::Statement 178s ok 171 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using SQL::Statement 178s ok 172 - parse 'SELECT * FROM test WHERE ACOSH(x)' using SQL::Statement 178s ok 173 - parse 'SELECT * FROM test WHERE ACOT(x)' using SQL::Statement 178s ok 174 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using SQL::Statement 178s ok 175 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using SQL::Statement 178s ok 176 - parse 'SELECT * FROM test WHERE ACOTH(x)' using SQL::Statement 178s ok 177 - parse 'SELECT * FROM test WHERE ACSC(x)' using SQL::Statement 178s ok 178 - parse 'SELECT * FROM test WHERE ACSCH(x)' using SQL::Statement 178s ok 179 - parse 'SELECT * FROM test WHERE ASEC(x)' using SQL::Statement 178s ok 180 - parse 'SELECT * FROM test WHERE ASECH(x)' using SQL::Statement 178s ok 181 - parse 'SELECT * FROM test WHERE ASIN(x)' using SQL::Statement 178s ok 182 - parse 'SELECT * FROM test WHERE ASINH(x)' using SQL::Statement 178s ok 183 - parse 'SELECT * FROM test WHERE ATAN(x)' using SQL::Statement 178s ok 184 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using SQL::Statement 178s ok 185 - parse 'SELECT * FROM test WHERE ATANH(x)' using SQL::Statement 178s ok 186 - parse 'SELECT * FROM test WHERE COS(x)' using SQL::Statement 178s ok 187 - parse 'SELECT * FROM test WHERE COSEC(x)' using SQL::Statement 178s ok 188 - parse 'SELECT * FROM test WHERE COSECH(x)' using SQL::Statement 178s ok 189 - parse 'SELECT * FROM test WHERE COSH(x)' using SQL::Statement 178s ok 190 - parse 'SELECT * FROM test WHERE COT(x)' using SQL::Statement 178s ok 191 - parse 'SELECT * FROM test WHERE COTAN(x)' using SQL::Statement 178s ok 192 - parse 'SELECT * FROM test WHERE COTANH(x)' using SQL::Statement 178s ok 193 - parse 'SELECT * FROM test WHERE COTH(x)' using SQL::Statement 178s ok 194 - parse 'SELECT * FROM test WHERE CSC(x)' using SQL::Statement 178s ok 195 - parse 'SELECT * FROM test WHERE CSCH(x)' using SQL::Statement 178s ok 196 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using SQL::Statement 178s ok 197 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using SQL::Statement 178s ok 198 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using SQL::Statement 178s ok 199 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using SQL::Statement 178s ok 200 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using SQL::Statement 178s ok 201 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using SQL::Statement 178s ok 202 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using SQL::Statement 178s ok 203 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using SQL::Statement 178s ok 204 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using SQL::Statement 178s ok 205 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using SQL::Statement 178s ok 206 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using SQL::Statement 178s ok 207 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using SQL::Statement 178s ok 208 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using SQL::Statement 178s ok 209 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using SQL::Statement 178s ok 210 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using SQL::Statement 178s ok 211 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using SQL::Statement 178s ok 212 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using SQL::Statement 178s ok 213 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using SQL::Statement 178s ok 214 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using SQL::Statement 178s ok 215 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using SQL::Statement 178s ok 216 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using SQL::Statement 178s ok 217 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using SQL::Statement 178s ok 218 - parse 'SELECT * FROM test WHERE PI()' using SQL::Statement 178s ok 219 - parse 'SELECT * FROM test WHERE SEC(x)' using SQL::Statement 178s ok 220 - parse 'SELECT * FROM test WHERE SECH(x)' using SQL::Statement 178s ok 221 - parse 'SELECT * FROM test WHERE SIN(x)' using SQL::Statement 178s ok 222 - parse 'SELECT * FROM test WHERE SINH(x)' using SQL::Statement 178s ok 223 - parse 'SELECT * FROM test WHERE TAN(x)' using SQL::Statement 178s ok 224 - parse 'SELECT * FROM test WHERE TANH(x)' using SQL::Statement 178s ok 225 - parse ' /* SYSTEM FUNCTIONS */' using SQL::Statement 178s ok 226 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using SQL::Statement 178s ok 227 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using SQL::Statement 178s ok 228 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using SQL::Statement 178s ok 229 - parse ' /* TABLE NAME ALIASES */' using SQL::Statement 178s ok 230 - parse 'SELECT * FROM test as T1' using SQL::Statement 178s ok 231 - parse 'SELECT * FROM test T1' using SQL::Statement 178s ok 232 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using SQL::Statement 178s ok 233 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using SQL::Statement 178s ok 234 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using SQL::Statement 178s ok 235 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using SQL::Statement 178s ok 236 - parse ' /* NUMERIC EXPRESSIONS */' using SQL::Statement 178s ok 237 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using SQL::Statement 178s ok 238 - parse ' /* CASE OF IDENTIFIERS */' using SQL::Statement 178s ok 239 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using SQL::Statement 178s ok 240 - parse ' /* PARENS */' using SQL::Statement 178s ok 241 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using SQL::Statement 178s ok 242 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using SQL::Statement 178s ok 243 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using SQL::Statement 178s ok 244 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using SQL::Statement 178s ok 245 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using SQL::Statement 178s ok 246 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using SQL::Statement 178s ok 247 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using SQL::Statement 178s ok 248 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using SQL::Statement 178s ok 249 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using SQL::Statement 178s ok 250 - parse ' /* NOT */' using SQL::Statement 178s ok 251 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using SQL::Statement 178s ok 252 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using SQL::Statement 178s ok 253 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using SQL::Statement 178s ok 254 - parse ' /* IN */' using SQL::Statement 178s ok 255 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using SQL::Statement 178s ok 256 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using SQL::Statement 178s ok 257 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using SQL::Statement 178s ok 258 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using SQL::Statement 178s ok 259 - parse ' /* BETWEEN */' using SQL::Statement 178s ok 260 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using SQL::Statement 178s ok 261 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using SQL::Statement 178s ok 262 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using SQL::Statement 178s ok 263 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using SQL::Statement 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 264 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using SQL::Statement # TODO Analyze failures 178s not ok 265 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using SQL::Statement # TODO Analyze failures 178s # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using SQL::Statement' 178s # at t/01prepare.t line 312. 178s # 178s # Execution ERROR: Unknown predicate '{$VAR1 = {}; 178s # }' called from t/TestLib.pm at 190. 178s # 178s not ok 266 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using SQL::Statement # TODO Analyze failures 178s # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using SQL::Statement' 178s # at t/01prepare.t line 312. 178s # 178s # Execution ERROR: Unknown predicate '{$VAR1 = {}; 178s # }' called from t/TestLib.pm at 190. 178s # 178s ok 267 - $sth->new 178s ok 268 - $sth->command 178s ok 269 - $sth->params 178s ok 270 - $sth->tables 178s ok 271 - $sth->where()->op 178s ok 272 - $sth->where()->left 178s ok 273 - $sth->where()->left->left 178s ok 274 - $sth->where()->left->right 178s ok 275 - $sth->limit 178s ok 276 - $sth->offset 178s # Command SELECT 178s # Num Pholders 1 178s # Columns 178s # Tables SQL::Statement::Table=HASH(0xc6a739ca8478),SQL::Statement::Table=HASH(0xc6a739d07570) 178s # Where op AND 178s # Limit 2 178s # Offset 5 178s # Order Cols f,g 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 277 - $stmt->row_values() 178s ok 278 - $stmt->row_values(0) 178s ok 279 - $stmt->row_values(0,1) 178s ok 280 - structure 178s ok 281 - command 178s ok 282 - distinct 178s ok 283 - parse ' /* DROP TABLE */' using DBD::File 178s ok 284 - parse 'DROP TABLE foo' using DBD::File 178s ok 285 - parse 'DROP TABLE foo CASCADE' using DBD::File 178s ok 286 - parse 'DROP TABLE foo RESTRICT' using DBD::File 178s ok 287 - parse ' /* DELETE */' using DBD::File 178s ok 288 - parse 'DELETE FROM foo' using DBD::File 178s ok 289 - parse 'DELETE FROM foo WHERE id < 7' using DBD::File 178s ok 290 - parse ' /* UPDATE */' using DBD::File 178s ok 291 - parse 'UPDATE foo SET bar = 7' using DBD::File 178s ok 292 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using DBD::File 178s ok 293 - parse ' /* INSERT */' using DBD::File 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 294 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using DBD::File 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 295 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::File 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 296 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using DBD::File 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 297 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using DBD::File 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 298 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using DBD::File 178s ok 299 - parse ' /* CREATE TABLE */' using DBD::File 178s ok 300 - parse 'CREATE TABLE foo ( id INT )' using DBD::File 178s ok 301 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using DBD::File 178s ok 302 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::File 178s ok 303 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::File 178s ok 304 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using DBD::File 178s ok 305 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::File 178s ok 306 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::File 178s ok 307 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using DBD::File 178s ok 308 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using DBD::File 178s ok 309 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using DBD::File 178s ok 310 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using DBD::File 178s ok 311 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using DBD::File 178s ok 312 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using DBD::File 178s ok 313 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using DBD::File 178s ok 314 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using DBD::File 178s ok 315 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using DBD::File 178s ok 316 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using DBD::File 178s ok 317 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using DBD::File 178s ok 318 - parse ' /* JOINS */' using DBD::File 178s ok 319 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using DBD::File 178s ok 320 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using DBD::File 178s ok 321 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::File 178s ok 322 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using DBD::File 178s ok 323 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::File 178s ok 324 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::File 178s ok 325 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::File 178s ok 326 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::File 178s ok 327 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using DBD::File 178s ok 328 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using DBD::File 178s ok 329 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::File 178s ok 330 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using DBD::File 178s ok 331 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using DBD::File 178s ok 332 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using DBD::File 178s ok 333 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using DBD::File 178s ok 334 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::File 178s ok 335 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using DBD::File 178s ok 336 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::File 178s ok 337 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::File 178s ok 338 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::File 178s ok 339 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::File 178s ok 340 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using DBD::File 178s ok 341 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using DBD::File 178s ok 342 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::File 178s ok 343 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using DBD::File 178s ok 344 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using DBD::File 178s ok 345 - parse ' /* SELECT COLUMNS */' using DBD::File 178s ok 346 - parse 'SELECT id, phrase FROM foo' using DBD::File 178s ok 347 - parse 'SELECT * FROM foo' using DBD::File 178s ok 348 - parse 'SELECT DISTINCT * FROM foo' using DBD::File 178s ok 349 - parse 'SELECT ALL * FROM foo' using DBD::File 178s ok 350 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using DBD::File 178s ok 351 - parse ' /* SET FUNCTIONS */' using DBD::File 178s ok 352 - parse 'SELECT MAX(foo) FROM bar' using DBD::File 178s ok 353 - parse 'SELECT MIN(foo) FROM bar' using DBD::File 178s ok 354 - parse 'SELECT AVG(foo) FROM bar' using DBD::File 178s ok 355 - parse 'SELECT SUM(foo) FROM bar' using DBD::File 178s ok 356 - parse 'SELECT COUNT(foo) FROM foo' using DBD::File 178s ok 357 - parse 'SELECT COUNT(*) FROM foo' using DBD::File 178s ok 358 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using DBD::File 178s ok 359 - parse 'SELECT SUM(ALL foo) FROM bar' using DBD::File 178s ok 360 - parse ' /* ORDER BY */' using DBD::File 178s ok 361 - parse 'SELECT * FROM foo ORDER BY bar' using DBD::File 178s ok 362 - parse 'SELECT * FROM foo ORDER BY bar, baz' using DBD::File 178s ok 363 - parse 'SELECT * FROM foo ORDER BY bar DESC' using DBD::File 178s ok 364 - parse 'SELECT * FROM foo ORDER BY bar ASC' using DBD::File 178s ok 365 - parse ' /* LIMIT */' using DBD::File 178s ok 366 - parse 'SELECT * FROM foo LIMIT 5' using DBD::File 178s ok 367 - parse 'SELECT * FROM foo LIMIT 0, 5' using DBD::File 178s ok 368 - parse 'SELECT * FROM foo LIMIT 5, 10' using DBD::File 178s ok 369 - parse '/* DATE/TIME FUNCTIONS */' using DBD::File 178s ok 370 - parse 'SELECT CURRENT_DATE()' using DBD::File 178s ok 371 - parse 'SELECT CURRENT_TIME()' using DBD::File 178s ok 372 - parse 'SELECT CURRENT_TIMESTAMP()' using DBD::File 178s ok 373 - parse 'SELECT CURDATE()' using DBD::File 178s ok 374 - parse 'SELECT CURTIME()' using DBD::File 178s ok 375 - parse 'SELECT NOW()' using DBD::File 178s ok 376 - parse 'SELECT UNIX_TIMESTAMP() ' using DBD::File 178s ok 377 - parse 'SELECT CURRENT_TIME(2)' using DBD::File 178s ok 378 - parse 'SELECT CURRENT_TIMESTAMP(2)' using DBD::File 178s ok 379 - parse 'SELECT CURTIME(2)' using DBD::File 178s ok 380 - parse 'SELECT NOW(2)' using DBD::File 178s ok 381 - parse 'SELECT UNIX_TIMESTAMP(2)' using DBD::File 178s ok 382 - parse ' /* STRING FUNCTIONS */' using DBD::File 178s ok 383 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using DBD::File 178s ok 384 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using DBD::File 178s ok 385 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using DBD::File 178s ok 386 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using DBD::File 178s ok 387 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using DBD::File 178s ok 388 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using DBD::File 178s ok 389 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using DBD::File 178s ok 390 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using DBD::File 178s ok 391 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using DBD::File 178s ok 392 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using DBD::File 178s ok 393 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using DBD::File 178s ok 394 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using DBD::File 178s ok 395 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using DBD::File 178s ok 396 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using DBD::File 178s ok 397 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using DBD::File 178s ok 398 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using DBD::File 178s ok 399 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using DBD::File 178s ok 400 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using DBD::File 178s ok 401 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using DBD::File 178s ok 402 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using DBD::File 178s ok 403 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using DBD::File 178s ok 404 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using DBD::File 178s ok 405 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using DBD::File 178s ok 406 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using DBD::File 178s ok 407 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using DBD::File 178s ok 408 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using DBD::File 178s ok 409 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using DBD::File 178s ok 410 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::File 178s ok 411 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::File 178s ok 412 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using DBD::File 178s ok 413 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using DBD::File 178s ok 414 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using DBD::File 178s ok 415 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using DBD::File 178s ok 416 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using DBD::File 178s ok 417 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using DBD::File 178s ok 418 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using DBD::File 178s ok 419 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using DBD::File 178s ok 420 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using DBD::File 178s ok 421 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using DBD::File 178s ok 422 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using DBD::File 178s ok 423 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using DBD::File 178s ok 424 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using DBD::File 178s ok 425 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using DBD::File 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 426 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using DBD::File 178s ok 427 - parse ' /* NUMERIC FUNCTIONS */' using DBD::File 178s ok 428 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using DBD::File 178s ok 429 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using DBD::File 178s ok 430 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using DBD::File 178s ok 431 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using DBD::File 178s ok 432 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using DBD::File 178s ok 433 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using DBD::File 178s ok 434 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using DBD::File 178s ok 435 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using DBD::File 178s ok 436 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using DBD::File 178s ok 437 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using DBD::File 178s ok 438 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using DBD::File 178s ok 439 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using DBD::File 178s ok 440 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using DBD::File 178s ok 441 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using DBD::File 178s ok 442 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using DBD::File 178s ok 443 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using DBD::File 178s ok 444 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using DBD::File 178s ok 445 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using DBD::File 178s ok 446 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using DBD::File 178s ok 447 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using DBD::File 178s ok 448 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using DBD::File 178s ok 449 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using DBD::File 178s ok 450 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using DBD::File 178s ok 451 - parse 'SELECT * FROM test WHERE ACOS(x)' using DBD::File 178s ok 452 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using DBD::File 178s ok 453 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using DBD::File 178s ok 454 - parse 'SELECT * FROM test WHERE ACOSH(x)' using DBD::File 178s ok 455 - parse 'SELECT * FROM test WHERE ACOT(x)' using DBD::File 178s ok 456 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using DBD::File 178s ok 457 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using DBD::File 178s ok 458 - parse 'SELECT * FROM test WHERE ACOTH(x)' using DBD::File 178s ok 459 - parse 'SELECT * FROM test WHERE ACSC(x)' using DBD::File 178s ok 460 - parse 'SELECT * FROM test WHERE ACSCH(x)' using DBD::File 178s ok 461 - parse 'SELECT * FROM test WHERE ASEC(x)' using DBD::File 178s ok 462 - parse 'SELECT * FROM test WHERE ASECH(x)' using DBD::File 178s ok 463 - parse 'SELECT * FROM test WHERE ASIN(x)' using DBD::File 178s ok 464 - parse 'SELECT * FROM test WHERE ASINH(x)' using DBD::File 178s ok 465 - parse 'SELECT * FROM test WHERE ATAN(x)' using DBD::File 178s ok 466 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using DBD::File 178s ok 467 - parse 'SELECT * FROM test WHERE ATANH(x)' using DBD::File 178s ok 468 - parse 'SELECT * FROM test WHERE COS(x)' using DBD::File 178s ok 469 - parse 'SELECT * FROM test WHERE COSEC(x)' using DBD::File 178s ok 470 - parse 'SELECT * FROM test WHERE COSECH(x)' using DBD::File 178s ok 471 - parse 'SELECT * FROM test WHERE COSH(x)' using DBD::File 178s ok 472 - parse 'SELECT * FROM test WHERE COT(x)' using DBD::File 178s ok 473 - parse 'SELECT * FROM test WHERE COTAN(x)' using DBD::File 178s ok 474 - parse 'SELECT * FROM test WHERE COTANH(x)' using DBD::File 178s ok 475 - parse 'SELECT * FROM test WHERE COTH(x)' using DBD::File 178s ok 476 - parse 'SELECT * FROM test WHERE CSC(x)' using DBD::File 178s ok 477 - parse 'SELECT * FROM test WHERE CSCH(x)' using DBD::File 178s ok 478 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using DBD::File 178s ok 479 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using DBD::File 178s ok 480 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using DBD::File 178s ok 481 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using DBD::File 178s ok 482 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using DBD::File 178s ok 483 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using DBD::File 178s ok 484 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using DBD::File 178s ok 485 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using DBD::File 178s ok 486 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using DBD::File 178s ok 487 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using DBD::File 178s ok 488 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using DBD::File 178s ok 489 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using DBD::File 178s ok 490 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using DBD::File 178s ok 491 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using DBD::File 178s ok 492 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using DBD::File 178s ok 493 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using DBD::File 178s ok 494 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using DBD::File 178s ok 495 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using DBD::File 178s ok 496 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using DBD::File 178s ok 497 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using DBD::File 178s ok 498 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using DBD::File 178s ok 499 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using DBD::File 178s ok 500 - parse 'SELECT * FROM test WHERE PI()' using DBD::File 178s ok 501 - parse 'SELECT * FROM test WHERE SEC(x)' using DBD::File 178s ok 502 - parse 'SELECT * FROM test WHERE SECH(x)' using DBD::File 178s ok 503 - parse 'SELECT * FROM test WHERE SIN(x)' using DBD::File 178s ok 504 - parse 'SELECT * FROM test WHERE SINH(x)' using DBD::File 178s ok 505 - parse 'SELECT * FROM test WHERE TAN(x)' using DBD::File 178s ok 506 - parse 'SELECT * FROM test WHERE TANH(x)' using DBD::File 178s ok 507 - parse ' /* SYSTEM FUNCTIONS */' using DBD::File 178s ok 508 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using DBD::File 178s ok 509 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using DBD::File 178s ok 510 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using DBD::File 178s ok 511 - parse ' /* TABLE NAME ALIASES */' using DBD::File 178s ok 512 - parse 'SELECT * FROM test as T1' using DBD::File 178s ok 513 - parse 'SELECT * FROM test T1' using DBD::File 178s ok 514 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using DBD::File 178s ok 515 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using DBD::File 178s ok 516 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using DBD::File 178s ok 517 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using DBD::File 178s ok 518 - parse ' /* NUMERIC EXPRESSIONS */' using DBD::File 178s ok 519 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using DBD::File 178s ok 520 - parse ' /* CASE OF IDENTIFIERS */' using DBD::File 178s ok 521 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using DBD::File 178s ok 522 - parse ' /* PARENS */' using DBD::File 178s ok 523 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using DBD::File 178s ok 524 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using DBD::File 178s ok 525 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using DBD::File 178s ok 526 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using DBD::File 178s ok 527 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using DBD::File 178s ok 528 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using DBD::File 178s ok 529 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using DBD::File 178s ok 530 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using DBD::File 178s ok 531 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using DBD::File 178s ok 532 - parse ' /* NOT */' using DBD::File 178s ok 533 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::File 178s ok 534 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using DBD::File 178s ok 535 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using DBD::File 178s ok 536 - parse ' /* IN */' using DBD::File 178s ok 537 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using DBD::File 178s ok 538 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using DBD::File 178s ok 539 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using DBD::File 178s ok 540 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using DBD::File 178s ok 541 - parse ' /* BETWEEN */' using DBD::File 178s ok 542 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using DBD::File 178s ok 543 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using DBD::File 178s ok 544 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using DBD::File 178s ok 545 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using DBD::File 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 546 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::File # TODO Analyze failures 178s not ok 547 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::File # TODO Analyze failures 178s # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::File' 178s # at t/01prepare.t line 312. 178s # 178s # Execution ERROR: Unknown predicate '{$VAR1 = {}; 178s # }' called from /usr/lib/aarch64-linux-gnu/perl5/5.38/DBI/DBD/SqlEngine.pm at 335. 178s # 178s not ok 548 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::File # TODO Analyze failures 178s # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::File' 178s # at t/01prepare.t line 312. 178s # 178s # Execution ERROR: Unknown predicate '{$VAR1 = {}; 178s # }' called from /usr/lib/aarch64-linux-gnu/perl5/5.38/DBI/DBD/SqlEngine.pm at 335. 178s # 178s ok 549 - $sth->new 178s ok 550 - $sth->command 178s ok 551 - $sth->params 178s ok 552 - $sth->tables 178s ok 553 - $sth->where()->op 178s ok 554 - $sth->where()->left 178s ok 555 - $sth->where()->left->left 178s ok 556 - $sth->where()->left->right 178s ok 557 - $sth->limit 178s ok 558 - $sth->offset 178s # Command SELECT 178s # Num Pholders 1 178s # Columns 178s # Tables SQL::Statement::Table=HASH(0xc6a739ca2a60),SQL::Statement::Table=HASH(0xc6a739ca2a18) 178s # Where op AND 178s # Limit 2 178s # Offset 5 178s # Order Cols f,g 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 559 - $stmt->row_values() 178s ok 560 - $stmt->row_values(0) 178s ok 561 - $stmt->row_values(0,1) 178s ok 562 - structure 178s ok 563 - command 178s ok 564 - distinct 178s ok 565 - parse ' /* DROP TABLE */' using DBD::DBM 178s ok 566 - parse 'DROP TABLE foo' using DBD::DBM 178s ok 567 - parse 'DROP TABLE foo CASCADE' using DBD::DBM 178s ok 568 - parse 'DROP TABLE foo RESTRICT' using DBD::DBM 178s ok 569 - parse ' /* DELETE */' using DBD::DBM 178s ok 570 - parse 'DELETE FROM foo' using DBD::DBM 178s ok 571 - parse 'DELETE FROM foo WHERE id < 7' using DBD::DBM 178s ok 572 - parse ' /* UPDATE */' using DBD::DBM 178s ok 573 - parse 'UPDATE foo SET bar = 7' using DBD::DBM 178s ok 574 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using DBD::DBM 178s ok 575 - parse ' /* INSERT */' using DBD::DBM 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 576 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using DBD::DBM 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 577 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::DBM 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 578 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using DBD::DBM 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 579 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using DBD::DBM 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 580 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using DBD::DBM 178s ok 581 - parse ' /* CREATE TABLE */' using DBD::DBM 178s ok 582 - parse 'CREATE TABLE foo ( id INT )' using DBD::DBM 178s ok 583 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using DBD::DBM 178s ok 584 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::DBM 178s ok 585 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::DBM 178s ok 586 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using DBD::DBM 178s ok 587 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::DBM 178s ok 588 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::DBM 178s ok 589 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using DBD::DBM 178s ok 590 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using DBD::DBM 178s ok 591 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using DBD::DBM 178s ok 592 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using DBD::DBM 178s ok 593 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using DBD::DBM 178s ok 594 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using DBD::DBM 178s ok 595 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using DBD::DBM 178s ok 596 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using DBD::DBM 178s ok 597 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using DBD::DBM 178s ok 598 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using DBD::DBM 178s ok 599 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using DBD::DBM 178s ok 600 - parse ' /* JOINS */' using DBD::DBM 178s ok 601 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using DBD::DBM 178s ok 602 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using DBD::DBM 178s ok 603 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::DBM 178s ok 604 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using DBD::DBM 178s ok 605 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::DBM 178s ok 606 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::DBM 178s ok 607 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::DBM 178s ok 608 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::DBM 178s ok 609 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using DBD::DBM 178s ok 610 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using DBD::DBM 178s ok 611 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::DBM 178s ok 612 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using DBD::DBM 178s ok 613 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using DBD::DBM 178s ok 614 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using DBD::DBM 178s ok 615 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using DBD::DBM 178s ok 616 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::DBM 178s ok 617 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using DBD::DBM 178s ok 618 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::DBM 178s ok 619 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::DBM 178s ok 620 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::DBM 178s ok 621 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::DBM 178s ok 622 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using DBD::DBM 178s ok 623 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using DBD::DBM 178s ok 624 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::DBM 178s ok 625 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using DBD::DBM 178s ok 626 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using DBD::DBM 178s ok 627 - parse ' /* SELECT COLUMNS */' using DBD::DBM 178s ok 628 - parse 'SELECT id, phrase FROM foo' using DBD::DBM 178s ok 629 - parse 'SELECT * FROM foo' using DBD::DBM 178s ok 630 - parse 'SELECT DISTINCT * FROM foo' using DBD::DBM 178s ok 631 - parse 'SELECT ALL * FROM foo' using DBD::DBM 178s ok 632 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using DBD::DBM 178s ok 633 - parse ' /* SET FUNCTIONS */' using DBD::DBM 178s ok 634 - parse 'SELECT MAX(foo) FROM bar' using DBD::DBM 178s ok 635 - parse 'SELECT MIN(foo) FROM bar' using DBD::DBM 178s ok 636 - parse 'SELECT AVG(foo) FROM bar' using DBD::DBM 178s ok 637 - parse 'SELECT SUM(foo) FROM bar' using DBD::DBM 178s ok 638 - parse 'SELECT COUNT(foo) FROM foo' using DBD::DBM 178s ok 639 - parse 'SELECT COUNT(*) FROM foo' using DBD::DBM 178s ok 640 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using DBD::DBM 178s ok 641 - parse 'SELECT SUM(ALL foo) FROM bar' using DBD::DBM 178s ok 642 - parse ' /* ORDER BY */' using DBD::DBM 178s ok 643 - parse 'SELECT * FROM foo ORDER BY bar' using DBD::DBM 178s ok 644 - parse 'SELECT * FROM foo ORDER BY bar, baz' using DBD::DBM 178s ok 645 - parse 'SELECT * FROM foo ORDER BY bar DESC' using DBD::DBM 178s ok 646 - parse 'SELECT * FROM foo ORDER BY bar ASC' using DBD::DBM 178s ok 647 - parse ' /* LIMIT */' using DBD::DBM 178s ok 648 - parse 'SELECT * FROM foo LIMIT 5' using DBD::DBM 178s ok 649 - parse 'SELECT * FROM foo LIMIT 0, 5' using DBD::DBM 178s ok 650 - parse 'SELECT * FROM foo LIMIT 5, 10' using DBD::DBM 178s ok 651 - parse '/* DATE/TIME FUNCTIONS */' using DBD::DBM 178s ok 652 - parse 'SELECT CURRENT_DATE()' using DBD::DBM 178s ok 653 - parse 'SELECT CURRENT_TIME()' using DBD::DBM 178s ok 654 - parse 'SELECT CURRENT_TIMESTAMP()' using DBD::DBM 178s ok 655 - parse 'SELECT CURDATE()' using DBD::DBM 178s ok 656 - parse 'SELECT CURTIME()' using DBD::DBM 178s ok 657 - parse 'SELECT NOW()' using DBD::DBM 178s ok 658 - parse 'SELECT UNIX_TIMESTAMP() ' using DBD::DBM 178s ok 659 - parse 'SELECT CURRENT_TIME(2)' using DBD::DBM 178s ok 660 - parse 'SELECT CURRENT_TIMESTAMP(2)' using DBD::DBM 178s ok 661 - parse 'SELECT CURTIME(2)' using DBD::DBM 178s ok 662 - parse 'SELECT NOW(2)' using DBD::DBM 178s ok 663 - parse 'SELECT UNIX_TIMESTAMP(2)' using DBD::DBM 178s ok 664 - parse ' /* STRING FUNCTIONS */' using DBD::DBM 178s ok 665 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using DBD::DBM 178s ok 666 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using DBD::DBM 178s ok 667 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using DBD::DBM 178s ok 668 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using DBD::DBM 178s ok 669 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using DBD::DBM 178s ok 670 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using DBD::DBM 178s ok 671 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using DBD::DBM 178s ok 672 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using DBD::DBM 178s ok 673 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using DBD::DBM 178s ok 674 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using DBD::DBM 178s ok 675 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using DBD::DBM 178s ok 676 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using DBD::DBM 178s ok 677 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using DBD::DBM 178s ok 678 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using DBD::DBM 178s ok 679 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using DBD::DBM 178s ok 680 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using DBD::DBM 178s ok 681 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using DBD::DBM 178s ok 682 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using DBD::DBM 178s ok 683 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using DBD::DBM 178s ok 684 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using DBD::DBM 178s ok 685 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using DBD::DBM 178s ok 686 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using DBD::DBM 178s ok 687 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using DBD::DBM 178s ok 688 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using DBD::DBM 178s ok 689 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using DBD::DBM 178s ok 690 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using DBD::DBM 178s ok 691 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using DBD::DBM 178s ok 692 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::DBM 178s ok 693 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::DBM 178s ok 694 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using DBD::DBM 178s ok 695 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using DBD::DBM 178s ok 696 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using DBD::DBM 178s ok 697 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using DBD::DBM 178s ok 698 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using DBD::DBM 178s ok 699 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using DBD::DBM 178s ok 700 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using DBD::DBM 178s ok 701 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using DBD::DBM 178s ok 702 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using DBD::DBM 178s ok 703 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using DBD::DBM 178s ok 704 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using DBD::DBM 178s ok 705 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using DBD::DBM 178s ok 706 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using DBD::DBM 178s ok 707 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using DBD::DBM 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 708 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using DBD::DBM 178s ok 709 - parse ' /* NUMERIC FUNCTIONS */' using DBD::DBM 178s ok 710 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using DBD::DBM 178s ok 711 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using DBD::DBM 178s ok 712 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using DBD::DBM 178s ok 713 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using DBD::DBM 178s ok 714 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using DBD::DBM 178s ok 715 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using DBD::DBM 178s ok 716 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using DBD::DBM 178s ok 717 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using DBD::DBM 178s ok 718 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using DBD::DBM 178s ok 719 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using DBD::DBM 178s ok 720 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using DBD::DBM 178s ok 721 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using DBD::DBM 178s ok 722 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using DBD::DBM 178s ok 723 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using DBD::DBM 178s ok 724 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using DBD::DBM 178s ok 725 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using DBD::DBM 178s ok 726 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using DBD::DBM 178s ok 727 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using DBD::DBM 178s ok 728 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using DBD::DBM 178s ok 729 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using DBD::DBM 178s ok 730 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using DBD::DBM 178s ok 731 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using DBD::DBM 178s ok 732 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using DBD::DBM 178s ok 733 - parse 'SELECT * FROM test WHERE ACOS(x)' using DBD::DBM 178s ok 734 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using DBD::DBM 178s ok 735 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using DBD::DBM 178s ok 736 - parse 'SELECT * FROM test WHERE ACOSH(x)' using DBD::DBM 178s ok 737 - parse 'SELECT * FROM test WHERE ACOT(x)' using DBD::DBM 178s ok 738 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using DBD::DBM 178s ok 739 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using DBD::DBM 178s ok 740 - parse 'SELECT * FROM test WHERE ACOTH(x)' using DBD::DBM 178s ok 741 - parse 'SELECT * FROM test WHERE ACSC(x)' using DBD::DBM 178s ok 742 - parse 'SELECT * FROM test WHERE ACSCH(x)' using DBD::DBM 178s ok 743 - parse 'SELECT * FROM test WHERE ASEC(x)' using DBD::DBM 178s ok 744 - parse 'SELECT * FROM test WHERE ASECH(x)' using DBD::DBM 178s ok 745 - parse 'SELECT * FROM test WHERE ASIN(x)' using DBD::DBM 178s ok 746 - parse 'SELECT * FROM test WHERE ASINH(x)' using DBD::DBM 178s ok 747 - parse 'SELECT * FROM test WHERE ATAN(x)' using DBD::DBM 178s ok 748 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using DBD::DBM 178s ok 749 - parse 'SELECT * FROM test WHERE ATANH(x)' using DBD::DBM 178s ok 750 - parse 'SELECT * FROM test WHERE COS(x)' using DBD::DBM 178s ok 751 - parse 'SELECT * FROM test WHERE COSEC(x)' using DBD::DBM 178s ok 752 - parse 'SELECT * FROM test WHERE COSECH(x)' using DBD::DBM 178s ok 753 - parse 'SELECT * FROM test WHERE COSH(x)' using DBD::DBM 178s ok 754 - parse 'SELECT * FROM test WHERE COT(x)' using DBD::DBM 178s ok 755 - parse 'SELECT * FROM test WHERE COTAN(x)' using DBD::DBM 178s ok 756 - parse 'SELECT * FROM test WHERE COTANH(x)' using DBD::DBM 178s ok 757 - parse 'SELECT * FROM test WHERE COTH(x)' using DBD::DBM 178s ok 758 - parse 'SELECT * FROM test WHERE CSC(x)' using DBD::DBM 178s ok 759 - parse 'SELECT * FROM test WHERE CSCH(x)' using DBD::DBM 178s ok 760 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using DBD::DBM 178s ok 761 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using DBD::DBM 178s ok 762 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using DBD::DBM 178s ok 763 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using DBD::DBM 178s ok 764 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using DBD::DBM 178s ok 765 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using DBD::DBM 178s ok 766 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using DBD::DBM 178s ok 767 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using DBD::DBM 178s ok 768 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using DBD::DBM 178s ok 769 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using DBD::DBM 178s ok 770 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using DBD::DBM 178s ok 771 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using DBD::DBM 178s ok 772 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using DBD::DBM 178s ok 773 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using DBD::DBM 178s ok 774 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using DBD::DBM 178s ok 775 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using DBD::DBM 178s ok 776 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using DBD::DBM 178s ok 777 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using DBD::DBM 178s ok 778 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using DBD::DBM 178s ok 779 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using DBD::DBM 178s ok 780 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using DBD::DBM 178s ok 781 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using DBD::DBM 178s ok 782 - parse 'SELECT * FROM test WHERE PI()' using DBD::DBM 178s ok 783 - parse 'SELECT * FROM test WHERE SEC(x)' using DBD::DBM 178s ok 784 - parse 'SELECT * FROM test WHERE SECH(x)' using DBD::DBM 178s ok 785 - parse 'SELECT * FROM test WHERE SIN(x)' using DBD::DBM 178s ok 786 - parse 'SELECT * FROM test WHERE SINH(x)' using DBD::DBM 178s ok 787 - parse 'SELECT * FROM test WHERE TAN(x)' using DBD::DBM 178s ok 788 - parse 'SELECT * FROM test WHERE TANH(x)' using DBD::DBM 178s ok 789 - parse ' /* SYSTEM FUNCTIONS */' using DBD::DBM 178s ok 790 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using DBD::DBM 178s ok 791 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using DBD::DBM 178s ok 792 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using DBD::DBM 178s ok 793 - parse ' /* TABLE NAME ALIASES */' using DBD::DBM 178s ok 794 - parse 'SELECT * FROM test as T1' using DBD::DBM 178s ok 795 - parse 'SELECT * FROM test T1' using DBD::DBM 178s ok 796 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using DBD::DBM 178s ok 797 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using DBD::DBM 178s ok 798 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using DBD::DBM 178s ok 799 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using DBD::DBM 178s ok 800 - parse ' /* NUMERIC EXPRESSIONS */' using DBD::DBM 178s ok 801 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using DBD::DBM 178s ok 802 - parse ' /* CASE OF IDENTIFIERS */' using DBD::DBM 178s ok 803 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using DBD::DBM 178s ok 804 - parse ' /* PARENS */' using DBD::DBM 178s ok 805 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using DBD::DBM 178s ok 806 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using DBD::DBM 178s ok 807 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using DBD::DBM 178s ok 808 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using DBD::DBM 178s ok 809 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using DBD::DBM 178s ok 810 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using DBD::DBM 178s ok 811 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using DBD::DBM 178s ok 812 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using DBD::DBM 178s ok 813 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using DBD::DBM 178s ok 814 - parse ' /* NOT */' using DBD::DBM 178s ok 815 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::DBM 178s ok 816 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using DBD::DBM 178s ok 817 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using DBD::DBM 178s ok 818 - parse ' /* IN */' using DBD::DBM 178s ok 819 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using DBD::DBM 178s ok 820 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using DBD::DBM 178s ok 821 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using DBD::DBM 178s ok 822 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using DBD::DBM 178s ok 823 - parse ' /* BETWEEN */' using DBD::DBM 178s ok 824 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using DBD::DBM 178s ok 825 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using DBD::DBM 178s ok 826 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using DBD::DBM 178s ok 827 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using DBD::DBM 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 828 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::DBM # TODO Analyze failures 178s not ok 829 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::DBM # TODO Analyze failures 178s # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::DBM' 178s # at t/01prepare.t line 312. 178s # 178s # Execution ERROR: Unknown predicate '{$VAR1 = {}; 178s # }' called from /usr/lib/aarch64-linux-gnu/perl5/5.38/DBI/DBD/SqlEngine.pm at 335. 178s # 178s not ok 830 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::DBM # TODO Analyze failures 178s # Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::DBM' 178s # at t/01prepare.t line 312. 178s # 178s # Execution ERROR: Unknown predicate '{$VAR1 = {}; 178s # }' called from /usr/lib/aarch64-linux-gnu/perl5/5.38/DBI/DBD/SqlEngine.pm at 335. 178s # 178s ok 831 - $sth->new 178s ok 832 - $sth->command 178s ok 833 - $sth->params 178s ok 834 - $sth->tables 178s ok 835 - $sth->where()->op 178s ok 836 - $sth->where()->left 178s ok 837 - $sth->where()->left->left 178s ok 838 - $sth->where()->left->right 178s ok 839 - $sth->limit 178s ok 840 - $sth->offset 178s # Command SELECT 178s # Num Pholders 1 178s # Columns 178s # Tables SQL::Statement::Table=HASH(0xc6a738f60b00),SQL::Statement::Table=HASH(0xc6a738f60d88) 178s # Where op AND 178s # Limit 2 178s # Offset 5 178s # Order Cols f,g 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 841 - $stmt->row_values() 178s ok 842 - $stmt->row_values(0) 178s ok 843 - $stmt->row_values(0,1) 178s ok 844 - structure 178s ok 845 - command 178s ok 846 - distinct 178s 1..846 178s ok 178s t/02execute.t ... 178s # Can't locate MLDBM.pm in @INC (you may need to install the MLDBM module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 178s # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 178s # # Using required: 178s # # SQL::Statement: 1.414 178s # # Using recommended: 178s # # DBD::DBM: 0.08 178s # # DBD::File: 0.44 178s # # DBI: 1.643 178s # Running tests for SQL::Statement 178s ok 1 - CREATE Tmp 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 2 - placeholder insert with named cols 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 3 - placeholder insert without named cols 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 4 - placeholder delete 178s ok 5 - placeholder update 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 6 - placeholder update 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 7 - multiline insert 178s ok 8 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id' 178s ok 9 - verify table contents 178s ok 10 - prepare 'SELECT id,phrase FROM Tmp WHERE (id?) and phrase LIKE ? ORDER BY id' 178s ok 11 - verify placeholder processing 178s ok 12 - DROP TABLE 178s ok 13 - CREATE 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 14 - INSERT 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 15 - INSERT 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 16 - INSERT 178s ok 17 - UPDATE 178s ok 18 - DELETE 178s ok 19 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' 178s ok 20 - SELECT 178s ok 21 - COUNT * 178s ok 22 - DROP TEMP TABLE 178s ok 23 - COMPUTED COLUMNS IN SELECT LIST 178s ok 24 - CREATE FUNCTION from script 178s # < CREATE TEMP TABLE a (b INT, c CHAR)> 178s ok 25 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE) 178s # < INSERT INTO a VALUES(1,'abc')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 26 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) 178s # < INSERT INTO a VALUES(2,'efg')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 27 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT) 178s # < INSERT INTO a VALUES(3,'hij')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 28 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT) 178s # < INSERT INTO a VALUES(4,'klm')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 29 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT) 178s # < INSERT INTO a VALUES(5,'nmo')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 30 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT) 178s # < INSERT INTO a VALUES(6,'pqr')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 31 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT) 178s # < INSERT INTO a VALUES(7,'stu')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 32 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT) 178s # < INSERT INTO a VALUES(8,'vwx')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 33 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT) 178s # < INSERT INTO a VALUES(9,'yz')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 34 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT) 178s # < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"> 178s ok 35 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT) 178s ok 36 - $stmt->where_hash 178s ok 37 - $stmt->columns 178s ok 38 - $stmt->column_names 178s ok 39 - $stmt->order 178s ok 40 - $stmt->fetch 178s ok 41 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) 178s ok 42 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) 178s ok 43 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) 178s ok 44 - SELECT b,c FROM a WHERE b BETWEEN (5,7) 178s ok 45 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) 178s ok 46 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') 178s ok 47 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 48 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') 178s ok 49 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 50 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') 178s ok 51 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) 178s ok 52 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) 178s ok 53 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) 178s ok 54 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') 178s ok 55 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) 178s ok 56 - SELECT b,c FROM a WHERE b IN (2,3,5,7) 178s ok 57 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) 178s ok 58 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') 178s ok 59 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) 178s ok 60 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) 178s ok 61 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 62 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') 178s ok 63 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) 178s ok 64 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) 178s ok 65 - CREATE FUNCTION from module 178s ok 66 - CREATE FUNCTION from module with argument 178s ok 67 - LOAD FUNCTIONS 178s ok 68 - CREATE pauli test table 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 69 - UPDATE with placeholders 178s ok 70 - UPDATE with placeholder updates correct 178s # Running tests for DBD::File 178s ok 71 - CREATE Tmp 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 72 - placeholder insert with named cols 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 73 - placeholder insert without named cols 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 74 - placeholder delete 178s ok 75 - placeholder update 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 76 - placeholder update 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 77 - multiline insert 178s ok 78 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id' 178s ok 79 - verify table contents 178s ok 80 - prepare 'SELECT id,phrase FROM Tmp WHERE (id?) and phrase LIKE ? ORDER BY id' 178s ok 81 - verify placeholder processing 178s ok 82 - DROP TABLE 178s ok 83 - CREATE 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 84 - INSERT 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 85 - INSERT 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 86 - INSERT 178s ok 87 - UPDATE 178s ok 88 - DELETE 178s ok 89 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' 178s ok 90 - SELECT 178s ok 91 - COUNT * 178s ok 92 - DROP TEMP TABLE 178s ok 93 - COMPUTED COLUMNS IN SELECT LIST 178s ok 94 - CREATE FUNCTION from script 178s # < CREATE TEMP TABLE a (b INT, c CHAR)> 178s ok 95 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE) 178s # < INSERT INTO a VALUES(1,'abc')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 96 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) 178s # < INSERT INTO a VALUES(2,'efg')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 97 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT) 178s # < INSERT INTO a VALUES(3,'hij')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 98 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT) 178s # < INSERT INTO a VALUES(4,'klm')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 99 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT) 178s # < INSERT INTO a VALUES(5,'nmo')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 100 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT) 178s # < INSERT INTO a VALUES(6,'pqr')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 101 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT) 178s # < INSERT INTO a VALUES(7,'stu')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 102 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT) 178s # < INSERT INTO a VALUES(8,'vwx')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 103 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT) 178s # < INSERT INTO a VALUES(9,'yz')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 104 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT) 178s # < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"> 178s ok 105 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT) 178s ok 106 - $stmt->where_hash 178s ok 107 - $stmt->columns 178s ok 108 - $stmt->column_names 178s ok 109 - $stmt->order 178s ok 110 - $stmt->fetch 178s ok 111 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) 178s ok 112 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) 178s ok 113 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 114 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') 178s ok 115 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) 178s ok 116 - SELECT b,c FROM a WHERE b IN (2,3,5,7) 178s ok 117 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) 178s ok 118 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') 178s ok 119 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) 178s ok 120 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') 178s ok 121 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) 178s ok 122 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) 178s ok 123 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) 178s ok 124 - SELECT b,c FROM a WHERE b BETWEEN (5,7) 178s ok 125 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) 178s ok 126 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') 178s ok 127 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 128 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') 178s ok 129 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 130 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') 178s ok 131 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) 178s ok 132 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) 178s ok 133 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) 178s ok 134 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) 178s ok 135 - CREATE FUNCTION from module 178s ok 136 - CREATE FUNCTION from module with argument 178s ok 137 - LOAD FUNCTIONS 178s ok 138 - CREATE pauli test table 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 139 - UPDATE with placeholders 178s ok 140 - UPDATE with placeholder updates correct 178s # Running tests for DBD::DBM 178s ok 141 - CREATE Tmp 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 142 - placeholder insert with named cols 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 143 - placeholder insert without named cols 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 144 - placeholder delete 178s ok 145 - placeholder update 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 146 - placeholder update 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 147 - multiline insert 178s ok 148 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id' 178s ok 149 - verify table contents 178s ok 150 - prepare 'SELECT id,phrase FROM Tmp WHERE (id?) and phrase LIKE ? ORDER BY id' 178s ok 151 - verify placeholder processing 178s ok 152 - DROP TABLE 178s ok 153 - CREATE 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 154 - INSERT 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 155 - INSERT 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 156 - INSERT 178s ok 157 - UPDATE 178s ok 158 - DELETE 178s ok 159 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase' 178s ok 160 - SELECT 178s ok 161 - COUNT * 178s ok 162 - DROP TABLE 178s ok 163 - COMPUTED COLUMNS IN SELECT LIST 178s ok 164 - CREATE FUNCTION from script 178s # < CREATE TABLE a (b INT, c CHAR)> 178s ok 165 - $stmt->execute " CREATE TABLE a (b INT, c CHAR)" (CREATE) 178s # < INSERT INTO a VALUES(1,'abc')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 166 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) 178s # < INSERT INTO a VALUES(2,'efg')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 167 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT) 178s # < INSERT INTO a VALUES(3,'hij')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 168 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT) 178s # < INSERT INTO a VALUES(4,'klm')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 169 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT) 178s # < INSERT INTO a VALUES(5,'nmo')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 170 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT) 178s # < INSERT INTO a VALUES(6,'pqr')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 171 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT) 178s # < INSERT INTO a VALUES(7,'stu')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 172 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT) 178s # < INSERT INTO a VALUES(8,'vwx')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 173 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT) 178s # < INSERT INTO a VALUES(9,'yz')> 178s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 178s ok 174 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT) 178s # < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"> 178s ok 175 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT) 178s ok 176 - $stmt->where_hash 178s ok 177 - $stmt->columns 178s ok 178 - $stmt->column_names 178s ok 179 - $stmt->order 178s ok 180 - $stmt->fetch 178s ok 181 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 182 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') 178s ok 183 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) 178s ok 184 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) 178s ok 185 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) 178s ok 186 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) 178s ok 187 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) 178s ok 188 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') 178s ok 189 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) 178s ok 190 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') 178s ok 191 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) 178s ok 192 - SELECT b,c FROM a WHERE b IN (2,3,5,7) 178s ok 193 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 194 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') 178s ok 195 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) 178s ok 196 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) 178s ok 197 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) 178s ok 198 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') 178s ok 199 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) 178s ok 200 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') 178s ok 201 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) 178s ok 202 - SELECT b,c FROM a WHERE b BETWEEN (5,7) 178s ok 203 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) 178s ok 204 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) 178s ok 205 - CREATE FUNCTION from module 178s ok 206 - CREATE FUNCTION from module with argument 178s ok 207 - LOAD FUNCTIONS 178s ok 208 # skip DBD::DBM Update test won't run without MLDBM 178s ok 209 # skip DBD::DBM Update test won't run without MLDBM 178s ok 210 # skip DBD::DBM Update test won't run without MLDBM 178s 1..210 178s ok 179s t/03import.t .... 179s # Can't locate MLDBM.pm in @INC (you may need to install the MLDBM module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 179s # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 179s # Can't locate DBD/SQLite.pm in @INC (you may need to install the DBD::SQLite module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 179s # # Using required: 179s # # SQL::Statement: 1.414 179s # # Using recommended: 179s # # DBD::DBM: 0.08 179s # # DBD::File: 0.44 179s # # DBI: 1.643 179s # Running tests for SQL::Statement 179s ok 1 - IMPORT($AoA) 179s ok 2 - IMPORT($AoH) 179s ok 3 # skip Need DBI statement handle - can't use when executing direct 179s ok 4 # skip Need DBI statement handle - can't use when executing direct 179s ok 5 # skip Need DBI statement handle - can't use when executing direct 179s ok 6 # skip Need DBI statement handle - can't use when executing direct 179s ok 7 # skip Need DBI statement handle - can't use when executing direct 179s ok 8 # skip Need DBI statement handle - can't use when executing direct 179s ok 9 # skip Need DBI statement handle - can't use when executing direct 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 10 - SELECT IMPORT($external_sth) 179s ok 11 # skip Need DBI statement handle - can't use when executing direct 179s ok 12 # skip Need DBI statement handle - can't use when executing direct 179s # Running tests for DBD::DBM 179s ok 13 - IMPORT($AoA) 179s ok 14 - IMPORT($AoH) 179s ok 15 - CREATE AS IMPORT($aoh) 179s ok 16 - SELECT FROM IMPORTED($AoH) 179s ok 17 - CREATE AS IMPORT($aoa) 179s ok 18 - SELECT FROM IMPORTED($AoA) 179s ok 19 - CREATE AS SELECT * 179s ok 20 - SELECT FROM "SELECTED(*)" tbl_copy 179s ok 21 - CREATE AS SELECT * with quoted restriction 179s ok 22 - SELECT FROM "SELECTED(*)" tbl_extract 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 23 - IMPORT($internal_sth) 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 24 - SELECT IMPORT($external_sth) 179s ok 25 - CREATE AS IMPORT($sth) 179s ok 26 - SELECT FROM IMPORTED ($external_sth) 179s # Running tests for DBD::File 179s ok 27 - IMPORT($AoA) 179s ok 28 - IMPORT($AoH) 179s ok 29 - CREATE AS IMPORT($aoh) 179s ok 30 - SELECT FROM IMPORTED($AoH) 179s ok 31 - CREATE AS IMPORT($aoa) 179s ok 32 - SELECT FROM IMPORTED($AoA) 179s ok 33 - CREATE AS SELECT * 179s ok 34 - SELECT FROM "SELECTED(*)" tbl_copy 179s ok 35 - CREATE AS SELECT * with quoted restriction 179s ok 36 - SELECT FROM "SELECTED(*)" tbl_extract 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 37 - IMPORT($internal_sth) 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 38 - SELECT IMPORT($external_sth) 179s ok 39 - CREATE AS IMPORT($sth) 179s ok 40 - SELECT FROM IMPORTED ($external_sth) 179s 1..40 179s ok 179s t/04idents.t .... 179s # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 179s # Can't locate DBD/SQLite.pm in @INC (you may need to install the DBD::SQLite module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 179s # # Using required: 179s # # SQL::Statement: 1.414 179s # # Using recommended: 179s # # DBD::DBM: 0.08 179s # # DBD::File: 0.44 179s # # DBI: 1.643 179s # Running tests for SQL::Statement 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 1 - Column Names: select list = * 179s ok 2 - Column Names: select list = named 179s ok 3 - Column Names: select list = aliased 179s ok 4 - Column Names: select list with function 179s ok 5 - Column Names: select list with function = aliased 179s ok 6 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased) 179s ok 7 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased) 179s ok 8 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names) 179s ok 9 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names) 179s ok 10 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted) 179s ok 11 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted) 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 12 - ->{all_cols} structure does not grow beyond control 179s ok 13 - execute for 'lower/lower' 179s ok 14 - lower/lower 179s ok 15 - execute for 'lower/upper' 179s ok 16 - lower/upper 179s ok 17 - execute for 'lower/mixed' 179s ok 18 - lower/mixed 179s ok 19 - execute for 'lower/asterisked' 179s ok 20 - lower/asterisked 179s ok 21 - execute for 'upper/lower' 179s ok 22 - upper/lower 179s ok 23 - execute for 'upper/upper' 179s ok 24 - upper/upper 179s ok 25 - execute for 'upper/mixed' 179s ok 26 - upper/mixed 179s ok 27 - execute for 'upper/asterisked' 179s ok 28 - upper/asterisked 179s ok 29 - execute for 'mixed/lower' 179s ok 30 - mixed/lower 179s ok 31 - execute for 'mixed/upper' 179s ok 32 - mixed/upper 179s ok 33 - execute for 'mixed/mixed' 179s ok 34 - mixed/mixed 179s ok 35 - execute for 'mixed/asterisked' 179s ok 36 - mixed/asterisked 179s ok 37 # skip Need DBI statement handle - can't use when executing direct 179s # Running tests for DBD::File 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 38 - Column Names: select list = * 179s ok 39 - Column Names: select list = named 179s ok 40 - Column Names: select list = aliased 179s ok 41 - Column Names: select list with function 179s ok 42 - Column Names: select list with function = aliased 179s ok 43 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased) 179s ok 44 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased) 179s ok 45 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names) 179s ok 46 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names) 179s ok 47 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted) 179s ok 48 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted) 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 49 - ->{all_cols} structure does not grow beyond control 179s ok 50 - execute for 'lower/lower' 179s ok 51 - lower/lower 179s ok 52 - execute for 'lower/upper' 179s ok 53 - lower/upper 179s ok 54 - execute for 'lower/mixed' 179s ok 55 - lower/mixed 179s ok 56 - execute for 'lower/asterisked' 179s ok 57 - lower/asterisked 179s ok 58 - execute for 'upper/lower' 179s ok 59 - upper/lower 179s ok 60 - execute for 'upper/upper' 179s ok 61 - upper/upper 179s ok 62 - execute for 'upper/mixed' 179s ok 63 - upper/mixed 179s ok 64 - execute for 'upper/asterisked' 179s ok 65 - upper/asterisked 179s ok 66 - execute for 'mixed/lower' 179s ok 67 - mixed/lower 179s ok 68 - execute for 'mixed/upper' 179s ok 69 - mixed/upper 179s ok 70 - execute for 'mixed/mixed' 179s ok 71 - mixed/mixed 179s ok 72 - execute for 'mixed/asterisked' 179s ok 73 - mixed/asterisked 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 74 - imported table : lower 179s ok 75 - imported table : upper 179s ok 76 - imported table : mixed 179s ok 77 - imported table : asterisked 179s # Running tests for DBD::DBM 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 78 - Column Names: select list = * 179s ok 79 - Column Names: select list = named 179s ok 80 - Column Names: select list = aliased 179s ok 81 - Column Names: select list with function 179s ok 82 - Column Names: select list with function = aliased 179s ok 83 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased) 179s ok 84 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased) 179s ok 85 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names) 179s ok 86 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names) 179s ok 87 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted) 179s ok 88 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted) 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 89 - ->{all_cols} structure does not grow beyond control 179s ok 90 - execute for 'lower/lower' 179s ok 91 - lower/lower 179s ok 92 - execute for 'lower/upper' 179s ok 93 - lower/upper 179s ok 94 - execute for 'lower/mixed' 179s ok 95 - lower/mixed 179s ok 96 - execute for 'lower/asterisked' 179s ok 97 - lower/asterisked 179s ok 98 - execute for 'upper/lower' 179s ok 99 - upper/lower 179s ok 100 - execute for 'upper/upper' 179s ok 101 - upper/upper 179s ok 102 - execute for 'upper/mixed' 179s ok 103 - upper/mixed 179s ok 104 - execute for 'upper/asterisked' 179s ok 105 - upper/asterisked 179s ok 106 - execute for 'mixed/lower' 179s ok 107 - mixed/lower 179s ok 108 - execute for 'mixed/upper' 179s ok 109 - mixed/upper 179s ok 110 - execute for 'mixed/mixed' 179s ok 111 - mixed/mixed 179s ok 112 - execute for 'mixed/asterisked' 179s ok 113 - mixed/asterisked 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 114 - imported table : lower 179s ok 115 - imported table : upper 179s ok 116 - imported table : mixed 179s ok 117 - imported table : asterisked 179s 1..117 179s ok 179s t/05simple.t .... 179s # Can't locate DBD/CSV.pm in @INC (you may need to install the DBD::CSV module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 179s # Can't locate MLDBM.pm in @INC (you may need to install the MLDBM module) (@INC entries checked: t /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/lib /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl/blib/arch /tmp/autopkgtest.aNd4Mx/autopkgtest_tmp/smokekzgUkl /etc/perl /usr/local/lib/aarch64-linux-gnu/perl/5.38.2 /usr/local/share/perl/5.38.2 /usr/lib/aarch64-linux-gnu/perl5/5.38 /usr/share/perl5 /usr/lib/aarch64-linux-gnu/perl-base /usr/lib/aarch64-linux-gnu/perl/5.38 /usr/share/perl/5.38 /usr/local/lib/site_perl) at t/TestLib.pm line 42. 179s # # Using required: 179s # # SQL::Statement: 1.414 179s # # Using recommended: 179s # # DBD::DBM: 0.08 179s # # DBD::File: 0.44 179s # # DBI: 1.643 179s # Running tests for SQL::Statement 179s ok 1 - prepare using 'SQL::Statement' 179s ok 21 - execute using 'SQL::Statement' 2nd time 179s ok 24 - execute using 'SQL::Statement' 179s ok 30 - execute using 'SQL::Statement' 2nd time 179s ok 33 - execute using 'SQL::Statement' 179s ok 49 - execute using 'SQL::Statement' 2nd time 179s ok 52 - execute using 'SQL::Statement' 179s ok 67 - execute using 'SQL::Statement' 2nd time 179s ok 70 - execute using 'SQL::Statement' 179s ok 77 - execute == 1 using 'SQL::Statement' 179s ok 79 - SELECT results for SELECT COUNT(*) FROM multi_fruit using SQL::Statement 179s ok 80 - execute == 1 using 'SQL::Statement' 179s ok 82 - SELECT results for SELECT COUNT(*) FROM multi_fruit using 'SQL::Statement' 2nd time 179s ok 83 - prepare using 'SQL::Statement' 179s ok 84 - execute using 'SQL::Statement' 179s ok 85 - execute(DROP TABLE multi_fruit) == -1 using 'SQL::Statement' 179s Use of uninitialized value $unkpos in subtraction (-) at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s Use of uninitialized value $unkpos in substr at /usr/share/perl/5.38/Text/Balanced.pm line 1008. 179s ok 86 - prepare using 'SQL::Statement' 179s ok 87 - prepare using 'SQL::Statement' 179s ok 97 - execute using 'SQL::Statement' 2nd time 179s ok 100 - execute using 'SQL::Statement' 179s ok 105 - execute using 'SQL::Statement' 2nd time 179s ok 108 - execute using 'SQL::Statement' 179s ok 113 - execute using 'SQL::Statement' 2nd time 179s ok 116 - execute using 'SQL::Statement' 179s ok 121 - execute using 'SQL::Statement' 2nd time 179s ok 124 - execute using 'SQL::Statement' 179s ok 129 - execute using 'SQL::Statement' 2nd time 179s ok 132 - execute using 'SQL::Statement' 179s ok 137 - execute using 'SQL::Statement' 2nd time 179s ok 140 - execute using 'SQL::Statement' 179s ok 145 - execute using 'SQL::Statement' 2nd time 179s ok 148 - execute using 'SQL::Statement' 179s ok 153 - execute using 'SQL::Statement' 2nd time 179s ok 156 - execute