0s autopkgtest [00:39:16]: starting date: 2024-02-27 0s autopkgtest [00:39:16]: git checkout: d9c0295 adt_testbed.py: supress warnings from apt using a shell pipeline 0s autopkgtest [00:39:16]: host juju-7f2275-prod-proposed-migration-environment-3; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.n61onjlk/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:pytest --apt-upgrade sqlite-utils --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=pytest/8.0.2-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-3@lcy02-2.secgroup --name adt-noble-amd64-sqlite-utils-20240227-003916-juju-7f2275-prod-proposed-migration-environment-3 --image adt/ubuntu-noble-amd64-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/ 454s autopkgtest [00:46:50]: @@@@@@@@@@@@@@@@@@@@ test bed setup 454s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 455s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [422 kB] 455s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [11.1 kB] 455s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [13.4 kB] 455s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [52.0 kB] 455s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 Packages [116 kB] 455s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main i386 Packages [64.4 kB] 455s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 c-n-f Metadata [3508 B] 455s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 Packages [52.6 kB] 455s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/restricted i386 Packages [5000 B] 455s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 c-n-f Metadata [116 B] 455s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/universe i386 Packages [167 kB] 455s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 Packages [333 kB] 455s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 c-n-f Metadata [9396 B] 455s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/multiverse i386 Packages [2528 B] 455s Get:16 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 Packages [6604 B] 455s Get:17 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 c-n-f Metadata [196 B] 456s Fetched 1375 kB in 0s (3697 kB/s) 456s Reading package lists... 460s Reading package lists... 460s Building dependency tree... 460s Reading state information... 461s Calculating upgrade... 461s The following packages will be upgraded: 461s xfsprogs 461s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 461s Need to get 900 kB of archives. 461s After this operation, 8192 B of additional disk space will be used. 461s Get:1 http://ftpmaster.internal/ubuntu noble/main amd64 xfsprogs amd64 6.6.0-1ubuntu1 [900 kB] 461s Fetched 900 kB in 0s (31.8 MB/s) 461s (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 ... 70435 files and directories currently installed.) 461s Preparing to unpack .../xfsprogs_6.6.0-1ubuntu1_amd64.deb ... 461s Unpacking xfsprogs (6.6.0-1ubuntu1) over (6.5.0-1ubuntu2) ... 462s Setting up xfsprogs (6.6.0-1ubuntu1) ... 462s update-initramfs: deferring update (trigger activated) 462s Processing triggers for man-db (2.12.0-3) ... 463s Processing triggers for libc-bin (2.39-0ubuntu2) ... 463s Processing triggers for initramfs-tools (0.142ubuntu19) ... 463s update-initramfs: Generating /boot/initrd.img-6.6.0-14-generic 463s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 471s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 471s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 471s Reading package lists... 471s Building dependency tree... 471s Reading state information... 471s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 472s sh: Attempting to set up Debian/Ubuntu apt sources automatically 472s sh: Distribution appears to be Ubuntu 475s Reading package lists... 476s Building dependency tree... 476s Reading state information... 476s eatmydata is already the newest version (131-1). 476s dbus is already the newest version (1.14.10-3ubuntu1). 476s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 476s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 476s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 476s Reading package lists... 476s Building dependency tree... 476s Reading state information... 477s rng-tools-debian is already the newest version (2.4). 477s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 477s Reading package lists... 477s Building dependency tree... 477s Reading state information... 477s haveged is already the newest version (1.9.14-1ubuntu1). 477s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 477s Reading package lists... 478s Building dependency tree... 478s Reading state information... 478s The following packages will be REMOVED: 478s cloud-init* python3-configobj* python3-debconf* 478s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 478s After this operation, 3228 kB disk space will be freed. 478s (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 ... 70435 files and directories currently installed.) 478s Removing cloud-init (24.1~6ga4140119-0ubuntu1) ... 479s Removing python3-configobj (5.0.8-3) ... 479s Removing python3-debconf (1.5.86) ... 479s Processing triggers for man-db (2.12.0-3) ... 480s (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 ... 70047 files and directories currently installed.) 480s Purging configuration files for cloud-init (24.1~6ga4140119-0ubuntu1) ... 480s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 480s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 481s Reading package lists... 481s Building dependency tree... 481s Reading state information... 481s linux-generic is already the newest version (6.6.0-14.14). 481s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 481s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 481s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 481s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 481s Hit:4 http://ftpmaster.internal/ubuntu noble-proposed InRelease 481s Hit:5 http://ftpmaster.internal/ubuntu noble-backports InRelease 485s Reading package lists... 485s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 485s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 485s Reading package lists... 485s Building dependency tree... 485s Reading state information... 486s Calculating upgrade... 486s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 486s Reading package lists... 486s Building dependency tree... 486s Reading state information... 486s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 487s autopkgtest [00:47:23]: rebooting testbed after setup commands that affected boot 505s autopkgtest [00:47:41]: testbed running kernel: Linux 6.6.0-14-generic #14-Ubuntu SMP PREEMPT_DYNAMIC Thu Nov 30 10:27:29 UTC 2023 505s autopkgtest [00:47:41]: testbed dpkg architecture: amd64 506s autopkgtest [00:47:42]: @@@@@@@@@@@@@@@@@@@@ apt-source sqlite-utils 506s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:1 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:2 and /etc/apt/sources.list.d/ubuntu.sources:1 506s W: Target Packages (main/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (main/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (main/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target CNF (main/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target CNF (main/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (universe/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (universe/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (universe/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target CNF (universe/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target CNF (universe/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (restricted/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (restricted/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (restricted/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target CNF (restricted/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target CNF (restricted/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (multiverse/binary-amd64/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (multiverse/binary-i386/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target Packages (multiverse/binary-all/Packages) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target CNF (multiverse/cnf/Commands-amd64) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 506s W: Target CNF (multiverse/cnf/Commands-all) is configured multiple times in /etc/apt/sources.list:3 and /etc/apt/sources.list.d/ubuntu.sources:2 507s Get:1 http://ftpmaster.internal/ubuntu noble/universe sqlite-utils 3.35.2-1 (dsc) [2424 B] 507s Get:2 http://ftpmaster.internal/ubuntu noble/universe sqlite-utils 3.35.2-1 (tar) [459 kB] 507s Get:3 http://ftpmaster.internal/ubuntu noble/universe sqlite-utils 3.35.2-1 (diff) [4320 B] 507s gpgv: Signature made Wed Nov 8 13:11:48 2023 UTC 507s gpgv: using RSA key FB8ACFA78C726089C38AD0269605A1098C63B92A 507s gpgv: Can't check signature: No public key 507s dpkg-source: warning: cannot verify inline signature for ./sqlite-utils_3.35.2-1.dsc: no acceptable signature found 507s autopkgtest [00:47:43]: testing package sqlite-utils version 3.35.2-1 507s autopkgtest [00:47:43]: build not needed 507s autopkgtest [00:47:43]: test run-tests: preparing testbed 509s Reading package lists... 509s Building dependency tree... 509s Reading state information... 510s Correcting dependencies...Starting pkgProblemResolver with broken count: 0 510s Starting 2 pkgProblemResolver with broken count: 0 510s Done 510s Done 510s Starting pkgProblemResolver with broken count: 0 510s Starting 2 pkgProblemResolver with broken count: 0 510s Done 510s The following additional packages will be installed: 510s libjs-jquery libjs-sphinxdoc libjs-underscore libpython3.11-minimal 510s libpython3.11-stdlib python3-all python3-click python3-click-default-group 510s python3-colorama python3-dateutil python3-distutils python3-hypothesis 510s python3-iniconfig python3-lib2to3 python3-packaging python3-pluggy 510s python3-pytest python3-sortedcontainers python3-sqlite-fts4 python3-tabulate 510s python3.11 python3.11-minimal sqlite-utils 510s Suggested packages: 510s python-hypothesis-doc python-sortedcontainers-doc python3.11-venv 510s python3.11-doc binfmt-support 510s Recommended packages: 510s javascript-common 511s The following NEW packages will be installed: 511s libjs-jquery libjs-sphinxdoc libjs-underscore libpython3.11-minimal 511s libpython3.11-stdlib python3-all python3-click python3-click-default-group 511s python3-colorama python3-dateutil python3-distutils python3-hypothesis 511s python3-iniconfig python3-lib2to3 python3-packaging python3-pluggy 511s python3-pytest python3-sortedcontainers python3-sqlite-fts4 python3-tabulate 511s python3.11 python3.11-minimal sqlite-utils 511s 0 upgraded, 23 newly installed, 0 to remove and 0 not upgraded. 511s 1 not fully installed or removed. 511s Need to get 7867 kB of archives. 511s After this operation, 30.5 MB of additional disk space will be used. 511s Get:1 http://ftpmaster.internal/ubuntu noble/main amd64 python3-lib2to3 all 3.11.5-1 [79.0 kB] 511s Get:2 http://ftpmaster.internal/ubuntu noble/main amd64 python3-distutils all 3.11.5-1 [131 kB] 511s Get:3 http://ftpmaster.internal/ubuntu noble/main amd64 libpython3.11-minimal amd64 3.11.8-1 [840 kB] 511s Get:4 http://ftpmaster.internal/ubuntu noble/main amd64 python3.11-minimal amd64 3.11.8-1 [2218 kB] 511s Get:5 http://ftpmaster.internal/ubuntu noble/main amd64 libpython3.11-stdlib amd64 3.11.8-1 [1932 kB] 511s Get:6 http://ftpmaster.internal/ubuntu noble/main amd64 python3.11 amd64 3.11.8-1 [589 kB] 511s Get:7 http://ftpmaster.internal/ubuntu noble/main amd64 python3-all amd64 3.12.1-0ubuntu1 [910 B] 511s Get:8 http://ftpmaster.internal/ubuntu noble/main amd64 python3-colorama all 0.4.6-4 [32.1 kB] 511s Get:9 http://ftpmaster.internal/ubuntu noble/main amd64 python3-click all 8.1.6-1 [79.0 kB] 511s Get:10 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-click-default-group all 1.2.4-1 [5684 B] 511s Get:11 http://ftpmaster.internal/ubuntu noble/main amd64 python3-dateutil all 2.8.2-3 [79.2 kB] 511s Get:12 http://ftpmaster.internal/ubuntu noble/main amd64 python3-sortedcontainers all 2.4.0-2 [27.6 kB] 511s Get:13 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-hypothesis all 6.92.2-1 [371 kB] 511s Get:14 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-iniconfig all 1.1.1-2 [6024 B] 511s Get:15 http://ftpmaster.internal/ubuntu noble/main amd64 python3-packaging all 23.2-1 [40.6 kB] 511s Get:16 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-pluggy all 1.4.0-1 [20.4 kB] 511s Get:17 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 python3-pytest all 8.0.2-1 [248 kB] 511s Get:18 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-sqlite-fts4 all 1.0.3-2 [9228 B] 511s Get:19 http://ftpmaster.internal/ubuntu noble/main amd64 python3-tabulate all 0.8.10-1 [38.2 kB] 511s Get:20 http://ftpmaster.internal/ubuntu noble/main amd64 libjs-jquery all 3.6.1+dfsg+~3.5.14-1 [328 kB] 511s Get:21 http://ftpmaster.internal/ubuntu noble/main amd64 libjs-underscore all 1.13.4~dfsg+~1.11.4-3 [118 kB] 511s Get:22 http://ftpmaster.internal/ubuntu noble/main amd64 libjs-sphinxdoc all 7.2.6-4 [149 kB] 511s Get:23 http://ftpmaster.internal/ubuntu noble/universe amd64 sqlite-utils all 3.35.2-1 [525 kB] 511s Fetched 7867 kB in 0s (81.3 MB/s) 511s Selecting previously unselected package python3-lib2to3. 511s (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 ... 69992 files and directories currently installed.) 511s Preparing to unpack .../00-python3-lib2to3_3.11.5-1_all.deb ... 511s Unpacking python3-lib2to3 (3.11.5-1) ... 511s Selecting previously unselected package python3-distutils. 511s Preparing to unpack .../01-python3-distutils_3.11.5-1_all.deb ... 511s Unpacking python3-distutils (3.11.5-1) ... 511s Selecting previously unselected package libpython3.11-minimal:amd64. 511s Preparing to unpack .../02-libpython3.11-minimal_3.11.8-1_amd64.deb ... 511s Unpacking libpython3.11-minimal:amd64 (3.11.8-1) ... 511s Selecting previously unselected package python3.11-minimal. 511s Preparing to unpack .../03-python3.11-minimal_3.11.8-1_amd64.deb ... 511s Unpacking python3.11-minimal (3.11.8-1) ... 511s Selecting previously unselected package libpython3.11-stdlib:amd64. 511s Preparing to unpack .../04-libpython3.11-stdlib_3.11.8-1_amd64.deb ... 511s Unpacking libpython3.11-stdlib:amd64 (3.11.8-1) ... 512s Selecting previously unselected package python3.11. 512s Preparing to unpack .../05-python3.11_3.11.8-1_amd64.deb ... 512s Unpacking python3.11 (3.11.8-1) ... 512s Selecting previously unselected package python3-all. 512s Preparing to unpack .../06-python3-all_3.12.1-0ubuntu1_amd64.deb ... 512s Unpacking python3-all (3.12.1-0ubuntu1) ... 512s Selecting previously unselected package python3-colorama. 512s Preparing to unpack .../07-python3-colorama_0.4.6-4_all.deb ... 512s Unpacking python3-colorama (0.4.6-4) ... 512s Selecting previously unselected package python3-click. 512s Preparing to unpack .../08-python3-click_8.1.6-1_all.deb ... 512s Unpacking python3-click (8.1.6-1) ... 512s Selecting previously unselected package python3-click-default-group. 512s Preparing to unpack .../09-python3-click-default-group_1.2.4-1_all.deb ... 512s Unpacking python3-click-default-group (1.2.4-1) ... 512s Selecting previously unselected package python3-dateutil. 512s Preparing to unpack .../10-python3-dateutil_2.8.2-3_all.deb ... 512s Unpacking python3-dateutil (2.8.2-3) ... 512s Selecting previously unselected package python3-sortedcontainers. 512s Preparing to unpack .../11-python3-sortedcontainers_2.4.0-2_all.deb ... 512s Unpacking python3-sortedcontainers (2.4.0-2) ... 512s Selecting previously unselected package python3-hypothesis. 512s Preparing to unpack .../12-python3-hypothesis_6.92.2-1_all.deb ... 512s Unpacking python3-hypothesis (6.92.2-1) ... 512s Selecting previously unselected package python3-iniconfig. 512s Preparing to unpack .../13-python3-iniconfig_1.1.1-2_all.deb ... 512s Unpacking python3-iniconfig (1.1.1-2) ... 512s Selecting previously unselected package python3-packaging. 512s Preparing to unpack .../14-python3-packaging_23.2-1_all.deb ... 512s Unpacking python3-packaging (23.2-1) ... 512s Selecting previously unselected package python3-pluggy. 512s Preparing to unpack .../15-python3-pluggy_1.4.0-1_all.deb ... 512s Unpacking python3-pluggy (1.4.0-1) ... 512s Selecting previously unselected package python3-pytest. 512s Preparing to unpack .../16-python3-pytest_8.0.2-1_all.deb ... 512s Unpacking python3-pytest (8.0.2-1) ... 512s Selecting previously unselected package python3-sqlite-fts4. 512s Preparing to unpack .../17-python3-sqlite-fts4_1.0.3-2_all.deb ... 512s Unpacking python3-sqlite-fts4 (1.0.3-2) ... 512s Selecting previously unselected package python3-tabulate. 512s Preparing to unpack .../18-python3-tabulate_0.8.10-1_all.deb ... 512s Unpacking python3-tabulate (0.8.10-1) ... 512s Selecting previously unselected package libjs-jquery. 512s Preparing to unpack .../19-libjs-jquery_3.6.1+dfsg+~3.5.14-1_all.deb ... 512s Unpacking libjs-jquery (3.6.1+dfsg+~3.5.14-1) ... 512s Selecting previously unselected package libjs-underscore. 512s Preparing to unpack .../20-libjs-underscore_1.13.4~dfsg+~1.11.4-3_all.deb ... 512s Unpacking libjs-underscore (1.13.4~dfsg+~1.11.4-3) ... 512s Selecting previously unselected package libjs-sphinxdoc. 512s Preparing to unpack .../21-libjs-sphinxdoc_7.2.6-4_all.deb ... 512s Unpacking libjs-sphinxdoc (7.2.6-4) ... 512s Selecting previously unselected package sqlite-utils. 512s Preparing to unpack .../22-sqlite-utils_3.35.2-1_all.deb ... 512s Unpacking sqlite-utils (3.35.2-1) ... 512s Setting up python3-iniconfig (1.1.1-2) ... 512s Setting up python3-colorama (0.4.6-4) ... 513s Setting up python3-tabulate (0.8.10-1) ... 513s Setting up python3-sortedcontainers (2.4.0-2) ... 513s Setting up python3-sqlite-fts4 (1.0.3-2) ... 513s Setting up python3-click (8.1.6-1) ... 513s Setting up python3-packaging (23.2-1) ... 514s Setting up python3-click-default-group (1.2.4-1) ... 514s Setting up python3-pluggy (1.4.0-1) ... 514s Setting up python3-dateutil (2.8.2-3) ... 514s Setting up libpython3.11-minimal:amd64 (3.11.8-1) ... 514s Setting up libjs-jquery (3.6.1+dfsg+~3.5.14-1) ... 514s Setting up python3-lib2to3 (3.11.5-1) ... 514s Setting up libjs-underscore (1.13.4~dfsg+~1.11.4-3) ... 514s Setting up python3-distutils (3.11.5-1) ... 515s python3.12: can't get files for byte-compilation 515s Setting up python3.11-minimal (3.11.8-1) ... 515s Setting up python3-pytest (8.0.2-1) ... 516s Setting up libpython3.11-stdlib:amd64 (3.11.8-1) ... 516s Setting up python3-hypothesis (6.92.2-1) ... 516s Setting up libjs-sphinxdoc (7.2.6-4) ... 516s Setting up sqlite-utils (3.35.2-1) ... 517s Setting up python3.11 (3.11.8-1) ... 517s Setting up python3-all (3.12.1-0ubuntu1) ... 517s Setting up autopkgtest-satdep (0) ... 517s Processing triggers for man-db (2.12.0-3) ... 518s Processing triggers for systemd (255.2-3ubuntu2) ... 521s (Reading database ... 71459 files and directories currently installed.) 521s Removing autopkgtest-satdep (0) ... 521s autopkgtest [00:47:57]: test run-tests: [----------------------- 522s ============================= test session starts ============================== 522s platform linux -- Python 3.11.8, pytest-8.0.2, pluggy-1.4.0 -- /usr/bin/python3.11 522s cachedir: .pytest_cache 522s hypothesis profile 'default' -> database=DirectoryBasedExampleDatabase(PosixPath('/tmp/autopkgtest.6YryoZ/autopkgtest_tmp/.hypothesis/examples')) 522s rootdir: /tmp/autopkgtest.6YryoZ/autopkgtest_tmp 522s plugins: hypothesis-6.92.2 523s collecting ... collected 965 items 523s 523s tests/test_analyze.py::test_analyze_whole_database PASSED [ 0%] 523s tests/test_analyze.py::test_analyze_one_table[db_method_with_name] PASSED [ 0%] 523s tests/test_analyze.py::test_analyze_one_table[table_method] PASSED [ 0%] 523s tests/test_analyze.py::test_analyze_index_by_name PASSED [ 0%] 523s tests/test_analyze_tables.py::test_analyze_column[id-extra_kwargs0-expected0] PASSED [ 0%] 523s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs1-expected1] PASSED [ 0%] 523s tests/test_analyze_tables.py::test_analyze_column[size-extra_kwargs2-expected2] PASSED [ 0%] 523s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs3-expected3] PASSED [ 0%] 523s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs4-expected4] PASSED [ 0%] 523s tests/test_analyze_tables.py::test_analyze_table PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_save PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[False-False] PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[True-False] PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[False-True] PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[True-True] PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_column_all_nulls PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args0-These columns were not found: bad_column\n] PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args1-These columns were not found: age\n] PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args2-None] PASSED [ 1%] 523s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args3-These columns were not found: age, bad\n] PASSED [ 2%] 523s tests/test_attach.py::test_attach PASSED [ 2%] 523s tests/test_cli.py::test_help[options0] PASSED [ 2%] 523s tests/test_cli.py::test_help[options1] PASSED [ 2%] 523s tests/test_cli.py::test_help[options2] PASSED [ 2%] 523s tests/test_cli.py::test_help[options3] PASSED [ 2%] 523s tests/test_cli.py::test_tables PASSED [ 2%] 523s tests/test_cli.py::test_views PASSED [ 2%] 523s tests/test_cli.py::test_tables_fts4 PASSED [ 2%] 523s tests/test_cli.py::test_tables_fts5 PASSED [ 3%] 523s tests/test_cli.py::test_tables_counts_and_columns PASSED [ 3%] 523s tests/test_cli.py::test_tables_counts_and_columns_csv[--csv-table,count,columns\nGosh,0,"c1\nc2\nc3"\nGosh2,0,"c1\nc2\nc3"\nlots,30,"id\nage"] PASSED [ 3%] 523s tests/test_cli.py::test_tables_counts_and_columns_csv[--tsv-table\tcount\tcolumns\nGosh\t0\t['c1', 'c2', 'c3']\nGosh2\t0\t['c1', 'c2', 'c3']\nlots\t30\t['id', 'age']] PASSED [ 3%] 523s tests/test_cli.py::test_tables_schema PASSED [ 3%] 523s tests/test_cli.py::test_output_table[options0-c1 c2 c3\n----- ----- ----------\nverb0 noun0 adjective0\nverb1 noun1 adjective1\nverb2 noun2 adjective2\nverb3 noun3 adjective3] PASSED [ 3%] 523s tests/test_cli.py::test_output_table[options1-c1 c2 c3\n----- ----- ----------\nverb0 noun0 adjective0\nverb1 noun1 adjective1\nverb2 noun2 adjective2\nverb3 noun3 adjective3] PASSED [ 3%] 523s tests/test_cli.py::test_output_table[options2-===== ===== ==========\nc1 c2 c3\n===== ===== ==========\nverb0 noun0 adjective0\nverb1 noun1 adjective1\nverb2 noun2 adjective2\nverb3 noun3 adjective3\n===== ===== ==========] PASSED [ 3%] 523s tests/test_cli.py::test_create_index PASSED [ 3%] 523s tests/test_cli.py::test_create_index_analyze PASSED [ 3%] 523s tests/test_cli.py::test_create_index_desc PASSED [ 4%] 523s tests/test_cli.py::test_add_column[text-TEXT-CREATE TABLE [dogs] (\n [name] TEXT\n, [text] TEXT)] PASSED [ 4%] 523s tests/test_cli.py::test_add_column[integer-INTEGER-CREATE TABLE [dogs] (\n [name] TEXT\n, [integer] INTEGER)] PASSED [ 4%] 523s tests/test_cli.py::test_add_column[float-FLOAT-CREATE TABLE [dogs] (\n [name] TEXT\n, [float] FLOAT)] PASSED [ 4%] 523s tests/test_cli.py::test_add_column[blob-blob-CREATE TABLE [dogs] (\n [name] TEXT\n, [blob] BLOB)] PASSED [ 4%] 523s tests/test_cli.py::test_add_column[default-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [default] TEXT)] PASSED [ 4%] 523s tests/test_cli.py::test_add_column_ignore[True] PASSED [ 4%] 523s tests/test_cli.py::test_add_column_ignore[False] PASSED [ 4%] 523s tests/test_cli.py::test_add_column_not_null_default PASSED [ 4%] 523s tests/test_cli.py::test_add_foreign_key[args0-Explicit other_table and other_column] PASSED [ 4%] 523s tests/test_cli.py::test_add_foreign_key[args1-Explicit other_table, guess other_column] PASSED [ 5%] 523s tests/test_cli.py::test_add_foreign_key[args2-Automatically guess other_table and other_column] PASSED [ 5%] 523s tests/test_cli.py::test_add_column_foreign_key PASSED [ 5%] 523s tests/test_cli.py::test_suggest_alter_if_column_missing PASSED [ 5%] 523s tests/test_cli.py::test_index_foreign_keys PASSED [ 5%] 523s tests/test_cli.py::test_enable_fts PASSED [ 5%] 523s tests/test_cli.py::test_enable_fts_replace PASSED [ 5%] 523s tests/test_cli.py::test_enable_fts_with_triggers PASSED [ 5%] 523s tests/test_cli.py::test_populate_fts PASSED [ 5%] 523s tests/test_cli.py::test_disable_fts PASSED [ 6%] 523s tests/test_cli.py::test_vacuum PASSED [ 6%] 523s tests/test_cli.py::test_dump PASSED [ 6%] 524s tests/test_cli.py::test_optimize[tables0] PASSED [ 6%] 525s tests/test_cli.py::test_optimize[tables1] PASSED [ 6%] 526s tests/test_cli.py::test_optimize[tables2] PASSED [ 6%] 528s tests/test_cli.py::test_rebuild_fts_fixes_docsize_error PASSED [ 6%] 528s tests/test_cli.py::test_query_csv[--csv-id,name,age\n1,Cleo,4\n2,Pancakes,2\n] PASSED [ 6%] 528s tests/test_cli.py::test_query_csv[--tsv-id\tname\tage\n1\tCleo\t4\n2\tPancakes\t2\n] PASSED [ 6%] 528s tests/test_cli.py::test_query_json[select id, name, age from dogs-args0-[{"id": 1, "name": "Cleo", "age": 4},\n {"id": 2, "name": "Pancakes", "age": 2}]] PASSED [ 6%] 528s tests/test_cli.py::test_query_json[select id, name, age from dogs-args1-{"id": 1, "name": "Cleo", "age": 4}\n{"id": 2, "name": "Pancakes", "age": 2}] PASSED [ 7%] 528s tests/test_cli.py::test_query_json[select id, name, age from dogs-args2-[[1, "Cleo", 4],\n [2, "Pancakes", 2]]] PASSED [ 7%] 528s tests/test_cli.py::test_query_json[select id, name, age from dogs-args3-[1, "Cleo", 4]\n[2, "Pancakes", 2]] PASSED [ 7%] 528s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args4-[{"id": 1, "name": "Cleo", "age": 4}]] PASSED [ 7%] 528s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args5-{"id": 1, "name": "Cleo", "age": 4}] PASSED [ 7%] 528s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args6-[[1, "Cleo", 4]]] PASSED [ 7%] 528s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args7-[1, "Cleo", 4]] PASSED [ 7%] 528s tests/test_cli.py::test_query_json[select id, dog(age) from dogs-args8-[{"id": 1, "dog(age)": 28},\n {"id": 2, "dog(age)": 14}]] PASSED [ 7%] 528s tests/test_cli.py::test_query_json_empty PASSED [ 7%] 528s tests/test_cli.py::test_query_invalid_function PASSED [ 7%] 528s tests/test_cli.py::test_query_complex_function PASSED [ 8%] 528s tests/test_cli.py::test_hidden_functions_are_hidden PASSED [ 8%] 528s tests/test_cli.py::test_query_json_binary PASSED [ 8%] 528s tests/test_cli.py::test_query_params[select 1 + 1 as out-params0-2] PASSED [ 8%] 528s tests/test_cli.py::test_query_params[select 1 + :p as out-params1-3] PASSED [ 8%] 528s tests/test_cli.py::test_query_params[select :hello as out-params2-This"has'many'quote"s] PASSED [ 8%] 528s tests/test_cli.py::test_query_json_with_json_cols PASSED [ 8%] 528s tests/test_cli.py::test_query_raw[\x00\x0fbinary-True] PASSED [ 8%] 528s tests/test_cli.py::test_query_raw[this is text-False] PASSED [ 8%] 528s tests/test_cli.py::test_query_raw[1-False] PASSED [ 9%] 528s tests/test_cli.py::test_query_raw[1.5-False] PASSED [ 9%] 528s tests/test_cli.py::test_query_raw_lines[\x00\x0fbinary-True] PASSED [ 9%] 528s tests/test_cli.py::test_query_raw_lines[this is text-False] PASSED [ 9%] 528s tests/test_cli.py::test_query_raw_lines[1-False] PASSED [ 9%] 528s tests/test_cli.py::test_query_raw_lines[1.5-False] PASSED [ 9%] 528s tests/test_cli.py::test_query_memory_does_not_create_file PASSED [ 9%] 528s tests/test_cli.py::test_rows[args0-[{"id": 1, "name": "Cleo", "age": 4},\n {"id": 2, "name": "Pancakes", "age": 2}]] PASSED [ 9%] 528s tests/test_cli.py::test_rows[args1-{"id": 1, "name": "Cleo", "age": 4}\n{"id": 2, "name": "Pancakes", "age": 2}] PASSED [ 9%] 528s tests/test_cli.py::test_rows[args2-[[1, "Cleo", 4],\n [2, "Pancakes", 2]]] PASSED [ 9%] 528s tests/test_cli.py::test_rows[args3-[1, "Cleo", 4]\n[2, "Pancakes", 2]] PASSED [ 10%] 528s tests/test_cli.py::test_rows[args4-{"age": 4, "name": "Cleo"}\n{"age": 2, "name": "Pancakes"}] PASSED [ 10%] 528s tests/test_cli.py::test_rows[args5-[{"name": "Cleo"}]] PASSED [ 10%] 528s tests/test_cli.py::test_rows[args6-[{"name": "Pancakes"}]] PASSED [ 10%] 528s tests/test_cli.py::test_rows[args7-[{"name": "Cleo"}]] PASSED [ 10%] 528s tests/test_cli.py::test_rows[args8-[{"name": "Cleo"}]] PASSED [ 10%] 528s tests/test_cli.py::test_rows[args9-[{"name": "Cleo"}]] PASSED [ 10%] 528s tests/test_cli.py::test_rows[args10-[{"id": 2}]] PASSED [ 10%] 528s tests/test_cli.py::test_rows[args11-[{"id": 1}]] PASSED [ 10%] 528s tests/test_cli.py::test_upsert PASSED [ 10%] 528s tests/test_cli.py::test_upsert_pk_required PASSED [ 11%] 528s tests/test_cli.py::test_upsert_analyze PASSED [ 11%] 528s tests/test_cli.py::test_upsert_flatten PASSED [ 11%] 528s tests/test_cli.py::test_upsert_alter PASSED [ 11%] 528s tests/test_cli.py::test_create_table[args0-CREATE TABLE [t] (\n [name] TEXT,\n [age] INTEGER\n)] PASSED [ 11%] 528s tests/test_cli.py::test_create_table[args1-CREATE TABLE [t] (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [age] INTEGER,\n [weight] FLOAT,\n [thumbnail] BLOB\n)] PASSED [ 11%] 528s tests/test_cli.py::test_create_table[args2-CREATE TABLE [t] (\n [name] TEXT NOT NULL\n)] PASSED [ 11%] 528s tests/test_cli.py::test_create_table[args3-CREATE TABLE [t] (\n [age] INTEGER DEFAULT '3'\n)] PASSED [ 11%] 528s tests/test_cli.py::test_create_table_foreign_key PASSED [ 11%] 528s tests/test_cli.py::test_create_table_error_if_table_exists PASSED [ 12%] 528s tests/test_cli.py::test_create_table_ignore PASSED [ 12%] 528s tests/test_cli.py::test_create_table_replace PASSED [ 12%] 528s tests/test_cli.py::test_create_view PASSED [ 12%] 528s tests/test_cli.py::test_create_view_error_if_view_exists PASSED [ 12%] 528s tests/test_cli.py::test_create_view_ignore PASSED [ 12%] 528s tests/test_cli.py::test_create_view_replace PASSED [ 12%] 528s tests/test_cli.py::test_drop_table PASSED [ 12%] 528s tests/test_cli.py::test_drop_table_error PASSED [ 12%] 528s tests/test_cli.py::test_drop_view PASSED [ 12%] 528s tests/test_cli.py::test_drop_view_error PASSED [ 13%] 528s tests/test_cli.py::test_enable_wal PASSED [ 13%] 528s tests/test_cli.py::test_disable_wal PASSED [ 13%] 528s tests/test_cli.py::test_query_update[args0-[{"rows_affected": 1}]] PASSED [ 13%] 528s tests/test_cli.py::test_query_update[args1-rows_affected\n---------------\n 1] PASSED [ 13%] 528s tests/test_cli.py::test_add_foreign_keys PASSED [ 13%] 528s tests/test_cli.py::test_transform[args0-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT\n)] PASSED [ 13%] 528s tests/test_cli.py::test_transform[args1-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] TEXT NOT NULL DEFAULT '1',\n [name] TEXT\n)] PASSED [ 13%] 528s tests/test_cli.py::test_transform[args2-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)] PASSED [ 13%] 528s tests/test_cli.py::test_transform[args3-CREATE TABLE "dogs" (\n [pk] INTEGER PRIMARY KEY,\n [age2] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT\n)] PASSED [ 13%] 528s tests/test_cli.py::test_transform[args4-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT NOT NULL\n)] PASSED [ 14%] 528s tests/test_cli.py::test_transform[args5-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER DEFAULT '1',\n [name] TEXT\n)] PASSED [ 14%] 528s tests/test_cli.py::test_transform[args6-CREATE TABLE "dogs" (\n [id] INTEGER,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT PRIMARY KEY\n)] PASSED [ 14%] 528s tests/test_cli.py::test_transform[args7-CREATE TABLE "dogs" (\n [id] INTEGER,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT\n)] PASSED [ 14%] 529s tests/test_cli.py::test_transform[args8-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT DEFAULT 'Turnip'\n)] PASSED [ 14%] 529s tests/test_cli.py::test_transform[args9-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER NOT NULL,\n [name] TEXT\n)] PASSED [ 14%] 529s tests/test_cli.py::test_transform[args10-CREATE TABLE "dogs" (\n [name] TEXT,\n [age] INTEGER NOT NULL DEFAULT '1',\n [id] INTEGER PRIMARY KEY\n)] PASSED [ 14%] 529s tests/test_cli.py::test_transform_add_or_drop_foreign_key[extra_args0-CREATE TABLE "places" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [country] INTEGER,\n [city] INTEGER REFERENCES [city]([id]),\n [continent] INTEGER\n)] PASSED [ 14%] 529s tests/test_cli.py::test_transform_add_or_drop_foreign_key[extra_args1-CREATE TABLE "places" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [country] INTEGER,\n [city] INTEGER,\n [continent] INTEGER\n)] PASSED [ 14%] 529s tests/test_cli.py::test_transform_add_or_drop_foreign_key[extra_args2-CREATE TABLE "places" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [country] INTEGER REFERENCES [country]([id]),\n [city] INTEGER REFERENCES [city]([id]),\n [continent] INTEGER REFERENCES [continent]([id])\n)] PASSED [ 15%] 529s tests/test_cli.py::test_extract[args0-CREATE TABLE "trees" (\n [id] INTEGER PRIMARY KEY,\n [address] TEXT,\n [species_id] INTEGER REFERENCES [species]([id])\n)-CREATE TABLE [species] (\n [id] INTEGER PRIMARY KEY,\n [species] TEXT\n)] PASSED [ 15%] 529s tests/test_cli.py::test_extract[args1-CREATE TABLE "trees" (\n [id] INTEGER PRIMARY KEY,\n [address] TEXT,\n [custom_table_id] INTEGER REFERENCES [custom_table]([id])\n)-CREATE TABLE [custom_table] (\n [id] INTEGER PRIMARY KEY,\n [species] TEXT\n)] PASSED [ 15%] 529s tests/test_cli.py::test_extract[args2-CREATE TABLE "trees" (\n [id] INTEGER PRIMARY KEY,\n [address] TEXT,\n [custom_fk] INTEGER REFERENCES [species]([id])\n)-CREATE TABLE [species] (\n [id] INTEGER PRIMARY KEY,\n [species] TEXT\n)] PASSED [ 15%] 529s tests/test_cli.py::test_extract[args3-CREATE TABLE "trees" (\n [id] INTEGER PRIMARY KEY,\n [address] TEXT,\n [species_id] INTEGER REFERENCES [species]([id])\n)-CREATE TABLE [species] (\n [id] INTEGER PRIMARY KEY,\n [species] TEXT\n)] PASSED [ 15%] 529s tests/test_cli.py::test_insert_encoding PASSED [ 15%] 529s tests/test_cli.py::test_search[None-[{"rowid": 2, "id": 2, "title": "Title the second"}]\n-FTS4] PASSED [ 15%] 529s tests/test_cli.py::test_search[None-[{"rowid": 2, "id": 2, "title": "Title the second"}]\n-FTS5] PASSED [ 15%] 529s tests/test_cli.py::test_search[--csv-rowid,id,title\n2,2,Title the second\n-FTS4] PASSED [ 15%] 529s tests/test_cli.py::test_search[--csv-rowid,id,title\n2,2,Title the second\n-FTS5] PASSED [ 15%] 529s tests/test_cli.py::test_search_quote PASSED [ 16%] 529s tests/test_cli.py::test_indexes PASSED [ 16%] 529s tests/test_cli.py::test_triggers[extra_args0-[{"name": "blah", "table": "articles", "sql": "CREATE TRIGGER blah AFTER INSERT ON articles\\nBEGIN\\n UPDATE counter SET count = count + 1;\\nEND"}]\n] PASSED [ 16%] 529s tests/test_cli.py::test_triggers[extra_args1-[{"name": "blah", "table": "articles", "sql": "CREATE TRIGGER blah AFTER INSERT ON articles\\nBEGIN\\n UPDATE counter SET count = count + 1;\\nEND"}]\n] PASSED [ 16%] 529s tests/test_cli.py::test_triggers[extra_args2-[]\n] PASSED [ 16%] 529s tests/test_cli.py::test_schema[options0-CREATE TABLE [dogs] (\n [id] INTEGER,\n [name] TEXT\n);\nCREATE TABLE [chickens] (\n [id] INTEGER,\n [name] TEXT,\n [breed] TEXT\n);\nCREATE INDEX [idx_chickens_breed]\n ON [chickens] ([breed]);\n] PASSED [ 16%] 529s tests/test_cli.py::test_schema[options1-CREATE TABLE [dogs] (\n [id] INTEGER,\n [name] TEXT\n)\n] PASSED [ 16%] 529s tests/test_cli.py::test_schema[options2-CREATE TABLE [chickens] (\n [id] INTEGER,\n [name] TEXT,\n [breed] TEXT\n)\nCREATE TABLE [dogs] (\n [id] INTEGER,\n [name] TEXT\n)\n] PASSED [ 16%] 529s tests/test_cli.py::test_long_csv_column_value PASSED [ 16%] 529s tests/test_cli.py::test_import_no_headers[args0-False] PASSED [ 16%] 529s tests/test_cli.py::test_import_no_headers[args1-False] PASSED [ 17%] 529s tests/test_cli.py::test_import_no_headers[args2-True] PASSED [ 17%] 529s tests/test_cli.py::test_attach PASSED [ 17%] 529s tests/test_cli.py::test_csv_insert_bom PASSED [ 17%] 529s tests/test_cli.py::test_insert_detect_types[None] PASSED [ 17%] 529s tests/test_cli.py::test_insert_detect_types[-d] PASSED [ 17%] 529s tests/test_cli.py::test_insert_detect_types[--detect-types] PASSED [ 17%] 529s tests/test_cli.py::test_upsert_detect_types[-d] PASSED [ 17%] 529s tests/test_cli.py::test_upsert_detect_types[--detect-types] PASSED [ 17%] 529s tests/test_cli.py::test_integer_overflow_error PASSED [ 18%] 529s tests/test_cli.py::test_python_dash_m PASSED [ 18%] 529s tests/test_cli.py::test_create_database[False] PASSED [ 18%] 529s tests/test_cli.py::test_create_database[True] PASSED [ 18%] 529s tests/test_cli.py::test_analyze[options0-expected0] PASSED [ 18%] 529s tests/test_cli.py::test_analyze[options1-expected1] PASSED [ 18%] 529s tests/test_cli.py::test_analyze[options2-expected2] PASSED [ 18%] 529s tests/test_cli.py::test_rename_table PASSED [ 18%] 529s tests/test_cli.py::test_duplicate_table PASSED [ 18%] 529s tests/test_cli.py::test_load_extension[None-should_pass0-should_fail0] SKIPPED [ 18%] 529s tests/test_cli.py::test_load_extension[sqlite3_ext_b_init-b-should_fail1] SKIPPED [ 19%] 529s tests/test_cli.py::test_load_extension[sqlite3_ext_c_init-c-should_fail2] SKIPPED [ 19%] 529s tests/test_cli_bulk.py::test_cli_bulk PASSED [ 19%] 531s tests/test_cli_bulk.py::test_cli_bulk_batch_size PASSED [ 19%] 531s tests/test_cli_bulk.py::test_cli_bulk_error PASSED [ 19%] 531s tests/test_cli_convert.py::test_convert_code[return value.replace('October', 'Spooktober')] PASSED [ 19%] 532s tests/test_cli_convert.py::test_convert_code[value.replace('October', 'Spooktober')] PASSED [ 19%] 532s tests/test_cli_convert.py::test_convert_code[v = value.replace('October', 'Spooktober')\nreturn v] PASSED [ 19%] 532s tests/test_cli_convert.py::test_convert_code[def convert(value): return value.replace('October', 'Spooktober')] PASSED [ 19%] 532s tests/test_cli_convert.py::test_convert_code[import re\n\ndef convert(value): return value.replace('October', 'Spooktober')] PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_code_errors[def foo(value)] PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_code_errors[$] PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_import PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_import_nested PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_dryrun PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_multi_dryrun PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_output_column[True] PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_output_column[False] PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_output_column_output_type[text-expected0] PASSED [ 20%] 532s tests/test_cli_convert.py::test_convert_output_column_output_type[float-expected1] PASSED [ 21%] 532s tests/test_cli_convert.py::test_convert_output_column_output_type[integer-expected2] PASSED [ 21%] 532s tests/test_cli_convert.py::test_convert_output_column_output_type[None-expected3] PASSED [ 21%] 532s tests/test_cli_convert.py::test_convert_output_error[options0-Cannot use --output with more than one column] PASSED [ 21%] 532s tests/test_cli_convert.py::test_convert_output_error[options1-Error: Invalid value for '--output-type'] PASSED [ 21%] 532s tests/test_cli_convert.py::test_convert_output_error[options2-Missing argument 'COLUMNS...'] PASSED [ 21%] 532s tests/test_cli_convert.py::test_convert_multi[True] PASSED [ 21%] 532s tests/test_cli_convert.py::test_convert_multi[False] PASSED [ 21%] 532s tests/test_cli_convert.py::test_convert_multi_complex_column_types PASSED [ 21%] 532s tests/test_cli_convert.py::test_recipe_jsonsplit[None] PASSED [ 21%] 532s tests/test_cli_convert.py::test_recipe_jsonsplit[;] PASSED [ 22%] 532s tests/test_cli_convert.py::test_recipe_jsonsplit[-] PASSED [ 22%] 532s tests/test_cli_convert.py::test_recipe_jsonsplit_type[None-expected_array0] PASSED [ 22%] 532s tests/test_cli_convert.py::test_recipe_jsonsplit_type[float-expected_array1] PASSED [ 22%] 532s tests/test_cli_convert.py::test_recipe_jsonsplit_type[int-expected_array2] PASSED [ 22%] 532s tests/test_cli_convert.py::test_recipe_jsonsplit_output[True] PASSED [ 22%] 532s tests/test_cli_convert.py::test_recipe_jsonsplit_output[False] PASSED [ 22%] 532s tests/test_cli_convert.py::test_cannot_use_drop_without_multi_or_output PASSED [ 22%] 532s tests/test_cli_convert.py::test_cannot_use_multi_with_more_than_one_column PASSED [ 22%] 532s tests/test_cli_convert.py::test_multi_with_bad_function PASSED [ 23%] 532s tests/test_cli_convert.py::test_convert_where PASSED [ 23%] 532s tests/test_cli_convert.py::test_convert_where_multi PASSED [ 23%] 532s tests/test_cli_convert.py::test_convert_code_standard_input PASSED [ 23%] 532s tests/test_cli_convert.py::test_convert_hyphen_workaround PASSED [ 23%] 532s tests/test_cli_convert.py::test_convert_initialization_pattern PASSED [ 23%] 532s tests/test_cli_convert.py::test_convert_no_skip_false[True-1] PASSED [ 23%] 532s tests/test_cli_convert.py::test_convert_no_skip_false[False-0] PASSED [ 23%] 532s tests/test_cli_insert.py::test_insert_simple PASSED [ 23%] 532s tests/test_cli_insert.py::test_insert_from_stdin PASSED [ 23%] 532s tests/test_cli_insert.py::test_insert_invalid_json_error PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_json_flatten PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_json_flatten_nl PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_with_primary_key PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_multiple_with_primary_key PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_multiple_with_compound_primary_key PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_not_null_default PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_binary_base64 PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_newline_delimited PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_ignore PASSED [ 24%] 532s tests/test_cli_insert.py::test_insert_csv_tsv[foo\tbar\tbaz\n1\t2\tcat,dog-options0] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,"cat,dog"-options1] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_csv_tsv[foo;bar;baz\n1;2;"cat,dog"-options2] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_csv_tsv[foo;bar;baz\n1;2;"cat,dog"-options3] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,|cat,dog|-options4] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,|cat,dog|-options5] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_csv_empty_null[True] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_csv_empty_null[False] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_stop_after[[{"name": "One"}, {"name": "Two"}, {"name": "Three"}, {"name": "Four"}]-args0] PASSED [ 25%] 532s tests/test_cli_insert.py::test_insert_stop_after[name\nOne\nTwo\nThree\nFour\n-args1] PASSED [ 26%] 532s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options0] PASSED [ 26%] 532s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options1] PASSED [ 26%] 532s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options2] PASSED [ 26%] 532s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options3] PASSED [ 26%] 532s tests/test_cli_insert.py::test_insert_replace PASSED [ 26%] 532s tests/test_cli_insert.py::test_insert_truncate PASSED [ 26%] 532s tests/test_cli_insert.py::test_insert_alter PASSED [ 26%] 532s tests/test_cli_insert.py::test_insert_analyze PASSED [ 26%] 532s tests/test_cli_insert.py::test_insert_lines PASSED [ 26%] 532s tests/test_cli_insert.py::test_insert_text PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options0-[{"id": "1", "name": "Bob"}, {"id": "2", "name": "Cat"}]] PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options1-id,name\n1,Bob\n2,Cat] PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options2-{"id": "1", "name": "Bob"}\n{"id": "2", "name": "Cat"}] PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_text PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_text_returning_iterator PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_lines PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_row_modifying_in_place PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_error_messages[options0-Error: --convert must return dict or iterator\n] PASSED [ 27%] 532s tests/test_cli_insert.py::test_insert_convert_error_messages[options1-Error: Rows must all be dictionaries, got: 1\n] PASSED [ 27%] 533s tests/test_cli_insert.py::test_insert_streaming_batch_size_1 PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_basic PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_csv[True-test] PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_csv[True-t] PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_csv[True-t1] PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_csv[False-test] PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_csv[False-t] PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_csv[False-t1] PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_tsv[True] PASSED [ 28%] 533s tests/test_cli_memory.py::test_memory_tsv[False] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_json[True] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_json[False] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_json_nl[True] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_json_nl[False] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_csv_encoding[True] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_csv_encoding[False] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_dump[extra_args0] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_dump[extra_args1] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_schema[extra_args0] PASSED [ 29%] 533s tests/test_cli_memory.py::test_memory_schema[extra_args1] PASSED [ 30%] 533s tests/test_cli_memory.py::test_memory_save[extra_args0] PASSED [ 30%] 533s tests/test_cli_memory.py::test_memory_save[extra_args1] PASSED [ 30%] 533s tests/test_cli_memory.py::test_memory_no_detect_types[-n] PASSED [ 30%] 533s tests/test_cli_memory.py::test_memory_no_detect_types[--no-detect-types] PASSED [ 30%] 533s tests/test_cli_memory.py::test_memory_flatten PASSED [ 30%] 533s tests/test_cli_memory.py::test_memory_analyze PASSED [ 30%] 533s tests/test_cli_memory.py::test_memory_two_files_with_same_stem PASSED [ 30%] 533s tests/test_cli_memory.py::test_memory_functions PASSED [ 30%] 533s tests/test_column_affinity.py::test_column_affinity[INT-int] PASSED [ 30%] 533s tests/test_column_affinity.py::test_column_affinity[INTEGER-int] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[TINYINT-int] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[SMALLINT-int] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[MEDIUMINT-int] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[BIGINT-int] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[UNSIGNED BIG INT-int] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[INT2-int] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[INT8-int] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[CHARACTER(20)-str] PASSED [ 31%] 533s tests/test_column_affinity.py::test_column_affinity[VARCHAR(255)-str] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[VARYING CHARACTER(255)-str] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[NCHAR(55)-str] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[NATIVE CHARACTER(70)-str] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[NVARCHAR(100)-str] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[TEXT-str] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[CLOB-str] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[BLOB-bytes] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[REAL-float] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[DOUBLE-float] PASSED [ 32%] 533s tests/test_column_affinity.py::test_column_affinity[DOUBLE PRECISION-float] PASSED [ 33%] 533s tests/test_column_affinity.py::test_column_affinity[FLOAT-float] PASSED [ 33%] 533s tests/test_column_affinity.py::test_column_affinity[NUMERIC-float] PASSED [ 33%] 533s tests/test_column_affinity.py::test_column_affinity[DECIMAL(10,5)-float] PASSED [ 33%] 533s tests/test_column_affinity.py::test_column_affinity[BOOLEAN-float] PASSED [ 33%] 533s tests/test_column_affinity.py::test_column_affinity[DATE-float] PASSED [ 33%] 533s tests/test_column_affinity.py::test_column_affinity[DATETIME-float] PASSED [ 33%] 533s tests/test_column_affinity.py::test_columns_dict[INT-int] PASSED [ 33%] 533s tests/test_column_affinity.py::test_columns_dict[INTEGER-int] PASSED [ 33%] 533s tests/test_column_affinity.py::test_columns_dict[TINYINT-int] PASSED [ 33%] 533s tests/test_column_affinity.py::test_columns_dict[SMALLINT-int] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[MEDIUMINT-int] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[BIGINT-int] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[UNSIGNED BIG INT-int] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[INT2-int] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[INT8-int] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[CHARACTER(20)-str] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[VARCHAR(255)-str] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[VARYING CHARACTER(255)-str] PASSED [ 34%] 533s tests/test_column_affinity.py::test_columns_dict[NCHAR(55)-str] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[NATIVE CHARACTER(70)-str] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[NVARCHAR(100)-str] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[TEXT-str] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[CLOB-str] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[BLOB-bytes] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[REAL-float] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[DOUBLE-float] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[DOUBLE PRECISION-float] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[FLOAT-float] PASSED [ 35%] 533s tests/test_column_affinity.py::test_columns_dict[NUMERIC-float] PASSED [ 36%] 533s tests/test_column_affinity.py::test_columns_dict[DECIMAL(10,5)-float] PASSED [ 36%] 533s tests/test_column_affinity.py::test_columns_dict[BOOLEAN-float] PASSED [ 36%] 533s tests/test_column_affinity.py::test_columns_dict[DATE-float] PASSED [ 36%] 533s tests/test_column_affinity.py::test_columns_dict[DATETIME-float] PASSED [ 36%] 533s tests/test_constructor.py::test_recursive_triggers PASSED [ 36%] 533s tests/test_constructor.py::test_recursive_triggers_off PASSED [ 36%] 533s tests/test_constructor.py::test_memory_name PASSED [ 36%] 533s tests/test_constructor.py::test_sqlite_version PASSED [ 36%] 533s tests/test_constructor.py::test_database_close[True] PASSED [ 36%] 533s tests/test_constructor.py::test_database_close[False] PASSED [ 37%] 533s tests/test_conversions.py::test_insert_conversion PASSED [ 37%] 533s tests/test_conversions.py::test_insert_all_conversion PASSED [ 37%] 533s tests/test_conversions.py::test_upsert_conversion PASSED [ 37%] 533s tests/test_conversions.py::test_upsert_all_conversion PASSED [ 37%] 533s tests/test_conversions.py::test_update_conversion PASSED [ 37%] 533s tests/test_conversions.py::test_table_constructor_conversion PASSED [ 37%] 533s tests/test_convert.py::test_convert[title--expected0] PASSED [ 37%] 533s tests/test_convert.py::test_convert[columns1--expected1] PASSED [ 37%] 533s tests/test_convert.py::test_convert[title--expected2] PASSED [ 38%] 533s tests/test_convert.py::test_convert_where[id > 1-None] PASSED [ 38%] 533s tests/test_convert.py::test_convert_where[id > :id-where_args1] PASSED [ 38%] 533s tests/test_convert.py::test_convert_where[id > ?-where_args2] PASSED [ 38%] 533s tests/test_convert.py::test_convert_skip_false PASSED [ 38%] 533s tests/test_convert.py::test_convert_output[False-expected0] PASSED [ 38%] 533s tests/test_convert.py::test_convert_output[True-expected1] PASSED [ 38%] 533s tests/test_convert.py::test_convert_output_multiple_column_error PASSED [ 38%] 533s tests/test_convert.py::test_convert_output_type[int-expected0] PASSED [ 38%] 533s tests/test_convert.py::test_convert_output_type[float-expected1] PASSED [ 38%] 533s tests/test_convert.py::test_convert_multi PASSED [ 39%] 533s tests/test_convert.py::test_convert_multi_where PASSED [ 39%] 533s tests/test_convert.py::test_convert_multi_exception PASSED [ 39%] 533s tests/test_convert.py::test_convert_repeated PASSED [ 39%] 533s tests/test_create.py::test_create_table PASSED [ 39%] 533s tests/test_create.py::test_create_table_compound_primary_key PASSED [ 39%] 533s tests/test_create.py::test_create_table_with_single_primary_key[id] PASSED [ 39%] 533s tests/test_create.py::test_create_table_with_single_primary_key[pk1] PASSED [ 39%] 533s tests/test_create.py::test_create_table_with_invalid_column_characters PASSED [ 39%] 533s tests/test_create.py::test_create_table_with_defaults PASSED [ 40%] 533s tests/test_create.py::test_create_table_with_bad_not_null PASSED [ 40%] 533s tests/test_create.py::test_create_table_with_not_null PASSED [ 40%] 533s tests/test_create.py::test_create_table_from_example[example0-expected_columns0] PASSED [ 40%] 533s tests/test_create.py::test_create_table_from_example[example1-expected_columns1] PASSED [ 40%] 533s tests/test_create.py::test_create_table_from_example[example2-expected_columns2] PASSED [ 40%] 533s tests/test_create.py::test_create_table_from_example[example3-expected_columns3] PASSED [ 40%] 533s tests/test_create.py::test_create_table_from_example[example4-expected_columns4] PASSED [ 40%] 533s tests/test_create.py::test_create_table_from_example[example5-expected_columns5] PASSED [ 40%] 533s tests/test_create.py::test_create_table_from_example[example6-expected_columns6] PASSED [ 40%] 533s tests/test_create.py::test_create_table_from_example[example7-expected_columns7] PASSED [ 41%] 533s tests/test_create.py::test_create_table_from_example_with_compound_primary_keys PASSED [ 41%] 533s tests/test_create.py::test_create_table_with_custom_columns[insert] PASSED [ 41%] 533s tests/test_create.py::test_create_table_with_custom_columns[upsert] PASSED [ 41%] 533s tests/test_create.py::test_create_table_with_custom_columns[insert_all] PASSED [ 41%] 533s tests/test_create.py::test_create_table_with_custom_columns[upsert_all] PASSED [ 41%] 533s tests/test_create.py::test_create_table_column_order[True] PASSED [ 41%] 533s tests/test_create.py::test_create_table_column_order[False] PASSED [ 41%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification0-False] PASSED [ 41%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification1-False] PASSED [ 41%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification2-False] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification3-False] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification4-NoObviousTable] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification5-AssertionError] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification6-AlterError] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification7-AssertionError] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification0-False] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification1-False] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification2-False] PASSED [ 42%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification3-False] PASSED [ 43%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification4-NoObviousTable] PASSED [ 43%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification5-AssertionError] PASSED [ 43%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification6-AlterError] PASSED [ 43%] 533s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification7-AssertionError] PASSED [ 43%] 533s tests/test_create.py::test_self_referential_foreign_key PASSED [ 43%] 533s tests/test_create.py::test_create_error_if_invalid_foreign_keys PASSED [ 43%] 533s tests/test_create.py::test_create_error_if_invalid_self_referential_foreign_keys PASSED [ 43%] 533s tests/test_create.py::test_add_column[nickname-str-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [nickname] TEXT)] PASSED [ 43%] 533s tests/test_create.py::test_add_column[dob-date-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [dob] TEXT)] PASSED [ 43%] 533s tests/test_create.py::test_add_column[age-int-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [age] INTEGER)] PASSED [ 44%] 533s tests/test_create.py::test_add_column[weight-float-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [weight] FLOAT)] PASSED [ 44%] 533s tests/test_create.py::test_add_column[text-TEXT-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [text] TEXT)] PASSED [ 44%] 533s tests/test_create.py::test_add_column[integer-INTEGER-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [integer] INTEGER)] PASSED [ 44%] 533s tests/test_create.py::test_add_column[float-FLOAT-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [float] FLOAT)] PASSED [ 44%] 533s tests/test_create.py::test_add_column[blob-blob-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [blob] BLOB)] PASSED [ 44%] 533s tests/test_create.py::test_add_column[default_str-None-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [default_str] TEXT)] PASSED [ 44%] 533s tests/test_create.py::test_add_column[nickname-str--CREATE TABLE [dogs] (\n [name] TEXT\n, [nickname] TEXT NOT NULL DEFAULT '')] PASSED [ 44%] 533s tests/test_create.py::test_add_column[nickname-str-dawg's dawg-CREATE TABLE [dogs] (\n [name] TEXT\n, [nickname] TEXT NOT NULL DEFAULT 'dawg''s dawg')] PASSED [ 44%] 533s tests/test_create.py::test_add_foreign_key PASSED [ 44%] 533s tests/test_create.py::test_add_foreign_key_if_column_contains_space PASSED [ 45%] 533s tests/test_create.py::test_add_foreign_key_error_if_column_does_not_exist PASSED [ 45%] 533s tests/test_create.py::test_add_foreign_key_error_if_other_table_does_not_exist PASSED [ 45%] 533s tests/test_create.py::test_add_foreign_key_error_if_already_exists PASSED [ 45%] 533s tests/test_create.py::test_add_foreign_key_no_error_if_exists_and_ignore_true PASSED [ 45%] 533s tests/test_create.py::test_add_foreign_keys PASSED [ 45%] 533s tests/test_create.py::test_add_column_foreign_key PASSED [ 45%] 533s tests/test_create.py::test_add_foreign_key_guess_table PASSED [ 45%] 533s tests/test_create.py::test_index_foreign_keys PASSED [ 45%] 533s tests/test_create.py::test_index_foreign_keys_if_index_name_is_already_used PASSED [ 46%] 533s tests/test_create.py::test_insert_row_alter_table[True-extra_data0-expected_new_columns0] PASSED [ 46%] 533s tests/test_create.py::test_insert_row_alter_table[True-extra_data1-expected_new_columns1] PASSED [ 46%] 533s tests/test_create.py::test_insert_row_alter_table[True-extra_data2-expected_new_columns2] PASSED [ 46%] 533s tests/test_create.py::test_insert_row_alter_table[False-extra_data0-expected_new_columns0] PASSED [ 46%] 533s tests/test_create.py::test_insert_row_alter_table[False-extra_data1-expected_new_columns1] PASSED [ 46%] 533s tests/test_create.py::test_insert_row_alter_table[False-extra_data2-expected_new_columns2] PASSED [ 46%] 533s tests/test_create.py::test_add_missing_columns_case_insensitive PASSED [ 46%] 533s tests/test_create.py::test_insert_replace_rows_alter_table[True] PASSED [ 46%] 533s tests/test_create.py::test_insert_replace_rows_alter_table[False] PASSED [ 46%] 533s tests/test_create.py::test_insert_all_with_extra_columns_in_later_chunks PASSED [ 47%] 533s tests/test_create.py::test_bulk_insert_more_than_999_values PASSED [ 47%] 533s tests/test_create.py::test_error_if_more_than_999_columns[900-False] PASSED [ 47%] 533s tests/test_create.py::test_error_if_more_than_999_columns[999-False] PASSED [ 47%] 533s tests/test_create.py::test_error_if_more_than_999_columns[1000-True] PASSED [ 47%] 534s tests/test_create.py::test_columns_not_in_first_record_should_not_cause_batch_to_be_too_large PASSED [ 47%] 534s tests/test_create.py::test_create_index[columns0-None-expected_index0] PASSED [ 47%] 534s tests/test_create.py::test_create_index[columns1-None-expected_index1] PASSED [ 47%] 534s tests/test_create.py::test_create_index[columns2-age_index-expected_index2] PASSED [ 47%] 534s tests/test_create.py::test_create_index_unique PASSED [ 47%] 534s tests/test_create.py::test_create_index_if_not_exists PASSED [ 48%] 534s tests/test_create.py::test_create_index_desc PASSED [ 48%] 534s tests/test_create.py::test_create_index_find_unique_name PASSED [ 48%] 534s tests/test_create.py::test_create_index_analyze PASSED [ 48%] 534s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure0] PASSED [ 48%] 534s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure1] PASSED [ 48%] 534s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure2] PASSED [ 48%] 534s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure3] PASSED [ 48%] 534s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure4] PASSED [ 48%] 534s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure5] PASSED [ 49%] 534s tests/test_create.py::test_insert_list_nested_unicode PASSED [ 49%] 534s tests/test_create.py::test_insert_uuid PASSED [ 49%] 534s tests/test_create.py::test_insert_memoryview PASSED [ 49%] 534s tests/test_create.py::test_insert_thousands_using_generator PASSED [ 49%] 534s tests/test_create.py::test_insert_thousands_raises_exception_with_extra_columns_after_first_100 PASSED [ 49%] 534s tests/test_create.py::test_insert_thousands_adds_extra_columns_after_first_100_with_alter PASSED [ 49%] 534s tests/test_create.py::test_insert_ignore PASSED [ 49%] 534s tests/test_create.py::test_insert_hash_id PASSED [ 49%] 534s tests/test_create.py::test_insert_hash_id_columns[True] PASSED [ 49%] 534s tests/test_create.py::test_insert_hash_id_columns[False] PASSED [ 50%] 534s tests/test_create.py::test_vacuum PASSED [ 50%] 534s tests/test_create.py::test_works_with_pathlib_path PASSED [ 50%] 534s tests/test_create.py::test_create_table_numpy SKIPPED (pandas and nu...) [ 50%] 534s tests/test_create.py::test_cannot_provide_both_filename_and_memory PASSED [ 50%] 534s tests/test_create.py::test_creates_id_column PASSED [ 50%] 534s tests/test_create.py::test_drop PASSED [ 50%] 534s tests/test_create.py::test_drop_view PASSED [ 50%] 534s tests/test_create.py::test_drop_ignore PASSED [ 50%] 534s tests/test_create.py::test_insert_all_empty_list PASSED [ 50%] 534s tests/test_create.py::test_insert_all_single_column PASSED [ 51%] 534s tests/test_create.py::test_insert_all_analyze[insert_all] PASSED [ 51%] 534s tests/test_create.py::test_insert_all_analyze[upsert_all] PASSED [ 51%] 534s tests/test_create.py::test_create_with_a_null_column PASSED [ 51%] 534s tests/test_create.py::test_create_with_nested_bytes PASSED [ 51%] 534s tests/test_create.py::test_quote[hello-'hello'] PASSED [ 51%] 534s tests/test_create.py::test_quote[hello'there'-'hello''there'''] PASSED [ 51%] 534s tests/test_create.py::test_create_table_sql[columns0-[id] INTEGER] PASSED [ 51%] 534s tests/test_create.py::test_create_table_sql[columns1-[col] TEXT] PASSED [ 51%] 534s tests/test_create.py::test_create_table_sql[columns2-[col] TEXT] PASSED [ 52%] 534s tests/test_create.py::test_create_table_sql[columns3-[col] TEXT] PASSED [ 52%] 534s tests/test_create.py::test_create PASSED [ 52%] 534s tests/test_create.py::test_create_if_not_exists PASSED [ 52%] 534s tests/test_create.py::test_create_if_no_columns PASSED [ 52%] 534s tests/test_create.py::test_create_ignore PASSED [ 52%] 534s tests/test_create.py::test_create_replace PASSED [ 52%] 534s tests/test_create.py::test_create_transform[cols0-kwargs0-CREATE TABLE [demo] (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)-False] PASSED [ 52%] 534s tests/test_create.py::test_create_transform[cols1-kwargs1-CREATE TABLE "demo" (\n [id] INTEGER\n)-True] PASSED [ 52%] 534s tests/test_create.py::test_create_transform[cols2-kwargs2-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [age] INTEGER\n)-True] PASSED [ 52%] 534s tests/test_create.py::test_create_transform[cols3-kwargs3-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY,\n [name] BLOB\n)-True] PASSED [ 53%] 534s tests/test_create.py::test_create_transform[cols4-kwargs4-CREATE TABLE "demo" (\n [id] INTEGER,\n [name] TEXT PRIMARY KEY\n)-True] PASSED [ 53%] 534s tests/test_create.py::test_create_transform[cols5-kwargs5-CREATE TABLE "demo" (\n [name] TEXT,\n [id] INTEGER PRIMARY KEY\n)-True] PASSED [ 53%] 534s tests/test_create.py::test_create_transform[cols6-kwargs6-CREATE TABLE [demo] (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)-False] PASSED [ 53%] 534s tests/test_create.py::test_create_transform[cols7-kwargs7-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT NOT NULL\n)-True] PASSED [ 53%] 534s tests/test_create.py::test_create_transform[cols8-kwargs8-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY DEFAULT 0,\n [name] TEXT DEFAULT 'Bob'\n)-True] PASSED [ 53%] 534s tests/test_create.py::test_rename_table PASSED [ 53%] 534s tests/test_create_view.py::test_create_view PASSED [ 53%] 534s tests/test_create_view.py::test_create_view_error PASSED [ 53%] 534s tests/test_create_view.py::test_create_view_only_arrow_one_param PASSED [ 53%] 534s tests/test_create_view.py::test_create_view_ignore PASSED [ 54%] 534s tests/test_create_view.py::test_create_view_replace PASSED [ 54%] 534s tests/test_create_view.py::test_create_view_replace_with_same_does_nothing PASSED [ 54%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'foo'-'foo'-'foo'] PASSED [ 54%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'foo)'-'foo)'-'foo)'] PASSED [ 54%] 534s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT '1'-'1'-'1'] PASSED [ 54%] 534s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT 1-1-'1'] PASSED [ 54%] 534s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT (1)-1-'1'] PASSED [ 54%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW'))-STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')-(STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW'))] PASSED [ 54%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_TIME-CURRENT_TIME-CURRENT_TIME] PASSED [ 55%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_DATE-CURRENT_DATE-CURRENT_DATE] PASSED [ 55%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_TIMESTAMP-CURRENT_TIMESTAMP-CURRENT_TIMESTAMP] PASSED [ 55%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT current_timestamp-current_timestamp-current_timestamp] PASSED [ 55%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT (CURRENT_TIMESTAMP)-CURRENT_TIMESTAMP-CURRENT_TIMESTAMP] PASSED [ 55%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'CURRENT_TIMESTAMP'-'CURRENT_TIMESTAMP'-'CURRENT_TIMESTAMP'] PASSED [ 55%] 534s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT "CURRENT_TIMESTAMP"-"CURRENT_TIMESTAMP"-"CURRENT_TIMESTAMP"] PASSED [ 55%] 534s tests/test_delete.py::test_delete_rowid_table PASSED [ 55%] 534s tests/test_delete.py::test_delete_pk_table PASSED [ 55%] 534s tests/test_delete.py::test_delete_where PASSED [ 55%] 534s tests/test_delete.py::test_delete_where_all PASSED [ 56%] 534s tests/test_delete.py::test_delete_where_analyze PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[tables] PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[views] PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[optimize] PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[rebuild-fts] PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[analyze] PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[vacuum] PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[dump] PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[add-column] PASSED [ 56%] 534s tests/test_docs.py::test_commands_are_documented[add-foreign-key] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[add-foreign-keys] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[index-foreign-keys] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[create-index] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[enable-fts] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[populate-fts] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[disable-fts] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[enable-wal] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[disable-wal] PASSED [ 57%] 534s tests/test_docs.py::test_commands_are_documented[enable-counts] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[reset-counts] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[insert] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[upsert] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[bulk] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[create-database] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[create-table] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[duplicate] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[rename-table] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[drop-table] PASSED [ 58%] 534s tests/test_docs.py::test_commands_are_documented[create-view] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[drop-view] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[query] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[memory] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[search] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[rows] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[triggers] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[indexes] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[schema] PASSED [ 59%] 534s tests/test_docs.py::test_commands_are_documented[transform] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[extract] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[insert-files] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[analyze-tables] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[install] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[uninstall] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[convert] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[add-geometry-column] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[create-spatial-index] PASSED [ 60%] 534s tests/test_docs.py::test_commands_are_documented[plugins] PASSED [ 60%] 534s tests/test_docs.py::test_commands_have_help[command0] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command1] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command2] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command3] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command4] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command5] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command6] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command7] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command8] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command9] PASSED [ 61%] 534s tests/test_docs.py::test_commands_have_help[command10] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command11] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command12] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command13] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command14] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command15] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command16] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command17] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command18] PASSED [ 62%] 534s tests/test_docs.py::test_commands_have_help[command19] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command20] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command21] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command22] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command23] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command24] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command25] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command26] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command27] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command28] PASSED [ 63%] 534s tests/test_docs.py::test_commands_have_help[command29] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command30] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command31] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command32] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command33] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command34] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command35] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command36] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command37] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command38] PASSED [ 64%] 534s tests/test_docs.py::test_commands_have_help[command39] PASSED [ 65%] 534s tests/test_docs.py::test_commands_have_help[command40] PASSED [ 65%] 534s tests/test_docs.py::test_commands_have_help[command41] PASSED [ 65%] 534s tests/test_docs.py::test_commands_have_help[command42] PASSED [ 65%] 534s tests/test_docs.py::test_commands_have_help[command43] PASSED [ 65%] 534s tests/test_docs.py::test_commands_have_help[command44] PASSED [ 65%] 534s tests/test_docs.py::test_commands_have_help[command45] PASSED [ 65%] 534s tests/test_docs.py::test_convert_help PASSED [ 65%] 534s tests/test_docs.py::test_recipes_are_documented[jsonsplit] PASSED [ 65%] 534s tests/test_docs.py::test_recipes_are_documented[parsedate] PASSED [ 66%] 534s tests/test_docs.py::test_recipes_are_documented[parsedatetime] PASSED [ 66%] 534s tests/test_duplicate.py::test_duplicate PASSED [ 66%] 534s tests/test_duplicate.py::test_duplicate_fails_if_table_does_not_exist PASSED [ 66%] 534s tests/test_enable_counts.py::test_enable_counts_specific_table PASSED [ 66%] 534s tests/test_enable_counts.py::test_enable_counts_all_tables PASSED [ 66%] 534s tests/test_enable_counts.py::test_cli_enable_counts[extra_args0-expected_triggers0] PASSED [ 66%] 534s tests/test_enable_counts.py::test_cli_enable_counts[extra_args1-expected_triggers1] PASSED [ 66%] 534s tests/test_enable_counts.py::test_uses_counts_after_enable_counts PASSED [ 66%] 534s tests/test_enable_counts.py::test_reset_counts PASSED [ 66%] 534s tests/test_enable_counts.py::test_reset_counts_cli PASSED [ 67%] 534s tests/test_extract.py::test_extract_single_column[None-None] PASSED [ 67%] 534s tests/test_extract.py::test_extract_single_column[None-Species] PASSED [ 67%] 534s tests/test_extract.py::test_extract_single_column[species-None] PASSED [ 67%] 534s tests/test_extract.py::test_extract_single_column[species-Species] PASSED [ 67%] 534s tests/test_extract.py::test_extract_multiple_columns_with_rename PASSED [ 67%] 534s tests/test_extract.py::test_extract_invalid_columns PASSED [ 67%] 534s tests/test_extract.py::test_extract_rowid_table PASSED [ 67%] 534s tests/test_extract.py::test_reuse_lookup_table PASSED [ 67%] 534s tests/test_extract.py::test_extract_error_on_incompatible_existing_lookup_table PASSED [ 67%] 534s tests/test_extract.py::test_extract_works_with_null_values PASSED [ 68%] 534s tests/test_extracts.py::test_extracts[True-kwargs0-Species] PASSED [ 68%] 534s tests/test_extracts.py::test_extracts[True-kwargs1-species_id] PASSED [ 68%] 534s tests/test_extracts.py::test_extracts[True-kwargs2-species_id] PASSED [ 68%] 534s tests/test_extracts.py::test_extracts[False-kwargs0-Species] PASSED [ 68%] 534s tests/test_extracts.py::test_extracts[False-kwargs1-species_id] PASSED [ 68%] 534s tests/test_extracts.py::test_extracts[False-kwargs2-species_id] PASSED [ 68%] 534s tests/test_fts.py::test_enable_fts PASSED [ 68%] 534s tests/test_fts.py::test_enable_fts_escape_table_names PASSED [ 68%] 534s tests/test_fts.py::test_search_limit_offset PASSED [ 69%] 534s tests/test_fts.py::test_search_where[FTS4] PASSED [ 69%] 534s tests/test_fts.py::test_search_where[FTS5] PASSED [ 69%] 534s tests/test_fts.py::test_search_where_args_disallows_query PASSED [ 69%] 534s tests/test_fts.py::test_enable_fts_table_names_containing_spaces PASSED [ 69%] 534s tests/test_fts.py::test_populate_fts PASSED [ 69%] 534s tests/test_fts.py::test_populate_fts_escape_table_names PASSED [ 69%] 534s tests/test_fts.py::test_fts_tokenize[4] PASSED [ 69%] 534s tests/test_fts.py::test_fts_tokenize[5] PASSED [ 69%] 534s tests/test_fts.py::test_optimize_fts PASSED [ 69%] 534s tests/test_fts.py::test_enable_fts_with_triggers PASSED [ 70%] 534s tests/test_fts.py::test_disable_fts[True] PASSED [ 70%] 534s tests/test_fts.py::test_disable_fts[False] PASSED [ 70%] 534s tests/test_fts.py::test_rebuild_fts PASSED [ 70%] 534s tests/test_fts.py::test_rebuild_fts_invalid[does_not_exist] PASSED [ 70%] 534s tests/test_fts.py::test_rebuild_fts_invalid[not_searchable] PASSED [ 70%] 534s tests/test_fts.py::test_rebuild_removes_junk_docsize_rows[FTS4] PASSED [ 70%] 534s tests/test_fts.py::test_rebuild_removes_junk_docsize_rows[FTS5] PASSED [ 70%] 534s tests/test_fts.py::test_enable_fts_replace[kwargs0] PASSED [ 70%] 534s tests/test_fts.py::test_enable_fts_replace[kwargs1] PASSED [ 70%] 534s tests/test_fts.py::test_enable_fts_replace[kwargs2] PASSED [ 71%] 534s tests/test_fts.py::test_enable_fts_replace[kwargs3] PASSED [ 71%] 534s tests/test_fts.py::test_enable_fts_replace_does_nothing_if_args_the_same PASSED [ 71%] 534s tests/test_fts.py::test_enable_fts_error_message_on_views PASSED [ 71%] 534s tests/test_fts.py::test_search_sql[kwargs0-FTS5-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n [books_fts].rank] PASSED [ 71%] 534s tests/test_fts.py::test_search_sql[kwargs1-FTS5-with original as (\n select\n rowid,\n [title]\n from [books]\n)\nselect\n [original].[title]\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rowid\nlimit 10] PASSED [ 71%] 534s tests/test_fts.py::test_search_sql[kwargs2-FTS5-with original as (\n select\n rowid,\n *\n from [books]\n where author = :author\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n [books_fts].rank] PASSED [ 71%] 534s tests/test_fts.py::test_search_sql[kwargs3-FTS4-with original as (\n select\n rowid,\n [title]\n from [books]\n)\nselect\n [original].[title]\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))] PASSED [ 71%] 534s tests/test_fts.py::test_search_sql[kwargs4-FTS4-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))\nlimit 1 offset 1] PASSED [ 71%] 534s tests/test_fts.py::test_search_sql[kwargs5-FTS4-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))\nlimit 2] PASSED [ 72%] 534s tests/test_fts.py::test_search_sql[kwargs6-FTS4-with original as (\n select\n rowid,\n *\n from [books]\n where author = :author\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))] PASSED [ 72%] 534s tests/test_fts.py::test_search_sql[kwargs7-FTS5-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*,\n [books_fts].rank rank\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n [books_fts].rank] PASSED [ 72%] 534s tests/test_fts.py::test_search_sql[kwargs8-FTS4-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*,\n rank_bm25(matchinfo([books_fts], 'pcnalx')) rank\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))] PASSED [ 72%] 534s tests/test_fts.py::test_quote_fts_query[dog-"dog"] PASSED [ 72%] 534s tests/test_fts.py::test_quote_fts_query[cat,-"cat,"] PASSED [ 72%] 534s tests/test_fts.py::test_quote_fts_query[cat's-"cat's"] PASSED [ 72%] 534s tests/test_fts.py::test_quote_fts_query[dog.-"dog."] PASSED [ 72%] 534s tests/test_fts.py::test_quote_fts_query[cat dog-"cat" "dog"] PASSED [ 72%] 534s tests/test_fts.py::test_quote_fts_query["cat dog"-"cat dog"] PASSED [ 72%] 534s tests/test_fts.py::test_quote_fts_query["cat dog" fish-"cat dog" "fish"] PASSED [ 73%] 534s tests/test_fts.py::test_quote_fts_query[cat"-"cat"] PASSED [ 73%] 534s tests/test_fts.py::test_quote_fts_query["cat dog" "fish-"cat dog" "fish"] PASSED [ 73%] 534s tests/test_fts.py::test_search_quote PASSED [ 73%] 534s tests/test_get.py::test_get_rowid PASSED [ 73%] 534s tests/test_get.py::test_get_primary_key PASSED [ 73%] 534s tests/test_get.py::test_get_not_found[100-None] PASSED [ 73%] 534s tests/test_get.py::test_get_not_found[None-None] PASSED [ 73%] 534s tests/test_get.py::test_get_not_found[argument2-Need 1 primary key value] PASSED [ 73%] 534s tests/test_get.py::test_get_not_found[2-None] PASSED [ 73%] 534s tests/test_gis.py::test_find_spatialite SKIPPED (Could not find Spat...) [ 74%] 534s tests/test_gis.py::test_init_spatialite SKIPPED (Could not find Spat...) [ 74%] 534s tests/test_gis.py::test_add_geometry_column SKIPPED (Could not find ...) [ 74%] 534s tests/test_gis.py::test_create_spatial_index SKIPPED (Could not find...) [ 74%] 534s tests/test_gis.py::test_double_create_spatial_index SKIPPED (Could n...) [ 74%] 534s tests/test_gis.py::test_query_load_extension[True] SKIPPED (Could no...) [ 74%] 534s tests/test_gis.py::test_query_load_extension[False] SKIPPED (Could n...) [ 74%] 534s tests/test_gis.py::test_cli_create_spatialite SKIPPED (Could not fin...) [ 74%] 534s tests/test_gis.py::test_cli_add_geometry_column SKIPPED (Could not f...) [ 74%] 534s tests/test_gis.py::test_cli_add_geometry_column_options SKIPPED (Cou...) [ 75%] 534s tests/test_gis.py::test_cli_add_geometry_column_invalid_type SKIPPED [ 75%] 534s tests/test_gis.py::test_cli_create_spatial_index SKIPPED (Could not ...) [ 75%] 535s tests/test_hypothesis.py::test_roundtrip_integers PASSED [ 75%] 536s tests/test_hypothesis.py::test_roundtrip_text PASSED [ 75%] 536s tests/test_hypothesis.py::test_roundtrip_binary PASSED [ 75%] 537s tests/test_hypothesis.py::test_roundtrip_floats PASSED [ 75%] 537s tests/test_insert_files.py::test_insert_files[False] PASSED [ 75%] 537s tests/test_insert_files.py::test_insert_files[True] PASSED [ 75%] 537s tests/test_insert_files.py::test_insert_files_stdin[False-None-hello world-hello world] PASSED [ 75%] 537s tests/test_insert_files.py::test_insert_files_stdin[True-None-hello world-hello world] PASSED [ 76%] 537s tests/test_insert_files.py::test_insert_files_stdin[False-None-S\xe3o Paulo-S\xe3o Paulo] PASSED [ 76%] 537s tests/test_insert_files.py::test_insert_files_stdin[True-latin-1-S\xe3o Paulo-S\xe3o Paulo] PASSED [ 76%] 537s tests/test_insert_files.py::test_insert_files_bad_text_encoding_error PASSED [ 76%] 537s tests/test_introspect.py::test_table_names PASSED [ 76%] 537s tests/test_introspect.py::test_view_names PASSED [ 76%] 537s tests/test_introspect.py::test_table_names_fts4 PASSED [ 76%] 537s tests/test_introspect.py::test_detect_fts PASSED [ 76%] 537s tests/test_introspect.py::test_detect_fts_similar_tables[True] PASSED [ 76%] 537s tests/test_introspect.py::test_detect_fts_similar_tables[False] PASSED [ 76%] 537s tests/test_introspect.py::test_tables PASSED [ 77%] 537s tests/test_introspect.py::test_views PASSED [ 77%] 537s tests/test_introspect.py::test_count PASSED [ 77%] 537s tests/test_introspect.py::test_count_where PASSED [ 77%] 537s tests/test_introspect.py::test_columns PASSED [ 77%] 537s tests/test_introspect.py::test_table_schema PASSED [ 77%] 537s tests/test_introspect.py::test_database_schema PASSED [ 77%] 537s tests/test_introspect.py::test_table_repr PASSED [ 77%] 537s tests/test_introspect.py::test_indexes PASSED [ 77%] 537s tests/test_introspect.py::test_xindexes PASSED [ 78%] 537s tests/test_introspect.py::test_guess_foreign_table[author-authors] PASSED [ 78%] 537s tests/test_introspect.py::test_guess_foreign_table[author_id-authors] PASSED [ 78%] 537s tests/test_introspect.py::test_guess_foreign_table[authors-authors] PASSED [ 78%] 537s tests/test_introspect.py::test_guess_foreign_table[genre-genre] PASSED [ 78%] 537s tests/test_introspect.py::test_guess_foreign_table[genre_id-genre] PASSED [ 78%] 537s tests/test_introspect.py::test_pks[None-expected0] PASSED [ 78%] 537s tests/test_introspect.py::test_pks[id-expected1] PASSED [ 78%] 537s tests/test_introspect.py::test_pks[pk2-expected2] PASSED [ 78%] 537s tests/test_introspect.py::test_triggers_and_triggers_dict PASSED [ 78%] 537s tests/test_introspect.py::test_has_counts_triggers PASSED [ 79%] 537s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE foo USING FTS5(name)\n -foo-FTS5] PASSED [ 79%] 537s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE "foo" USING FTS4(name)\n -foo-FTS4] PASSED [ 79%] 537s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE IF NOT EXISTS `foo` USING FTS4(name)\n -foo-FTS4] PASSED [ 79%] 537s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE IF NOT EXISTS `foo` USING fts5(name)\n -foo-FTS5] PASSED [ 79%] 537s tests/test_introspect.py::test_virtual_table_using[\n CREATE TABLE IF NOT EXISTS `foo` (id integer primary key)\n -foo-None] PASSED [ 79%] 537s tests/test_introspect.py::test_use_rowid PASSED [ 79%] 537s tests/test_introspect.py::test_table_strict[create table t (id integer) strict-True] PASSED [ 79%] 537s tests/test_introspect.py::test_table_strict[create table t (id integer) STRICT-True] PASSED [ 79%] 537s tests/test_introspect.py::test_table_strict[create table t (id integer primary key) StriCt, WITHOUT ROWID-True] PASSED [ 80%] 537s tests/test_introspect.py::test_table_strict[create table t (id integer primary key) WITHOUT ROWID-False] PASSED [ 80%] 537s tests/test_introspect.py::test_table_strict[create table t (id integer)-False] PASSED [ 80%] 537s tests/test_introspect.py::test_table_default_values[1] PASSED [ 80%] 537s tests/test_introspect.py::test_table_default_values[1.3] PASSED [ 80%] 537s tests/test_introspect.py::test_table_default_values[foo] PASSED [ 80%] 537s tests/test_introspect.py::test_table_default_values[True] PASSED [ 80%] 537s tests/test_introspect.py::test_table_default_values[binary] PASSED [ 80%] 537s tests/test_lookup.py::test_lookup_new_table PASSED [ 80%] 537s tests/test_lookup.py::test_lookup_new_table_compound_key PASSED [ 80%] 537s tests/test_lookup.py::test_lookup_adds_unique_constraint_to_existing_table PASSED [ 81%] 537s tests/test_lookup.py::test_lookup_fails_if_constraint_cannot_be_added PASSED [ 81%] 537s tests/test_lookup.py::test_lookup_with_extra_values PASSED [ 81%] 537s tests/test_lookup.py::test_lookup_with_extra_insert_parameters PASSED [ 81%] 537s tests/test_m2m.py::test_insert_m2m_single PASSED [ 81%] 537s tests/test_m2m.py::test_insert_m2m_alter PASSED [ 81%] 537s tests/test_m2m.py::test_insert_m2m_list PASSED [ 81%] 537s tests/test_m2m.py::test_insert_m2m_iterable PASSED [ 81%] 537s tests/test_m2m.py::test_m2m_with_table_objects PASSED [ 81%] 537s tests/test_m2m.py::test_m2m_lookup PASSED [ 81%] 537s tests/test_m2m.py::test_m2m_requires_either_records_or_lookup PASSED [ 82%] 537s tests/test_m2m.py::test_m2m_explicit_table_name_argument PASSED [ 82%] 537s tests/test_m2m.py::test_m2m_table_candidates PASSED [ 82%] 537s tests/test_m2m.py::test_uses_existing_m2m_table_if_exists PASSED [ 82%] 537s tests/test_m2m.py::test_requires_explicit_m2m_table_if_multiple_options PASSED [ 82%] 537s tests/test_plugins.py::test_register_commands PASSED [ 82%] 537s tests/test_plugins.py::test_prepare_connection PASSED [ 82%] 537s tests/test_query.py::test_query PASSED [ 82%] 537s tests/test_query.py::test_execute_returning_dicts PASSED [ 82%] 537s tests/test_recipes.py::test_parsedate PASSED [ 83%] 537s tests/test_recipes.py::test_parsedatetime PASSED [ 83%] 537s tests/test_recipes.py::test_dayfirst_yearfirst[parsedate-kwargs0-2005-03-04] PASSED [ 83%] 537s tests/test_recipes.py::test_dayfirst_yearfirst[parsedate-kwargs1-2005-04-03] PASSED [ 83%] 537s tests/test_recipes.py::test_dayfirst_yearfirst[parsedatetime-kwargs2-2005-03-04T00:00:00] PASSED [ 83%] 537s tests/test_recipes.py::test_dayfirst_yearfirst[parsedatetime-kwargs3-2005-04-03T00:00:00] PASSED [ 83%] 537s tests/test_recipes.py::test_dateparse_errors[None-parsedate] PASSED [ 83%] 537s tests/test_recipes.py::test_dateparse_errors[None-parsedatetime] PASSED [ 83%] 537s tests/test_recipes.py::test_dateparse_errors[errors1-parsedate] PASSED [ 83%] 537s tests/test_recipes.py::test_dateparse_errors[errors1-parsedatetime] PASSED [ 83%] 537s tests/test_recipes.py::test_dateparse_errors[errors2-parsedate] PASSED [ 84%] 537s tests/test_recipes.py::test_dateparse_errors[errors2-parsedatetime] PASSED [ 84%] 537s tests/test_recipes.py::test_jsonsplit[None] PASSED [ 84%] 537s tests/test_recipes.py::test_jsonsplit[;] PASSED [ 84%] 537s tests/test_recipes.py::test_jsonsplit[-] PASSED [ 84%] 537s tests/test_recipes.py::test_jsonsplit_type[None-expected0] PASSED [ 84%] 537s tests/test_recipes.py::test_jsonsplit_type[float-expected1] PASSED [ 84%] 537s tests/test_recipes.py::test_jsonsplit_type[int-expected2] PASSED [ 84%] 537s tests/test_recreate.py::test_recreate_ignored_for_in_memory PASSED [ 84%] 537s tests/test_recreate.py::test_recreate_not_allowed_for_connection PASSED [ 84%] 537s tests/test_recreate.py::test_recreate[True-True] PASSED [ 85%] 537s tests/test_recreate.py::test_recreate[True-False] PASSED [ 85%] 537s tests/test_recreate.py::test_recreate[False-True] PASSED [ 85%] 537s tests/test_recreate.py::test_recreate[False-False] PASSED [ 85%] 537s tests/test_register_function.py::test_register_function PASSED [ 85%] 537s tests/test_register_function.py::test_register_function_custom_name PASSED [ 85%] 537s tests/test_register_function.py::test_register_function_multiple_arguments PASSED [ 85%] 537s tests/test_register_function.py::test_register_function_deterministic PASSED [ 85%] 537s tests/test_register_function.py::test_register_function_deterministic_tries_again_if_exception_raised PASSED [ 85%] 537s tests/test_register_function.py::test_register_function_replace PASSED [ 86%] 537s tests/test_rows.py::test_rows PASSED [ 86%] 537s tests/test_rows.py::test_rows_where[name = ?-where_args0-expected_ids0] PASSED [ 86%] 537s tests/test_rows.py::test_rows_where[age > ?-where_args1-expected_ids1] PASSED [ 86%] 537s tests/test_rows.py::test_rows_where[age > :age-where_args2-expected_ids2] PASSED [ 86%] 537s tests/test_rows.py::test_rows_where[name is not null-where_args3-expected_ids3] PASSED [ 86%] 537s tests/test_rows.py::test_rows_where[is_good = ?-where_args4-expected_ids4] PASSED [ 86%] 537s tests/test_rows.py::test_rows_where_order_by[None-None-expected_ids0] PASSED [ 86%] 537s tests/test_rows.py::test_rows_where_order_by[None-id desc-expected_ids1] PASSED [ 86%] 537s tests/test_rows.py::test_rows_where_order_by[None-age-expected_ids2] PASSED [ 86%] 537s tests/test_rows.py::test_rows_where_order_by[id > 1-age-expected_ids3] PASSED [ 87%] 537s tests/test_rows.py::test_rows_where_offset_limit[None-3-expected0] PASSED [ 87%] 537s tests/test_rows.py::test_rows_where_offset_limit[0-3-expected1] PASSED [ 87%] 537s tests/test_rows.py::test_rows_where_offset_limit[3-3-expected2] PASSED [ 87%] 537s tests/test_rows.py::test_pks_and_rows_where_rowid PASSED [ 87%] 537s tests/test_rows.py::test_pks_and_rows_where_simple_pk PASSED [ 87%] 537s tests/test_rows.py::test_pks_and_rows_where_compound_pk PASSED [ 87%] 537s tests/test_rows_from_file.py::test_rows_from_file_detect_format[id,name\n1,Cleo-Format.CSV] PASSED [ 87%] 537s tests/test_rows_from_file.py::test_rows_from_file_detect_format[id\tname\n1\tCleo-Format.TSV] PASSED [ 87%] 537s tests/test_rows_from_file.py::test_rows_from_file_detect_format[[{"id": "1", "name": "Cleo"}]-Format.JSON] PASSED [ 87%] 537s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[True-None-expected0] PASSED [ 88%] 537s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[False-_rest-expected1] PASSED [ 88%] 537s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[False-False-None] PASSED [ 88%] 537s tests/test_rows_from_file.py::test_rows_from_file_error_on_string_io PASSED [ 88%] 537s tests/test_sniff.py::test_sniff[filepath0] PASSED [ 88%] 537s tests/test_sniff.py::test_sniff[filepath1] PASSED [ 88%] 537s tests/test_sniff.py::test_sniff[filepath2] PASSED [ 88%] 537s tests/test_sniff.py::test_sniff[filepath3] PASSED [ 88%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records0-types0] PASSED [ 88%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records1-types1] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records2-types2] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records3-types3] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records4-types4] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records5-types5] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records6-types6] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records7-types7] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records8-types8] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records9-types9] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records10-types10] PASSED [ 89%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records11-types11] PASSED [ 90%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records12-types12] PASSED [ 90%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records13-types13] PASSED [ 90%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records14-types14] PASSED [ 90%] 537s tests/test_suggest_column_types.py::test_suggest_column_types[records15-types15] PASSED [ 90%] 537s tests/test_tracer.py::test_tracer PASSED [ 90%] 537s tests/test_tracer.py::test_with_tracer PASSED [ 90%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params0-expected_sql0] PASSED [ 90%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params1-expected_sql1] PASSED [ 90%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params2-expected_sql2] PASSED [ 90%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params3-expected_sql3] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params4-expected_sql4] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params5-expected_sql5] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params6-expected_sql6] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params7-expected_sql7] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params8-expected_sql8] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params0-expected_sql0] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params1-expected_sql1] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params2-expected_sql2] PASSED [ 91%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params3-expected_sql3] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params4-expected_sql4] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params5-expected_sql5] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params6-expected_sql6] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params7-expected_sql7] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params8-expected_sql8] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params0-expected_sql0] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params1-expected_sql1] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params2-expected_sql2] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params3-expected_sql3] PASSED [ 92%] 537s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params0-expected_sql0] PASSED [ 93%] 537s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params1-expected_sql1] PASSED [ 93%] 537s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params2-expected_sql2] PASSED [ 93%] 537s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params3-expected_sql3] PASSED [ 93%] 537s tests/test_transform.py::test_transform_sql_with_no_primary_key_to_primary_key_of_id PASSED [ 93%] 537s tests/test_transform.py::test_transform_rename_pk PASSED [ 93%] 537s tests/test_transform.py::test_transform_not_null PASSED [ 93%] 537s tests/test_transform.py::test_transform_remove_a_not_null PASSED [ 93%] 537s tests/test_transform.py::test_transform_add_not_null_with_rename[not_null0] PASSED [ 93%] 537s tests/test_transform.py::test_transform_add_not_null_with_rename[not_null1] PASSED [ 93%] 537s tests/test_transform.py::test_transform_defaults PASSED [ 94%] 537s tests/test_transform.py::test_transform_defaults_and_rename_column PASSED [ 94%] 537s tests/test_transform.py::test_remove_defaults PASSED [ 94%] 537s tests/test_transform.py::test_transform_foreign_keys_persist PASSED [ 94%] 537s tests/test_transform.py::test_transform_foreign_keys_survive_renamed_column[False] PASSED [ 94%] 537s tests/test_transform.py::test_transform_foreign_keys_survive_renamed_column[True] PASSED [ 94%] 537s tests/test_transform.py::test_transform_drop_foreign_keys[False] PASSED [ 94%] 537s tests/test_transform.py::test_transform_drop_foreign_keys[True] PASSED [ 94%] 537s tests/test_transform.py::test_transform_verify_foreign_keys PASSED [ 94%] 537s tests/test_transform.py::test_transform_add_foreign_keys_from_scratch PASSED [ 95%] 537s tests/test_transform.py::test_transform_add_foreign_keys_from_partial[add_foreign_keys0] PASSED [ 95%] 537s tests/test_transform.py::test_transform_add_foreign_keys_from_partial[add_foreign_keys1] PASSED [ 95%] 537s tests/test_transform.py::test_transform_replace_foreign_keys[foreign_keys0] PASSED [ 95%] 537s tests/test_transform.py::test_transform_replace_foreign_keys[foreign_keys1] PASSED [ 95%] 537s tests/test_transform.py::test_transform_preserves_rowids[id_pk] PASSED [ 95%] 537s tests/test_transform.py::test_transform_preserves_rowids[rowid] PASSED [ 95%] 537s tests/test_transform.py::test_transform_preserves_rowids[compound_pk] PASSED [ 95%] 537s tests/test_update.py::test_update_rowid_table PASSED [ 95%] 537s tests/test_update.py::test_update_pk_table PASSED [ 95%] 537s tests/test_update.py::test_update_compound_pk_table PASSED [ 96%] 537s tests/test_update.py::test_update_invalid_pk[None-2] PASSED [ 96%] 537s tests/test_update.py::test_update_invalid_pk[None-None] PASSED [ 96%] 537s tests/test_update.py::test_update_invalid_pk[id1-None] PASSED [ 96%] 537s tests/test_update.py::test_update_invalid_pk[id1-4] PASSED [ 96%] 537s tests/test_update.py::test_update_invalid_pk[pk4-None] PASSED [ 96%] 537s tests/test_update.py::test_update_invalid_pk[pk5-4] PASSED [ 96%] 537s tests/test_update.py::test_update_invalid_pk[pk6-update_pk6] PASSED [ 96%] 537s tests/test_update.py::test_update_alter PASSED [ 96%] 537s tests/test_update.py::test_update_alter_with_invalid_column_characters PASSED [ 96%] 537s tests/test_update.py::test_update_with_no_values_sets_last_pk PASSED [ 97%] 537s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure0] PASSED [ 97%] 537s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure1] PASSED [ 97%] 537s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure2] PASSED [ 97%] 537s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure3] PASSED [ 97%] 537s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure4] PASSED [ 97%] 537s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure5] PASSED [ 97%] 537s tests/test_upsert.py::test_upsert PASSED [ 97%] 537s tests/test_upsert.py::test_upsert_all PASSED [ 97%] 537s tests/test_upsert.py::test_upsert_all_single_column PASSED [ 98%] 537s tests/test_upsert.py::test_upsert_all_not_null PASSED [ 98%] 537s tests/test_upsert.py::test_upsert_error_if_no_pk PASSED [ 98%] 537s tests/test_upsert.py::test_upsert_with_hash_id PASSED [ 98%] 537s tests/test_upsert.py::test_upsert_with_hash_id_columns[None] PASSED [ 98%] 537s tests/test_upsert.py::test_upsert_with_hash_id_columns[custom_id] PASSED [ 98%] 537s tests/test_upsert.py::test_upsert_compound_primary_key PASSED [ 98%] 537s tests/test_utils.py::test_decode_base64_values[input0-None-True] PASSED [ 98%] 537s tests/test_utils.py::test_decode_base64_values[input1-None-True] PASSED [ 98%] 537s tests/test_utils.py::test_decode_base64_values[input2-expected2-False] PASSED [ 98%] 537s tests/test_utils.py::test_chunks[1-expected0] PASSED [ 99%] 537s tests/test_utils.py::test_chunks[2-expected1] PASSED [ 99%] 537s tests/test_utils.py::test_chunks[3-expected2] PASSED [ 99%] 537s tests/test_utils.py::test_chunks[4-expected3] PASSED [ 99%] 537s tests/test_utils.py::test_hash_record PASSED [ 99%] 537s tests/test_utils.py::test_maximize_csv_field_size_limit PASSED [ 99%] 537s tests/test_utils.py::test_flatten[input0-expected0] PASSED [ 99%] 537s tests/test_utils.py::test_flatten[input1-expected1] PASSED [ 99%] 537s tests/test_utils.py::test_flatten[input2-expected2] PASSED [ 99%] 537s tests/test_wal.py::test_enable_disable_wal PASSED [100%] 537s 537s =============================== warnings summary =============================== 537s tests/test_cli.py::test_upsert_flatten 537s /usr/lib/python3/dist-packages/click/core.py:1285: ResourceWarning: unclosed file <_io.FileIO name='/tmp/pytest-of-ubuntu/pytest-0/test_upsert_pk_required0/dogs.json' mode='rb' closefd=True> 537s all_names = set(ctx.help_option_names) 537s Enable tracemalloc to get traceback where the object was allocated. 537s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 537s 537s tests/test_cli_memory.py::test_memory_csv[False-test] 537s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-0/test_memory_csv_False_test_0/test.csv' encoding='utf-8-sig'> 537s for row in reader: 537s Enable tracemalloc to get traceback where the object was allocated. 537s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 537s 537s tests/test_cli_memory.py::test_memory_csv[False-t] 537s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-0/test_memory_csv_False_t_0/test.csv' encoding='utf-8-sig'> 537s for row in reader: 537s Enable tracemalloc to get traceback where the object was allocated. 537s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 537s 537s tests/test_cli_memory.py::test_memory_csv[False-t1] 537s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-0/test_memory_csv_False_t1_0/test.csv' encoding='utf-8-sig'> 537s for row in reader: 537s Enable tracemalloc to get traceback where the object was allocated. 537s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 537s 537s tests/test_cli_memory.py::test_memory_tsv[False] 537s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-0/test_memory_tsv_False_0/chickens.tsv' encoding='utf-8-sig'> 537s for row in reader: 537s Enable tracemalloc to get traceback where the object was allocated. 537s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 537s 537s tests/test_cli_memory.py::test_memory_dump[extra_args1] 537s /usr/lib/python3.11/csv.py:314: ResourceWarning: unclosed file <_io.FileIO name='/tmp/pytest-of-ubuntu/pytest-0/test_memory_csv_encoding_False0/test.csv' mode='rb' closefd=True> 537s metaFrequency = charFrequency.get(char, {}) 537s Enable tracemalloc to get traceback where the object was allocated. 537s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 537s 537s tests/test_cli_memory.py::test_memory_two_files_with_same_stem 537s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-0/test_memory_two_files_with_sam0/one/data.csv' encoding='utf-8-sig'> 537s for row in reader: 537s Enable tracemalloc to get traceback where the object was allocated. 537s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 537s 537s tests/test_cli_memory.py::test_memory_two_files_with_same_stem 537s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-0/test_memory_two_files_with_sam0/two/data.csv' encoding='utf-8-sig'> 537s for row in reader: 537s Enable tracemalloc to get traceback where the object was allocated. 537s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 537s 537s tests/test_recipes.py::test_dateparse_errors[None-parsedate] 537s /usr/lib/python3/dist-packages/_pytest/unraisableexception.py:80: PytestUnraisableExceptionWarning: Exception ignored in: .convert_value at 0x78f440a2a520> 537s 537s Traceback (most recent call last): 537s File "/usr/lib/python3/dist-packages/sqlite_utils/db.py", line 2818, in convert_value 537s return jsonify_if_needed(fn(v)) 537s ^^^^^ 537s File "/tmp/autopkgtest.6YryoZ/autopkgtest_tmp/tests/test_recipes.py", line 77, in 537s fresh_db["example"].convert("dt", lambda value: getattr(recipes, fn)(value)) 537s ^^^^^^^^^^^^^^^^^^^^^^^^^^^ 537s File "/usr/lib/python3/dist-packages/sqlite_utils/recipes.py", line 19, in parsedate 537s parser.parse(value, dayfirst=dayfirst, yearfirst=yearfirst) 537s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 1368, in parse 537s return DEFAULTPARSER.parse(timestr, **kwargs) 537s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 537s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 643, in parse 537s raise ParserError("Unknown string format: %s", timestr) 537s dateutil.parser._parser.ParserError: Unknown string format: invalid 537s 537s warnings.warn(pytest.PytestUnraisableExceptionWarning(msg)) 537s 537s tests/test_recipes.py::test_dateparse_errors[None-parsedatetime] 537s /usr/lib/python3/dist-packages/_pytest/unraisableexception.py:80: PytestUnraisableExceptionWarning: Exception ignored in: .convert_value at 0x78f440aa18a0> 537s 537s Traceback (most recent call last): 537s File "/usr/lib/python3/dist-packages/sqlite_utils/db.py", line 2818, in convert_value 537s return jsonify_if_needed(fn(v)) 537s ^^^^^ 537s File "/tmp/autopkgtest.6YryoZ/autopkgtest_tmp/tests/test_recipes.py", line 77, in 537s fresh_db["example"].convert("dt", lambda value: getattr(recipes, fn)(value)) 537s ^^^^^^^^^^^^^^^^^^^^^^^^^^^ 537s File "/usr/lib/python3/dist-packages/sqlite_utils/recipes.py", line 42, in parsedatetime 537s return parser.parse(value, dayfirst=dayfirst, yearfirst=yearfirst).isoformat() 537s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 537s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 1368, in parse 537s return DEFAULTPARSER.parse(timestr, **kwargs) 537s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 537s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 643, in parse 537s raise ParserError("Unknown string format: %s", timestr) 537s dateutil.parser._parser.ParserError: Unknown string format: invalid 537s 537s warnings.warn(pytest.PytestUnraisableExceptionWarning(msg)) 537s 537s -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html 537s ================ 949 passed, 16 skipped, 10 warnings in 15.74s ================= 538s ============================= test session starts ============================== 538s platform linux -- Python 3.12.2, pytest-8.0.2, pluggy-1.4.0 -- /usr/bin/python3.12 538s cachedir: .pytest_cache 538s hypothesis profile 'default' -> database=DirectoryBasedExampleDatabase(PosixPath('/tmp/autopkgtest.6YryoZ/autopkgtest_tmp/.hypothesis/examples')) 538s rootdir: /tmp/autopkgtest.6YryoZ/autopkgtest_tmp 538s plugins: hypothesis-6.92.2 538s collecting ... collected 965 items 538s 538s tests/test_analyze.py::test_analyze_whole_database PASSED [ 0%] 538s tests/test_analyze.py::test_analyze_one_table[db_method_with_name] PASSED [ 0%] 538s tests/test_analyze.py::test_analyze_one_table[table_method] PASSED [ 0%] 538s tests/test_analyze.py::test_analyze_index_by_name PASSED [ 0%] 538s tests/test_analyze_tables.py::test_analyze_column[id-extra_kwargs0-expected0] PASSED [ 0%] 539s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs1-expected1] PASSED [ 0%] 539s tests/test_analyze_tables.py::test_analyze_column[size-extra_kwargs2-expected2] PASSED [ 0%] 539s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs3-expected3] PASSED [ 0%] 539s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs4-expected4] PASSED [ 0%] 539s tests/test_analyze_tables.py::test_analyze_table PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_save PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[False-False] PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[True-False] PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[False-True] PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[True-True] PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_column_all_nulls PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args0-These columns were not found: bad_column\n] PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args1-These columns were not found: age\n] PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args2-None] PASSED [ 1%] 539s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args3-These columns were not found: age, bad\n] PASSED [ 2%] 539s tests/test_attach.py::test_attach PASSED [ 2%] 539s tests/test_cli.py::test_help[options0] PASSED [ 2%] 539s tests/test_cli.py::test_help[options1] PASSED [ 2%] 539s tests/test_cli.py::test_help[options2] PASSED [ 2%] 539s tests/test_cli.py::test_help[options3] PASSED [ 2%] 539s tests/test_cli.py::test_tables PASSED [ 2%] 539s tests/test_cli.py::test_views PASSED [ 2%] 539s tests/test_cli.py::test_tables_fts4 PASSED [ 2%] 539s tests/test_cli.py::test_tables_fts5 PASSED [ 3%] 539s tests/test_cli.py::test_tables_counts_and_columns PASSED [ 3%] 539s tests/test_cli.py::test_tables_counts_and_columns_csv[--csv-table,count,columns\nGosh,0,"c1\nc2\nc3"\nGosh2,0,"c1\nc2\nc3"\nlots,30,"id\nage"] PASSED [ 3%] 539s tests/test_cli.py::test_tables_counts_and_columns_csv[--tsv-table\tcount\tcolumns\nGosh\t0\t['c1', 'c2', 'c3']\nGosh2\t0\t['c1', 'c2', 'c3']\nlots\t30\t['id', 'age']] PASSED [ 3%] 539s tests/test_cli.py::test_tables_schema PASSED [ 3%] 539s tests/test_cli.py::test_output_table[options0-c1 c2 c3\n----- ----- ----------\nverb0 noun0 adjective0\nverb1 noun1 adjective1\nverb2 noun2 adjective2\nverb3 noun3 adjective3] PASSED [ 3%] 539s tests/test_cli.py::test_output_table[options1-c1 c2 c3\n----- ----- ----------\nverb0 noun0 adjective0\nverb1 noun1 adjective1\nverb2 noun2 adjective2\nverb3 noun3 adjective3] PASSED [ 3%] 539s tests/test_cli.py::test_output_table[options2-===== ===== ==========\nc1 c2 c3\n===== ===== ==========\nverb0 noun0 adjective0\nverb1 noun1 adjective1\nverb2 noun2 adjective2\nverb3 noun3 adjective3\n===== ===== ==========] PASSED [ 3%] 539s tests/test_cli.py::test_create_index PASSED [ 3%] 539s tests/test_cli.py::test_create_index_analyze PASSED [ 3%] 539s tests/test_cli.py::test_create_index_desc PASSED [ 4%] 539s tests/test_cli.py::test_add_column[text-TEXT-CREATE TABLE [dogs] (\n [name] TEXT\n, [text] TEXT)] PASSED [ 4%] 539s tests/test_cli.py::test_add_column[integer-INTEGER-CREATE TABLE [dogs] (\n [name] TEXT\n, [integer] INTEGER)] PASSED [ 4%] 539s tests/test_cli.py::test_add_column[float-FLOAT-CREATE TABLE [dogs] (\n [name] TEXT\n, [float] FLOAT)] PASSED [ 4%] 539s tests/test_cli.py::test_add_column[blob-blob-CREATE TABLE [dogs] (\n [name] TEXT\n, [blob] BLOB)] PASSED [ 4%] 539s tests/test_cli.py::test_add_column[default-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [default] TEXT)] PASSED [ 4%] 539s tests/test_cli.py::test_add_column_ignore[True] PASSED [ 4%] 539s tests/test_cli.py::test_add_column_ignore[False] PASSED [ 4%] 539s tests/test_cli.py::test_add_column_not_null_default PASSED [ 4%] 539s tests/test_cli.py::test_add_foreign_key[args0-Explicit other_table and other_column] PASSED [ 4%] 539s tests/test_cli.py::test_add_foreign_key[args1-Explicit other_table, guess other_column] PASSED [ 5%] 539s tests/test_cli.py::test_add_foreign_key[args2-Automatically guess other_table and other_column] PASSED [ 5%] 539s tests/test_cli.py::test_add_column_foreign_key PASSED [ 5%] 539s tests/test_cli.py::test_suggest_alter_if_column_missing PASSED [ 5%] 539s tests/test_cli.py::test_index_foreign_keys PASSED [ 5%] 539s tests/test_cli.py::test_enable_fts PASSED [ 5%] 539s tests/test_cli.py::test_enable_fts_replace PASSED [ 5%] 539s tests/test_cli.py::test_enable_fts_with_triggers PASSED [ 5%] 539s tests/test_cli.py::test_populate_fts PASSED [ 5%] 539s tests/test_cli.py::test_disable_fts PASSED [ 6%] 539s tests/test_cli.py::test_vacuum PASSED [ 6%] 539s tests/test_cli.py::test_dump PASSED [ 6%] 540s tests/test_cli.py::test_optimize[tables0] PASSED [ 6%] 541s tests/test_cli.py::test_optimize[tables1] PASSED [ 6%] 542s tests/test_cli.py::test_optimize[tables2] PASSED [ 6%] 543s tests/test_cli.py::test_rebuild_fts_fixes_docsize_error PASSED [ 6%] 543s tests/test_cli.py::test_query_csv[--csv-id,name,age\n1,Cleo,4\n2,Pancakes,2\n] PASSED [ 6%] 543s tests/test_cli.py::test_query_csv[--tsv-id\tname\tage\n1\tCleo\t4\n2\tPancakes\t2\n] PASSED [ 6%] 543s tests/test_cli.py::test_query_json[select id, name, age from dogs-args0-[{"id": 1, "name": "Cleo", "age": 4},\n {"id": 2, "name": "Pancakes", "age": 2}]] PASSED [ 6%] 543s tests/test_cli.py::test_query_json[select id, name, age from dogs-args1-{"id": 1, "name": "Cleo", "age": 4}\n{"id": 2, "name": "Pancakes", "age": 2}] PASSED [ 7%] 543s tests/test_cli.py::test_query_json[select id, name, age from dogs-args2-[[1, "Cleo", 4],\n [2, "Pancakes", 2]]] PASSED [ 7%] 543s tests/test_cli.py::test_query_json[select id, name, age from dogs-args3-[1, "Cleo", 4]\n[2, "Pancakes", 2]] PASSED [ 7%] 543s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args4-[{"id": 1, "name": "Cleo", "age": 4}]] PASSED [ 7%] 543s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args5-{"id": 1, "name": "Cleo", "age": 4}] PASSED [ 7%] 543s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args6-[[1, "Cleo", 4]]] PASSED [ 7%] 543s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args7-[1, "Cleo", 4]] PASSED [ 7%] 543s tests/test_cli.py::test_query_json[select id, dog(age) from dogs-args8-[{"id": 1, "dog(age)": 28},\n {"id": 2, "dog(age)": 14}]] PASSED [ 7%] 543s tests/test_cli.py::test_query_json_empty PASSED [ 7%] 543s tests/test_cli.py::test_query_invalid_function PASSED [ 7%] 543s tests/test_cli.py::test_query_complex_function PASSED [ 8%] 543s tests/test_cli.py::test_hidden_functions_are_hidden PASSED [ 8%] 543s tests/test_cli.py::test_query_json_binary PASSED [ 8%] 543s tests/test_cli.py::test_query_params[select 1 + 1 as out-params0-2] PASSED [ 8%] 543s tests/test_cli.py::test_query_params[select 1 + :p as out-params1-3] PASSED [ 8%] 543s tests/test_cli.py::test_query_params[select :hello as out-params2-This"has'many'quote"s] PASSED [ 8%] 543s tests/test_cli.py::test_query_json_with_json_cols PASSED [ 8%] 543s tests/test_cli.py::test_query_raw[\x00\x0fbinary-True] PASSED [ 8%] 543s tests/test_cli.py::test_query_raw[this is text-False] PASSED [ 8%] 543s tests/test_cli.py::test_query_raw[1-False] PASSED [ 9%] 543s tests/test_cli.py::test_query_raw[1.5-False] PASSED [ 9%] 543s tests/test_cli.py::test_query_raw_lines[\x00\x0fbinary-True] PASSED [ 9%] 543s tests/test_cli.py::test_query_raw_lines[this is text-False] PASSED [ 9%] 543s tests/test_cli.py::test_query_raw_lines[1-False] PASSED [ 9%] 543s tests/test_cli.py::test_query_raw_lines[1.5-False] PASSED [ 9%] 543s tests/test_cli.py::test_query_memory_does_not_create_file PASSED [ 9%] 543s tests/test_cli.py::test_rows[args0-[{"id": 1, "name": "Cleo", "age": 4},\n {"id": 2, "name": "Pancakes", "age": 2}]] PASSED [ 9%] 543s tests/test_cli.py::test_rows[args1-{"id": 1, "name": "Cleo", "age": 4}\n{"id": 2, "name": "Pancakes", "age": 2}] PASSED [ 9%] 543s tests/test_cli.py::test_rows[args2-[[1, "Cleo", 4],\n [2, "Pancakes", 2]]] PASSED [ 9%] 543s tests/test_cli.py::test_rows[args3-[1, "Cleo", 4]\n[2, "Pancakes", 2]] PASSED [ 10%] 543s tests/test_cli.py::test_rows[args4-{"age": 4, "name": "Cleo"}\n{"age": 2, "name": "Pancakes"}] PASSED [ 10%] 543s tests/test_cli.py::test_rows[args5-[{"name": "Cleo"}]] PASSED [ 10%] 543s tests/test_cli.py::test_rows[args6-[{"name": "Pancakes"}]] PASSED [ 10%] 543s tests/test_cli.py::test_rows[args7-[{"name": "Cleo"}]] PASSED [ 10%] 543s tests/test_cli.py::test_rows[args8-[{"name": "Cleo"}]] PASSED [ 10%] 543s tests/test_cli.py::test_rows[args9-[{"name": "Cleo"}]] PASSED [ 10%] 543s tests/test_cli.py::test_rows[args10-[{"id": 2}]] PASSED [ 10%] 543s tests/test_cli.py::test_rows[args11-[{"id": 1}]] PASSED [ 10%] 543s tests/test_cli.py::test_upsert PASSED [ 10%] 543s tests/test_cli.py::test_upsert_pk_required PASSED [ 11%] 543s tests/test_cli.py::test_upsert_analyze PASSED [ 11%] 543s tests/test_cli.py::test_upsert_flatten PASSED [ 11%] 543s tests/test_cli.py::test_upsert_alter PASSED [ 11%] 543s tests/test_cli.py::test_create_table[args0-CREATE TABLE [t] (\n [name] TEXT,\n [age] INTEGER\n)] PASSED [ 11%] 543s tests/test_cli.py::test_create_table[args1-CREATE TABLE [t] (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [age] INTEGER,\n [weight] FLOAT,\n [thumbnail] BLOB\n)] PASSED [ 11%] 543s tests/test_cli.py::test_create_table[args2-CREATE TABLE [t] (\n [name] TEXT NOT NULL\n)] PASSED [ 11%] 543s tests/test_cli.py::test_create_table[args3-CREATE TABLE [t] (\n [age] INTEGER DEFAULT '3'\n)] PASSED [ 11%] 543s tests/test_cli.py::test_create_table_foreign_key PASSED [ 11%] 543s tests/test_cli.py::test_create_table_error_if_table_exists PASSED [ 12%] 543s tests/test_cli.py::test_create_table_ignore PASSED [ 12%] 543s tests/test_cli.py::test_create_table_replace PASSED [ 12%] 543s tests/test_cli.py::test_create_view PASSED [ 12%] 543s tests/test_cli.py::test_create_view_error_if_view_exists PASSED [ 12%] 543s tests/test_cli.py::test_create_view_ignore PASSED [ 12%] 543s tests/test_cli.py::test_create_view_replace PASSED [ 12%] 543s tests/test_cli.py::test_drop_table PASSED [ 12%] 543s tests/test_cli.py::test_drop_table_error PASSED [ 12%] 543s tests/test_cli.py::test_drop_view PASSED [ 12%] 543s tests/test_cli.py::test_drop_view_error PASSED [ 13%] 543s tests/test_cli.py::test_enable_wal PASSED [ 13%] 543s tests/test_cli.py::test_disable_wal PASSED [ 13%] 543s tests/test_cli.py::test_query_update[args0-[{"rows_affected": 1}]] PASSED [ 13%] 543s tests/test_cli.py::test_query_update[args1-rows_affected\n---------------\n 1] PASSED [ 13%] 543s tests/test_cli.py::test_add_foreign_keys PASSED [ 13%] 543s tests/test_cli.py::test_transform[args0-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT\n)] PASSED [ 13%] 543s tests/test_cli.py::test_transform[args1-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] TEXT NOT NULL DEFAULT '1',\n [name] TEXT\n)] PASSED [ 13%] 543s tests/test_cli.py::test_transform[args2-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)] PASSED [ 13%] 543s tests/test_cli.py::test_transform[args3-CREATE TABLE "dogs" (\n [pk] INTEGER PRIMARY KEY,\n [age2] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT\n)] PASSED [ 13%] 543s tests/test_cli.py::test_transform[args4-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT NOT NULL\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform[args5-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER DEFAULT '1',\n [name] TEXT\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform[args6-CREATE TABLE "dogs" (\n [id] INTEGER,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT PRIMARY KEY\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform[args7-CREATE TABLE "dogs" (\n [id] INTEGER,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform[args8-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER NOT NULL DEFAULT '1',\n [name] TEXT DEFAULT 'Turnip'\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform[args9-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [age] INTEGER NOT NULL,\n [name] TEXT\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform[args10-CREATE TABLE "dogs" (\n [name] TEXT,\n [age] INTEGER NOT NULL DEFAULT '1',\n [id] INTEGER PRIMARY KEY\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform_add_or_drop_foreign_key[extra_args0-CREATE TABLE "places" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [country] INTEGER,\n [city] INTEGER REFERENCES [city]([id]),\n [continent] INTEGER\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform_add_or_drop_foreign_key[extra_args1-CREATE TABLE "places" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [country] INTEGER,\n [city] INTEGER,\n [continent] INTEGER\n)] PASSED [ 14%] 543s tests/test_cli.py::test_transform_add_or_drop_foreign_key[extra_args2-CREATE TABLE "places" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [country] INTEGER REFERENCES [country]([id]),\n [city] INTEGER REFERENCES [city]([id]),\n [continent] INTEGER REFERENCES [continent]([id])\n)] PASSED [ 15%] 543s tests/test_cli.py::test_extract[args0-CREATE TABLE "trees" (\n [id] INTEGER PRIMARY KEY,\n [address] TEXT,\n [species_id] INTEGER REFERENCES [species]([id])\n)-CREATE TABLE [species] (\n [id] INTEGER PRIMARY KEY,\n [species] TEXT\n)] PASSED [ 15%] 543s tests/test_cli.py::test_extract[args1-CREATE TABLE "trees" (\n [id] INTEGER PRIMARY KEY,\n [address] TEXT,\n [custom_table_id] INTEGER REFERENCES [custom_table]([id])\n)-CREATE TABLE [custom_table] (\n [id] INTEGER PRIMARY KEY,\n [species] TEXT\n)] PASSED [ 15%] 544s tests/test_cli.py::test_extract[args2-CREATE TABLE "trees" (\n [id] INTEGER PRIMARY KEY,\n [address] TEXT,\n [custom_fk] INTEGER REFERENCES [species]([id])\n)-CREATE TABLE [species] (\n [id] INTEGER PRIMARY KEY,\n [species] TEXT\n)] PASSED [ 15%] 544s tests/test_cli.py::test_extract[args3-CREATE TABLE "trees" (\n [id] INTEGER PRIMARY KEY,\n [address] TEXT,\n [species_id] INTEGER REFERENCES [species]([id])\n)-CREATE TABLE [species] (\n [id] INTEGER PRIMARY KEY,\n [species] TEXT\n)] PASSED [ 15%] 544s tests/test_cli.py::test_insert_encoding PASSED [ 15%] 544s tests/test_cli.py::test_search[None-[{"rowid": 2, "id": 2, "title": "Title the second"}]\n-FTS4] PASSED [ 15%] 544s tests/test_cli.py::test_search[None-[{"rowid": 2, "id": 2, "title": "Title the second"}]\n-FTS5] PASSED [ 15%] 544s tests/test_cli.py::test_search[--csv-rowid,id,title\n2,2,Title the second\n-FTS4] PASSED [ 15%] 544s tests/test_cli.py::test_search[--csv-rowid,id,title\n2,2,Title the second\n-FTS5] PASSED [ 15%] 544s tests/test_cli.py::test_search_quote PASSED [ 16%] 544s tests/test_cli.py::test_indexes PASSED [ 16%] 544s tests/test_cli.py::test_triggers[extra_args0-[{"name": "blah", "table": "articles", "sql": "CREATE TRIGGER blah AFTER INSERT ON articles\\nBEGIN\\n UPDATE counter SET count = count + 1;\\nEND"}]\n] PASSED [ 16%] 544s tests/test_cli.py::test_triggers[extra_args1-[{"name": "blah", "table": "articles", "sql": "CREATE TRIGGER blah AFTER INSERT ON articles\\nBEGIN\\n UPDATE counter SET count = count + 1;\\nEND"}]\n] PASSED [ 16%] 544s tests/test_cli.py::test_triggers[extra_args2-[]\n] PASSED [ 16%] 544s tests/test_cli.py::test_schema[options0-CREATE TABLE [dogs] (\n [id] INTEGER,\n [name] TEXT\n);\nCREATE TABLE [chickens] (\n [id] INTEGER,\n [name] TEXT,\n [breed] TEXT\n);\nCREATE INDEX [idx_chickens_breed]\n ON [chickens] ([breed]);\n] PASSED [ 16%] 544s tests/test_cli.py::test_schema[options1-CREATE TABLE [dogs] (\n [id] INTEGER,\n [name] TEXT\n)\n] PASSED [ 16%] 544s tests/test_cli.py::test_schema[options2-CREATE TABLE [chickens] (\n [id] INTEGER,\n [name] TEXT,\n [breed] TEXT\n)\nCREATE TABLE [dogs] (\n [id] INTEGER,\n [name] TEXT\n)\n] PASSED [ 16%] 544s tests/test_cli.py::test_long_csv_column_value PASSED [ 16%] 544s tests/test_cli.py::test_import_no_headers[args0-False] PASSED [ 16%] 544s tests/test_cli.py::test_import_no_headers[args1-False] PASSED [ 17%] 544s tests/test_cli.py::test_import_no_headers[args2-True] PASSED [ 17%] 544s tests/test_cli.py::test_attach PASSED [ 17%] 544s tests/test_cli.py::test_csv_insert_bom PASSED [ 17%] 544s tests/test_cli.py::test_insert_detect_types[None] PASSED [ 17%] 544s tests/test_cli.py::test_insert_detect_types[-d] PASSED [ 17%] 544s tests/test_cli.py::test_insert_detect_types[--detect-types] PASSED [ 17%] 544s tests/test_cli.py::test_upsert_detect_types[-d] PASSED [ 17%] 544s tests/test_cli.py::test_upsert_detect_types[--detect-types] PASSED [ 17%] 544s tests/test_cli.py::test_integer_overflow_error PASSED [ 18%] 544s tests/test_cli.py::test_python_dash_m PASSED [ 18%] 544s tests/test_cli.py::test_create_database[False] PASSED [ 18%] 544s tests/test_cli.py::test_create_database[True] PASSED [ 18%] 544s tests/test_cli.py::test_analyze[options0-expected0] PASSED [ 18%] 544s tests/test_cli.py::test_analyze[options1-expected1] PASSED [ 18%] 544s tests/test_cli.py::test_analyze[options2-expected2] PASSED [ 18%] 544s tests/test_cli.py::test_rename_table PASSED [ 18%] 544s tests/test_cli.py::test_duplicate_table PASSED [ 18%] 544s tests/test_cli.py::test_load_extension[None-should_pass0-should_fail0] SKIPPED [ 18%] 544s tests/test_cli.py::test_load_extension[sqlite3_ext_b_init-b-should_fail1] SKIPPED [ 19%] 544s tests/test_cli.py::test_load_extension[sqlite3_ext_c_init-c-should_fail2] SKIPPED [ 19%] 544s tests/test_cli_bulk.py::test_cli_bulk PASSED [ 19%] 546s tests/test_cli_bulk.py::test_cli_bulk_batch_size PASSED [ 19%] 546s tests/test_cli_bulk.py::test_cli_bulk_error PASSED [ 19%] 546s tests/test_cli_convert.py::test_convert_code[return value.replace('October', 'Spooktober')] PASSED [ 19%] 546s tests/test_cli_convert.py::test_convert_code[value.replace('October', 'Spooktober')] PASSED [ 19%] 546s tests/test_cli_convert.py::test_convert_code[v = value.replace('October', 'Spooktober')\nreturn v] PASSED [ 19%] 546s tests/test_cli_convert.py::test_convert_code[def convert(value): return value.replace('October', 'Spooktober')] PASSED [ 19%] 546s tests/test_cli_convert.py::test_convert_code[import re\n\ndef convert(value): return value.replace('October', 'Spooktober')] PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_code_errors[def foo(value)] PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_code_errors[$] PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_import PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_import_nested PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_dryrun PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_multi_dryrun PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_output_column[True] PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_output_column[False] PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_output_column_output_type[text-expected0] PASSED [ 20%] 546s tests/test_cli_convert.py::test_convert_output_column_output_type[float-expected1] PASSED [ 21%] 546s tests/test_cli_convert.py::test_convert_output_column_output_type[integer-expected2] PASSED [ 21%] 546s tests/test_cli_convert.py::test_convert_output_column_output_type[None-expected3] PASSED [ 21%] 546s tests/test_cli_convert.py::test_convert_output_error[options0-Cannot use --output with more than one column] PASSED [ 21%] 546s tests/test_cli_convert.py::test_convert_output_error[options1-Error: Invalid value for '--output-type'] PASSED [ 21%] 546s tests/test_cli_convert.py::test_convert_output_error[options2-Missing argument 'COLUMNS...'] PASSED [ 21%] 546s tests/test_cli_convert.py::test_convert_multi[True] PASSED [ 21%] 546s tests/test_cli_convert.py::test_convert_multi[False] PASSED [ 21%] 546s tests/test_cli_convert.py::test_convert_multi_complex_column_types PASSED [ 21%] 546s tests/test_cli_convert.py::test_recipe_jsonsplit[None] PASSED [ 21%] 546s tests/test_cli_convert.py::test_recipe_jsonsplit[;] PASSED [ 22%] 546s tests/test_cli_convert.py::test_recipe_jsonsplit[-] PASSED [ 22%] 546s tests/test_cli_convert.py::test_recipe_jsonsplit_type[None-expected_array0] PASSED [ 22%] 546s tests/test_cli_convert.py::test_recipe_jsonsplit_type[float-expected_array1] PASSED [ 22%] 546s tests/test_cli_convert.py::test_recipe_jsonsplit_type[int-expected_array2] PASSED [ 22%] 546s tests/test_cli_convert.py::test_recipe_jsonsplit_output[True] PASSED [ 22%] 546s tests/test_cli_convert.py::test_recipe_jsonsplit_output[False] PASSED [ 22%] 546s tests/test_cli_convert.py::test_cannot_use_drop_without_multi_or_output PASSED [ 22%] 546s tests/test_cli_convert.py::test_cannot_use_multi_with_more_than_one_column PASSED [ 22%] 546s tests/test_cli_convert.py::test_multi_with_bad_function PASSED [ 23%] 547s tests/test_cli_convert.py::test_convert_where PASSED [ 23%] 547s tests/test_cli_convert.py::test_convert_where_multi PASSED [ 23%] 547s tests/test_cli_convert.py::test_convert_code_standard_input PASSED [ 23%] 547s tests/test_cli_convert.py::test_convert_hyphen_workaround PASSED [ 23%] 547s tests/test_cli_convert.py::test_convert_initialization_pattern PASSED [ 23%] 547s tests/test_cli_convert.py::test_convert_no_skip_false[True-1] PASSED [ 23%] 547s tests/test_cli_convert.py::test_convert_no_skip_false[False-0] PASSED [ 23%] 547s tests/test_cli_insert.py::test_insert_simple PASSED [ 23%] 547s tests/test_cli_insert.py::test_insert_from_stdin PASSED [ 23%] 547s tests/test_cli_insert.py::test_insert_invalid_json_error PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_json_flatten PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_json_flatten_nl PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_with_primary_key PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_multiple_with_primary_key PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_multiple_with_compound_primary_key PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_not_null_default PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_binary_base64 PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_newline_delimited PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_ignore PASSED [ 24%] 547s tests/test_cli_insert.py::test_insert_csv_tsv[foo\tbar\tbaz\n1\t2\tcat,dog-options0] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,"cat,dog"-options1] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_csv_tsv[foo;bar;baz\n1;2;"cat,dog"-options2] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_csv_tsv[foo;bar;baz\n1;2;"cat,dog"-options3] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,|cat,dog|-options4] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,|cat,dog|-options5] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_csv_empty_null[True] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_csv_empty_null[False] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_stop_after[[{"name": "One"}, {"name": "Two"}, {"name": "Three"}, {"name": "Four"}]-args0] PASSED [ 25%] 547s tests/test_cli_insert.py::test_insert_stop_after[name\nOne\nTwo\nThree\nFour\n-args1] PASSED [ 26%] 547s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options0] PASSED [ 26%] 547s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options1] PASSED [ 26%] 547s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options2] PASSED [ 26%] 547s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options3] PASSED [ 26%] 547s tests/test_cli_insert.py::test_insert_replace PASSED [ 26%] 547s tests/test_cli_insert.py::test_insert_truncate PASSED [ 26%] 547s tests/test_cli_insert.py::test_insert_alter PASSED [ 26%] 547s tests/test_cli_insert.py::test_insert_analyze PASSED [ 26%] 547s tests/test_cli_insert.py::test_insert_lines PASSED [ 26%] 547s tests/test_cli_insert.py::test_insert_text PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options0-[{"id": "1", "name": "Bob"}, {"id": "2", "name": "Cat"}]] PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options1-id,name\n1,Bob\n2,Cat] PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options2-{"id": "1", "name": "Bob"}\n{"id": "2", "name": "Cat"}] PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_text PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_text_returning_iterator PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_lines PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_row_modifying_in_place PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_error_messages[options0-Error: --convert must return dict or iterator\n] PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_convert_error_messages[options1-Error: Rows must all be dictionaries, got: 1\n] PASSED [ 27%] 547s tests/test_cli_insert.py::test_insert_streaming_batch_size_1 PASSED [ 28%] 547s tests/test_cli_memory.py::test_memory_basic PASSED [ 28%] 547s tests/test_cli_memory.py::test_memory_csv[True-test] PASSED [ 28%] 547s tests/test_cli_memory.py::test_memory_csv[True-t] PASSED [ 28%] 548s tests/test_cli_memory.py::test_memory_csv[True-t1] PASSED [ 28%] 548s tests/test_cli_memory.py::test_memory_csv[False-test] PASSED [ 28%] 548s tests/test_cli_memory.py::test_memory_csv[False-t] PASSED [ 28%] 548s tests/test_cli_memory.py::test_memory_csv[False-t1] PASSED [ 28%] 548s tests/test_cli_memory.py::test_memory_tsv[True] PASSED [ 28%] 548s tests/test_cli_memory.py::test_memory_tsv[False] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_json[True] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_json[False] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_json_nl[True] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_json_nl[False] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_csv_encoding[True] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_csv_encoding[False] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_dump[extra_args0] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_dump[extra_args1] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_schema[extra_args0] PASSED [ 29%] 548s tests/test_cli_memory.py::test_memory_schema[extra_args1] PASSED [ 30%] 548s tests/test_cli_memory.py::test_memory_save[extra_args0] PASSED [ 30%] 548s tests/test_cli_memory.py::test_memory_save[extra_args1] PASSED [ 30%] 548s tests/test_cli_memory.py::test_memory_no_detect_types[-n] PASSED [ 30%] 548s tests/test_cli_memory.py::test_memory_no_detect_types[--no-detect-types] PASSED [ 30%] 548s tests/test_cli_memory.py::test_memory_flatten PASSED [ 30%] 548s tests/test_cli_memory.py::test_memory_analyze PASSED [ 30%] 548s tests/test_cli_memory.py::test_memory_two_files_with_same_stem PASSED [ 30%] 548s tests/test_cli_memory.py::test_memory_functions PASSED [ 30%] 548s tests/test_column_affinity.py::test_column_affinity[INT-int] PASSED [ 30%] 548s tests/test_column_affinity.py::test_column_affinity[INTEGER-int] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[TINYINT-int] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[SMALLINT-int] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[MEDIUMINT-int] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[BIGINT-int] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[UNSIGNED BIG INT-int] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[INT2-int] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[INT8-int] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[CHARACTER(20)-str] PASSED [ 31%] 548s tests/test_column_affinity.py::test_column_affinity[VARCHAR(255)-str] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[VARYING CHARACTER(255)-str] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[NCHAR(55)-str] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[NATIVE CHARACTER(70)-str] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[NVARCHAR(100)-str] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[TEXT-str] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[CLOB-str] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[BLOB-bytes] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[REAL-float] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[DOUBLE-float] PASSED [ 32%] 548s tests/test_column_affinity.py::test_column_affinity[DOUBLE PRECISION-float] PASSED [ 33%] 548s tests/test_column_affinity.py::test_column_affinity[FLOAT-float] PASSED [ 33%] 548s tests/test_column_affinity.py::test_column_affinity[NUMERIC-float] PASSED [ 33%] 548s tests/test_column_affinity.py::test_column_affinity[DECIMAL(10,5)-float] PASSED [ 33%] 548s tests/test_column_affinity.py::test_column_affinity[BOOLEAN-float] PASSED [ 33%] 548s tests/test_column_affinity.py::test_column_affinity[DATE-float] PASSED [ 33%] 548s tests/test_column_affinity.py::test_column_affinity[DATETIME-float] PASSED [ 33%] 548s tests/test_column_affinity.py::test_columns_dict[INT-int] PASSED [ 33%] 548s tests/test_column_affinity.py::test_columns_dict[INTEGER-int] PASSED [ 33%] 548s tests/test_column_affinity.py::test_columns_dict[TINYINT-int] PASSED [ 33%] 548s tests/test_column_affinity.py::test_columns_dict[SMALLINT-int] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[MEDIUMINT-int] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[BIGINT-int] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[UNSIGNED BIG INT-int] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[INT2-int] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[INT8-int] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[CHARACTER(20)-str] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[VARCHAR(255)-str] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[VARYING CHARACTER(255)-str] PASSED [ 34%] 548s tests/test_column_affinity.py::test_columns_dict[NCHAR(55)-str] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[NATIVE CHARACTER(70)-str] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[NVARCHAR(100)-str] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[TEXT-str] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[CLOB-str] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[BLOB-bytes] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[REAL-float] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[DOUBLE-float] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[DOUBLE PRECISION-float] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[FLOAT-float] PASSED [ 35%] 548s tests/test_column_affinity.py::test_columns_dict[NUMERIC-float] PASSED [ 36%] 548s tests/test_column_affinity.py::test_columns_dict[DECIMAL(10,5)-float] PASSED [ 36%] 548s tests/test_column_affinity.py::test_columns_dict[BOOLEAN-float] PASSED [ 36%] 548s tests/test_column_affinity.py::test_columns_dict[DATE-float] PASSED [ 36%] 548s tests/test_column_affinity.py::test_columns_dict[DATETIME-float] PASSED [ 36%] 548s tests/test_constructor.py::test_recursive_triggers PASSED [ 36%] 548s tests/test_constructor.py::test_recursive_triggers_off PASSED [ 36%] 548s tests/test_constructor.py::test_memory_name PASSED [ 36%] 548s tests/test_constructor.py::test_sqlite_version PASSED [ 36%] 548s tests/test_constructor.py::test_database_close[True] PASSED [ 36%] 548s tests/test_constructor.py::test_database_close[False] PASSED [ 37%] 548s tests/test_conversions.py::test_insert_conversion PASSED [ 37%] 548s tests/test_conversions.py::test_insert_all_conversion PASSED [ 37%] 548s tests/test_conversions.py::test_upsert_conversion PASSED [ 37%] 548s tests/test_conversions.py::test_upsert_all_conversion PASSED [ 37%] 548s tests/test_conversions.py::test_update_conversion PASSED [ 37%] 548s tests/test_conversions.py::test_table_constructor_conversion PASSED [ 37%] 548s tests/test_convert.py::test_convert[title--expected0] PASSED [ 37%] 548s tests/test_convert.py::test_convert[columns1--expected1] PASSED [ 37%] 548s tests/test_convert.py::test_convert[title--expected2] PASSED [ 38%] 548s tests/test_convert.py::test_convert_where[id > 1-None] PASSED [ 38%] 548s tests/test_convert.py::test_convert_where[id > :id-where_args1] PASSED [ 38%] 548s tests/test_convert.py::test_convert_where[id > ?-where_args2] PASSED [ 38%] 548s tests/test_convert.py::test_convert_skip_false PASSED [ 38%] 548s tests/test_convert.py::test_convert_output[False-expected0] PASSED [ 38%] 548s tests/test_convert.py::test_convert_output[True-expected1] PASSED [ 38%] 548s tests/test_convert.py::test_convert_output_multiple_column_error PASSED [ 38%] 548s tests/test_convert.py::test_convert_output_type[int-expected0] PASSED [ 38%] 548s tests/test_convert.py::test_convert_output_type[float-expected1] PASSED [ 38%] 548s tests/test_convert.py::test_convert_multi PASSED [ 39%] 548s tests/test_convert.py::test_convert_multi_where PASSED [ 39%] 548s tests/test_convert.py::test_convert_multi_exception PASSED [ 39%] 548s tests/test_convert.py::test_convert_repeated PASSED [ 39%] 548s tests/test_create.py::test_create_table PASSED [ 39%] 548s tests/test_create.py::test_create_table_compound_primary_key PASSED [ 39%] 548s tests/test_create.py::test_create_table_with_single_primary_key[id] PASSED [ 39%] 548s tests/test_create.py::test_create_table_with_single_primary_key[pk1] PASSED [ 39%] 548s tests/test_create.py::test_create_table_with_invalid_column_characters PASSED [ 39%] 548s tests/test_create.py::test_create_table_with_defaults PASSED [ 40%] 548s tests/test_create.py::test_create_table_with_bad_not_null PASSED [ 40%] 548s tests/test_create.py::test_create_table_with_not_null PASSED [ 40%] 548s tests/test_create.py::test_create_table_from_example[example0-expected_columns0] PASSED [ 40%] 548s tests/test_create.py::test_create_table_from_example[example1-expected_columns1] PASSED [ 40%] 548s tests/test_create.py::test_create_table_from_example[example2-expected_columns2] PASSED [ 40%] 548s tests/test_create.py::test_create_table_from_example[example3-expected_columns3] PASSED [ 40%] 548s tests/test_create.py::test_create_table_from_example[example4-expected_columns4] PASSED [ 40%] 548s tests/test_create.py::test_create_table_from_example[example5-expected_columns5] PASSED [ 40%] 548s tests/test_create.py::test_create_table_from_example[example6-expected_columns6] PASSED [ 40%] 548s tests/test_create.py::test_create_table_from_example[example7-expected_columns7] PASSED [ 41%] 548s tests/test_create.py::test_create_table_from_example_with_compound_primary_keys PASSED [ 41%] 548s tests/test_create.py::test_create_table_with_custom_columns[insert] PASSED [ 41%] 548s tests/test_create.py::test_create_table_with_custom_columns[upsert] PASSED [ 41%] 548s tests/test_create.py::test_create_table_with_custom_columns[insert_all] PASSED [ 41%] 548s tests/test_create.py::test_create_table_with_custom_columns[upsert_all] PASSED [ 41%] 548s tests/test_create.py::test_create_table_column_order[True] PASSED [ 41%] 548s tests/test_create.py::test_create_table_column_order[False] PASSED [ 41%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification0-False] PASSED [ 41%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification1-False] PASSED [ 41%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification2-False] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification3-False] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification4-NoObviousTable] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification5-AssertionError] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification6-AlterError] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification7-AssertionError] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification0-False] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification1-False] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification2-False] PASSED [ 42%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification3-False] PASSED [ 43%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification4-NoObviousTable] PASSED [ 43%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification5-AssertionError] PASSED [ 43%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification6-AlterError] PASSED [ 43%] 548s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification7-AssertionError] PASSED [ 43%] 548s tests/test_create.py::test_self_referential_foreign_key PASSED [ 43%] 548s tests/test_create.py::test_create_error_if_invalid_foreign_keys PASSED [ 43%] 548s tests/test_create.py::test_create_error_if_invalid_self_referential_foreign_keys PASSED [ 43%] 548s tests/test_create.py::test_add_column[nickname-str-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [nickname] TEXT)] PASSED [ 43%] 548s tests/test_create.py::test_add_column[dob-date-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [dob] TEXT)] PASSED [ 43%] 548s tests/test_create.py::test_add_column[age-int-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [age] INTEGER)] PASSED [ 44%] 548s tests/test_create.py::test_add_column[weight-float-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [weight] FLOAT)] PASSED [ 44%] 548s tests/test_create.py::test_add_column[text-TEXT-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [text] TEXT)] PASSED [ 44%] 548s tests/test_create.py::test_add_column[integer-INTEGER-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [integer] INTEGER)] PASSED [ 44%] 548s tests/test_create.py::test_add_column[float-FLOAT-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [float] FLOAT)] PASSED [ 44%] 548s tests/test_create.py::test_add_column[blob-blob-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [blob] BLOB)] PASSED [ 44%] 548s tests/test_create.py::test_add_column[default_str-None-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [default_str] TEXT)] PASSED [ 44%] 548s tests/test_create.py::test_add_column[nickname-str--CREATE TABLE [dogs] (\n [name] TEXT\n, [nickname] TEXT NOT NULL DEFAULT '')] PASSED [ 44%] 548s tests/test_create.py::test_add_column[nickname-str-dawg's dawg-CREATE TABLE [dogs] (\n [name] TEXT\n, [nickname] TEXT NOT NULL DEFAULT 'dawg''s dawg')] PASSED [ 44%] 548s tests/test_create.py::test_add_foreign_key PASSED [ 44%] 548s tests/test_create.py::test_add_foreign_key_if_column_contains_space PASSED [ 45%] 548s tests/test_create.py::test_add_foreign_key_error_if_column_does_not_exist PASSED [ 45%] 548s tests/test_create.py::test_add_foreign_key_error_if_other_table_does_not_exist PASSED [ 45%] 548s tests/test_create.py::test_add_foreign_key_error_if_already_exists PASSED [ 45%] 548s tests/test_create.py::test_add_foreign_key_no_error_if_exists_and_ignore_true PASSED [ 45%] 548s tests/test_create.py::test_add_foreign_keys PASSED [ 45%] 548s tests/test_create.py::test_add_column_foreign_key PASSED [ 45%] 548s tests/test_create.py::test_add_foreign_key_guess_table PASSED [ 45%] 548s tests/test_create.py::test_index_foreign_keys PASSED [ 45%] 548s tests/test_create.py::test_index_foreign_keys_if_index_name_is_already_used PASSED [ 46%] 548s tests/test_create.py::test_insert_row_alter_table[True-extra_data0-expected_new_columns0] PASSED [ 46%] 548s tests/test_create.py::test_insert_row_alter_table[True-extra_data1-expected_new_columns1] PASSED [ 46%] 548s tests/test_create.py::test_insert_row_alter_table[True-extra_data2-expected_new_columns2] PASSED [ 46%] 548s tests/test_create.py::test_insert_row_alter_table[False-extra_data0-expected_new_columns0] PASSED [ 46%] 548s tests/test_create.py::test_insert_row_alter_table[False-extra_data1-expected_new_columns1] PASSED [ 46%] 548s tests/test_create.py::test_insert_row_alter_table[False-extra_data2-expected_new_columns2] PASSED [ 46%] 548s tests/test_create.py::test_add_missing_columns_case_insensitive PASSED [ 46%] 548s tests/test_create.py::test_insert_replace_rows_alter_table[True] PASSED [ 46%] 548s tests/test_create.py::test_insert_replace_rows_alter_table[False] PASSED [ 46%] 548s tests/test_create.py::test_insert_all_with_extra_columns_in_later_chunks PASSED [ 47%] 548s tests/test_create.py::test_bulk_insert_more_than_999_values PASSED [ 47%] 548s tests/test_create.py::test_error_if_more_than_999_columns[900-False] PASSED [ 47%] 548s tests/test_create.py::test_error_if_more_than_999_columns[999-False] PASSED [ 47%] 548s tests/test_create.py::test_error_if_more_than_999_columns[1000-True] PASSED [ 47%] 549s tests/test_create.py::test_columns_not_in_first_record_should_not_cause_batch_to_be_too_large PASSED [ 47%] 549s tests/test_create.py::test_create_index[columns0-None-expected_index0] PASSED [ 47%] 549s tests/test_create.py::test_create_index[columns1-None-expected_index1] PASSED [ 47%] 549s tests/test_create.py::test_create_index[columns2-age_index-expected_index2] PASSED [ 47%] 549s tests/test_create.py::test_create_index_unique PASSED [ 47%] 549s tests/test_create.py::test_create_index_if_not_exists PASSED [ 48%] 549s tests/test_create.py::test_create_index_desc PASSED [ 48%] 549s tests/test_create.py::test_create_index_find_unique_name PASSED [ 48%] 549s tests/test_create.py::test_create_index_analyze PASSED [ 48%] 549s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure0] PASSED [ 48%] 549s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure1] PASSED [ 48%] 549s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure2] PASSED [ 48%] 549s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure3] PASSED [ 48%] 549s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure4] PASSED [ 48%] 549s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure5] PASSED [ 49%] 549s tests/test_create.py::test_insert_list_nested_unicode PASSED [ 49%] 549s tests/test_create.py::test_insert_uuid PASSED [ 49%] 549s tests/test_create.py::test_insert_memoryview PASSED [ 49%] 549s tests/test_create.py::test_insert_thousands_using_generator PASSED [ 49%] 549s tests/test_create.py::test_insert_thousands_raises_exception_with_extra_columns_after_first_100 PASSED [ 49%] 549s tests/test_create.py::test_insert_thousands_adds_extra_columns_after_first_100_with_alter PASSED [ 49%] 549s tests/test_create.py::test_insert_ignore PASSED [ 49%] 549s tests/test_create.py::test_insert_hash_id PASSED [ 49%] 549s tests/test_create.py::test_insert_hash_id_columns[True] PASSED [ 49%] 549s tests/test_create.py::test_insert_hash_id_columns[False] PASSED [ 50%] 549s tests/test_create.py::test_vacuum PASSED [ 50%] 549s tests/test_create.py::test_works_with_pathlib_path PASSED [ 50%] 549s tests/test_create.py::test_create_table_numpy SKIPPED (pandas and nu...) [ 50%] 549s tests/test_create.py::test_cannot_provide_both_filename_and_memory PASSED [ 50%] 549s tests/test_create.py::test_creates_id_column PASSED [ 50%] 549s tests/test_create.py::test_drop PASSED [ 50%] 549s tests/test_create.py::test_drop_view PASSED [ 50%] 549s tests/test_create.py::test_drop_ignore PASSED [ 50%] 549s tests/test_create.py::test_insert_all_empty_list PASSED [ 50%] 549s tests/test_create.py::test_insert_all_single_column PASSED [ 51%] 549s tests/test_create.py::test_insert_all_analyze[insert_all] PASSED [ 51%] 549s tests/test_create.py::test_insert_all_analyze[upsert_all] PASSED [ 51%] 549s tests/test_create.py::test_create_with_a_null_column PASSED [ 51%] 549s tests/test_create.py::test_create_with_nested_bytes PASSED [ 51%] 549s tests/test_create.py::test_quote[hello-'hello'] PASSED [ 51%] 549s tests/test_create.py::test_quote[hello'there'-'hello''there'''] PASSED [ 51%] 549s tests/test_create.py::test_create_table_sql[columns0-[id] INTEGER] PASSED [ 51%] 549s tests/test_create.py::test_create_table_sql[columns1-[col] TEXT] PASSED [ 51%] 549s tests/test_create.py::test_create_table_sql[columns2-[col] TEXT] PASSED [ 52%] 549s tests/test_create.py::test_create_table_sql[columns3-[col] TEXT] PASSED [ 52%] 549s tests/test_create.py::test_create PASSED [ 52%] 549s tests/test_create.py::test_create_if_not_exists PASSED [ 52%] 549s tests/test_create.py::test_create_if_no_columns PASSED [ 52%] 549s tests/test_create.py::test_create_ignore PASSED [ 52%] 549s tests/test_create.py::test_create_replace PASSED [ 52%] 549s tests/test_create.py::test_create_transform[cols0-kwargs0-CREATE TABLE [demo] (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)-False] PASSED [ 52%] 549s tests/test_create.py::test_create_transform[cols1-kwargs1-CREATE TABLE "demo" (\n [id] INTEGER\n)-True] PASSED [ 52%] 549s tests/test_create.py::test_create_transform[cols2-kwargs2-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT,\n [age] INTEGER\n)-True] PASSED [ 52%] 549s tests/test_create.py::test_create_transform[cols3-kwargs3-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY,\n [name] BLOB\n)-True] PASSED [ 53%] 549s tests/test_create.py::test_create_transform[cols4-kwargs4-CREATE TABLE "demo" (\n [id] INTEGER,\n [name] TEXT PRIMARY KEY\n)-True] PASSED [ 53%] 549s tests/test_create.py::test_create_transform[cols5-kwargs5-CREATE TABLE "demo" (\n [name] TEXT,\n [id] INTEGER PRIMARY KEY\n)-True] PASSED [ 53%] 549s tests/test_create.py::test_create_transform[cols6-kwargs6-CREATE TABLE [demo] (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)-False] PASSED [ 53%] 549s tests/test_create.py::test_create_transform[cols7-kwargs7-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT NOT NULL\n)-True] PASSED [ 53%] 549s tests/test_create.py::test_create_transform[cols8-kwargs8-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY DEFAULT 0,\n [name] TEXT DEFAULT 'Bob'\n)-True] PASSED [ 53%] 549s tests/test_create.py::test_rename_table PASSED [ 53%] 549s tests/test_create_view.py::test_create_view PASSED [ 53%] 549s tests/test_create_view.py::test_create_view_error PASSED [ 53%] 549s tests/test_create_view.py::test_create_view_only_arrow_one_param PASSED [ 53%] 549s tests/test_create_view.py::test_create_view_ignore PASSED [ 54%] 549s tests/test_create_view.py::test_create_view_replace PASSED [ 54%] 549s tests/test_create_view.py::test_create_view_replace_with_same_does_nothing PASSED [ 54%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'foo'-'foo'-'foo'] PASSED [ 54%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'foo)'-'foo)'-'foo)'] PASSED [ 54%] 549s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT '1'-'1'-'1'] PASSED [ 54%] 549s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT 1-1-'1'] PASSED [ 54%] 549s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT (1)-1-'1'] PASSED [ 54%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW'))-STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')-(STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW'))] PASSED [ 54%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_TIME-CURRENT_TIME-CURRENT_TIME] PASSED [ 55%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_DATE-CURRENT_DATE-CURRENT_DATE] PASSED [ 55%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_TIMESTAMP-CURRENT_TIMESTAMP-CURRENT_TIMESTAMP] PASSED [ 55%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT current_timestamp-current_timestamp-current_timestamp] PASSED [ 55%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT (CURRENT_TIMESTAMP)-CURRENT_TIMESTAMP-CURRENT_TIMESTAMP] PASSED [ 55%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'CURRENT_TIMESTAMP'-'CURRENT_TIMESTAMP'-'CURRENT_TIMESTAMP'] PASSED [ 55%] 549s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT "CURRENT_TIMESTAMP"-"CURRENT_TIMESTAMP"-"CURRENT_TIMESTAMP"] PASSED [ 55%] 549s tests/test_delete.py::test_delete_rowid_table PASSED [ 55%] 549s tests/test_delete.py::test_delete_pk_table PASSED [ 55%] 549s tests/test_delete.py::test_delete_where PASSED [ 55%] 549s tests/test_delete.py::test_delete_where_all PASSED [ 56%] 549s tests/test_delete.py::test_delete_where_analyze PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[tables] PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[views] PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[optimize] PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[rebuild-fts] PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[analyze] PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[vacuum] PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[dump] PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[add-column] PASSED [ 56%] 549s tests/test_docs.py::test_commands_are_documented[add-foreign-key] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[add-foreign-keys] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[index-foreign-keys] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[create-index] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[enable-fts] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[populate-fts] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[disable-fts] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[enable-wal] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[disable-wal] PASSED [ 57%] 549s tests/test_docs.py::test_commands_are_documented[enable-counts] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[reset-counts] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[insert] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[upsert] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[bulk] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[create-database] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[create-table] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[duplicate] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[rename-table] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[drop-table] PASSED [ 58%] 549s tests/test_docs.py::test_commands_are_documented[create-view] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[drop-view] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[query] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[memory] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[search] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[rows] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[triggers] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[indexes] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[schema] PASSED [ 59%] 549s tests/test_docs.py::test_commands_are_documented[transform] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[extract] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[insert-files] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[analyze-tables] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[install] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[uninstall] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[convert] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[add-geometry-column] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[create-spatial-index] PASSED [ 60%] 549s tests/test_docs.py::test_commands_are_documented[plugins] PASSED [ 60%] 549s tests/test_docs.py::test_commands_have_help[command0] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command1] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command2] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command3] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command4] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command5] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command6] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command7] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command8] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command9] PASSED [ 61%] 549s tests/test_docs.py::test_commands_have_help[command10] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command11] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command12] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command13] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command14] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command15] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command16] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command17] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command18] PASSED [ 62%] 549s tests/test_docs.py::test_commands_have_help[command19] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command20] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command21] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command22] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command23] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command24] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command25] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command26] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command27] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command28] PASSED [ 63%] 549s tests/test_docs.py::test_commands_have_help[command29] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command30] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command31] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command32] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command33] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command34] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command35] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command36] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command37] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command38] PASSED [ 64%] 549s tests/test_docs.py::test_commands_have_help[command39] PASSED [ 65%] 549s tests/test_docs.py::test_commands_have_help[command40] PASSED [ 65%] 549s tests/test_docs.py::test_commands_have_help[command41] PASSED [ 65%] 549s tests/test_docs.py::test_commands_have_help[command42] PASSED [ 65%] 549s tests/test_docs.py::test_commands_have_help[command43] PASSED [ 65%] 549s tests/test_docs.py::test_commands_have_help[command44] PASSED [ 65%] 549s tests/test_docs.py::test_commands_have_help[command45] PASSED [ 65%] 549s tests/test_docs.py::test_convert_help PASSED [ 65%] 549s tests/test_docs.py::test_recipes_are_documented[jsonsplit] PASSED [ 65%] 549s tests/test_docs.py::test_recipes_are_documented[parsedate] PASSED [ 66%] 549s tests/test_docs.py::test_recipes_are_documented[parsedatetime] PASSED [ 66%] 549s tests/test_duplicate.py::test_duplicate PASSED [ 66%] 549s tests/test_duplicate.py::test_duplicate_fails_if_table_does_not_exist PASSED [ 66%] 549s tests/test_enable_counts.py::test_enable_counts_specific_table PASSED [ 66%] 549s tests/test_enable_counts.py::test_enable_counts_all_tables PASSED [ 66%] 549s tests/test_enable_counts.py::test_cli_enable_counts[extra_args0-expected_triggers0] PASSED [ 66%] 549s tests/test_enable_counts.py::test_cli_enable_counts[extra_args1-expected_triggers1] PASSED [ 66%] 549s tests/test_enable_counts.py::test_uses_counts_after_enable_counts PASSED [ 66%] 549s tests/test_enable_counts.py::test_reset_counts PASSED [ 66%] 549s tests/test_enable_counts.py::test_reset_counts_cli PASSED [ 67%] 549s tests/test_extract.py::test_extract_single_column[None-None] PASSED [ 67%] 549s tests/test_extract.py::test_extract_single_column[None-Species] PASSED [ 67%] 549s tests/test_extract.py::test_extract_single_column[species-None] PASSED [ 67%] 549s tests/test_extract.py::test_extract_single_column[species-Species] PASSED [ 67%] 549s tests/test_extract.py::test_extract_multiple_columns_with_rename PASSED [ 67%] 549s tests/test_extract.py::test_extract_invalid_columns PASSED [ 67%] 549s tests/test_extract.py::test_extract_rowid_table PASSED [ 67%] 549s tests/test_extract.py::test_reuse_lookup_table PASSED [ 67%] 549s tests/test_extract.py::test_extract_error_on_incompatible_existing_lookup_table PASSED [ 67%] 549s tests/test_extract.py::test_extract_works_with_null_values PASSED [ 68%] 549s tests/test_extracts.py::test_extracts[True-kwargs0-Species] PASSED [ 68%] 549s tests/test_extracts.py::test_extracts[True-kwargs1-species_id] PASSED [ 68%] 549s tests/test_extracts.py::test_extracts[True-kwargs2-species_id] PASSED [ 68%] 549s tests/test_extracts.py::test_extracts[False-kwargs0-Species] PASSED [ 68%] 549s tests/test_extracts.py::test_extracts[False-kwargs1-species_id] PASSED [ 68%] 549s tests/test_extracts.py::test_extracts[False-kwargs2-species_id] PASSED [ 68%] 549s tests/test_fts.py::test_enable_fts PASSED [ 68%] 549s tests/test_fts.py::test_enable_fts_escape_table_names PASSED [ 68%] 549s tests/test_fts.py::test_search_limit_offset PASSED [ 69%] 549s tests/test_fts.py::test_search_where[FTS4] PASSED [ 69%] 549s tests/test_fts.py::test_search_where[FTS5] PASSED [ 69%] 549s tests/test_fts.py::test_search_where_args_disallows_query PASSED [ 69%] 549s tests/test_fts.py::test_enable_fts_table_names_containing_spaces PASSED [ 69%] 549s tests/test_fts.py::test_populate_fts PASSED [ 69%] 549s tests/test_fts.py::test_populate_fts_escape_table_names PASSED [ 69%] 549s tests/test_fts.py::test_fts_tokenize[4] PASSED [ 69%] 549s tests/test_fts.py::test_fts_tokenize[5] PASSED [ 69%] 549s tests/test_fts.py::test_optimize_fts PASSED [ 69%] 549s tests/test_fts.py::test_enable_fts_with_triggers PASSED [ 70%] 549s tests/test_fts.py::test_disable_fts[True] PASSED [ 70%] 549s tests/test_fts.py::test_disable_fts[False] PASSED [ 70%] 549s tests/test_fts.py::test_rebuild_fts PASSED [ 70%] 549s tests/test_fts.py::test_rebuild_fts_invalid[does_not_exist] PASSED [ 70%] 549s tests/test_fts.py::test_rebuild_fts_invalid[not_searchable] PASSED [ 70%] 549s tests/test_fts.py::test_rebuild_removes_junk_docsize_rows[FTS4] PASSED [ 70%] 549s tests/test_fts.py::test_rebuild_removes_junk_docsize_rows[FTS5] PASSED [ 70%] 549s tests/test_fts.py::test_enable_fts_replace[kwargs0] PASSED [ 70%] 549s tests/test_fts.py::test_enable_fts_replace[kwargs1] PASSED [ 70%] 549s tests/test_fts.py::test_enable_fts_replace[kwargs2] PASSED [ 71%] 549s tests/test_fts.py::test_enable_fts_replace[kwargs3] PASSED [ 71%] 549s tests/test_fts.py::test_enable_fts_replace_does_nothing_if_args_the_same PASSED [ 71%] 549s tests/test_fts.py::test_enable_fts_error_message_on_views PASSED [ 71%] 549s tests/test_fts.py::test_search_sql[kwargs0-FTS5-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n [books_fts].rank] PASSED [ 71%] 549s tests/test_fts.py::test_search_sql[kwargs1-FTS5-with original as (\n select\n rowid,\n [title]\n from [books]\n)\nselect\n [original].[title]\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rowid\nlimit 10] PASSED [ 71%] 549s tests/test_fts.py::test_search_sql[kwargs2-FTS5-with original as (\n select\n rowid,\n *\n from [books]\n where author = :author\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n [books_fts].rank] PASSED [ 71%] 549s tests/test_fts.py::test_search_sql[kwargs3-FTS4-with original as (\n select\n rowid,\n [title]\n from [books]\n)\nselect\n [original].[title]\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))] PASSED [ 71%] 549s tests/test_fts.py::test_search_sql[kwargs4-FTS4-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))\nlimit 1 offset 1] PASSED [ 71%] 549s tests/test_fts.py::test_search_sql[kwargs5-FTS4-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))\nlimit 2] PASSED [ 72%] 549s tests/test_fts.py::test_search_sql[kwargs6-FTS4-with original as (\n select\n rowid,\n *\n from [books]\n where author = :author\n)\nselect\n [original].*\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))] PASSED [ 72%] 549s tests/test_fts.py::test_search_sql[kwargs7-FTS5-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*,\n [books_fts].rank rank\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n [books_fts].rank] PASSED [ 72%] 549s tests/test_fts.py::test_search_sql[kwargs8-FTS4-with original as (\n select\n rowid,\n *\n from [books]\n)\nselect\n [original].*,\n rank_bm25(matchinfo([books_fts], 'pcnalx')) rank\nfrom\n [original]\n join [books_fts] on [original].rowid = [books_fts].rowid\nwhere\n [books_fts] match :query\norder by\n rank_bm25(matchinfo([books_fts], 'pcnalx'))] PASSED [ 72%] 549s tests/test_fts.py::test_quote_fts_query[dog-"dog"] PASSED [ 72%] 549s tests/test_fts.py::test_quote_fts_query[cat,-"cat,"] PASSED [ 72%] 549s tests/test_fts.py::test_quote_fts_query[cat's-"cat's"] PASSED [ 72%] 549s tests/test_fts.py::test_quote_fts_query[dog.-"dog."] PASSED [ 72%] 549s tests/test_fts.py::test_quote_fts_query[cat dog-"cat" "dog"] PASSED [ 72%] 549s tests/test_fts.py::test_quote_fts_query["cat dog"-"cat dog"] PASSED [ 72%] 549s tests/test_fts.py::test_quote_fts_query["cat dog" fish-"cat dog" "fish"] PASSED [ 73%] 549s tests/test_fts.py::test_quote_fts_query[cat"-"cat"] PASSED [ 73%] 549s tests/test_fts.py::test_quote_fts_query["cat dog" "fish-"cat dog" "fish"] PASSED [ 73%] 549s tests/test_fts.py::test_search_quote PASSED [ 73%] 549s tests/test_get.py::test_get_rowid PASSED [ 73%] 549s tests/test_get.py::test_get_primary_key PASSED [ 73%] 549s tests/test_get.py::test_get_not_found[100-None] PASSED [ 73%] 549s tests/test_get.py::test_get_not_found[None-None] PASSED [ 73%] 549s tests/test_get.py::test_get_not_found[argument2-Need 1 primary key value] PASSED [ 73%] 549s tests/test_get.py::test_get_not_found[2-None] PASSED [ 73%] 549s tests/test_gis.py::test_find_spatialite SKIPPED (Could not find Spat...) [ 74%] 549s tests/test_gis.py::test_init_spatialite SKIPPED (Could not find Spat...) [ 74%] 549s tests/test_gis.py::test_add_geometry_column SKIPPED (Could not find ...) [ 74%] 549s tests/test_gis.py::test_create_spatial_index SKIPPED (Could not find...) [ 74%] 549s tests/test_gis.py::test_double_create_spatial_index SKIPPED (Could n...) [ 74%] 549s tests/test_gis.py::test_query_load_extension[True] SKIPPED (Could no...) [ 74%] 549s tests/test_gis.py::test_query_load_extension[False] SKIPPED (Could n...) [ 74%] 549s tests/test_gis.py::test_cli_create_spatialite SKIPPED (Could not fin...) [ 74%] 549s tests/test_gis.py::test_cli_add_geometry_column SKIPPED (Could not f...) [ 74%] 549s tests/test_gis.py::test_cli_add_geometry_column_options SKIPPED (Cou...) [ 75%] 549s tests/test_gis.py::test_cli_add_geometry_column_invalid_type SKIPPED [ 75%] 549s tests/test_gis.py::test_cli_create_spatial_index SKIPPED (Could not ...) [ 75%] 549s tests/test_hypothesis.py::test_roundtrip_integers PASSED [ 75%] 551s tests/test_hypothesis.py::test_roundtrip_text PASSED [ 75%] 551s tests/test_hypothesis.py::test_roundtrip_binary PASSED [ 75%] 552s tests/test_hypothesis.py::test_roundtrip_floats PASSED [ 75%] 552s tests/test_insert_files.py::test_insert_files[False] PASSED [ 75%] 552s tests/test_insert_files.py::test_insert_files[True] PASSED [ 75%] 552s tests/test_insert_files.py::test_insert_files_stdin[False-None-hello world-hello world] PASSED [ 75%] 552s tests/test_insert_files.py::test_insert_files_stdin[True-None-hello world-hello world] PASSED [ 76%] 552s tests/test_insert_files.py::test_insert_files_stdin[False-None-S\xe3o Paulo-S\xe3o Paulo] PASSED [ 76%] 552s tests/test_insert_files.py::test_insert_files_stdin[True-latin-1-S\xe3o Paulo-S\xe3o Paulo] PASSED [ 76%] 552s tests/test_insert_files.py::test_insert_files_bad_text_encoding_error PASSED [ 76%] 552s tests/test_introspect.py::test_table_names PASSED [ 76%] 552s tests/test_introspect.py::test_view_names PASSED [ 76%] 552s tests/test_introspect.py::test_table_names_fts4 PASSED [ 76%] 552s tests/test_introspect.py::test_detect_fts PASSED [ 76%] 552s tests/test_introspect.py::test_detect_fts_similar_tables[True] PASSED [ 76%] 552s tests/test_introspect.py::test_detect_fts_similar_tables[False] PASSED [ 76%] 552s tests/test_introspect.py::test_tables PASSED [ 77%] 552s tests/test_introspect.py::test_views PASSED [ 77%] 552s tests/test_introspect.py::test_count PASSED [ 77%] 552s tests/test_introspect.py::test_count_where PASSED [ 77%] 552s tests/test_introspect.py::test_columns PASSED [ 77%] 552s tests/test_introspect.py::test_table_schema PASSED [ 77%] 552s tests/test_introspect.py::test_database_schema PASSED [ 77%] 552s tests/test_introspect.py::test_table_repr PASSED [ 77%] 552s tests/test_introspect.py::test_indexes PASSED [ 77%] 552s tests/test_introspect.py::test_xindexes PASSED [ 78%] 552s tests/test_introspect.py::test_guess_foreign_table[author-authors] PASSED [ 78%] 552s tests/test_introspect.py::test_guess_foreign_table[author_id-authors] PASSED [ 78%] 552s tests/test_introspect.py::test_guess_foreign_table[authors-authors] PASSED [ 78%] 552s tests/test_introspect.py::test_guess_foreign_table[genre-genre] PASSED [ 78%] 552s tests/test_introspect.py::test_guess_foreign_table[genre_id-genre] PASSED [ 78%] 552s tests/test_introspect.py::test_pks[None-expected0] PASSED [ 78%] 552s tests/test_introspect.py::test_pks[id-expected1] PASSED [ 78%] 552s tests/test_introspect.py::test_pks[pk2-expected2] PASSED [ 78%] 552s tests/test_introspect.py::test_triggers_and_triggers_dict PASSED [ 78%] 552s tests/test_introspect.py::test_has_counts_triggers PASSED [ 79%] 552s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE foo USING FTS5(name)\n -foo-FTS5] PASSED [ 79%] 552s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE "foo" USING FTS4(name)\n -foo-FTS4] PASSED [ 79%] 552s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE IF NOT EXISTS `foo` USING FTS4(name)\n -foo-FTS4] PASSED [ 79%] 552s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE IF NOT EXISTS `foo` USING fts5(name)\n -foo-FTS5] PASSED [ 79%] 552s tests/test_introspect.py::test_virtual_table_using[\n CREATE TABLE IF NOT EXISTS `foo` (id integer primary key)\n -foo-None] PASSED [ 79%] 552s tests/test_introspect.py::test_use_rowid PASSED [ 79%] 552s tests/test_introspect.py::test_table_strict[create table t (id integer) strict-True] PASSED [ 79%] 552s tests/test_introspect.py::test_table_strict[create table t (id integer) STRICT-True] PASSED [ 79%] 552s tests/test_introspect.py::test_table_strict[create table t (id integer primary key) StriCt, WITHOUT ROWID-True] PASSED [ 80%] 552s tests/test_introspect.py::test_table_strict[create table t (id integer primary key) WITHOUT ROWID-False] PASSED [ 80%] 552s tests/test_introspect.py::test_table_strict[create table t (id integer)-False] PASSED [ 80%] 552s tests/test_introspect.py::test_table_default_values[1] PASSED [ 80%] 552s tests/test_introspect.py::test_table_default_values[1.3] PASSED [ 80%] 552s tests/test_introspect.py::test_table_default_values[foo] PASSED [ 80%] 552s tests/test_introspect.py::test_table_default_values[True] PASSED [ 80%] 552s tests/test_introspect.py::test_table_default_values[binary] PASSED [ 80%] 552s tests/test_lookup.py::test_lookup_new_table PASSED [ 80%] 552s tests/test_lookup.py::test_lookup_new_table_compound_key PASSED [ 80%] 552s tests/test_lookup.py::test_lookup_adds_unique_constraint_to_existing_table PASSED [ 81%] 552s tests/test_lookup.py::test_lookup_fails_if_constraint_cannot_be_added PASSED [ 81%] 552s tests/test_lookup.py::test_lookup_with_extra_values PASSED [ 81%] 552s tests/test_lookup.py::test_lookup_with_extra_insert_parameters PASSED [ 81%] 552s tests/test_m2m.py::test_insert_m2m_single PASSED [ 81%] 552s tests/test_m2m.py::test_insert_m2m_alter PASSED [ 81%] 552s tests/test_m2m.py::test_insert_m2m_list PASSED [ 81%] 552s tests/test_m2m.py::test_insert_m2m_iterable PASSED [ 81%] 552s tests/test_m2m.py::test_m2m_with_table_objects PASSED [ 81%] 552s tests/test_m2m.py::test_m2m_lookup PASSED [ 81%] 552s tests/test_m2m.py::test_m2m_requires_either_records_or_lookup PASSED [ 82%] 552s tests/test_m2m.py::test_m2m_explicit_table_name_argument PASSED [ 82%] 552s tests/test_m2m.py::test_m2m_table_candidates PASSED [ 82%] 552s tests/test_m2m.py::test_uses_existing_m2m_table_if_exists PASSED [ 82%] 552s tests/test_m2m.py::test_requires_explicit_m2m_table_if_multiple_options PASSED [ 82%] 552s tests/test_plugins.py::test_register_commands PASSED [ 82%] 552s tests/test_plugins.py::test_prepare_connection PASSED [ 82%] 552s tests/test_query.py::test_query PASSED [ 82%] 552s tests/test_query.py::test_execute_returning_dicts PASSED [ 82%] 552s tests/test_recipes.py::test_parsedate PASSED [ 83%] 552s tests/test_recipes.py::test_parsedatetime PASSED [ 83%] 552s tests/test_recipes.py::test_dayfirst_yearfirst[parsedate-kwargs0-2005-03-04] PASSED [ 83%] 552s tests/test_recipes.py::test_dayfirst_yearfirst[parsedate-kwargs1-2005-04-03] PASSED [ 83%] 552s tests/test_recipes.py::test_dayfirst_yearfirst[parsedatetime-kwargs2-2005-03-04T00:00:00] PASSED [ 83%] 552s tests/test_recipes.py::test_dayfirst_yearfirst[parsedatetime-kwargs3-2005-04-03T00:00:00] PASSED [ 83%] 552s tests/test_recipes.py::test_dateparse_errors[None-parsedate] PASSED [ 83%] 552s tests/test_recipes.py::test_dateparse_errors[None-parsedatetime] PASSED [ 83%] 552s tests/test_recipes.py::test_dateparse_errors[errors1-parsedate] PASSED [ 83%] 552s tests/test_recipes.py::test_dateparse_errors[errors1-parsedatetime] PASSED [ 83%] 552s tests/test_recipes.py::test_dateparse_errors[errors2-parsedate] PASSED [ 84%] 552s tests/test_recipes.py::test_dateparse_errors[errors2-parsedatetime] PASSED [ 84%] 552s tests/test_recipes.py::test_jsonsplit[None] PASSED [ 84%] 552s tests/test_recipes.py::test_jsonsplit[;] PASSED [ 84%] 552s tests/test_recipes.py::test_jsonsplit[-] PASSED [ 84%] 552s tests/test_recipes.py::test_jsonsplit_type[None-expected0] PASSED [ 84%] 552s tests/test_recipes.py::test_jsonsplit_type[float-expected1] PASSED [ 84%] 552s tests/test_recipes.py::test_jsonsplit_type[int-expected2] PASSED [ 84%] 552s tests/test_recreate.py::test_recreate_ignored_for_in_memory PASSED [ 84%] 552s tests/test_recreate.py::test_recreate_not_allowed_for_connection PASSED [ 84%] 552s tests/test_recreate.py::test_recreate[True-True] PASSED [ 85%] 552s tests/test_recreate.py::test_recreate[True-False] PASSED [ 85%] 552s tests/test_recreate.py::test_recreate[False-True] PASSED [ 85%] 552s tests/test_recreate.py::test_recreate[False-False] PASSED [ 85%] 552s tests/test_register_function.py::test_register_function PASSED [ 85%] 552s tests/test_register_function.py::test_register_function_custom_name PASSED [ 85%] 552s tests/test_register_function.py::test_register_function_multiple_arguments PASSED [ 85%] 552s tests/test_register_function.py::test_register_function_deterministic PASSED [ 85%] 552s tests/test_register_function.py::test_register_function_deterministic_tries_again_if_exception_raised PASSED [ 85%] 552s tests/test_register_function.py::test_register_function_replace PASSED [ 86%] 552s tests/test_rows.py::test_rows PASSED [ 86%] 552s tests/test_rows.py::test_rows_where[name = ?-where_args0-expected_ids0] PASSED [ 86%] 552s tests/test_rows.py::test_rows_where[age > ?-where_args1-expected_ids1] PASSED [ 86%] 552s tests/test_rows.py::test_rows_where[age > :age-where_args2-expected_ids2] PASSED [ 86%] 552s tests/test_rows.py::test_rows_where[name is not null-where_args3-expected_ids3] PASSED [ 86%] 552s tests/test_rows.py::test_rows_where[is_good = ?-where_args4-expected_ids4] PASSED [ 86%] 552s tests/test_rows.py::test_rows_where_order_by[None-None-expected_ids0] PASSED [ 86%] 552s tests/test_rows.py::test_rows_where_order_by[None-id desc-expected_ids1] PASSED [ 86%] 552s tests/test_rows.py::test_rows_where_order_by[None-age-expected_ids2] PASSED [ 86%] 552s tests/test_rows.py::test_rows_where_order_by[id > 1-age-expected_ids3] PASSED [ 87%] 552s tests/test_rows.py::test_rows_where_offset_limit[None-3-expected0] PASSED [ 87%] 552s tests/test_rows.py::test_rows_where_offset_limit[0-3-expected1] PASSED [ 87%] 552s tests/test_rows.py::test_rows_where_offset_limit[3-3-expected2] PASSED [ 87%] 552s tests/test_rows.py::test_pks_and_rows_where_rowid PASSED [ 87%] 552s tests/test_rows.py::test_pks_and_rows_where_simple_pk PASSED [ 87%] 552s tests/test_rows.py::test_pks_and_rows_where_compound_pk PASSED [ 87%] 552s tests/test_rows_from_file.py::test_rows_from_file_detect_format[id,name\n1,Cleo-Format.CSV] PASSED [ 87%] 552s tests/test_rows_from_file.py::test_rows_from_file_detect_format[id\tname\n1\tCleo-Format.TSV] PASSED [ 87%] 552s tests/test_rows_from_file.py::test_rows_from_file_detect_format[[{"id": "1", "name": "Cleo"}]-Format.JSON] PASSED [ 87%] 552s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[True-None-expected0] PASSED [ 88%] 552s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[False-_rest-expected1] PASSED [ 88%] 552s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[False-False-None] PASSED [ 88%] 552s tests/test_rows_from_file.py::test_rows_from_file_error_on_string_io PASSED [ 88%] 552s tests/test_sniff.py::test_sniff[filepath0] PASSED [ 88%] 552s tests/test_sniff.py::test_sniff[filepath1] PASSED [ 88%] 552s tests/test_sniff.py::test_sniff[filepath2] PASSED [ 88%] 552s tests/test_sniff.py::test_sniff[filepath3] PASSED [ 88%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records0-types0] PASSED [ 88%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records1-types1] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records2-types2] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records3-types3] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records4-types4] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records5-types5] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records6-types6] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records7-types7] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records8-types8] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records9-types9] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records10-types10] PASSED [ 89%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records11-types11] PASSED [ 90%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records12-types12] PASSED [ 90%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records13-types13] PASSED [ 90%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records14-types14] PASSED [ 90%] 552s tests/test_suggest_column_types.py::test_suggest_column_types[records15-types15] PASSED [ 90%] 552s tests/test_tracer.py::test_tracer PASSED [ 90%] 552s tests/test_tracer.py::test_with_tracer PASSED [ 90%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params0-expected_sql0] PASSED [ 90%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params1-expected_sql1] PASSED [ 90%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params2-expected_sql2] PASSED [ 90%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params3-expected_sql3] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params4-expected_sql4] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params5-expected_sql5] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params6-expected_sql6] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params7-expected_sql7] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params8-expected_sql8] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params0-expected_sql0] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params1-expected_sql1] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params2-expected_sql2] PASSED [ 91%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params3-expected_sql3] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params4-expected_sql4] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params5-expected_sql5] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params6-expected_sql6] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params7-expected_sql7] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params8-expected_sql8] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params0-expected_sql0] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params1-expected_sql1] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params2-expected_sql2] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params3-expected_sql3] PASSED [ 92%] 552s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params0-expected_sql0] PASSED [ 93%] 552s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params1-expected_sql1] PASSED [ 93%] 552s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params2-expected_sql2] PASSED [ 93%] 552s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params3-expected_sql3] PASSED [ 93%] 552s tests/test_transform.py::test_transform_sql_with_no_primary_key_to_primary_key_of_id PASSED [ 93%] 552s tests/test_transform.py::test_transform_rename_pk PASSED [ 93%] 552s tests/test_transform.py::test_transform_not_null PASSED [ 93%] 552s tests/test_transform.py::test_transform_remove_a_not_null PASSED [ 93%] 552s tests/test_transform.py::test_transform_add_not_null_with_rename[not_null0] PASSED [ 93%] 552s tests/test_transform.py::test_transform_add_not_null_with_rename[not_null1] PASSED [ 93%] 552s tests/test_transform.py::test_transform_defaults PASSED [ 94%] 552s tests/test_transform.py::test_transform_defaults_and_rename_column PASSED [ 94%] 552s tests/test_transform.py::test_remove_defaults PASSED [ 94%] 552s tests/test_transform.py::test_transform_foreign_keys_persist PASSED [ 94%] 552s tests/test_transform.py::test_transform_foreign_keys_survive_renamed_column[False] PASSED [ 94%] 552s tests/test_transform.py::test_transform_foreign_keys_survive_renamed_column[True] PASSED [ 94%] 552s tests/test_transform.py::test_transform_drop_foreign_keys[False] PASSED [ 94%] 552s tests/test_transform.py::test_transform_drop_foreign_keys[True] PASSED [ 94%] 552s tests/test_transform.py::test_transform_verify_foreign_keys PASSED [ 94%] 552s tests/test_transform.py::test_transform_add_foreign_keys_from_scratch PASSED [ 95%] 552s tests/test_transform.py::test_transform_add_foreign_keys_from_partial[add_foreign_keys0] PASSED [ 95%] 552s tests/test_transform.py::test_transform_add_foreign_keys_from_partial[add_foreign_keys1] PASSED [ 95%] 552s tests/test_transform.py::test_transform_replace_foreign_keys[foreign_keys0] PASSED [ 95%] 552s tests/test_transform.py::test_transform_replace_foreign_keys[foreign_keys1] PASSED [ 95%] 552s tests/test_transform.py::test_transform_preserves_rowids[id_pk] PASSED [ 95%] 552s tests/test_transform.py::test_transform_preserves_rowids[rowid] PASSED [ 95%] 552s tests/test_transform.py::test_transform_preserves_rowids[compound_pk] PASSED [ 95%] 552s tests/test_update.py::test_update_rowid_table PASSED [ 95%] 552s tests/test_update.py::test_update_pk_table PASSED [ 95%] 552s tests/test_update.py::test_update_compound_pk_table PASSED [ 96%] 552s tests/test_update.py::test_update_invalid_pk[None-2] PASSED [ 96%] 552s tests/test_update.py::test_update_invalid_pk[None-None] PASSED [ 96%] 552s tests/test_update.py::test_update_invalid_pk[id1-None] PASSED [ 96%] 552s tests/test_update.py::test_update_invalid_pk[id1-4] PASSED [ 96%] 552s tests/test_update.py::test_update_invalid_pk[pk4-None] PASSED [ 96%] 552s tests/test_update.py::test_update_invalid_pk[pk5-4] PASSED [ 96%] 552s tests/test_update.py::test_update_invalid_pk[pk6-update_pk6] PASSED [ 96%] 552s tests/test_update.py::test_update_alter PASSED [ 96%] 552s tests/test_update.py::test_update_alter_with_invalid_column_characters PASSED [ 96%] 552s tests/test_update.py::test_update_with_no_values_sets_last_pk PASSED [ 97%] 552s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure0] PASSED [ 97%] 552s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure1] PASSED [ 97%] 552s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure2] PASSED [ 97%] 552s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure3] PASSED [ 97%] 552s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure4] PASSED [ 97%] 552s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure5] PASSED [ 97%] 552s tests/test_upsert.py::test_upsert PASSED [ 97%] 552s tests/test_upsert.py::test_upsert_all PASSED [ 97%] 552s tests/test_upsert.py::test_upsert_all_single_column PASSED [ 98%] 552s tests/test_upsert.py::test_upsert_all_not_null PASSED [ 98%] 552s tests/test_upsert.py::test_upsert_error_if_no_pk PASSED [ 98%] 552s tests/test_upsert.py::test_upsert_with_hash_id PASSED [ 98%] 552s tests/test_upsert.py::test_upsert_with_hash_id_columns[None] PASSED [ 98%] 552s tests/test_upsert.py::test_upsert_with_hash_id_columns[custom_id] PASSED [ 98%] 552s tests/test_upsert.py::test_upsert_compound_primary_key PASSED [ 98%] 552s tests/test_utils.py::test_decode_base64_values[input0-None-True] PASSED [ 98%] 552s tests/test_utils.py::test_decode_base64_values[input1-None-True] PASSED [ 98%] 552s tests/test_utils.py::test_decode_base64_values[input2-expected2-False] PASSED [ 98%] 552s tests/test_utils.py::test_chunks[1-expected0] PASSED [ 99%] 552s tests/test_utils.py::test_chunks[2-expected1] PASSED [ 99%] 552s tests/test_utils.py::test_chunks[3-expected2] PASSED [ 99%] 552s tests/test_utils.py::test_chunks[4-expected3] PASSED [ 99%] 552s tests/test_utils.py::test_hash_record PASSED [ 99%] 552s tests/test_utils.py::test_maximize_csv_field_size_limit PASSED [ 99%] 552s tests/test_utils.py::test_flatten[input0-expected0] PASSED [ 99%] 552s tests/test_utils.py::test_flatten[input1-expected1] PASSED [ 99%] 552s tests/test_utils.py::test_flatten[input2-expected2] PASSED [ 99%] 552s tests/test_wal.py::test_enable_disable_wal PASSED [100%] 552s 552s =============================== warnings summary =============================== 552s ../../../usr/lib/python3/dist-packages/dateutil/tz/tz.py:37 552s /usr/lib/python3/dist-packages/dateutil/tz/tz.py:37: DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.fromtimestamp(timestamp, datetime.UTC). 552s EPOCH = datetime.datetime.utcfromtimestamp(0) 552s 552s tests/test_cli.py::test_upsert_analyze 552s /usr/lib/python3/dist-packages/click/parser.py:171: ResourceWarning: unclosed file <_io.FileIO name='/tmp/pytest-of-ubuntu/pytest-1/test_upsert_pk_required0/dogs.json' mode='rb' closefd=True> 552s self.prefixes: t.Set[str] = set() 552s Enable tracemalloc to get traceback where the object was allocated. 552s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 552s 552s tests/test_cli_memory.py::test_memory_csv[False-test] 552s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-1/test_memory_csv_False_test_0/test.csv' encoding='utf-8-sig'> 552s for row in reader: 552s Enable tracemalloc to get traceback where the object was allocated. 552s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 552s 552s tests/test_cli_memory.py::test_memory_csv[False-t] 552s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-1/test_memory_csv_False_t_0/test.csv' encoding='utf-8-sig'> 552s for row in reader: 552s Enable tracemalloc to get traceback where the object was allocated. 552s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 552s 552s tests/test_cli_memory.py::test_memory_csv[False-t1] 552s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-1/test_memory_csv_False_t1_0/test.csv' encoding='utf-8-sig'> 552s for row in reader: 552s Enable tracemalloc to get traceback where the object was allocated. 552s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 552s 552s tests/test_cli_memory.py::test_memory_tsv[False] 552s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-1/test_memory_tsv_False_0/chickens.tsv' encoding='utf-8-sig'> 552s for row in reader: 552s Enable tracemalloc to get traceback where the object was allocated. 552s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 552s 552s tests/test_cli_memory.py::test_memory_dump[extra_args0] 552s /usr/lib/python3/dist-packages/click/core.py:127: ResourceWarning: unclosed file <_io.FileIO name='/tmp/pytest-of-ubuntu/pytest-1/test_memory_csv_encoding_False0/test.csv' mode='rb' closefd=True> 552s idx = float("inf") 552s Enable tracemalloc to get traceback where the object was allocated. 552s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 552s 552s tests/test_cli_memory.py::test_memory_two_files_with_same_stem 552s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-1/test_memory_two_files_with_sam0/one/data.csv' encoding='utf-8-sig'> 552s for row in reader: 552s Enable tracemalloc to get traceback where the object was allocated. 552s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 552s 552s tests/test_cli_memory.py::test_memory_two_files_with_same_stem 552s /usr/lib/python3/dist-packages/sqlite_utils/utils.py:217: ResourceWarning: unclosed file <_io.TextIOWrapper name='/tmp/pytest-of-ubuntu/pytest-1/test_memory_two_files_with_sam0/two/data.csv' encoding='utf-8-sig'> 552s for row in reader: 552s Enable tracemalloc to get traceback where the object was allocated. 552s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 552s 552s tests/test_insert_files.py::test_insert_files[False] 552s tests/test_insert_files.py::test_insert_files[True] 552s /usr/lib/python3/dist-packages/sqlite_utils/cli.py:3167: DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.fromtimestamp(timestamp, datetime.UTC). 552s "mtime_iso": lambda p: datetime.utcfromtimestamp(p.stat().st_mtime).isoformat(), 552s 552s tests/test_insert_files.py::test_insert_files[False] 552s tests/test_insert_files.py::test_insert_files[True] 552s /usr/lib/python3/dist-packages/sqlite_utils/cli.py:3168: DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.fromtimestamp(timestamp, datetime.UTC). 552s "ctime_iso": lambda p: datetime.utcfromtimestamp(p.stat().st_ctime).isoformat(), 552s 552s tests/test_recipes.py::test_dateparse_errors[None-parsedate] 552s /usr/lib/python3/dist-packages/_pytest/unraisableexception.py:80: PytestUnraisableExceptionWarning: Exception ignored in: .convert_value at 0x75294ba339c0> 552s 552s Traceback (most recent call last): 552s File "/usr/lib/python3/dist-packages/sqlite_utils/db.py", line 2818, in convert_value 552s return jsonify_if_needed(fn(v)) 552s ^^^^^ 552s File "/tmp/autopkgtest.6YryoZ/autopkgtest_tmp/tests/test_recipes.py", line 77, in 552s fresh_db["example"].convert("dt", lambda value: getattr(recipes, fn)(value)) 552s ^^^^^^^^^^^^^^^^^^^^^^^^^^^ 552s File "/usr/lib/python3/dist-packages/sqlite_utils/recipes.py", line 19, in parsedate 552s parser.parse(value, dayfirst=dayfirst, yearfirst=yearfirst) 552s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 1368, in parse 552s return DEFAULTPARSER.parse(timestr, **kwargs) 552s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 552s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 643, in parse 552s raise ParserError("Unknown string format: %s", timestr) 552s dateutil.parser._parser.ParserError: Unknown string format: invalid 552s 552s warnings.warn(pytest.PytestUnraisableExceptionWarning(msg)) 552s 552s tests/test_recipes.py::test_dateparse_errors[None-parsedatetime] 552s /usr/lib/python3/dist-packages/_pytest/unraisableexception.py:80: PytestUnraisableExceptionWarning: Exception ignored in: .convert_value at 0x75294ba919e0> 552s 552s Traceback (most recent call last): 552s File "/usr/lib/python3/dist-packages/sqlite_utils/db.py", line 2818, in convert_value 552s return jsonify_if_needed(fn(v)) 552s ^^^^^ 552s File "/tmp/autopkgtest.6YryoZ/autopkgtest_tmp/tests/test_recipes.py", line 77, in 552s fresh_db["example"].convert("dt", lambda value: getattr(recipes, fn)(value)) 552s ^^^^^^^^^^^^^^^^^^^^^^^^^^^ 552s File "/usr/lib/python3/dist-packages/sqlite_utils/recipes.py", line 42, in parsedatetime 552s return parser.parse(value, dayfirst=dayfirst, yearfirst=yearfirst).isoformat() 552s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 552s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 1368, in parse 552s return DEFAULTPARSER.parse(timestr, **kwargs) 552s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 552s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 643, in parse 552s raise ParserError("Unknown string format: %s", timestr) 552s dateutil.parser._parser.ParserError: Unknown string format: invalid 552s 552s warnings.warn(pytest.PytestUnraisableExceptionWarning(msg)) 552s 552s -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html 552s ================ 949 passed, 16 skipped, 15 warnings in 14.83s ================= 552s autopkgtest [00:48:28]: test run-tests: -----------------------] 553s run-tests PASS 553s autopkgtest [00:48:29]: test run-tests: - - - - - - - - - - results - - - - - - - - - - 553s autopkgtest [00:48:29]: @@@@@@@@@@@@@@@@@@@@ summary 553s run-tests PASS 562s Creating nova instance adt-noble-amd64-sqlite-utils-20240227-003916-juju-7f2275-prod-proposed-migration-environment-3 from image adt/ubuntu-noble-amd64-server-20240226.img (UUID fe3c0c7b-5419-4067-86f2-cd2ab88ea397)...