0s autopkgtest [19:13:14]: starting date and time: 2024-03-24 19:13:14+0000 0s autopkgtest [19:13:14]: git checkout: 4a1cd702 l/adt_testbed: don't blame the testbed for unsolvable build deps 0s autopkgtest [19:13:14]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.k81ic96l/out --timeout-copy=6000 -a i386 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed --apt-upgrade sqlite-utils --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=sphinx/7.2.6-6 python3-defaults/3.12.2-0ubuntu1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@lcy02-7.secgroup --name adt-noble-i386-sqlite-utils-20240324-191314-juju-7f2275-prod-proposed-migration-environment-2 --image adt/ubuntu-noble-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --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/ 608s autopkgtest [19:23:22]: testbed dpkg architecture: amd64 608s autopkgtest [19:23:22]: testbed apt version: 2.7.12 609s autopkgtest [19:23:23]: test architecture: i386 609s autopkgtest [19:23:23]: @@@@@@@@@@@@@@@@@@@@ test bed setup 609s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [117 kB] 609s Get:2 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [4007 kB] 609s Get:3 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [6540 B] 609s Get:4 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [57.3 kB] 609s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [495 kB] 609s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main i386 Packages [488 kB] 609s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 Packages [726 kB] 609s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 c-n-f Metadata [3508 B] 609s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 Packages [30.5 kB] 609s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/restricted i386 Packages [6700 B] 609s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 c-n-f Metadata [116 B] 609s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/universe i386 Packages [1299 kB] 609s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 Packages [4452 kB] 609s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 c-n-f Metadata [9396 B] 609s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/multiverse i386 Packages [27.4 kB] 609s Get:16 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 Packages [96.4 kB] 609s Get:17 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 c-n-f Metadata [196 B] 612s Fetched 11.8 MB in 1s (7936 kB/s) 612s Reading package lists... 614s Reading package lists... 614s Building dependency tree... 614s Reading state information... 614s Calculating upgrade... 614s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 614s Reading package lists... 615s Building dependency tree... 615s Reading state information... 615s 0 upgraded, 0 newly installed, 0 to remove and 248 not upgraded. 615s sh: Attempting to set up Debian/Ubuntu apt sources automatically 615s sh: Distribution appears to be Ubuntu 616s Reading package lists... 617s Building dependency tree... 617s Reading state information... 617s eatmydata is already the newest version (131-1). 617s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 617s Reading package lists... 617s Building dependency tree... 617s Reading state information... 617s dbus is already the newest version (1.14.10-4ubuntu1). 617s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 617s Reading package lists... 618s Building dependency tree... 618s Reading state information... 618s rng-tools-debian is already the newest version (2.4). 618s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 618s Reading package lists... 618s Building dependency tree... 618s Reading state information... 618s The following packages will be REMOVED: 618s cloud-init* python3-configobj* python3-debconf* 619s 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. 619s After this operation, 3256 kB disk space will be freed. 619s (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 ... 71864 files and directories currently installed.) 619s Removing cloud-init (24.1.2-0ubuntu1) ... 619s Removing python3-configobj (5.0.8-3) ... 619s Removing python3-debconf (1.5.86) ... 619s Processing triggers for man-db (2.12.0-3) ... 620s (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 ... 71475 files and directories currently installed.) 620s Purging configuration files for cloud-init (24.1.2-0ubuntu1) ... 621s dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed 621s Processing triggers for rsyslog (8.2312.0-3ubuntu3) ... 621s invoke-rc.d: policy-rc.d denied execution of try-restart. 621s Reading package lists... 621s Building dependency tree... 621s Reading state information... 621s linux-generic is already the newest version (6.8.0-11.11+1). 621s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 621s Hit:1 http://ftpmaster.internal/ubuntu noble InRelease 621s Hit:2 http://ftpmaster.internal/ubuntu noble-updates InRelease 621s Hit:3 http://ftpmaster.internal/ubuntu noble-security InRelease 624s Reading package lists... 624s Reading package lists... 624s Building dependency tree... 624s Reading state information... 624s Calculating upgrade... 624s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 624s Reading package lists... 624s Building dependency tree... 624s Reading state information... 625s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 625s autopkgtest [19:23:39]: rebooting testbed after setup commands that affected boot 667s autopkgtest [19:24:21]: testbed running kernel: Linux 6.8.0-11-generic #11-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 14 00:29:05 UTC 2024 668s autopkgtest [19:24:22]: @@@@@@@@@@@@@@@@@@@@ apt-source sqlite-utils 668s Get:1 http://ftpmaster.internal/ubuntu noble/universe sqlite-utils 3.35.2-1 (dsc) [2424 B] 668s Get:2 http://ftpmaster.internal/ubuntu noble/universe sqlite-utils 3.35.2-1 (tar) [459 kB] 668s Get:3 http://ftpmaster.internal/ubuntu noble/universe sqlite-utils 3.35.2-1 (diff) [4320 B] 669s gpgv: Signature made Wed Nov 8 13:11:48 2023 UTC 669s gpgv: using RSA key FB8ACFA78C726089C38AD0269605A1098C63B92A 669s gpgv: Can't check signature: No public key 669s dpkg-source: warning: cannot verify inline signature for ./sqlite-utils_3.35.2-1.dsc: no acceptable signature found 669s autopkgtest [19:24:23]: testing package sqlite-utils version 3.35.2-1 669s autopkgtest [19:24:23]: build not needed 669s autopkgtest [19:24:23]: test run-tests: preparing testbed 671s Note, using file '/tmp/autopkgtest.RK33d9/1-autopkgtest-satdep.dsc' to get the build dependencies 671s Reading package lists... 671s Building dependency tree... 671s Reading state information... 671s Starting pkgProblemResolver with broken count: 0 671s Starting 2 pkgProblemResolver with broken count: 0 671s Done 672s The following NEW packages will be installed: 672s build-essential cpp cpp-13 cpp-13-x86-64-linux-gnu cpp-x86-64-linux-gnu g++ 672s g++-13 g++-13-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-13 672s gcc-13-x86-64-linux-gnu gcc-x86-64-linux-gnu libasan8 libatomic1 672s libc-dev-bin libc6-dev libcc1-0 libcrypt-dev libgcc-13-dev libgomp1 672s libhwasan0 libisl23 libitm1 libjs-jquery libjs-sphinxdoc libjs-underscore 672s liblsan0 libmpc3 libquadmath0 libstdc++-13-dev libtsan2 libubsan1 672s linux-libc-dev python3-all python3-click python3-click-default-group 672s python3-colorama python3-dateutil python3-hypothesis python3-iniconfig 672s python3-packaging python3-pluggy python3-pytest python3-sortedcontainers 672s python3-sqlite-fts4 python3-tabulate rpcsvc-proto sqlite-utils 672s 0 upgraded, 49 newly installed, 0 to remove and 0 not upgraded. 672s Need to get 68.2 MB of archives. 672s After this operation, 252 MB of additional disk space will be used. 672s Get:1 http://ftpmaster.internal/ubuntu noble/main amd64 libc-dev-bin amd64 2.39-0ubuntu6 [20.4 kB] 672s Get:2 http://ftpmaster.internal/ubuntu noble/main amd64 linux-libc-dev amd64 6.8.0-11.11 [1595 kB] 672s Get:3 http://ftpmaster.internal/ubuntu noble/main amd64 libcrypt-dev amd64 1:4.4.36-4 [128 kB] 672s Get:4 http://ftpmaster.internal/ubuntu noble/main amd64 rpcsvc-proto amd64 1.4.2-0ubuntu6 [68.5 kB] 672s Get:5 http://ftpmaster.internal/ubuntu noble/main amd64 libc6-dev amd64 2.39-0ubuntu6 [2126 kB] 672s Get:6 http://ftpmaster.internal/ubuntu noble/main amd64 libisl23 amd64 0.26-3 [741 kB] 672s Get:7 http://ftpmaster.internal/ubuntu noble/main amd64 libmpc3 amd64 1.3.1-1 [54.1 kB] 672s Get:8 http://ftpmaster.internal/ubuntu noble/main amd64 cpp-13-x86-64-linux-gnu amd64 13.2.0-17ubuntu2 [11.2 MB] 672s Get:9 http://ftpmaster.internal/ubuntu noble/main amd64 cpp-13 amd64 13.2.0-17ubuntu2 [1030 B] 672s Get:10 http://ftpmaster.internal/ubuntu noble/main amd64 cpp-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [5326 B] 672s Get:11 http://ftpmaster.internal/ubuntu noble/main amd64 cpp amd64 4:13.2.0-7ubuntu1 [22.4 kB] 672s Get:12 http://ftpmaster.internal/ubuntu noble/main amd64 libcc1-0 amd64 14-20240303-1ubuntu1 [47.7 kB] 672s Get:13 http://ftpmaster.internal/ubuntu noble/main amd64 libgomp1 amd64 14-20240303-1ubuntu1 [147 kB] 672s Get:14 http://ftpmaster.internal/ubuntu noble/main amd64 libitm1 amd64 14-20240303-1ubuntu1 [29.1 kB] 672s Get:15 http://ftpmaster.internal/ubuntu noble/main amd64 libatomic1 amd64 14-20240303-1ubuntu1 [10.4 kB] 672s Get:16 http://ftpmaster.internal/ubuntu noble/main amd64 libasan8 amd64 14-20240303-1ubuntu1 [3026 kB] 672s Get:17 http://ftpmaster.internal/ubuntu noble/main amd64 liblsan0 amd64 14-20240303-1ubuntu1 [1310 kB] 672s Get:18 http://ftpmaster.internal/ubuntu noble/main amd64 libtsan2 amd64 14-20240303-1ubuntu1 [2732 kB] 672s Get:19 http://ftpmaster.internal/ubuntu noble/main amd64 libubsan1 amd64 14-20240303-1ubuntu1 [1172 kB] 672s Get:20 http://ftpmaster.internal/ubuntu noble/main amd64 libhwasan0 amd64 14-20240303-1ubuntu1 [1629 kB] 672s Get:21 http://ftpmaster.internal/ubuntu noble/main amd64 libquadmath0 amd64 14-20240303-1ubuntu1 [155 kB] 672s Get:22 http://ftpmaster.internal/ubuntu noble/main amd64 libgcc-13-dev amd64 13.2.0-17ubuntu2 [2687 kB] 672s Get:23 http://ftpmaster.internal/ubuntu noble/main amd64 gcc-13-x86-64-linux-gnu amd64 13.2.0-17ubuntu2 [21.9 MB] 672s Get:24 http://ftpmaster.internal/ubuntu noble/main amd64 gcc-13 amd64 13.2.0-17ubuntu2 [477 kB] 672s Get:25 http://ftpmaster.internal/ubuntu noble/main amd64 gcc-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [1212 B] 672s Get:26 http://ftpmaster.internal/ubuntu noble/main amd64 gcc amd64 4:13.2.0-7ubuntu1 [5018 B] 672s Get:27 http://ftpmaster.internal/ubuntu noble/main amd64 libstdc++-13-dev amd64 13.2.0-17ubuntu2 [2340 kB] 672s Get:28 http://ftpmaster.internal/ubuntu noble/main amd64 g++-13-x86-64-linux-gnu amd64 13.2.0-17ubuntu2 [12.5 MB] 672s Get:29 http://ftpmaster.internal/ubuntu noble/main amd64 g++-13 amd64 13.2.0-17ubuntu2 [14.5 kB] 672s Get:30 http://ftpmaster.internal/ubuntu noble/main amd64 g++-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [964 B] 672s Get:31 http://ftpmaster.internal/ubuntu noble/main amd64 g++ amd64 4:13.2.0-7ubuntu1 [1100 B] 672s Get:32 http://ftpmaster.internal/ubuntu noble/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 672s Get:33 http://ftpmaster.internal/ubuntu noble/main amd64 libjs-jquery all 3.6.1+dfsg+~3.5.14-1 [328 kB] 672s Get:34 http://ftpmaster.internal/ubuntu noble/main amd64 libjs-underscore all 1.13.4~dfsg+~1.11.4-3 [118 kB] 672s Get:35 http://ftpmaster.internal/ubuntu noble/main amd64 libjs-sphinxdoc all 7.2.6-4 [149 kB] 672s Get:36 http://ftpmaster.internal/ubuntu noble/main amd64 python3-all amd64 3.12.1-0ubuntu2 [906 B] 672s Get:37 http://ftpmaster.internal/ubuntu noble/main amd64 python3-colorama all 0.4.6-4 [32.1 kB] 672s Get:38 http://ftpmaster.internal/ubuntu noble/main amd64 python3-click all 8.1.6-1 [79.0 kB] 672s Get:39 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-click-default-group all 1.2.4-1 [5684 B] 672s Get:40 http://ftpmaster.internal/ubuntu noble/main amd64 python3-dateutil all 2.8.2-3 [79.2 kB] 672s Get:41 http://ftpmaster.internal/ubuntu noble/main amd64 python3-sortedcontainers all 2.4.0-2 [27.6 kB] 672s Get:42 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-hypothesis all 6.92.2-1 [371 kB] 672s Get:43 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-iniconfig all 1.1.1-2 [6024 B] 672s Get:44 http://ftpmaster.internal/ubuntu noble/main amd64 python3-packaging all 23.2-1 [40.6 kB] 672s Get:45 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-pluggy all 1.4.0-1 [20.4 kB] 672s Get:46 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-pytest all 7.4.4-1 [305 kB] 672s Get:47 http://ftpmaster.internal/ubuntu noble/universe amd64 python3-sqlite-fts4 all 1.0.3-2 [9228 B] 672s Get:48 http://ftpmaster.internal/ubuntu noble/main amd64 python3-tabulate all 0.8.10-1 [38.2 kB] 672s Get:49 http://ftpmaster.internal/ubuntu noble/universe amd64 sqlite-utils all 3.35.2-1 [525 kB] 673s Fetched 68.2 MB in 1s (128 MB/s) 673s Selecting previously unselected package libc-dev-bin. 673s (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 ... 71420 files and directories currently installed.) 673s Preparing to unpack .../00-libc-dev-bin_2.39-0ubuntu6_amd64.deb ... 673s Unpacking libc-dev-bin (2.39-0ubuntu6) ... 673s Selecting previously unselected package linux-libc-dev:amd64. 673s Preparing to unpack .../01-linux-libc-dev_6.8.0-11.11_amd64.deb ... 673s Unpacking linux-libc-dev:amd64 (6.8.0-11.11) ... 673s Selecting previously unselected package libcrypt-dev:amd64. 673s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.36-4_amd64.deb ... 673s Unpacking libcrypt-dev:amd64 (1:4.4.36-4) ... 673s Selecting previously unselected package rpcsvc-proto. 673s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_amd64.deb ... 673s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 673s Selecting previously unselected package libc6-dev:amd64. 673s Preparing to unpack .../04-libc6-dev_2.39-0ubuntu6_amd64.deb ... 673s Unpacking libc6-dev:amd64 (2.39-0ubuntu6) ... 673s Selecting previously unselected package libisl23:amd64. 673s Preparing to unpack .../05-libisl23_0.26-3_amd64.deb ... 673s Unpacking libisl23:amd64 (0.26-3) ... 673s Selecting previously unselected package libmpc3:amd64. 673s Preparing to unpack .../06-libmpc3_1.3.1-1_amd64.deb ... 673s Unpacking libmpc3:amd64 (1.3.1-1) ... 673s Selecting previously unselected package cpp-13-x86-64-linux-gnu. 673s Preparing to unpack .../07-cpp-13-x86-64-linux-gnu_13.2.0-17ubuntu2_amd64.deb ... 673s Unpacking cpp-13-x86-64-linux-gnu (13.2.0-17ubuntu2) ... 673s Selecting previously unselected package cpp-13. 673s Preparing to unpack .../08-cpp-13_13.2.0-17ubuntu2_amd64.deb ... 673s Unpacking cpp-13 (13.2.0-17ubuntu2) ... 674s Selecting previously unselected package cpp-x86-64-linux-gnu. 674s Preparing to unpack .../09-cpp-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 674s Unpacking cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 674s Selecting previously unselected package cpp. 674s Preparing to unpack .../10-cpp_4%3a13.2.0-7ubuntu1_amd64.deb ... 674s Unpacking cpp (4:13.2.0-7ubuntu1) ... 674s Selecting previously unselected package libcc1-0:amd64. 674s Preparing to unpack .../11-libcc1-0_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libcc1-0:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libgomp1:amd64. 674s Preparing to unpack .../12-libgomp1_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libgomp1:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libitm1:amd64. 674s Preparing to unpack .../13-libitm1_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libitm1:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libatomic1:amd64. 674s Preparing to unpack .../14-libatomic1_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libatomic1:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libasan8:amd64. 674s Preparing to unpack .../15-libasan8_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libasan8:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package liblsan0:amd64. 674s Preparing to unpack .../16-liblsan0_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking liblsan0:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libtsan2:amd64. 674s Preparing to unpack .../17-libtsan2_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libtsan2:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libubsan1:amd64. 674s Preparing to unpack .../18-libubsan1_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libubsan1:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libhwasan0:amd64. 674s Preparing to unpack .../19-libhwasan0_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libhwasan0:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libquadmath0:amd64. 674s Preparing to unpack .../20-libquadmath0_14-20240303-1ubuntu1_amd64.deb ... 674s Unpacking libquadmath0:amd64 (14-20240303-1ubuntu1) ... 674s Selecting previously unselected package libgcc-13-dev:amd64. 674s Preparing to unpack .../21-libgcc-13-dev_13.2.0-17ubuntu2_amd64.deb ... 674s Unpacking libgcc-13-dev:amd64 (13.2.0-17ubuntu2) ... 674s Selecting previously unselected package gcc-13-x86-64-linux-gnu. 674s Preparing to unpack .../22-gcc-13-x86-64-linux-gnu_13.2.0-17ubuntu2_amd64.deb ... 674s Unpacking gcc-13-x86-64-linux-gnu (13.2.0-17ubuntu2) ... 674s Selecting previously unselected package gcc-13. 674s Preparing to unpack .../23-gcc-13_13.2.0-17ubuntu2_amd64.deb ... 674s Unpacking gcc-13 (13.2.0-17ubuntu2) ... 674s Selecting previously unselected package gcc-x86-64-linux-gnu. 674s Preparing to unpack .../24-gcc-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 674s Unpacking gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 674s Selecting previously unselected package gcc. 674s Preparing to unpack .../25-gcc_4%3a13.2.0-7ubuntu1_amd64.deb ... 674s Unpacking gcc (4:13.2.0-7ubuntu1) ... 674s Selecting previously unselected package libstdc++-13-dev:amd64. 674s Preparing to unpack .../26-libstdc++-13-dev_13.2.0-17ubuntu2_amd64.deb ... 674s Unpacking libstdc++-13-dev:amd64 (13.2.0-17ubuntu2) ... 675s Selecting previously unselected package g++-13-x86-64-linux-gnu. 675s Preparing to unpack .../27-g++-13-x86-64-linux-gnu_13.2.0-17ubuntu2_amd64.deb ... 675s Unpacking g++-13-x86-64-linux-gnu (13.2.0-17ubuntu2) ... 675s Selecting previously unselected package g++-13. 675s Preparing to unpack .../28-g++-13_13.2.0-17ubuntu2_amd64.deb ... 675s Unpacking g++-13 (13.2.0-17ubuntu2) ... 675s Selecting previously unselected package g++-x86-64-linux-gnu. 675s Preparing to unpack .../29-g++-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 675s Unpacking g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 675s Selecting previously unselected package g++. 675s Preparing to unpack .../30-g++_4%3a13.2.0-7ubuntu1_amd64.deb ... 675s Unpacking g++ (4:13.2.0-7ubuntu1) ... 675s Selecting previously unselected package build-essential. 675s Preparing to unpack .../31-build-essential_12.10ubuntu1_amd64.deb ... 675s Unpacking build-essential (12.10ubuntu1) ... 675s Selecting previously unselected package libjs-jquery. 675s Preparing to unpack .../32-libjs-jquery_3.6.1+dfsg+~3.5.14-1_all.deb ... 675s Unpacking libjs-jquery (3.6.1+dfsg+~3.5.14-1) ... 675s Selecting previously unselected package libjs-underscore. 675s Preparing to unpack .../33-libjs-underscore_1.13.4~dfsg+~1.11.4-3_all.deb ... 675s Unpacking libjs-underscore (1.13.4~dfsg+~1.11.4-3) ... 675s Selecting previously unselected package libjs-sphinxdoc. 675s Preparing to unpack .../34-libjs-sphinxdoc_7.2.6-4_all.deb ... 675s Unpacking libjs-sphinxdoc (7.2.6-4) ... 675s Selecting previously unselected package python3-all. 675s Preparing to unpack .../35-python3-all_3.12.1-0ubuntu2_amd64.deb ... 675s Unpacking python3-all (3.12.1-0ubuntu2) ... 675s Selecting previously unselected package python3-colorama. 675s Preparing to unpack .../36-python3-colorama_0.4.6-4_all.deb ... 675s Unpacking python3-colorama (0.4.6-4) ... 675s Selecting previously unselected package python3-click. 675s Preparing to unpack .../37-python3-click_8.1.6-1_all.deb ... 675s Unpacking python3-click (8.1.6-1) ... 675s Selecting previously unselected package python3-click-default-group. 675s Preparing to unpack .../38-python3-click-default-group_1.2.4-1_all.deb ... 675s Unpacking python3-click-default-group (1.2.4-1) ... 675s Selecting previously unselected package python3-dateutil. 675s Preparing to unpack .../39-python3-dateutil_2.8.2-3_all.deb ... 675s Unpacking python3-dateutil (2.8.2-3) ... 675s Selecting previously unselected package python3-sortedcontainers. 675s Preparing to unpack .../40-python3-sortedcontainers_2.4.0-2_all.deb ... 675s Unpacking python3-sortedcontainers (2.4.0-2) ... 675s Selecting previously unselected package python3-hypothesis. 675s Preparing to unpack .../41-python3-hypothesis_6.92.2-1_all.deb ... 675s Unpacking python3-hypothesis (6.92.2-1) ... 675s Selecting previously unselected package python3-iniconfig. 675s Preparing to unpack .../42-python3-iniconfig_1.1.1-2_all.deb ... 675s Unpacking python3-iniconfig (1.1.1-2) ... 675s Selecting previously unselected package python3-packaging. 675s Preparing to unpack .../43-python3-packaging_23.2-1_all.deb ... 675s Unpacking python3-packaging (23.2-1) ... 675s Selecting previously unselected package python3-pluggy. 675s Preparing to unpack .../44-python3-pluggy_1.4.0-1_all.deb ... 675s Unpacking python3-pluggy (1.4.0-1) ... 675s Selecting previously unselected package python3-pytest. 675s Preparing to unpack .../45-python3-pytest_7.4.4-1_all.deb ... 675s Unpacking python3-pytest (7.4.4-1) ... 675s Selecting previously unselected package python3-sqlite-fts4. 675s Preparing to unpack .../46-python3-sqlite-fts4_1.0.3-2_all.deb ... 675s Unpacking python3-sqlite-fts4 (1.0.3-2) ... 675s Selecting previously unselected package python3-tabulate. 675s Preparing to unpack .../47-python3-tabulate_0.8.10-1_all.deb ... 675s Unpacking python3-tabulate (0.8.10-1) ... 675s Selecting previously unselected package sqlite-utils. 675s Preparing to unpack .../48-sqlite-utils_3.35.2-1_all.deb ... 675s Unpacking sqlite-utils (3.35.2-1) ... 676s Setting up python3-iniconfig (1.1.1-2) ... 676s Setting up python3-colorama (0.4.6-4) ... 676s Setting up linux-libc-dev:amd64 (6.8.0-11.11) ... 676s Setting up python3-tabulate (0.8.10-1) ... 676s Setting up python3-all (3.12.1-0ubuntu2) ... 676s Setting up python3-sortedcontainers (2.4.0-2) ... 676s Setting up python3-sqlite-fts4 (1.0.3-2) ... 676s Setting up libgomp1:amd64 (14-20240303-1ubuntu1) ... 676s Setting up python3-click (8.1.6-1) ... 676s Setting up python3-packaging (23.2-1) ... 676s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 676s Setting up python3-click-default-group (1.2.4-1) ... 676s Setting up libquadmath0:amd64 (14-20240303-1ubuntu1) ... 676s Setting up libmpc3:amd64 (1.3.1-1) ... 676s Setting up libatomic1:amd64 (14-20240303-1ubuntu1) ... 676s Setting up python3-pluggy (1.4.0-1) ... 677s Setting up libubsan1:amd64 (14-20240303-1ubuntu1) ... 677s Setting up libhwasan0:amd64 (14-20240303-1ubuntu1) ... 677s Setting up libcrypt-dev:amd64 (1:4.4.36-4) ... 677s Setting up libasan8:amd64 (14-20240303-1ubuntu1) ... 677s Setting up python3-dateutil (2.8.2-3) ... 677s Setting up libtsan2:amd64 (14-20240303-1ubuntu1) ... 677s Setting up libjs-jquery (3.6.1+dfsg+~3.5.14-1) ... 677s Setting up libisl23:amd64 (0.26-3) ... 677s Setting up libc-dev-bin (2.39-0ubuntu6) ... 677s Setting up libcc1-0:amd64 (14-20240303-1ubuntu1) ... 677s Setting up liblsan0:amd64 (14-20240303-1ubuntu1) ... 677s Setting up libitm1:amd64 (14-20240303-1ubuntu1) ... 677s Setting up libjs-underscore (1.13.4~dfsg+~1.11.4-3) ... 677s Setting up cpp-13-x86-64-linux-gnu (13.2.0-17ubuntu2) ... 677s Setting up python3-pytest (7.4.4-1) ... 677s Setting up python3-hypothesis (6.92.2-1) ... 677s Setting up libjs-sphinxdoc (7.2.6-4) ... 677s Setting up sqlite-utils (3.35.2-1) ... 677s Setting up libgcc-13-dev:amd64 (13.2.0-17ubuntu2) ... 677s Setting up libc6-dev:amd64 (2.39-0ubuntu6) ... 677s Setting up libstdc++-13-dev:amd64 (13.2.0-17ubuntu2) ... 677s Setting up cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 677s Setting up cpp-13 (13.2.0-17ubuntu2) ... 677s Setting up gcc-13-x86-64-linux-gnu (13.2.0-17ubuntu2) ... 677s Setting up gcc-13 (13.2.0-17ubuntu2) ... 677s Setting up cpp (4:13.2.0-7ubuntu1) ... 677s Setting up g++-13-x86-64-linux-gnu (13.2.0-17ubuntu2) ... 677s Setting up gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 677s Setting up gcc (4:13.2.0-7ubuntu1) ... 677s Setting up g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 677s Setting up g++-13 (13.2.0-17ubuntu2) ... 677s Setting up g++ (4:13.2.0-7ubuntu1) ... 677s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 677s Setting up build-essential (12.10ubuntu1) ... 677s Processing triggers for man-db (2.12.0-3) ... 678s Processing triggers for libc-bin (2.39-0ubuntu6) ... 681s Reading package lists... 681s Building dependency tree... 681s Reading state information... 682s Starting pkgProblemResolver with broken count: 0 682s Starting 2 pkgProblemResolver with broken count: 0 682s Done 682s The following NEW packages will be installed: 682s autopkgtest-satdep 682s 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. 682s Need to get 0 B/696 B of archives. 682s After this operation, 0 B of additional disk space will be used. 682s Get:1 /tmp/autopkgtest.RK33d9/2-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [696 B] 682s Selecting previously unselected package autopkgtest-satdep. 682s (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 ... 74855 files and directories currently installed.) 682s Preparing to unpack .../2-autopkgtest-satdep.deb ... 682s Unpacking autopkgtest-satdep (0) ... 682s Setting up autopkgtest-satdep (0) ... 684s (Reading database ... 74855 files and directories currently installed.) 684s Removing autopkgtest-satdep (0) ... 684s autopkgtest [19:24:38]: test run-tests: [----------------------- 685s ============================= test session starts ============================== 685s platform linux -- Python 3.12.2, pytest-7.4.4, pluggy-1.4.0 -- /usr/bin/python3.12 685s cachedir: .pytest_cache 685s hypothesis profile 'default' -> database=DirectoryBasedExampleDatabase(PosixPath('/tmp/autopkgtest.RK33d9/autopkgtest_tmp/.hypothesis/examples')) 685s rootdir: /tmp/autopkgtest.RK33d9/autopkgtest_tmp 685s plugins: hypothesis-6.92.2 685s collecting ... collected 965 items 685s 685s tests/test_analyze.py::test_analyze_whole_database PASSED [ 0%] 685s tests/test_analyze.py::test_analyze_one_table[db_method_with_name] PASSED [ 0%] 685s tests/test_analyze.py::test_analyze_one_table[table_method] PASSED [ 0%] 685s tests/test_analyze.py::test_analyze_index_by_name PASSED [ 0%] 685s tests/test_analyze_tables.py::test_analyze_column[id-extra_kwargs0-expected0] PASSED [ 0%] 685s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs1-expected1] PASSED [ 0%] 685s tests/test_analyze_tables.py::test_analyze_column[size-extra_kwargs2-expected2] PASSED [ 0%] 685s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs3-expected3] PASSED [ 0%] 685s tests/test_analyze_tables.py::test_analyze_column[owner-extra_kwargs4-expected4] PASSED [ 0%] 686s tests/test_analyze_tables.py::test_analyze_table PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_save PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[False-False] PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[True-False] PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[False-True] PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_save_no_most_no_least_options[True-True] PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_column_all_nulls PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args0-These columns were not found: bad_column\n] PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args1-These columns were not found: age\n] PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args2-None] PASSED [ 1%] 686s tests/test_analyze_tables.py::test_analyze_table_validate_columns[args3-These columns were not found: age, bad\n] PASSED [ 2%] 686s tests/test_attach.py::test_attach PASSED [ 2%] 686s tests/test_cli.py::test_help[options0] PASSED [ 2%] 686s tests/test_cli.py::test_help[options1] PASSED [ 2%] 686s tests/test_cli.py::test_help[options2] PASSED [ 2%] 686s tests/test_cli.py::test_help[options3] PASSED [ 2%] 686s tests/test_cli.py::test_tables PASSED [ 2%] 686s tests/test_cli.py::test_views PASSED [ 2%] 686s tests/test_cli.py::test_tables_fts4 PASSED [ 2%] 686s tests/test_cli.py::test_tables_fts5 PASSED [ 3%] 686s tests/test_cli.py::test_tables_counts_and_columns PASSED [ 3%] 686s 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%] 686s 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%] 686s tests/test_cli.py::test_tables_schema PASSED [ 3%] 686s 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%] 686s 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%] 686s 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%] 686s tests/test_cli.py::test_create_index PASSED [ 3%] 686s tests/test_cli.py::test_create_index_analyze PASSED [ 3%] 686s tests/test_cli.py::test_create_index_desc PASSED [ 4%] 686s tests/test_cli.py::test_add_column[text-TEXT-CREATE TABLE [dogs] (\n [name] TEXT\n, [text] TEXT)] PASSED [ 4%] 686s tests/test_cli.py::test_add_column[integer-INTEGER-CREATE TABLE [dogs] (\n [name] TEXT\n, [integer] INTEGER)] PASSED [ 4%] 686s tests/test_cli.py::test_add_column[float-FLOAT-CREATE TABLE [dogs] (\n [name] TEXT\n, [float] FLOAT)] PASSED [ 4%] 686s tests/test_cli.py::test_add_column[blob-blob-CREATE TABLE [dogs] (\n [name] TEXT\n, [blob] BLOB)] PASSED [ 4%] 686s tests/test_cli.py::test_add_column[default-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [default] TEXT)] PASSED [ 4%] 686s tests/test_cli.py::test_add_column_ignore[True] PASSED [ 4%] 686s tests/test_cli.py::test_add_column_ignore[False] PASSED [ 4%] 686s tests/test_cli.py::test_add_column_not_null_default PASSED [ 4%] 686s tests/test_cli.py::test_add_foreign_key[args0-Explicit other_table and other_column] PASSED [ 4%] 686s tests/test_cli.py::test_add_foreign_key[args1-Explicit other_table, guess other_column] PASSED [ 5%] 686s tests/test_cli.py::test_add_foreign_key[args2-Automatically guess other_table and other_column] PASSED [ 5%] 686s tests/test_cli.py::test_add_column_foreign_key PASSED [ 5%] 686s tests/test_cli.py::test_suggest_alter_if_column_missing PASSED [ 5%] 686s tests/test_cli.py::test_index_foreign_keys PASSED [ 5%] 686s tests/test_cli.py::test_enable_fts PASSED [ 5%] 686s tests/test_cli.py::test_enable_fts_replace PASSED [ 5%] 686s tests/test_cli.py::test_enable_fts_with_triggers PASSED [ 5%] 686s tests/test_cli.py::test_populate_fts PASSED [ 5%] 686s tests/test_cli.py::test_disable_fts PASSED [ 6%] 686s tests/test_cli.py::test_vacuum PASSED [ 6%] 686s tests/test_cli.py::test_dump PASSED [ 6%] 688s tests/test_cli.py::test_optimize[tables0] PASSED [ 6%] 688s tests/test_cli.py::test_optimize[tables1] PASSED [ 6%] 689s tests/test_cli.py::test_optimize[tables2] PASSED [ 6%] 691s tests/test_cli.py::test_rebuild_fts_fixes_docsize_error PASSED [ 6%] 691s tests/test_cli.py::test_query_csv[--csv-id,name,age\n1,Cleo,4\n2,Pancakes,2\n] PASSED [ 6%] 691s tests/test_cli.py::test_query_csv[--tsv-id\tname\tage\n1\tCleo\t4\n2\tPancakes\t2\n] PASSED [ 6%] 691s 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%] 691s 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%] 691s tests/test_cli.py::test_query_json[select id, name, age from dogs-args2-[[1, "Cleo", 4],\n [2, "Pancakes", 2]]] PASSED [ 7%] 691s tests/test_cli.py::test_query_json[select id, name, age from dogs-args3-[1, "Cleo", 4]\n[2, "Pancakes", 2]] PASSED [ 7%] 691s 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%] 691s 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%] 691s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args6-[[1, "Cleo", 4]]] PASSED [ 7%] 691s tests/test_cli.py::test_query_json[select id, name, age from dogs where id = 1-args7-[1, "Cleo", 4]] PASSED [ 7%] 691s 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%] 691s tests/test_cli.py::test_query_json_empty PASSED [ 7%] 691s tests/test_cli.py::test_query_invalid_function PASSED [ 7%] 691s tests/test_cli.py::test_query_complex_function PASSED [ 8%] 691s tests/test_cli.py::test_hidden_functions_are_hidden PASSED [ 8%] 691s tests/test_cli.py::test_query_json_binary PASSED [ 8%] 691s tests/test_cli.py::test_query_params[select 1 + 1 as out-params0-2] PASSED [ 8%] 691s tests/test_cli.py::test_query_params[select 1 + :p as out-params1-3] PASSED [ 8%] 691s tests/test_cli.py::test_query_params[select :hello as out-params2-This"has'many'quote"s] PASSED [ 8%] 691s tests/test_cli.py::test_query_json_with_json_cols PASSED [ 8%] 691s tests/test_cli.py::test_query_raw[\x00\x0fbinary-True] PASSED [ 8%] 691s tests/test_cli.py::test_query_raw[this is text-False] PASSED [ 8%] 691s tests/test_cli.py::test_query_raw[1-False] PASSED [ 9%] 691s tests/test_cli.py::test_query_raw[1.5-False] PASSED [ 9%] 691s tests/test_cli.py::test_query_raw_lines[\x00\x0fbinary-True] PASSED [ 9%] 691s tests/test_cli.py::test_query_raw_lines[this is text-False] PASSED [ 9%] 691s tests/test_cli.py::test_query_raw_lines[1-False] PASSED [ 9%] 691s tests/test_cli.py::test_query_raw_lines[1.5-False] PASSED [ 9%] 691s tests/test_cli.py::test_query_memory_does_not_create_file PASSED [ 9%] 691s tests/test_cli.py::test_rows[args0-[{"id": 1, "name": "Cleo", "age": 4},\n {"id": 2, "name": "Pancakes", "age": 2}]] PASSED [ 9%] 691s tests/test_cli.py::test_rows[args1-{"id": 1, "name": "Cleo", "age": 4}\n{"id": 2, "name": "Pancakes", "age": 2}] PASSED [ 9%] 691s tests/test_cli.py::test_rows[args2-[[1, "Cleo", 4],\n [2, "Pancakes", 2]]] PASSED [ 9%] 691s tests/test_cli.py::test_rows[args3-[1, "Cleo", 4]\n[2, "Pancakes", 2]] PASSED [ 10%] 691s tests/test_cli.py::test_rows[args4-{"age": 4, "name": "Cleo"}\n{"age": 2, "name": "Pancakes"}] PASSED [ 10%] 691s tests/test_cli.py::test_rows[args5-[{"name": "Cleo"}]] PASSED [ 10%] 691s tests/test_cli.py::test_rows[args6-[{"name": "Pancakes"}]] PASSED [ 10%] 691s tests/test_cli.py::test_rows[args7-[{"name": "Cleo"}]] PASSED [ 10%] 691s tests/test_cli.py::test_rows[args8-[{"name": "Cleo"}]] PASSED [ 10%] 691s tests/test_cli.py::test_rows[args9-[{"name": "Cleo"}]] PASSED [ 10%] 691s tests/test_cli.py::test_rows[args10-[{"id": 2}]] PASSED [ 10%] 691s tests/test_cli.py::test_rows[args11-[{"id": 1}]] PASSED [ 10%] 691s tests/test_cli.py::test_upsert PASSED [ 10%] 691s tests/test_cli.py::test_upsert_pk_required PASSED [ 11%] 691s tests/test_cli.py::test_upsert_analyze PASSED [ 11%] 691s tests/test_cli.py::test_upsert_flatten PASSED [ 11%] 691s tests/test_cli.py::test_upsert_alter PASSED [ 11%] 691s tests/test_cli.py::test_create_table[args0-CREATE TABLE [t] (\n [name] TEXT,\n [age] INTEGER\n)] PASSED [ 11%] 691s 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%] 691s tests/test_cli.py::test_create_table[args2-CREATE TABLE [t] (\n [name] TEXT NOT NULL\n)] PASSED [ 11%] 691s tests/test_cli.py::test_create_table[args3-CREATE TABLE [t] (\n [age] INTEGER DEFAULT '3'\n)] PASSED [ 11%] 691s tests/test_cli.py::test_create_table_foreign_key PASSED [ 11%] 691s tests/test_cli.py::test_create_table_error_if_table_exists PASSED [ 12%] 691s tests/test_cli.py::test_create_table_ignore PASSED [ 12%] 691s tests/test_cli.py::test_create_table_replace PASSED [ 12%] 691s tests/test_cli.py::test_create_view PASSED [ 12%] 691s tests/test_cli.py::test_create_view_error_if_view_exists PASSED [ 12%] 691s tests/test_cli.py::test_create_view_ignore PASSED [ 12%] 691s tests/test_cli.py::test_create_view_replace PASSED [ 12%] 691s tests/test_cli.py::test_drop_table PASSED [ 12%] 691s tests/test_cli.py::test_drop_table_error PASSED [ 12%] 691s tests/test_cli.py::test_drop_view PASSED [ 12%] 691s tests/test_cli.py::test_drop_view_error PASSED [ 13%] 691s tests/test_cli.py::test_enable_wal PASSED [ 13%] 691s tests/test_cli.py::test_disable_wal PASSED [ 13%] 691s tests/test_cli.py::test_query_update[args0-[{"rows_affected": 1}]] PASSED [ 13%] 691s tests/test_cli.py::test_query_update[args1-rows_affected\n---------------\n 1] PASSED [ 13%] 691s tests/test_cli.py::test_add_foreign_keys PASSED [ 13%] 691s 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%] 691s 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%] 691s tests/test_cli.py::test_transform[args2-CREATE TABLE "dogs" (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)] PASSED [ 13%] 691s 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%] 691s 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%] 691s 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%] 691s 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%] 691s 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%] 691s 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%] 691s 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%] 691s 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%] 692s 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%] 692s 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%] 692s 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%] 692s 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%] 692s 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%] 692s 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%] 692s 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%] 692s tests/test_cli.py::test_insert_encoding PASSED [ 15%] 692s tests/test_cli.py::test_search[None-[{"rowid": 2, "id": 2, "title": "Title the second"}]\n-FTS4] PASSED [ 15%] 692s tests/test_cli.py::test_search[None-[{"rowid": 2, "id": 2, "title": "Title the second"}]\n-FTS5] PASSED [ 15%] 692s tests/test_cli.py::test_search[--csv-rowid,id,title\n2,2,Title the second\n-FTS4] PASSED [ 15%] 692s tests/test_cli.py::test_search[--csv-rowid,id,title\n2,2,Title the second\n-FTS5] PASSED [ 15%] 692s tests/test_cli.py::test_search_quote PASSED [ 16%] 692s tests/test_cli.py::test_indexes PASSED [ 16%] 692s 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%] 692s 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%] 692s tests/test_cli.py::test_triggers[extra_args2-[]\n] PASSED [ 16%] 692s 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%] 692s tests/test_cli.py::test_schema[options1-CREATE TABLE [dogs] (\n [id] INTEGER,\n [name] TEXT\n)\n] PASSED [ 16%] 692s 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%] 692s tests/test_cli.py::test_long_csv_column_value PASSED [ 16%] 692s tests/test_cli.py::test_import_no_headers[args0-False] PASSED [ 16%] 692s tests/test_cli.py::test_import_no_headers[args1-False] PASSED [ 17%] 692s tests/test_cli.py::test_import_no_headers[args2-True] PASSED [ 17%] 692s tests/test_cli.py::test_attach PASSED [ 17%] 692s tests/test_cli.py::test_csv_insert_bom PASSED [ 17%] 692s tests/test_cli.py::test_insert_detect_types[None] PASSED [ 17%] 692s tests/test_cli.py::test_insert_detect_types[-d] PASSED [ 17%] 692s tests/test_cli.py::test_insert_detect_types[--detect-types] PASSED [ 17%] 692s tests/test_cli.py::test_upsert_detect_types[-d] PASSED [ 17%] 692s tests/test_cli.py::test_upsert_detect_types[--detect-types] PASSED [ 17%] 692s tests/test_cli.py::test_integer_overflow_error PASSED [ 18%] 692s tests/test_cli.py::test_python_dash_m PASSED [ 18%] 692s tests/test_cli.py::test_create_database[False] PASSED [ 18%] 692s tests/test_cli.py::test_create_database[True] PASSED [ 18%] 692s tests/test_cli.py::test_analyze[options0-expected0] PASSED [ 18%] 692s tests/test_cli.py::test_analyze[options1-expected1] PASSED [ 18%] 692s tests/test_cli.py::test_analyze[options2-expected2] PASSED [ 18%] 692s tests/test_cli.py::test_rename_table PASSED [ 18%] 692s tests/test_cli.py::test_duplicate_table PASSED [ 18%] 692s tests/test_cli.py::test_load_extension[None-should_pass0-should_fail0] SKIPPED [ 18%] 692s tests/test_cli.py::test_load_extension[sqlite3_ext_b_init-b-should_fail1] SKIPPED [ 19%] 692s tests/test_cli.py::test_load_extension[sqlite3_ext_c_init-c-should_fail2] SKIPPED [ 19%] 692s tests/test_cli_bulk.py::test_cli_bulk PASSED [ 19%] 694s tests/test_cli_bulk.py::test_cli_bulk_batch_size PASSED [ 19%] 694s tests/test_cli_bulk.py::test_cli_bulk_error PASSED [ 19%] 694s tests/test_cli_convert.py::test_convert_code[return value.replace('October', 'Spooktober')] PASSED [ 19%] 694s tests/test_cli_convert.py::test_convert_code[value.replace('October', 'Spooktober')] PASSED [ 19%] 694s tests/test_cli_convert.py::test_convert_code[v = value.replace('October', 'Spooktober')\nreturn v] PASSED [ 19%] 694s tests/test_cli_convert.py::test_convert_code[def convert(value): return value.replace('October', 'Spooktober')] PASSED [ 19%] 694s tests/test_cli_convert.py::test_convert_code[import re\n\ndef convert(value): return value.replace('October', 'Spooktober')] PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_code_errors[def foo(value)] PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_code_errors[$] PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_import PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_import_nested PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_dryrun PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_multi_dryrun PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_output_column[True] PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_output_column[False] PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_output_column_output_type[text-expected0] PASSED [ 20%] 694s tests/test_cli_convert.py::test_convert_output_column_output_type[float-expected1] PASSED [ 21%] 694s tests/test_cli_convert.py::test_convert_output_column_output_type[integer-expected2] PASSED [ 21%] 694s tests/test_cli_convert.py::test_convert_output_column_output_type[None-expected3] PASSED [ 21%] 694s tests/test_cli_convert.py::test_convert_output_error[options0-Cannot use --output with more than one column] PASSED [ 21%] 694s tests/test_cli_convert.py::test_convert_output_error[options1-Error: Invalid value for '--output-type'] PASSED [ 21%] 694s tests/test_cli_convert.py::test_convert_output_error[options2-Missing argument 'COLUMNS...'] PASSED [ 21%] 694s tests/test_cli_convert.py::test_convert_multi[True] PASSED [ 21%] 694s tests/test_cli_convert.py::test_convert_multi[False] PASSED [ 21%] 694s tests/test_cli_convert.py::test_convert_multi_complex_column_types PASSED [ 21%] 694s tests/test_cli_convert.py::test_recipe_jsonsplit[None] PASSED [ 21%] 694s tests/test_cli_convert.py::test_recipe_jsonsplit[;] PASSED [ 22%] 694s tests/test_cli_convert.py::test_recipe_jsonsplit[-] PASSED [ 22%] 694s tests/test_cli_convert.py::test_recipe_jsonsplit_type[None-expected_array0] PASSED [ 22%] 695s tests/test_cli_convert.py::test_recipe_jsonsplit_type[float-expected_array1] PASSED [ 22%] 695s tests/test_cli_convert.py::test_recipe_jsonsplit_type[int-expected_array2] PASSED [ 22%] 695s tests/test_cli_convert.py::test_recipe_jsonsplit_output[True] PASSED [ 22%] 695s tests/test_cli_convert.py::test_recipe_jsonsplit_output[False] PASSED [ 22%] 695s tests/test_cli_convert.py::test_cannot_use_drop_without_multi_or_output PASSED [ 22%] 695s tests/test_cli_convert.py::test_cannot_use_multi_with_more_than_one_column PASSED [ 22%] 695s tests/test_cli_convert.py::test_multi_with_bad_function PASSED [ 23%] 695s tests/test_cli_convert.py::test_convert_where PASSED [ 23%] 695s tests/test_cli_convert.py::test_convert_where_multi PASSED [ 23%] 695s tests/test_cli_convert.py::test_convert_code_standard_input PASSED [ 23%] 695s tests/test_cli_convert.py::test_convert_hyphen_workaround PASSED [ 23%] 695s tests/test_cli_convert.py::test_convert_initialization_pattern PASSED [ 23%] 695s tests/test_cli_convert.py::test_convert_no_skip_false[True-1] PASSED [ 23%] 695s tests/test_cli_convert.py::test_convert_no_skip_false[False-0] PASSED [ 23%] 695s tests/test_cli_insert.py::test_insert_simple PASSED [ 23%] 695s tests/test_cli_insert.py::test_insert_from_stdin PASSED [ 23%] 695s tests/test_cli_insert.py::test_insert_invalid_json_error PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_json_flatten PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_json_flatten_nl PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_with_primary_key PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_multiple_with_primary_key PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_multiple_with_compound_primary_key PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_not_null_default PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_binary_base64 PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_newline_delimited PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_ignore PASSED [ 24%] 695s tests/test_cli_insert.py::test_insert_csv_tsv[foo\tbar\tbaz\n1\t2\tcat,dog-options0] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,"cat,dog"-options1] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_csv_tsv[foo;bar;baz\n1;2;"cat,dog"-options2] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_csv_tsv[foo;bar;baz\n1;2;"cat,dog"-options3] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,|cat,dog|-options4] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_csv_tsv[foo,bar,baz\n1,2,|cat,dog|-options5] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_csv_empty_null[True] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_csv_empty_null[False] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_stop_after[[{"name": "One"}, {"name": "Two"}, {"name": "Three"}, {"name": "Four"}]-args0] PASSED [ 25%] 695s tests/test_cli_insert.py::test_insert_stop_after[name\nOne\nTwo\nThree\nFour\n-args1] PASSED [ 26%] 695s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options0] PASSED [ 26%] 695s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options1] PASSED [ 26%] 695s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options2] PASSED [ 26%] 695s tests/test_cli_insert.py::test_only_allow_one_of_nl_tsv_csv[options3] PASSED [ 26%] 695s tests/test_cli_insert.py::test_insert_replace PASSED [ 26%] 695s tests/test_cli_insert.py::test_insert_truncate PASSED [ 26%] 695s tests/test_cli_insert.py::test_insert_alter PASSED [ 26%] 695s tests/test_cli_insert.py::test_insert_analyze PASSED [ 26%] 695s tests/test_cli_insert.py::test_insert_lines PASSED [ 26%] 695s tests/test_cli_insert.py::test_insert_text PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options0-[{"id": "1", "name": "Bob"}, {"id": "2", "name": "Cat"}]] PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options1-id,name\n1,Bob\n2,Cat] PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_json_csv_jsonnl[options2-{"id": "1", "name": "Bob"}\n{"id": "2", "name": "Cat"}] PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_text PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_text_returning_iterator PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_lines PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_row_modifying_in_place PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_error_messages[options0-Error: --convert must return dict or iterator\n] PASSED [ 27%] 695s tests/test_cli_insert.py::test_insert_convert_error_messages[options1-Error: Rows must all be dictionaries, got: 1\n] PASSED [ 27%] 696s tests/test_cli_insert.py::test_insert_streaming_batch_size_1 PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_basic PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_csv[True-test] PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_csv[True-t] PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_csv[True-t1] PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_csv[False-test] PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_csv[False-t] PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_csv[False-t1] PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_tsv[True] PASSED [ 28%] 696s tests/test_cli_memory.py::test_memory_tsv[False] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_json[True] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_json[False] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_json_nl[True] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_json_nl[False] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_csv_encoding[True] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_csv_encoding[False] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_dump[extra_args0] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_dump[extra_args1] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_schema[extra_args0] PASSED [ 29%] 696s tests/test_cli_memory.py::test_memory_schema[extra_args1] PASSED [ 30%] 696s tests/test_cli_memory.py::test_memory_save[extra_args0] PASSED [ 30%] 696s tests/test_cli_memory.py::test_memory_save[extra_args1] PASSED [ 30%] 696s tests/test_cli_memory.py::test_memory_no_detect_types[-n] PASSED [ 30%] 696s tests/test_cli_memory.py::test_memory_no_detect_types[--no-detect-types] PASSED [ 30%] 696s tests/test_cli_memory.py::test_memory_flatten PASSED [ 30%] 696s tests/test_cli_memory.py::test_memory_analyze PASSED [ 30%] 696s tests/test_cli_memory.py::test_memory_two_files_with_same_stem PASSED [ 30%] 696s tests/test_cli_memory.py::test_memory_functions PASSED [ 30%] 696s tests/test_column_affinity.py::test_column_affinity[INT-int] PASSED [ 30%] 696s tests/test_column_affinity.py::test_column_affinity[INTEGER-int] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[TINYINT-int] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[SMALLINT-int] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[MEDIUMINT-int] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[BIGINT-int] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[UNSIGNED BIG INT-int] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[INT2-int] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[INT8-int] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[CHARACTER(20)-str] PASSED [ 31%] 696s tests/test_column_affinity.py::test_column_affinity[VARCHAR(255)-str] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[VARYING CHARACTER(255)-str] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[NCHAR(55)-str] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[NATIVE CHARACTER(70)-str] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[NVARCHAR(100)-str] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[TEXT-str] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[CLOB-str] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[BLOB-bytes] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[REAL-float] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[DOUBLE-float] PASSED [ 32%] 696s tests/test_column_affinity.py::test_column_affinity[DOUBLE PRECISION-float] PASSED [ 33%] 696s tests/test_column_affinity.py::test_column_affinity[FLOAT-float] PASSED [ 33%] 696s tests/test_column_affinity.py::test_column_affinity[NUMERIC-float] PASSED [ 33%] 696s tests/test_column_affinity.py::test_column_affinity[DECIMAL(10,5)-float] PASSED [ 33%] 696s tests/test_column_affinity.py::test_column_affinity[BOOLEAN-float] PASSED [ 33%] 696s tests/test_column_affinity.py::test_column_affinity[DATE-float] PASSED [ 33%] 696s tests/test_column_affinity.py::test_column_affinity[DATETIME-float] PASSED [ 33%] 696s tests/test_column_affinity.py::test_columns_dict[INT-int] PASSED [ 33%] 696s tests/test_column_affinity.py::test_columns_dict[INTEGER-int] PASSED [ 33%] 696s tests/test_column_affinity.py::test_columns_dict[TINYINT-int] PASSED [ 33%] 696s tests/test_column_affinity.py::test_columns_dict[SMALLINT-int] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[MEDIUMINT-int] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[BIGINT-int] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[UNSIGNED BIG INT-int] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[INT2-int] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[INT8-int] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[CHARACTER(20)-str] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[VARCHAR(255)-str] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[VARYING CHARACTER(255)-str] PASSED [ 34%] 696s tests/test_column_affinity.py::test_columns_dict[NCHAR(55)-str] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[NATIVE CHARACTER(70)-str] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[NVARCHAR(100)-str] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[TEXT-str] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[CLOB-str] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[BLOB-bytes] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[REAL-float] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[DOUBLE-float] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[DOUBLE PRECISION-float] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[FLOAT-float] PASSED [ 35%] 696s tests/test_column_affinity.py::test_columns_dict[NUMERIC-float] PASSED [ 36%] 696s tests/test_column_affinity.py::test_columns_dict[DECIMAL(10,5)-float] PASSED [ 36%] 696s tests/test_column_affinity.py::test_columns_dict[BOOLEAN-float] PASSED [ 36%] 696s tests/test_column_affinity.py::test_columns_dict[DATE-float] PASSED [ 36%] 696s tests/test_column_affinity.py::test_columns_dict[DATETIME-float] PASSED [ 36%] 696s tests/test_constructor.py::test_recursive_triggers PASSED [ 36%] 696s tests/test_constructor.py::test_recursive_triggers_off PASSED [ 36%] 696s tests/test_constructor.py::test_memory_name PASSED [ 36%] 696s tests/test_constructor.py::test_sqlite_version PASSED [ 36%] 696s tests/test_constructor.py::test_database_close[True] PASSED [ 36%] 696s tests/test_constructor.py::test_database_close[False] PASSED [ 37%] 696s tests/test_conversions.py::test_insert_conversion PASSED [ 37%] 696s tests/test_conversions.py::test_insert_all_conversion PASSED [ 37%] 696s tests/test_conversions.py::test_upsert_conversion PASSED [ 37%] 696s tests/test_conversions.py::test_upsert_all_conversion PASSED [ 37%] 696s tests/test_conversions.py::test_update_conversion PASSED [ 37%] 696s tests/test_conversions.py::test_table_constructor_conversion PASSED [ 37%] 696s tests/test_convert.py::test_convert[title--expected0] PASSED [ 37%] 696s tests/test_convert.py::test_convert[columns1--expected1] PASSED [ 37%] 696s tests/test_convert.py::test_convert[title--expected2] PASSED [ 38%] 696s tests/test_convert.py::test_convert_where[id > 1-None] PASSED [ 38%] 696s tests/test_convert.py::test_convert_where[id > :id-where_args1] PASSED [ 38%] 696s tests/test_convert.py::test_convert_where[id > ?-where_args2] PASSED [ 38%] 696s tests/test_convert.py::test_convert_skip_false PASSED [ 38%] 696s tests/test_convert.py::test_convert_output[False-expected0] PASSED [ 38%] 696s tests/test_convert.py::test_convert_output[True-expected1] PASSED [ 38%] 696s tests/test_convert.py::test_convert_output_multiple_column_error PASSED [ 38%] 696s tests/test_convert.py::test_convert_output_type[int-expected0] PASSED [ 38%] 696s tests/test_convert.py::test_convert_output_type[float-expected1] PASSED [ 38%] 696s tests/test_convert.py::test_convert_multi PASSED [ 39%] 696s tests/test_convert.py::test_convert_multi_where PASSED [ 39%] 696s tests/test_convert.py::test_convert_multi_exception PASSED [ 39%] 696s tests/test_convert.py::test_convert_repeated PASSED [ 39%] 696s tests/test_create.py::test_create_table PASSED [ 39%] 696s tests/test_create.py::test_create_table_compound_primary_key PASSED [ 39%] 696s tests/test_create.py::test_create_table_with_single_primary_key[id] PASSED [ 39%] 696s tests/test_create.py::test_create_table_with_single_primary_key[pk1] PASSED [ 39%] 696s tests/test_create.py::test_create_table_with_invalid_column_characters PASSED [ 39%] 696s tests/test_create.py::test_create_table_with_defaults PASSED [ 40%] 696s tests/test_create.py::test_create_table_with_bad_not_null PASSED [ 40%] 696s tests/test_create.py::test_create_table_with_not_null PASSED [ 40%] 696s tests/test_create.py::test_create_table_from_example[example0-expected_columns0] PASSED [ 40%] 696s tests/test_create.py::test_create_table_from_example[example1-expected_columns1] PASSED [ 40%] 696s tests/test_create.py::test_create_table_from_example[example2-expected_columns2] PASSED [ 40%] 696s tests/test_create.py::test_create_table_from_example[example3-expected_columns3] PASSED [ 40%] 696s tests/test_create.py::test_create_table_from_example[example4-expected_columns4] PASSED [ 40%] 696s tests/test_create.py::test_create_table_from_example[example5-expected_columns5] PASSED [ 40%] 696s tests/test_create.py::test_create_table_from_example[example6-expected_columns6] PASSED [ 40%] 696s tests/test_create.py::test_create_table_from_example[example7-expected_columns7] PASSED [ 41%] 696s tests/test_create.py::test_create_table_from_example_with_compound_primary_keys PASSED [ 41%] 696s tests/test_create.py::test_create_table_with_custom_columns[insert] PASSED [ 41%] 696s tests/test_create.py::test_create_table_with_custom_columns[upsert] PASSED [ 41%] 696s tests/test_create.py::test_create_table_with_custom_columns[insert_all] PASSED [ 41%] 696s tests/test_create.py::test_create_table_with_custom_columns[upsert_all] PASSED [ 41%] 696s tests/test_create.py::test_create_table_column_order[True] PASSED [ 41%] 696s tests/test_create.py::test_create_table_column_order[False] PASSED [ 41%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification0-False] PASSED [ 41%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification1-False] PASSED [ 41%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification2-False] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification3-False] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification4-NoObviousTable] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification5-AssertionError] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification6-AlterError] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[True-foreign_key_specification7-AssertionError] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification0-False] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification1-False] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification2-False] PASSED [ 42%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification3-False] PASSED [ 43%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification4-NoObviousTable] PASSED [ 43%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification5-AssertionError] PASSED [ 43%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification6-AlterError] PASSED [ 43%] 696s tests/test_create.py::test_create_table_works_for_m2m_with_only_foreign_keys[False-foreign_key_specification7-AssertionError] PASSED [ 43%] 696s tests/test_create.py::test_self_referential_foreign_key PASSED [ 43%] 696s tests/test_create.py::test_create_error_if_invalid_foreign_keys PASSED [ 43%] 696s tests/test_create.py::test_create_error_if_invalid_self_referential_foreign_keys PASSED [ 43%] 696s tests/test_create.py::test_add_column[nickname-str-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [nickname] TEXT)] PASSED [ 43%] 696s tests/test_create.py::test_add_column[dob-date-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [dob] TEXT)] PASSED [ 43%] 696s tests/test_create.py::test_add_column[age-int-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [age] INTEGER)] PASSED [ 44%] 696s tests/test_create.py::test_add_column[weight-float-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [weight] FLOAT)] PASSED [ 44%] 696s tests/test_create.py::test_add_column[text-TEXT-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [text] TEXT)] PASSED [ 44%] 696s tests/test_create.py::test_add_column[integer-INTEGER-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [integer] INTEGER)] PASSED [ 44%] 696s tests/test_create.py::test_add_column[float-FLOAT-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [float] FLOAT)] PASSED [ 44%] 696s tests/test_create.py::test_add_column[blob-blob-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [blob] BLOB)] PASSED [ 44%] 696s tests/test_create.py::test_add_column[default_str-None-None-CREATE TABLE [dogs] (\n [name] TEXT\n, [default_str] TEXT)] PASSED [ 44%] 696s tests/test_create.py::test_add_column[nickname-str--CREATE TABLE [dogs] (\n [name] TEXT\n, [nickname] TEXT NOT NULL DEFAULT '')] PASSED [ 44%] 696s 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%] 696s tests/test_create.py::test_add_foreign_key PASSED [ 44%] 696s tests/test_create.py::test_add_foreign_key_if_column_contains_space PASSED [ 45%] 696s tests/test_create.py::test_add_foreign_key_error_if_column_does_not_exist PASSED [ 45%] 696s tests/test_create.py::test_add_foreign_key_error_if_other_table_does_not_exist PASSED [ 45%] 696s tests/test_create.py::test_add_foreign_key_error_if_already_exists PASSED [ 45%] 696s tests/test_create.py::test_add_foreign_key_no_error_if_exists_and_ignore_true PASSED [ 45%] 696s tests/test_create.py::test_add_foreign_keys PASSED [ 45%] 696s tests/test_create.py::test_add_column_foreign_key PASSED [ 45%] 696s tests/test_create.py::test_add_foreign_key_guess_table PASSED [ 45%] 696s tests/test_create.py::test_index_foreign_keys PASSED [ 45%] 696s tests/test_create.py::test_index_foreign_keys_if_index_name_is_already_used PASSED [ 46%] 696s tests/test_create.py::test_insert_row_alter_table[True-extra_data0-expected_new_columns0] PASSED [ 46%] 696s tests/test_create.py::test_insert_row_alter_table[True-extra_data1-expected_new_columns1] PASSED [ 46%] 696s tests/test_create.py::test_insert_row_alter_table[True-extra_data2-expected_new_columns2] PASSED [ 46%] 696s tests/test_create.py::test_insert_row_alter_table[False-extra_data0-expected_new_columns0] PASSED [ 46%] 696s tests/test_create.py::test_insert_row_alter_table[False-extra_data1-expected_new_columns1] PASSED [ 46%] 696s tests/test_create.py::test_insert_row_alter_table[False-extra_data2-expected_new_columns2] PASSED [ 46%] 696s tests/test_create.py::test_add_missing_columns_case_insensitive PASSED [ 46%] 696s tests/test_create.py::test_insert_replace_rows_alter_table[True] PASSED [ 46%] 696s tests/test_create.py::test_insert_replace_rows_alter_table[False] PASSED [ 46%] 696s tests/test_create.py::test_insert_all_with_extra_columns_in_later_chunks PASSED [ 47%] 696s tests/test_create.py::test_bulk_insert_more_than_999_values PASSED [ 47%] 696s tests/test_create.py::test_error_if_more_than_999_columns[900-False] PASSED [ 47%] 696s tests/test_create.py::test_error_if_more_than_999_columns[999-False] PASSED [ 47%] 696s tests/test_create.py::test_error_if_more_than_999_columns[1000-True] PASSED [ 47%] 697s tests/test_create.py::test_columns_not_in_first_record_should_not_cause_batch_to_be_too_large PASSED [ 47%] 697s tests/test_create.py::test_create_index[columns0-None-expected_index0] PASSED [ 47%] 697s tests/test_create.py::test_create_index[columns1-None-expected_index1] PASSED [ 47%] 697s tests/test_create.py::test_create_index[columns2-age_index-expected_index2] PASSED [ 47%] 697s tests/test_create.py::test_create_index_unique PASSED [ 47%] 697s tests/test_create.py::test_create_index_if_not_exists PASSED [ 48%] 697s tests/test_create.py::test_create_index_desc PASSED [ 48%] 697s tests/test_create.py::test_create_index_find_unique_name PASSED [ 48%] 697s tests/test_create.py::test_create_index_analyze PASSED [ 48%] 697s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure0] PASSED [ 48%] 697s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure1] PASSED [ 48%] 697s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure2] PASSED [ 48%] 697s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure3] PASSED [ 48%] 697s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure4] PASSED [ 48%] 697s tests/test_create.py::test_insert_dictionaries_and_lists_as_json[data_structure5] PASSED [ 49%] 697s tests/test_create.py::test_insert_list_nested_unicode PASSED [ 49%] 697s tests/test_create.py::test_insert_uuid PASSED [ 49%] 697s tests/test_create.py::test_insert_memoryview PASSED [ 49%] 697s tests/test_create.py::test_insert_thousands_using_generator PASSED [ 49%] 697s tests/test_create.py::test_insert_thousands_raises_exception_with_extra_columns_after_first_100 PASSED [ 49%] 697s tests/test_create.py::test_insert_thousands_adds_extra_columns_after_first_100_with_alter PASSED [ 49%] 697s tests/test_create.py::test_insert_ignore PASSED [ 49%] 697s tests/test_create.py::test_insert_hash_id PASSED [ 49%] 697s tests/test_create.py::test_insert_hash_id_columns[True] PASSED [ 49%] 697s tests/test_create.py::test_insert_hash_id_columns[False] PASSED [ 50%] 697s tests/test_create.py::test_vacuum PASSED [ 50%] 697s tests/test_create.py::test_works_with_pathlib_path PASSED [ 50%] 697s tests/test_create.py::test_create_table_numpy SKIPPED (pandas and nu...) [ 50%] 697s tests/test_create.py::test_cannot_provide_both_filename_and_memory PASSED [ 50%] 697s tests/test_create.py::test_creates_id_column PASSED [ 50%] 697s tests/test_create.py::test_drop PASSED [ 50%] 697s tests/test_create.py::test_drop_view PASSED [ 50%] 697s tests/test_create.py::test_drop_ignore PASSED [ 50%] 697s tests/test_create.py::test_insert_all_empty_list PASSED [ 50%] 697s tests/test_create.py::test_insert_all_single_column PASSED [ 51%] 697s tests/test_create.py::test_insert_all_analyze[insert_all] PASSED [ 51%] 697s tests/test_create.py::test_insert_all_analyze[upsert_all] PASSED [ 51%] 697s tests/test_create.py::test_create_with_a_null_column PASSED [ 51%] 697s tests/test_create.py::test_create_with_nested_bytes PASSED [ 51%] 697s tests/test_create.py::test_quote[hello-'hello'] PASSED [ 51%] 697s tests/test_create.py::test_quote[hello'there'-'hello''there'''] PASSED [ 51%] 697s tests/test_create.py::test_create_table_sql[columns0-[id] INTEGER] PASSED [ 51%] 697s tests/test_create.py::test_create_table_sql[columns1-[col] TEXT] PASSED [ 51%] 697s tests/test_create.py::test_create_table_sql[columns2-[col] TEXT] PASSED [ 52%] 697s tests/test_create.py::test_create_table_sql[columns3-[col] TEXT] PASSED [ 52%] 697s tests/test_create.py::test_create PASSED [ 52%] 697s tests/test_create.py::test_create_if_not_exists PASSED [ 52%] 697s tests/test_create.py::test_create_if_no_columns PASSED [ 52%] 697s tests/test_create.py::test_create_ignore PASSED [ 52%] 697s tests/test_create.py::test_create_replace PASSED [ 52%] 697s tests/test_create.py::test_create_transform[cols0-kwargs0-CREATE TABLE [demo] (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)-False] PASSED [ 52%] 697s tests/test_create.py::test_create_transform[cols1-kwargs1-CREATE TABLE "demo" (\n [id] INTEGER\n)-True] PASSED [ 52%] 697s 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%] 697s tests/test_create.py::test_create_transform[cols3-kwargs3-CREATE TABLE "demo" (\n [id] INTEGER PRIMARY KEY,\n [name] BLOB\n)-True] PASSED [ 53%] 697s tests/test_create.py::test_create_transform[cols4-kwargs4-CREATE TABLE "demo" (\n [id] INTEGER,\n [name] TEXT PRIMARY KEY\n)-True] PASSED [ 53%] 697s tests/test_create.py::test_create_transform[cols5-kwargs5-CREATE TABLE "demo" (\n [name] TEXT,\n [id] INTEGER PRIMARY KEY\n)-True] PASSED [ 53%] 697s tests/test_create.py::test_create_transform[cols6-kwargs6-CREATE TABLE [demo] (\n [id] INTEGER PRIMARY KEY,\n [name] TEXT\n)-False] PASSED [ 53%] 697s 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%] 697s 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%] 697s tests/test_create.py::test_rename_table PASSED [ 53%] 697s tests/test_create_view.py::test_create_view PASSED [ 53%] 697s tests/test_create_view.py::test_create_view_error PASSED [ 53%] 697s tests/test_create_view.py::test_create_view_only_arrow_one_param PASSED [ 53%] 697s tests/test_create_view.py::test_create_view_ignore PASSED [ 54%] 697s tests/test_create_view.py::test_create_view_replace PASSED [ 54%] 697s tests/test_create_view.py::test_create_view_replace_with_same_does_nothing PASSED [ 54%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'foo'-'foo'-'foo'] PASSED [ 54%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'foo)'-'foo)'-'foo)'] PASSED [ 54%] 697s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT '1'-'1'-'1'] PASSED [ 54%] 697s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT 1-1-'1'] PASSED [ 54%] 697s tests/test_default_value.py::test_quote_default_value[INTEGER DEFAULT (1)-1-'1'] PASSED [ 54%] 697s 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%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_TIME-CURRENT_TIME-CURRENT_TIME] PASSED [ 55%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_DATE-CURRENT_DATE-CURRENT_DATE] PASSED [ 55%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT CURRENT_TIMESTAMP-CURRENT_TIMESTAMP-CURRENT_TIMESTAMP] PASSED [ 55%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT current_timestamp-current_timestamp-current_timestamp] PASSED [ 55%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT (CURRENT_TIMESTAMP)-CURRENT_TIMESTAMP-CURRENT_TIMESTAMP] PASSED [ 55%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT 'CURRENT_TIMESTAMP'-'CURRENT_TIMESTAMP'-'CURRENT_TIMESTAMP'] PASSED [ 55%] 697s tests/test_default_value.py::test_quote_default_value[TEXT DEFAULT "CURRENT_TIMESTAMP"-"CURRENT_TIMESTAMP"-"CURRENT_TIMESTAMP"] PASSED [ 55%] 697s tests/test_delete.py::test_delete_rowid_table PASSED [ 55%] 697s tests/test_delete.py::test_delete_pk_table PASSED [ 55%] 697s tests/test_delete.py::test_delete_where PASSED [ 55%] 697s tests/test_delete.py::test_delete_where_all PASSED [ 56%] 697s tests/test_delete.py::test_delete_where_analyze PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[tables] PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[views] PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[optimize] PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[rebuild-fts] PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[analyze] PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[vacuum] PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[dump] PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[add-column] PASSED [ 56%] 697s tests/test_docs.py::test_commands_are_documented[add-foreign-key] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[add-foreign-keys] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[index-foreign-keys] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[create-index] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[enable-fts] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[populate-fts] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[disable-fts] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[enable-wal] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[disable-wal] PASSED [ 57%] 697s tests/test_docs.py::test_commands_are_documented[enable-counts] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[reset-counts] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[insert] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[upsert] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[bulk] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[create-database] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[create-table] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[duplicate] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[rename-table] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[drop-table] PASSED [ 58%] 697s tests/test_docs.py::test_commands_are_documented[create-view] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[drop-view] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[query] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[memory] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[search] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[rows] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[triggers] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[indexes] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[schema] PASSED [ 59%] 697s tests/test_docs.py::test_commands_are_documented[transform] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[extract] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[insert-files] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[analyze-tables] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[install] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[uninstall] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[convert] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[add-geometry-column] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[create-spatial-index] PASSED [ 60%] 697s tests/test_docs.py::test_commands_are_documented[plugins] PASSED [ 60%] 697s tests/test_docs.py::test_commands_have_help[command0] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command1] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command2] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command3] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command4] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command5] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command6] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command7] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command8] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command9] PASSED [ 61%] 697s tests/test_docs.py::test_commands_have_help[command10] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command11] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command12] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command13] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command14] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command15] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command16] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command17] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command18] PASSED [ 62%] 697s tests/test_docs.py::test_commands_have_help[command19] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command20] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command21] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command22] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command23] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command24] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command25] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command26] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command27] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command28] PASSED [ 63%] 697s tests/test_docs.py::test_commands_have_help[command29] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command30] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command31] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command32] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command33] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command34] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command35] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command36] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command37] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command38] PASSED [ 64%] 697s tests/test_docs.py::test_commands_have_help[command39] PASSED [ 65%] 697s tests/test_docs.py::test_commands_have_help[command40] PASSED [ 65%] 697s tests/test_docs.py::test_commands_have_help[command41] PASSED [ 65%] 697s tests/test_docs.py::test_commands_have_help[command42] PASSED [ 65%] 697s tests/test_docs.py::test_commands_have_help[command43] PASSED [ 65%] 697s tests/test_docs.py::test_commands_have_help[command44] PASSED [ 65%] 697s tests/test_docs.py::test_commands_have_help[command45] PASSED [ 65%] 697s tests/test_docs.py::test_convert_help PASSED [ 65%] 697s tests/test_docs.py::test_recipes_are_documented[jsonsplit] PASSED [ 65%] 697s tests/test_docs.py::test_recipes_are_documented[parsedate] PASSED [ 66%] 697s tests/test_docs.py::test_recipes_are_documented[parsedatetime] PASSED [ 66%] 697s tests/test_duplicate.py::test_duplicate PASSED [ 66%] 697s tests/test_duplicate.py::test_duplicate_fails_if_table_does_not_exist PASSED [ 66%] 697s tests/test_enable_counts.py::test_enable_counts_specific_table PASSED [ 66%] 697s tests/test_enable_counts.py::test_enable_counts_all_tables PASSED [ 66%] 697s tests/test_enable_counts.py::test_cli_enable_counts[extra_args0-expected_triggers0] PASSED [ 66%] 697s tests/test_enable_counts.py::test_cli_enable_counts[extra_args1-expected_triggers1] PASSED [ 66%] 697s tests/test_enable_counts.py::test_uses_counts_after_enable_counts PASSED [ 66%] 697s tests/test_enable_counts.py::test_reset_counts PASSED [ 66%] 697s tests/test_enable_counts.py::test_reset_counts_cli PASSED [ 67%] 697s tests/test_extract.py::test_extract_single_column[None-None] PASSED [ 67%] 697s tests/test_extract.py::test_extract_single_column[None-Species] PASSED [ 67%] 697s tests/test_extract.py::test_extract_single_column[species-None] PASSED [ 67%] 697s tests/test_extract.py::test_extract_single_column[species-Species] PASSED [ 67%] 697s tests/test_extract.py::test_extract_multiple_columns_with_rename PASSED [ 67%] 697s tests/test_extract.py::test_extract_invalid_columns PASSED [ 67%] 697s tests/test_extract.py::test_extract_rowid_table PASSED [ 67%] 697s tests/test_extract.py::test_reuse_lookup_table PASSED [ 67%] 697s tests/test_extract.py::test_extract_error_on_incompatible_existing_lookup_table PASSED [ 67%] 697s tests/test_extract.py::test_extract_works_with_null_values PASSED [ 68%] 697s tests/test_extracts.py::test_extracts[True-kwargs0-Species] PASSED [ 68%] 697s tests/test_extracts.py::test_extracts[True-kwargs1-species_id] PASSED [ 68%] 697s tests/test_extracts.py::test_extracts[True-kwargs2-species_id] PASSED [ 68%] 697s tests/test_extracts.py::test_extracts[False-kwargs0-Species] PASSED [ 68%] 697s tests/test_extracts.py::test_extracts[False-kwargs1-species_id] PASSED [ 68%] 697s tests/test_extracts.py::test_extracts[False-kwargs2-species_id] PASSED [ 68%] 697s tests/test_fts.py::test_enable_fts PASSED [ 68%] 697s tests/test_fts.py::test_enable_fts_escape_table_names PASSED [ 68%] 697s tests/test_fts.py::test_search_limit_offset PASSED [ 69%] 697s tests/test_fts.py::test_search_where[FTS4] PASSED [ 69%] 697s tests/test_fts.py::test_search_where[FTS5] PASSED [ 69%] 697s tests/test_fts.py::test_search_where_args_disallows_query PASSED [ 69%] 697s tests/test_fts.py::test_enable_fts_table_names_containing_spaces PASSED [ 69%] 697s tests/test_fts.py::test_populate_fts PASSED [ 69%] 697s tests/test_fts.py::test_populate_fts_escape_table_names PASSED [ 69%] 697s tests/test_fts.py::test_fts_tokenize[4] PASSED [ 69%] 697s tests/test_fts.py::test_fts_tokenize[5] PASSED [ 69%] 697s tests/test_fts.py::test_optimize_fts PASSED [ 69%] 697s tests/test_fts.py::test_enable_fts_with_triggers PASSED [ 70%] 697s tests/test_fts.py::test_disable_fts[True] PASSED [ 70%] 697s tests/test_fts.py::test_disable_fts[False] PASSED [ 70%] 697s tests/test_fts.py::test_rebuild_fts PASSED [ 70%] 697s tests/test_fts.py::test_rebuild_fts_invalid[does_not_exist] PASSED [ 70%] 697s tests/test_fts.py::test_rebuild_fts_invalid[not_searchable] PASSED [ 70%] 697s tests/test_fts.py::test_rebuild_removes_junk_docsize_rows[FTS4] PASSED [ 70%] 697s tests/test_fts.py::test_rebuild_removes_junk_docsize_rows[FTS5] PASSED [ 70%] 697s tests/test_fts.py::test_enable_fts_replace[kwargs0] PASSED [ 70%] 697s tests/test_fts.py::test_enable_fts_replace[kwargs1] PASSED [ 70%] 697s tests/test_fts.py::test_enable_fts_replace[kwargs2] PASSED [ 71%] 697s tests/test_fts.py::test_enable_fts_replace[kwargs3] PASSED [ 71%] 697s tests/test_fts.py::test_enable_fts_replace_does_nothing_if_args_the_same PASSED [ 71%] 697s tests/test_fts.py::test_enable_fts_error_message_on_views PASSED [ 71%] 697s 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%] 697s 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%] 697s 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%] 697s 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%] 697s 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%] 697s 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%] 697s 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%] 697s 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%] 697s 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%] 697s tests/test_fts.py::test_quote_fts_query[dog-"dog"] PASSED [ 72%] 697s tests/test_fts.py::test_quote_fts_query[cat,-"cat,"] PASSED [ 72%] 697s tests/test_fts.py::test_quote_fts_query[cat's-"cat's"] PASSED [ 72%] 697s tests/test_fts.py::test_quote_fts_query[dog.-"dog."] PASSED [ 72%] 697s tests/test_fts.py::test_quote_fts_query[cat dog-"cat" "dog"] PASSED [ 72%] 697s tests/test_fts.py::test_quote_fts_query["cat dog"-"cat dog"] PASSED [ 72%] 697s tests/test_fts.py::test_quote_fts_query["cat dog" fish-"cat dog" "fish"] PASSED [ 73%] 697s tests/test_fts.py::test_quote_fts_query[cat"-"cat"] PASSED [ 73%] 697s tests/test_fts.py::test_quote_fts_query["cat dog" "fish-"cat dog" "fish"] PASSED [ 73%] 697s tests/test_fts.py::test_search_quote PASSED [ 73%] 697s tests/test_get.py::test_get_rowid PASSED [ 73%] 697s tests/test_get.py::test_get_primary_key PASSED [ 73%] 697s tests/test_get.py::test_get_not_found[100-None] PASSED [ 73%] 697s tests/test_get.py::test_get_not_found[None-None] PASSED [ 73%] 697s tests/test_get.py::test_get_not_found[argument2-Need 1 primary key value] PASSED [ 73%] 697s tests/test_get.py::test_get_not_found[2-None] PASSED [ 73%] 697s tests/test_gis.py::test_find_spatialite SKIPPED (Could not find Spat...) [ 74%] 697s tests/test_gis.py::test_init_spatialite SKIPPED (Could not find Spat...) [ 74%] 697s tests/test_gis.py::test_add_geometry_column SKIPPED (Could not find ...) [ 74%] 697s tests/test_gis.py::test_create_spatial_index SKIPPED (Could not find...) [ 74%] 697s tests/test_gis.py::test_double_create_spatial_index SKIPPED (Could n...) [ 74%] 697s tests/test_gis.py::test_query_load_extension[True] SKIPPED (Could no...) [ 74%] 697s tests/test_gis.py::test_query_load_extension[False] SKIPPED (Could n...) [ 74%] 697s tests/test_gis.py::test_cli_create_spatialite SKIPPED (Could not fin...) [ 74%] 697s tests/test_gis.py::test_cli_add_geometry_column SKIPPED (Could not f...) [ 74%] 697s tests/test_gis.py::test_cli_add_geometry_column_options SKIPPED (Cou...) [ 75%] 697s tests/test_gis.py::test_cli_add_geometry_column_invalid_type SKIPPED [ 75%] 697s tests/test_gis.py::test_cli_create_spatial_index SKIPPED (Could not ...) [ 75%] 697s tests/test_hypothesis.py::test_roundtrip_integers PASSED [ 75%] 699s tests/test_hypothesis.py::test_roundtrip_text PASSED [ 75%] 699s tests/test_hypothesis.py::test_roundtrip_binary PASSED [ 75%] 699s tests/test_hypothesis.py::test_roundtrip_floats PASSED [ 75%] 699s tests/test_insert_files.py::test_insert_files[False] PASSED [ 75%] 699s tests/test_insert_files.py::test_insert_files[True] PASSED [ 75%] 699s tests/test_insert_files.py::test_insert_files_stdin[False-None-hello world-hello world] PASSED [ 75%] 699s tests/test_insert_files.py::test_insert_files_stdin[True-None-hello world-hello world] PASSED [ 76%] 699s tests/test_insert_files.py::test_insert_files_stdin[False-None-S\xe3o Paulo-S\xe3o Paulo] PASSED [ 76%] 699s tests/test_insert_files.py::test_insert_files_stdin[True-latin-1-S\xe3o Paulo-S\xe3o Paulo] PASSED [ 76%] 699s tests/test_insert_files.py::test_insert_files_bad_text_encoding_error PASSED [ 76%] 699s tests/test_introspect.py::test_table_names PASSED [ 76%] 699s tests/test_introspect.py::test_view_names PASSED [ 76%] 699s tests/test_introspect.py::test_table_names_fts4 PASSED [ 76%] 699s tests/test_introspect.py::test_detect_fts PASSED [ 76%] 699s tests/test_introspect.py::test_detect_fts_similar_tables[True] PASSED [ 76%] 699s tests/test_introspect.py::test_detect_fts_similar_tables[False] PASSED [ 76%] 699s tests/test_introspect.py::test_tables PASSED [ 77%] 699s tests/test_introspect.py::test_views PASSED [ 77%] 699s tests/test_introspect.py::test_count PASSED [ 77%] 699s tests/test_introspect.py::test_count_where PASSED [ 77%] 699s tests/test_introspect.py::test_columns PASSED [ 77%] 699s tests/test_introspect.py::test_table_schema PASSED [ 77%] 699s tests/test_introspect.py::test_database_schema PASSED [ 77%] 699s tests/test_introspect.py::test_table_repr PASSED [ 77%] 699s tests/test_introspect.py::test_indexes PASSED [ 77%] 699s tests/test_introspect.py::test_xindexes PASSED [ 78%] 699s tests/test_introspect.py::test_guess_foreign_table[author-authors] PASSED [ 78%] 700s tests/test_introspect.py::test_guess_foreign_table[author_id-authors] PASSED [ 78%] 700s tests/test_introspect.py::test_guess_foreign_table[authors-authors] PASSED [ 78%] 700s tests/test_introspect.py::test_guess_foreign_table[genre-genre] PASSED [ 78%] 700s tests/test_introspect.py::test_guess_foreign_table[genre_id-genre] PASSED [ 78%] 700s tests/test_introspect.py::test_pks[None-expected0] PASSED [ 78%] 700s tests/test_introspect.py::test_pks[id-expected1] PASSED [ 78%] 700s tests/test_introspect.py::test_pks[pk2-expected2] PASSED [ 78%] 700s tests/test_introspect.py::test_triggers_and_triggers_dict PASSED [ 78%] 700s tests/test_introspect.py::test_has_counts_triggers PASSED [ 79%] 700s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE foo USING FTS5(name)\n -foo-FTS5] PASSED [ 79%] 700s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE "foo" USING FTS4(name)\n -foo-FTS4] PASSED [ 79%] 700s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE IF NOT EXISTS `foo` USING FTS4(name)\n -foo-FTS4] PASSED [ 79%] 700s tests/test_introspect.py::test_virtual_table_using[\n CREATE VIRTUAL TABLE IF NOT EXISTS `foo` USING fts5(name)\n -foo-FTS5] PASSED [ 79%] 700s tests/test_introspect.py::test_virtual_table_using[\n CREATE TABLE IF NOT EXISTS `foo` (id integer primary key)\n -foo-None] PASSED [ 79%] 700s tests/test_introspect.py::test_use_rowid PASSED [ 79%] 700s tests/test_introspect.py::test_table_strict[create table t (id integer) strict-True] PASSED [ 79%] 700s tests/test_introspect.py::test_table_strict[create table t (id integer) STRICT-True] PASSED [ 79%] 700s tests/test_introspect.py::test_table_strict[create table t (id integer primary key) StriCt, WITHOUT ROWID-True] PASSED [ 80%] 700s tests/test_introspect.py::test_table_strict[create table t (id integer primary key) WITHOUT ROWID-False] PASSED [ 80%] 700s tests/test_introspect.py::test_table_strict[create table t (id integer)-False] PASSED [ 80%] 700s tests/test_introspect.py::test_table_default_values[1] PASSED [ 80%] 700s tests/test_introspect.py::test_table_default_values[1.3] PASSED [ 80%] 700s tests/test_introspect.py::test_table_default_values[foo] PASSED [ 80%] 700s tests/test_introspect.py::test_table_default_values[True] PASSED [ 80%] 700s tests/test_introspect.py::test_table_default_values[binary] PASSED [ 80%] 700s tests/test_lookup.py::test_lookup_new_table PASSED [ 80%] 700s tests/test_lookup.py::test_lookup_new_table_compound_key PASSED [ 80%] 700s tests/test_lookup.py::test_lookup_adds_unique_constraint_to_existing_table PASSED [ 81%] 700s tests/test_lookup.py::test_lookup_fails_if_constraint_cannot_be_added PASSED [ 81%] 700s tests/test_lookup.py::test_lookup_with_extra_values PASSED [ 81%] 700s tests/test_lookup.py::test_lookup_with_extra_insert_parameters PASSED [ 81%] 700s tests/test_m2m.py::test_insert_m2m_single PASSED [ 81%] 700s tests/test_m2m.py::test_insert_m2m_alter PASSED [ 81%] 700s tests/test_m2m.py::test_insert_m2m_list PASSED [ 81%] 700s tests/test_m2m.py::test_insert_m2m_iterable PASSED [ 81%] 700s tests/test_m2m.py::test_m2m_with_table_objects PASSED [ 81%] 700s tests/test_m2m.py::test_m2m_lookup PASSED [ 81%] 700s tests/test_m2m.py::test_m2m_requires_either_records_or_lookup PASSED [ 82%] 700s tests/test_m2m.py::test_m2m_explicit_table_name_argument PASSED [ 82%] 700s tests/test_m2m.py::test_m2m_table_candidates PASSED [ 82%] 700s tests/test_m2m.py::test_uses_existing_m2m_table_if_exists PASSED [ 82%] 700s tests/test_m2m.py::test_requires_explicit_m2m_table_if_multiple_options PASSED [ 82%] 700s tests/test_plugins.py::test_register_commands PASSED [ 82%] 700s tests/test_plugins.py::test_prepare_connection PASSED [ 82%] 700s tests/test_query.py::test_query PASSED [ 82%] 700s tests/test_query.py::test_execute_returning_dicts PASSED [ 82%] 700s tests/test_recipes.py::test_parsedate PASSED [ 83%] 700s tests/test_recipes.py::test_parsedatetime PASSED [ 83%] 700s tests/test_recipes.py::test_dayfirst_yearfirst[parsedate-kwargs0-2005-03-04] PASSED [ 83%] 700s tests/test_recipes.py::test_dayfirst_yearfirst[parsedate-kwargs1-2005-04-03] PASSED [ 83%] 700s tests/test_recipes.py::test_dayfirst_yearfirst[parsedatetime-kwargs2-2005-03-04T00:00:00] PASSED [ 83%] 700s tests/test_recipes.py::test_dayfirst_yearfirst[parsedatetime-kwargs3-2005-04-03T00:00:00] PASSED [ 83%] 700s tests/test_recipes.py::test_dateparse_errors[None-parsedate] PASSED [ 83%] 700s tests/test_recipes.py::test_dateparse_errors[None-parsedatetime] PASSED [ 83%] 700s tests/test_recipes.py::test_dateparse_errors[errors1-parsedate] PASSED [ 83%] 700s tests/test_recipes.py::test_dateparse_errors[errors1-parsedatetime] PASSED [ 83%] 700s tests/test_recipes.py::test_dateparse_errors[errors2-parsedate] PASSED [ 84%] 700s tests/test_recipes.py::test_dateparse_errors[errors2-parsedatetime] PASSED [ 84%] 700s tests/test_recipes.py::test_jsonsplit[None] PASSED [ 84%] 700s tests/test_recipes.py::test_jsonsplit[;] PASSED [ 84%] 700s tests/test_recipes.py::test_jsonsplit[-] PASSED [ 84%] 700s tests/test_recipes.py::test_jsonsplit_type[None-expected0] PASSED [ 84%] 700s tests/test_recipes.py::test_jsonsplit_type[float-expected1] PASSED [ 84%] 700s tests/test_recipes.py::test_jsonsplit_type[int-expected2] PASSED [ 84%] 700s tests/test_recreate.py::test_recreate_ignored_for_in_memory PASSED [ 84%] 700s tests/test_recreate.py::test_recreate_not_allowed_for_connection PASSED [ 84%] 700s tests/test_recreate.py::test_recreate[True-True] PASSED [ 85%] 700s tests/test_recreate.py::test_recreate[True-False] PASSED [ 85%] 700s tests/test_recreate.py::test_recreate[False-True] PASSED [ 85%] 700s tests/test_recreate.py::test_recreate[False-False] PASSED [ 85%] 700s tests/test_register_function.py::test_register_function PASSED [ 85%] 700s tests/test_register_function.py::test_register_function_custom_name PASSED [ 85%] 700s tests/test_register_function.py::test_register_function_multiple_arguments PASSED [ 85%] 700s tests/test_register_function.py::test_register_function_deterministic PASSED [ 85%] 700s tests/test_register_function.py::test_register_function_deterministic_tries_again_if_exception_raised PASSED [ 85%] 700s tests/test_register_function.py::test_register_function_replace PASSED [ 86%] 700s tests/test_rows.py::test_rows PASSED [ 86%] 700s tests/test_rows.py::test_rows_where[name = ?-where_args0-expected_ids0] PASSED [ 86%] 700s tests/test_rows.py::test_rows_where[age > ?-where_args1-expected_ids1] PASSED [ 86%] 700s tests/test_rows.py::test_rows_where[age > :age-where_args2-expected_ids2] PASSED [ 86%] 700s tests/test_rows.py::test_rows_where[name is not null-where_args3-expected_ids3] PASSED [ 86%] 700s tests/test_rows.py::test_rows_where[is_good = ?-where_args4-expected_ids4] PASSED [ 86%] 700s tests/test_rows.py::test_rows_where_order_by[None-None-expected_ids0] PASSED [ 86%] 700s tests/test_rows.py::test_rows_where_order_by[None-id desc-expected_ids1] PASSED [ 86%] 700s tests/test_rows.py::test_rows_where_order_by[None-age-expected_ids2] PASSED [ 86%] 700s tests/test_rows.py::test_rows_where_order_by[id > 1-age-expected_ids3] PASSED [ 87%] 700s tests/test_rows.py::test_rows_where_offset_limit[None-3-expected0] PASSED [ 87%] 700s tests/test_rows.py::test_rows_where_offset_limit[0-3-expected1] PASSED [ 87%] 700s tests/test_rows.py::test_rows_where_offset_limit[3-3-expected2] PASSED [ 87%] 700s tests/test_rows.py::test_pks_and_rows_where_rowid PASSED [ 87%] 700s tests/test_rows.py::test_pks_and_rows_where_simple_pk PASSED [ 87%] 700s tests/test_rows.py::test_pks_and_rows_where_compound_pk PASSED [ 87%] 700s tests/test_rows_from_file.py::test_rows_from_file_detect_format[id,name\n1,Cleo-Format.CSV] PASSED [ 87%] 700s tests/test_rows_from_file.py::test_rows_from_file_detect_format[id\tname\n1\tCleo-Format.TSV] PASSED [ 87%] 700s tests/test_rows_from_file.py::test_rows_from_file_detect_format[[{"id": "1", "name": "Cleo"}]-Format.JSON] PASSED [ 87%] 700s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[True-None-expected0] PASSED [ 88%] 700s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[False-_rest-expected1] PASSED [ 88%] 700s tests/test_rows_from_file.py::test_rows_from_file_extra_fields_strategies[False-False-None] PASSED [ 88%] 700s tests/test_rows_from_file.py::test_rows_from_file_error_on_string_io PASSED [ 88%] 700s tests/test_sniff.py::test_sniff[filepath0] PASSED [ 88%] 700s tests/test_sniff.py::test_sniff[filepath1] PASSED [ 88%] 700s tests/test_sniff.py::test_sniff[filepath2] PASSED [ 88%] 700s tests/test_sniff.py::test_sniff[filepath3] PASSED [ 88%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records0-types0] PASSED [ 88%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records1-types1] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records2-types2] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records3-types3] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records4-types4] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records5-types5] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records6-types6] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records7-types7] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records8-types8] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records9-types9] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records10-types10] PASSED [ 89%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records11-types11] PASSED [ 90%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records12-types12] PASSED [ 90%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records13-types13] PASSED [ 90%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records14-types14] PASSED [ 90%] 700s tests/test_suggest_column_types.py::test_suggest_column_types[records15-types15] PASSED [ 90%] 700s tests/test_tracer.py::test_tracer PASSED [ 90%] 700s tests/test_tracer.py::test_with_tracer PASSED [ 90%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params0-expected_sql0] PASSED [ 90%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params1-expected_sql1] PASSED [ 90%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params2-expected_sql2] PASSED [ 90%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params3-expected_sql3] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params4-expected_sql4] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params5-expected_sql5] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params6-expected_sql6] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params7-expected_sql7] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[False-params8-expected_sql8] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params0-expected_sql0] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params1-expected_sql1] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params2-expected_sql2] PASSED [ 91%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params3-expected_sql3] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params4-expected_sql4] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params5-expected_sql5] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params6-expected_sql6] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params7-expected_sql7] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_primary_key[True-params8-expected_sql8] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params0-expected_sql0] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params1-expected_sql1] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params2-expected_sql2] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[False-params3-expected_sql3] PASSED [ 92%] 700s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params0-expected_sql0] PASSED [ 93%] 700s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params1-expected_sql1] PASSED [ 93%] 700s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params2-expected_sql2] PASSED [ 93%] 700s tests/test_transform.py::test_transform_sql_table_with_no_primary_key[True-params3-expected_sql3] PASSED [ 93%] 700s tests/test_transform.py::test_transform_sql_with_no_primary_key_to_primary_key_of_id PASSED [ 93%] 700s tests/test_transform.py::test_transform_rename_pk PASSED [ 93%] 700s tests/test_transform.py::test_transform_not_null PASSED [ 93%] 700s tests/test_transform.py::test_transform_remove_a_not_null PASSED [ 93%] 700s tests/test_transform.py::test_transform_add_not_null_with_rename[not_null0] PASSED [ 93%] 700s tests/test_transform.py::test_transform_add_not_null_with_rename[not_null1] PASSED [ 93%] 700s tests/test_transform.py::test_transform_defaults PASSED [ 94%] 700s tests/test_transform.py::test_transform_defaults_and_rename_column PASSED [ 94%] 700s tests/test_transform.py::test_remove_defaults PASSED [ 94%] 700s tests/test_transform.py::test_transform_foreign_keys_persist PASSED [ 94%] 700s tests/test_transform.py::test_transform_foreign_keys_survive_renamed_column[False] PASSED [ 94%] 700s tests/test_transform.py::test_transform_foreign_keys_survive_renamed_column[True] PASSED [ 94%] 700s tests/test_transform.py::test_transform_drop_foreign_keys[False] PASSED [ 94%] 700s tests/test_transform.py::test_transform_drop_foreign_keys[True] PASSED [ 94%] 700s tests/test_transform.py::test_transform_verify_foreign_keys PASSED [ 94%] 700s tests/test_transform.py::test_transform_add_foreign_keys_from_scratch PASSED [ 95%] 700s tests/test_transform.py::test_transform_add_foreign_keys_from_partial[add_foreign_keys0] PASSED [ 95%] 700s tests/test_transform.py::test_transform_add_foreign_keys_from_partial[add_foreign_keys1] PASSED [ 95%] 700s tests/test_transform.py::test_transform_replace_foreign_keys[foreign_keys0] PASSED [ 95%] 700s tests/test_transform.py::test_transform_replace_foreign_keys[foreign_keys1] PASSED [ 95%] 700s tests/test_transform.py::test_transform_preserves_rowids[id_pk] PASSED [ 95%] 700s tests/test_transform.py::test_transform_preserves_rowids[rowid] PASSED [ 95%] 700s tests/test_transform.py::test_transform_preserves_rowids[compound_pk] PASSED [ 95%] 700s tests/test_update.py::test_update_rowid_table PASSED [ 95%] 700s tests/test_update.py::test_update_pk_table PASSED [ 95%] 700s tests/test_update.py::test_update_compound_pk_table PASSED [ 96%] 700s tests/test_update.py::test_update_invalid_pk[None-2] PASSED [ 96%] 700s tests/test_update.py::test_update_invalid_pk[None-None] PASSED [ 96%] 700s tests/test_update.py::test_update_invalid_pk[id1-None] PASSED [ 96%] 700s tests/test_update.py::test_update_invalid_pk[id1-4] PASSED [ 96%] 700s tests/test_update.py::test_update_invalid_pk[pk4-None] PASSED [ 96%] 700s tests/test_update.py::test_update_invalid_pk[pk5-4] PASSED [ 96%] 700s tests/test_update.py::test_update_invalid_pk[pk6-update_pk6] PASSED [ 96%] 700s tests/test_update.py::test_update_alter PASSED [ 96%] 700s tests/test_update.py::test_update_alter_with_invalid_column_characters PASSED [ 96%] 700s tests/test_update.py::test_update_with_no_values_sets_last_pk PASSED [ 97%] 700s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure0] PASSED [ 97%] 700s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure1] PASSED [ 97%] 700s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure2] PASSED [ 97%] 700s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure3] PASSED [ 97%] 700s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure4] PASSED [ 97%] 700s tests/test_update.py::test_update_dictionaries_and_lists_as_json[data_structure5] PASSED [ 97%] 700s tests/test_upsert.py::test_upsert PASSED [ 97%] 700s tests/test_upsert.py::test_upsert_all PASSED [ 97%] 700s tests/test_upsert.py::test_upsert_all_single_column PASSED [ 98%] 700s tests/test_upsert.py::test_upsert_all_not_null PASSED [ 98%] 700s tests/test_upsert.py::test_upsert_error_if_no_pk PASSED [ 98%] 700s tests/test_upsert.py::test_upsert_with_hash_id PASSED [ 98%] 700s tests/test_upsert.py::test_upsert_with_hash_id_columns[None] PASSED [ 98%] 700s tests/test_upsert.py::test_upsert_with_hash_id_columns[custom_id] PASSED [ 98%] 700s tests/test_upsert.py::test_upsert_compound_primary_key PASSED [ 98%] 700s tests/test_utils.py::test_decode_base64_values[input0-None-True] PASSED [ 98%] 700s tests/test_utils.py::test_decode_base64_values[input1-None-True] PASSED [ 98%] 700s tests/test_utils.py::test_decode_base64_values[input2-expected2-False] PASSED [ 98%] 700s tests/test_utils.py::test_chunks[1-expected0] PASSED [ 99%] 700s tests/test_utils.py::test_chunks[2-expected1] PASSED [ 99%] 700s tests/test_utils.py::test_chunks[3-expected2] PASSED [ 99%] 700s tests/test_utils.py::test_chunks[4-expected3] PASSED [ 99%] 700s tests/test_utils.py::test_hash_record PASSED [ 99%] 700s tests/test_utils.py::test_maximize_csv_field_size_limit PASSED [ 99%] 700s tests/test_utils.py::test_flatten[input0-expected0] PASSED [ 99%] 700s tests/test_utils.py::test_flatten[input1-expected1] PASSED [ 99%] 700s tests/test_utils.py::test_flatten[input2-expected2] PASSED [ 99%] 700s tests/test_wal.py::test_enable_disable_wal PASSED [100%] 700s 700s =============================== warnings summary =============================== 700s ../../../usr/lib/python3/dist-packages/dateutil/tz/tz.py:37 700s /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). 700s EPOCH = datetime.datetime.utcfromtimestamp(0) 700s 700s tests/test_cli.py::test_upsert_alter 700s :685: ResourceWarning: unclosed file <_io.BufferedReader name='/tmp/pytest-of-ubuntu/pytest-0/test_upsert_pk_required0/dogs.json'> 700s Enable tracemalloc to get traceback where the object was allocated. 700s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 700s 700s tests/test_cli_memory.py::test_memory_csv[False-test] 700s /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'> 700s for row in reader: 700s Enable tracemalloc to get traceback where the object was allocated. 700s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 700s 700s tests/test_cli_memory.py::test_memory_csv[False-t] 700s /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'> 700s for row in reader: 700s Enable tracemalloc to get traceback where the object was allocated. 700s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 700s 700s tests/test_cli_memory.py::test_memory_csv[False-t1] 700s /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'> 700s for row in reader: 700s Enable tracemalloc to get traceback where the object was allocated. 700s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 700s 700s tests/test_cli_memory.py::test_memory_tsv[False] 700s /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'> 700s for row in reader: 700s Enable tracemalloc to get traceback where the object was allocated. 700s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 700s 700s tests/test_cli_memory.py::test_memory_dump[extra_args1] 700s /usr/lib/python3.12/csv.py:321: ResourceWarning: unclosed file <_io.FileIO name='/tmp/pytest-of-ubuntu/pytest-0/test_memory_csv_encoding_False0/test.csv' mode='rb' closefd=True> 700s metaFrequency = charFrequency.get(char, {}) 700s Enable tracemalloc to get traceback where the object was allocated. 700s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 700s 700s tests/test_cli_memory.py::test_memory_two_files_with_same_stem 700s /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'> 700s for row in reader: 700s Enable tracemalloc to get traceback where the object was allocated. 700s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 700s 700s tests/test_cli_memory.py::test_memory_two_files_with_same_stem 700s /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'> 700s for row in reader: 700s Enable tracemalloc to get traceback where the object was allocated. 700s See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. 700s 700s tests/test_insert_files.py::test_insert_files[False] 700s tests/test_insert_files.py::test_insert_files[True] 700s /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). 700s "mtime_iso": lambda p: datetime.utcfromtimestamp(p.stat().st_mtime).isoformat(), 700s 700s tests/test_insert_files.py::test_insert_files[False] 700s tests/test_insert_files.py::test_insert_files[True] 700s /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). 700s "ctime_iso": lambda p: datetime.utcfromtimestamp(p.stat().st_ctime).isoformat(), 700s 700s tests/test_recipes.py::test_dateparse_errors[None-parsedate] 700s /usr/lib/python3/dist-packages/_pytest/unraisableexception.py:78: PytestUnraisableExceptionWarning: Exception ignored in: .convert_value at 0x7b935bbd4860> 700s 700s Traceback (most recent call last): 700s File "/usr/lib/python3/dist-packages/sqlite_utils/db.py", line 2818, in convert_value 700s return jsonify_if_needed(fn(v)) 700s ^^^^^ 700s File "/tmp/autopkgtest.RK33d9/autopkgtest_tmp/tests/test_recipes.py", line 77, in 700s fresh_db["example"].convert("dt", lambda value: getattr(recipes, fn)(value)) 700s ^^^^^^^^^^^^^^^^^^^^^^^^^^^ 700s File "/usr/lib/python3/dist-packages/sqlite_utils/recipes.py", line 19, in parsedate 700s parser.parse(value, dayfirst=dayfirst, yearfirst=yearfirst) 700s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 1368, in parse 700s return DEFAULTPARSER.parse(timestr, **kwargs) 700s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 700s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 643, in parse 700s raise ParserError("Unknown string format: %s", timestr) 700s dateutil.parser._parser.ParserError: Unknown string format: invalid 700s 700s warnings.warn(pytest.PytestUnraisableExceptionWarning(msg)) 700s 700s tests/test_recipes.py::test_dateparse_errors[None-parsedatetime] 700s /usr/lib/python3/dist-packages/_pytest/unraisableexception.py:78: PytestUnraisableExceptionWarning: Exception ignored in: .convert_value at 0x7b935b853f60> 700s 700s Traceback (most recent call last): 700s File "/usr/lib/python3/dist-packages/sqlite_utils/db.py", line 2818, in convert_value 700s return jsonify_if_needed(fn(v)) 700s ^^^^^ 700s File "/tmp/autopkgtest.RK33d9/autopkgtest_tmp/tests/test_recipes.py", line 77, in 700s fresh_db["example"].convert("dt", lambda value: getattr(recipes, fn)(value)) 700s ^^^^^^^^^^^^^^^^^^^^^^^^^^^ 700s File "/usr/lib/python3/dist-packages/sqlite_utils/recipes.py", line 42, in parsedatetime 700s return parser.parse(value, dayfirst=dayfirst, yearfirst=yearfirst).isoformat() 700s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 700s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 1368, in parse 700s return DEFAULTPARSER.parse(timestr, **kwargs) 700s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 700s File "/usr/lib/python3/dist-packages/dateutil/parser/_parser.py", line 643, in parse 700s raise ParserError("Unknown string format: %s", timestr) 700s dateutil.parser._parser.ParserError: Unknown string format: invalid 700s 700s warnings.warn(pytest.PytestUnraisableExceptionWarning(msg)) 700s 700s -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html 700s ================ 949 passed, 16 skipped, 15 warnings in 15.71s ================= 700s autopkgtest [19:24:54]: test run-tests: -----------------------] 701s run-tests PASS 701s autopkgtest [19:24:55]: test run-tests: - - - - - - - - - - results - - - - - - - - - - 701s autopkgtest [19:24:55]: @@@@@@@@@@@@@@@@@@@@ summary 701s run-tests PASS 711s Creating nova instance adt-noble-i386-sqlite-utils-20240324-191314-juju-7f2275-prod-proposed-migration-environment-2 from image adt/ubuntu-noble-amd64-server-20240324.img (UUID 4e56ccec-954f-4884-8b9c-3e1a29e50308)...