issues: 766156875

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
766156875 MDU6SXNzdWU3NjYxNTY4NzU= 209 Test failure with sqlite 3.34 in test_cli.py::test_optimize 191622 closed 0     1 2020-12-14T08:58:18Z 2021-01-01T23:52:46Z 2021-01-01T23:52:46Z CONTRIBUTOR  

pytest output: ... ============================== short test summary info =============================== FAILED tests/test_cli.py::test_optimize[tables0] - assert 1662976 < 1662976 FAILED tests/test_cli.py::test_optimize[tables1] - assert 1667072 < 1662976 ===================== 2 failed, 538 passed, 3 skipped in 34.32s ======================

Came across this while packaging sqlite-utils for NixOS, but it can be recreated it using the alpine:edge docker image as well as follows:

``` docker run --rm -it alpine:edge /bin/sh

apk update && apk add git sqlite python3 gcc python3-dev musl-dev && python3 -m ensurepip

git clone https://github.com/simonw/sqlite-utils.git

cd sqlite-utils/

pip3 install -e .[test]

pytest

```

This definitely works on sqlite v3.33.

 140912432 issue     
{
    "url": "https://api.github.com/repos/simonw/sqlite-utils/issues/209/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   completed

Links from other tables